Search: "database"

#data cleaning #csv #pandas

data Intermediate

ChatGPT prompt for creating a data cleaning pipeline for messy CSV files

Act as a senior data engineer who specializes in data quality and ETL pipelines....

productivity Intermediate

Notion Workspace Setup for Second Brain System

Design a complete Notion workspace structure to implement a "Second Brain" perso...

#productivity #notion #second brain

#power query #M code #data transformation

excel advanced

Excel Power Query Data Transformation Pipeline

Help me build an Excel Power Query transformation pipeline. My raw data source i...

#data #etl #data-warehouse

ETL Pipeline Design for Cloud Data Warehouse

You are a data engineer specializing in cloud data infrastructure. I need to des...

#data #quality #assessment

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#SQL #GROUP BY #window functions

SQL Advanced Queries: GROUP BY, HAVING, and Window Functions

Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...

#XLOOKUP #VLOOKUP #Excel formulas

excel Intermediate

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

#coding #database #schema

coding intermediate

Database Schema Designer for Web Application

Design an optimized database schema for my web application. Requirements: Appli...

SQL Query Builder for Complex Analytics

Help me write an optimized SQL query for my analytics need. Database details: D...

#data #sql #analytics

Data Cleaning Strategy and Python Script Generator

Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...

#data #cleaning #python

#kubernetes #k8s #deployment

coding advanced

Kubernetes Deployment Configuration: Production Best Practices Guide

Help me create a production-ready Kubernetes deployment configuration. My applic...

#SQL optimization #query performance #database

data Advanced

SQL Query Optimization Guide for Slow Database Queries

Analyze and optimize the following slow SQL query that is causing performance is...

#database migration #schema change #postgres

coding Advanced

ChatGPT Prompt: Database Migration Plan with Rollback Strategy

Design a safe database migration plan for [SCHEMA CHANGE]. Details: - Database:...

#sql migration prompt #rollback safe deployment #database schema change

coding Advanced

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

#sql #churn analysis #customer retention

data Advanced

ChatGPT prompt for building a SQL query to analyze customer churn patterns

Act as a senior data analyst specializing in customer retention. I need SQL que...

ETL Pipeline Design for Data Warehouse

Design an ETL (Extract, Transform, Load) pipeline for loading data from [source ...

#data #etl #pipeline

#coding #docker #docker-compose

coding Intermediate

Docker Compose Setup for Full-Stack Application

Write a complete docker-compose.yml for a full-stack application with the follow...

#SQL #window functions #analytics

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

excel advanced

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

#Python #web scraping #BeautifulSoup

coding intermediate

Python Web Scraping: BeautifulSoup & Requests Data Extraction

Help me write a Python web scraper to extract [type of data] from [website descr...

#coding #sql #query optimization

coding Advanced

ChatGPT prompt for reviewing SQL query performance and suggesting optimizations

Act as a senior SQL performance engineer. I will share a slow SQL query, the ta...

👁 7 views

coding Intermediate

ChatGPT prompt for building a Python web scraper with error handling and rate limiting

Act as a senior Python developer specializing in web scraping and data collectio...

#python #web scraping #beautifulsoup

👁 7 views