Search: "pivot table"

#excel #pivot-table #reporting

Excel Pivot Table Design for Management Reporting

You are an Excel reporting expert. I need to build a professional pivot table re...

#excel #scenario-manager #what-if

excel advanced

Excel Scenario Manager and What-If Analysis Business Planning

You are a financial modeling expert using Excel. I need to build a what-if analy...

#power query #data cleaning #ETL

Excel Power Query: Clean & Transform Raw Data Automatically

I have raw data in Excel that needs cleaning and transformation. Help me build a...

#coding #database #schema

coding intermediate

Database Schema Designer for Web Application

Design an optimized database schema for my web application. Requirements: Appli...

#product-roadmap #startup #prioritization

business intermediate

Startup Product Roadmap: Quarterly Planning & Prioritization Framework

Build a product roadmap for my startup for the next [X QUARTERS]. My context: P...

#SQL optimization #query performance #database

data Advanced

SQL Query Optimization Guide for Slow Database Queries

Analyze and optimize the following slow SQL query that is causing performance is...

#spaced repetition #study #learning

education Intermediate

Spaced Repetition Study Schedule Long-Term Retention Method

Act as a learning scientist. Build a spaced-repetition study schedule for [SUBJE...

#positioning #competitive strategy #brand strategy

marketing Advanced

ChatGPT Prompt: Competitive Positioning Statement and Differentiation Map

Develop competitive positioning for [COMPANY/PRODUCT] that clearly differentiate...

#power query #excel #web scraping

excel Advanced

ChatGPT Prompt: Excel Power Query M Code for Web Data Scraping

Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...

#excel #index match #formula

excel Advanced

INDEX/MATCH Formula Generator with Dynamic Multi-Criteria Lookup

You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...

#data #visualization #charts

data Intermediate

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

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

#excel #pivot table #dashboard

excel Advanced

Employee Performance Dashboard Pivot

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

#excel #scheduling #shift planning

excel Beginner

ChatGPT Prompt for Excel Shift Schedule Conflict Checker

Help me build an Excel shift scheduling sheet that automatically flags staffing ...

#competitive positioning #messaging #product launch

business Advanced

ChatGPT Prompt for Competitive Positioning Matrix Before a Product Launch

Act as a product marketing strategist. Help me create a competitive positioning ...

#writing #technical-documentation #api

writing intermediate

Technical Documentation for API Endpoints

Write clear technical documentation for the following API endpoint: [paste endpo...

#api #documentation #technical-writing

writing advanced

Technical Documentation Writing Guide for API Reference

Write comprehensive API reference documentation for [API endpoint or feature]. I...

data intermediate

Python Pandas Advanced GroupBy and Aggregation Techniques

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

#pandas #python #groupby

#excel #dashboard #slicer

Excel Dashboard with Slicers and Conditional Formatting

Act as an Excel dashboard designer. I want to build an interactive dashboard wit...

#data #quality #assessment

data intermediate

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#pivot table #grouping #calculated fields

Excel Pivot Table: Advanced Grouping and Summarization Techniques

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

#excel #data-validation #dropdown

Excel Data Validation Dropdown Lists for Error-Free Data Entry

Create a comprehensive guide for implementing Excel data validation with dropdow...

#data #looker-studio #dashboard

data intermediate

Looker Studio Dashboard Design Best Practices Business Reporting

Create a complete guide for designing professional Looker Studio dashboards for ...

#finance #budget #variance-analysis

finance intermediate

Business Budget Variance Analysis Template Monthly Reporting

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