Search: "power"

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

👁 8 views

#power query #CSV import #data transformation

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

#creative #fantasy #world-building

creative intermediate

Fantasy World Building: Magic System and Lore Template

Act as a fantasy world building specialist and author consultant. Help me design...

#ab-test #power-analysis #experimentation

A/B Test Power Analysis Pre-Launch Check

Act as an experimentation statistician. Before launching an A/B test on [METRIC]...

#ab testing #statistics #hypothesis testing

ChatGPT Prompt: Statistical Hypothesis Testing for Product Experiments

Help me design a hypothesis test for a product experiment. Context: - Hypothesi...

#excel #power query #m code

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

#business #competitive analysis #porter

business Advanced

Competitive Teardown Framework Using Porter's Five Forces

You are a strategy MBA professor. Run a Porter's Five Forces analysis for [INDUS...

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#excel #text-functions #parsing

Convert Messy Text Column Into Clean Structured Fields

I have a single column in Excel containing messy entries like "{{example raw ent...

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

#power query #excel #web scraping

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

👁 6 views

#data #ab testing #statistics

A/B Test Power Analysis and Sample Size Calculator Walkthrough

Act as a statistics tutor for product analysts. Walk me through a complete power...

👁 6 views

creative advanced

Fantasy World-Building for Creative Writing

Help me build a detailed fantasy world for a [novel / short story / game / scree...

#creative #writing #fantasy

#power query #excel #data combine

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

#ab testing #statistics #significance

A/B Test Analysis Statistical Significance Sample Size Calculator

You are a data scientist. Help me analyze an A/B test on [METRIC] comparing [VAR...

#xlookup #formulas #excel

Excel XLOOKUP Formula Builder for Multi-Criteria Match

Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...

#creative #worldbuilding #fiction

creative Advanced

Create a World-building Bible for a New Setting

You are a world-building consultant. Help me draft a bible for a new fictional s...

#duplicates #data cleaning #excel

Excel Formula to Detect Duplicate Records Across Columns

I need an Excel formula to detect duplicate records based on a combination of mu...

#stakeholder #project management #analysis

business Intermediate

Stakeholder Analysis Matrix for Cross-Functional Project

Create a stakeholder analysis matrix for the project: [PROJECT NAME]. Project go...

#dates #iso #data cleaning

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

👁 3 views