Search: "pivot tables"

#data #SQL #business intelligence

SQL for Business Intelligence

Write SQL queries for a business intelligence dashboard. Tables: orders, custome...

👁 26 views

design intermediate

Figma Design Handoff: Specification Documentation for Developers

Act as a product designer and design systems expert with experience in Figma-to-...

#design #figma #handoff

👁 23 views

coding Intermediate

Python Script to Parse and Analyze CSV Data

Write a Python script that reads a CSV file named "data.csv", performs analysis,...

#coding #python #csv

👁 22 views

coding Intermediate

SQL Query - Complex Joins and Aggregation

Write SQL queries for a database with tables: orders (id, customer_id, order_dat...

#coding #SQL #joins

👁 21 views

data Intermediate

ChatGPT Prompt for Data Dictionary from a Messy Analytics Schema

Help me create a clear data dictionary from a messy analytics database so busine...

#data dictionary #analytics schema #documentation

👁 21 views

#ETL #data warehouse #data pipeline

ETL Pipeline Design: Best Practices for Data Warehouse Architecture

Help me design a production-grade ETL (Extract, Transform, Load) pipeline for a ...

👁 21 views

coding Intermediate

ChatGPT Prompt for SQL Query to Build Weekly Active User Trend and Segments

Write a SQL query for weekly active user reporting from this schema: [paste tabl...

#coding #sql #analytics

#Excel #analysis #reporting

Excel Intermediate

Data Analysis Report Template

Design a data analysis report template in Excel for [DATA TYPE]. Include: execut...

#sql #churn analysis #customer retention

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...

#excel #dashboard #visualization

excel intermediate

Excel Dashboard Builder from Raw Data

I have raw data in Excel and want to create a professional dashboard. My data in...

#sql #optimization #performance

SQL Query Optimizer with Explain-Plan Reading

Act as a database performance engineer. I will paste a slow SQL query and its EX...

#email #internal-comms #leadership

email Intermediate

Internal Announcement Email for a Major Product Pivot

Help me draft an internal email to the entire engineering and product team annou...

customer-service Intermediate

De-escalation Script for Angry Customer Complaint

Create a de-escalation script for handling an angry customer complaining about [...

#de-escalation #angry customer #support

#excel #pivot table #sales analysis

excel Intermediate

Sales Analysis Pivot Table

Guide me step by step to create a pivot table in Excel for sales analysis. My da...

#excel #pivot table #dashboard

excel Advanced

Employee Performance Dashboard Pivot

Create a pivot table setup for employee performance analysis. Data columns: Empl...

#JWT #authentication #refresh tokens

coding Advanced

Authentication System with JWT and Refresh Tokens

Build a complete authentication system with JWT access tokens and refresh tokens...

#sql optimization #query tuning #performance

coding Advanced

ChatGPT Prompt for Refactoring a Slow SQL Query Without Breaking Results

Help me refactor a slow SQL query so it runs faster without changing the busines...

#excel #pivot table #sales analysis

excel Beginner

Excel Pivot Table Sales Analysis from Raw Data

Guide me through creating a comprehensive sales analysis using Excel Pivot Table...

coding Advanced

SQL Query Optimization for Slow Database Queries

Help me optimize this slow SQL query: [paste your query]. The database is [MySQL...

#coding #sql #database

#data #documentation #data-dictionary

data Beginner

ChatGPT Prompt: Data Dictionary Documentation Template for Production Tables

You are a data governance lead. Generate a data dictionary template I can fill o...

#data #documentation #metrics

data Intermediate

Write a Data Definition Doc That Stops 'Wait, How Is This Calculated' Questions

Help me write a data definition doc for [METRIC NAME] that ends ambiguity foreve...