Search: "pivot chart"

Build Dynamic Dashboard With Slicers and Pivot Charts

Act as an Excel dashboard designer. I have a dataset of {{describe data: e.g., m...

#excel #dashboard #pivot

👁 13 views

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

#data #survey analysis #Python

data Advanced

Survey Data Analysis Pipeline with Python

Act as a data analyst. Write a complete Python pipeline to analyze survey data f...

#sales commission tracker #tiered commission excel #clawback formula

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

#chatgpt prompt for MRR waterfall #subscription revenue #excel finance model

ChatGPT Prompt for Creating an Excel Subscription Revenue Waterfall

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

#data #storytelling #presentation

data intermediate

Data Storytelling Report and Narrative Structure Framework

You are a data storytelling expert and communications consultant. I have analyze...

#finance #budget #variance-analysis

finance intermediate

Business Budget Variance Analysis Template Monthly Reporting

Build a complete budget variance analysis system for business financial manageme...

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

excel intermediate

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

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

#budget analysis #variance #financial template

excel intermediate

Excel Budget vs Actual Variance Analysis Template

Create a complete Excel budget vs. actual variance analysis template for [depart...

#tableau #churn #analytics

data intermediate

Tableau Dashboard Design for Customer Churn Analysis

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

#data #power-bi #dashboard

data intermediate

Power BI Dashboard Design: Sales Performance Metrics

Act as a Power BI specialist and data visualization expert. Help me design a sal...

#pivot table #grouping #calculated fields

excel intermediate

Excel Pivot Table: Advanced Grouping and Summarization Techniques

I have a dataset in Excel with the following columns: [list your columns, e.g., ...

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

#Gantt chart #project management #Excel timeline

Excel Gantt Chart: Project Timeline and Milestone Tracker

I want to build a professional Gantt chart in Excel for project management witho...

#charts #data-visualization #visual-storytelling

excel beginner

Excel Chart Types Selection & Visual Storytelling Guide

Help me choose the right Excel chart type and tell a compelling data story. I ha...

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

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

#data #chart #visualization

data Beginner

Choose the Right Chart for Your Dataset

Given my dataset and what I'm trying to communicate, help me pick the right char...

#excel #forecasting #revenue

Forecast Monthly Revenue With Excel's FORECAST.ETS

I have 36 months of revenue data (column A: month-end dates, column B: revenue)....

#data visualization #chart design #business intelligence

data beginner

Data Visualization Best Practices: Chart Selection and Design Guide

I have the following data and need to visualize it effectively: Data type: [desc...

👁 10 views