Search: "tables"

#excel #pivot table #sales analysis

Pivot Table Mastery for Multi-Year Sales Data Analysis

Act as an Excel data analyst. I will paste a sales dataset with columns Date, Re...

👁 9 views

#excel #pivot tables #data cleaning

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

👁 9 views

design intermediate

Email Newsletter Design: Responsive HTML Template Best Practices

Help me design and code a high-quality responsive email newsletter template. Con...

#email-design #html-email #newsletter-design

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

#excel #pivot-table #calculated-field

Excel Pivot Table Calculated Field for Margin Percentage by Segment

I have a sales table with columns: order_id, date, customer_segment, product, re...

#data #data-quality #monitoring

data Advanced

Data Quality Monitoring Rules for a Production Table

I need to monitor data quality on a production table loaded daily from upstream ...

#excel #dashboard #slicers

Excel Dashboard with Dynamic Slicers

Help me design a single-page Excel dashboard for KPIs (revenue, orders, conversi...

data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization

👁 7 views

#excel #scenarios #data tables

Create a What-If Scenario Comparison Table With Data Tables

I have a financial model with three driver inputs (cells B2: pricing, B3: churn,...

👁 6 views

excel Advanced

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#excel #goal-seek #solver

👁 6 views

excel Advanced

Build a Weekly KPI Dashboard in Excel That Doesn't Break When Someone Renames a Tab

I'm building a weekly KPI dashboard in Excel for a small operations team. The so...

#excel #dashboard #kpi

👁 6 views

#excel #pivot-table #calculated-field

ChatGPT Prompt: Excel Pivot Table Calculated Field for Custom Metrics

You are an Excel pivot table expert. Help me add a calculated field to my pivot ...

👁 5 views

#excel #pivot-tables #executive-reporting

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...

👁 5 views

coding Intermediate

Write a SQL query that you'll still understand in six months

Write a SQL query that answers this question: [QUESTION]. Tables and columns I h...

#coding #sql #readability

👁 5 views

excel Advanced

Excel: Replace a Fragile VLOOKUP Chain With Power Query

I have a workbook stitched together by [N] VLOOKUPs across [M] sheets, and it br...

#excel #power-query #vlookup

#data #database-design #schema

data Advanced

Data: Design a Schema That Won't Need a Migration in 6 Months

I'm designing a schema for [DOMAIN] from scratch. The team wants to ship fast, b...

#excel #pivot-table #data-cleanup

Find the rows that broke a pivot table without scrolling 40,000 rows

My pivot table is showing #N/A or a mysterious 'blank' row, and the source data ...

#pivot tables #dashboard #monthly report

excel Beginner

Turn a flat sales export into a one-screen monthly summary

I have a sales export with columns: order_id, date, region, sales_rep, product_c...

data Intermediate

Write a query that survives the source table being renamed in six months

I need to write a SQL query that pulls weekly metrics for a dashboard. The sourc...

#sql #data #query

data Intermediate

Build a SQL Style Guide That Survives a Growing Team

Act as a data platform tech lead. Write me a SQL style guide tailored to a 10-pe...

#sql #style-guide #dbt

finance Advanced

Translate the P&L into a one-page story a non-finance executive will read

Act as a controller. Translate our [PERIOD] P&L into a one-page narrative for no...

#finance #reporting #pnl

#excel #data validation #conditional formatting

excel Beginner

Design a self-updating Excel tracker with data validation

Help me build an Excel tracker (for tasks, inventory, or expenses — I'll tell yo...