Search: "pivot chart"

#pivot table #sales analysis #monthly report

Excel Pivot Table Report for Monthly Sales Analysis

Design a step-by-step guide for creating an Excel pivot table report to analyze ...

#pivot table #sales analysis #excel

Build Dynamic Pivot Table from Sales Data

Act as an Excel data analyst. I have a sales dataset with columns: [Date, Region...

#excel #dashboard #slicers

Excel Dashboard with Dynamic Slicers

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

Pick the Right Chart Type When Stakeholders Keep Asking for Pie Charts of Everything

My stakeholders default to asking for pie charts for every dataset, including on...

#data #visualization #honesty

Visualize a comparison without inventing a story that isn't there

I want to visualize a comparison between [GROUP A] and [GROUP B] on [METRIC]. Th...

#tableau #churn #analytics

data intermediate

Tableau Dashboard Design for Customer Churn Analysis

Design a Tableau dashboard to analyze customer churn. Include: 1) Overall churn ...

#break-even analysis #financial modeling #startup finance

finance intermediate

Break-Even Analysis: Startup Product Calculation Template

Help me calculate and model the break-even analysis for [product/business type]....

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

#excel #dashboard #index-match

Build a Dynamic Dashboard Using INDEX-MATCH and Slicers

Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...

excel Advanced

Forecast Sales with Excel FORECAST.ETS

I have monthly sales data in Excel for the last 3 years. Help me build a 12-mont...

#excel #forecast #ets

#excel #burn-down #project management

Build a Dynamic Project Burn-Down Chart in Excel

Act as an Excel expert. I need to build a project burn-down chart that automatic...

#excel #gantt #project-management

Excel Project Gantt Chart from Task List

Generate an Excel Gantt chart from a task list with columns Task, Start Date, Du...

Data: Choose the Right Chart for the Question I'm Trying to Answer

I have a dataset and a question I want to answer. Don't just suggest a chart — i...

Data: Pick the Right Chart for Data That Has No Good Chart

I'm trying to visualize [DESCRIBE DATA — many dimensions, sparse, unequal catego...

#net worth #personal finance #wealth tracker

finance Beginner

Personal Net Worth Tracker Template Annual Wealth Review

Act as a personal finance coach. Build me an annual net-worth tracker. Include: ...

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

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

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

data Beginner

Choose the Right Chart Type for the Question You're Asking

I have [DATA DESCRIPTION] and I'm trying to answer [QUESTION] for [AUDIENCE]. Wa...

#data #analysis #statistics

data Advanced

Data: Stop a Stakeholder From Acting on a Spurious Correlation

A [ROLE] just sent me [CHART/CLAIM] showing [X correlates with Y] and they're ab...

#anomaly detection #metrics #WAU

Decide if a weekly metric drop is signal or noise

Our weekly active users dropped 8% week-over-week. Before I escalate, help me de...

#excel #power-query #unpivot

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...