Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "pivot tables"

113 prompts matching "pivot tables"

"pivot tables" ✕ Clear all ✕
excel intermediate

Build a Dynamic KPI Dashboard in Excel

Create a dynamic KPI dashboard in Excel for [business/department]. The dashboard...

#excel #dashboard #kpi
👁 24 views
data Advanced

SQL for Business Intelligence

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

#data #SQL #business intelligence
👁 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
👁 19 views
design intermediate

Responsive Web Design: Breakpoints and Layout Strategy Guide

Help me design a responsive web layout strategy for [website type: marketing sit...

#responsive design #CSS #web layout
👁 19 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
👁 18 views
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 #sales analysis
👁 17 views
excel Advanced

Employee Performance Dashboard Pivot

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

#excel #pivot table #dashboard
👁 17 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
👁 17 views
coding Advanced

Authentication System with JWT and Refresh Tokens

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

#JWT #authentication #refresh tokens
👁 16 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

ChatGPT prompt for monthly budget variance report from exported accounting data

I need help turning exported accounting data into a monthly budget variance repo...

#budget variance report #excel finance analysis #accounting export cleanup
👁 16 views
excel Advanced

ChatGPT Prompt for Creating an Excel Subscription Revenue Waterfall

Act as a finance analyst who specializes in subscription businesses. Help me bui...

#chatgpt prompt for MRR waterfall #subscription revenue #excel finance model
👁 16 views
coding advanced

SQL Stored Procedure for Data Transformation

Write a SQL stored procedure in [MySQL / PostgreSQL / SQL Server] for the follow...

#coding #sql #stored-procedure
👁 16 views
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
👁 16 views
data intermediate

Python Pandas Advanced GroupBy and Aggregation Techniques

Demonstrate advanced Pandas GroupBy operations for [dataset type, e.g., sales tr...

#pandas #python #groupby
👁 16 views
excel intermediate

Excel Dashboard Builder from Raw Data

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

#excel #dashboard #visualization
👁 16 views
data Advanced

SQL Query Optimizer with Explain-Plan Reading

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

#sql #optimization #performance
👁 16 views
Excel Intermediate

Data Analysis Report Template

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

#Excel #analysis #reporting
👁 15 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
👁 15 views
data Advanced

ETL Pipeline Design: Best Practices for Data Warehouse Architecture

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

#ETL #data warehouse #data pipeline
👁 15 views
data Advanced

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres
👁 15 views
excel Intermediate

ChatGPT prompt for Excel inventory reorder tracker with lead times

Act as an Excel operations specialist. I need an inventory reorder tracker for a...

#excel inventory tracker #reorder point #stock management
👁 14 views
excel Advanced

ChatGPT prompt for Excel sales commission tracker with tiered rates and clawbacks

Act as a sales operations analyst who is great at Excel. I need a commission tra...

#sales commission tracker #tiered commission excel #clawback formula
👁 14 views
data Beginner

ChatGPT Prompt for Building a Weekly SaaS KPI Narrative from Raw Metrics

Act as a data storyteller for a SaaS business. I will paste weekly KPI numbers s...

#chatgpt prompt for KPI summary #SaaS metrics #weekly report
👁 14 views
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...

#sql optimization #query tuning #performance
👁 14 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval