Search: "power analysis"

#business #competitive analysis #positioning

business Intermediate

Compare yourself to a competitor without flattering yourself

Compare my company [MY COMPANY + ONE-LINE DESCRIPTION] to [COMPETITOR]. Do this ...

#excel #automation #power-query

excel Advanced

Schedule an Excel file refresh without setting up a server

I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....

#excel #power-query #reconciliation

excel Advanced

Reconcile two messy spreadsheets when the join keys don't match

I have two Excel files I need to reconcile, but the join columns aren't clean ma...

#marketing #competitor-analysis #strategy

marketing Advanced

Audit a competitor without convincing yourself you need to copy them

I'm doing a competitor audit on [competitor] before [decision — repositioning, n...

#data #analysis #insights

data intermediate

Analyze a Dataset and Find Insights

Act as a data analyst. I have a dataset with these columns: [list columns]. Sugg...

#excel #dates #data cleaning

excel Intermediate

Turn a messy date column into clean, consistent dates in Excel

I have an Excel column of dates entered in mixed formats (some text, some real d...

#data #analysis #planning

data Advanced

Write the analysis plan before I touch the data

I have a dataset and a business question (I'll describe both). Before I start qu...

#business #swot #strategy

business Beginner

Run a SWOT Analysis with Actionable Recommendations

You are a business strategy consultant. Conduct a structured SWOT analysis for t...

#data #storytelling #insights

Turn Raw Numbers into a Clear Data Story

Act as a data storyteller who helps non-technical stakeholders understand number...

#finance #decision #comparison

finance Intermediate

Compare Two Financial Options with a Clear Breakdown

You are a financial decision analyst who helps people think clearly about money ...

#cohort analysis #retention #saas

data Advanced

Cohort Retention Analysis Framework SaaS Product Health

Act as a product analyst. Build a cohort retention analysis for [PRODUCT] using ...

data Advanced

Cohort Retention Analysis from Event Log

From the event log table with columns user_id, event_name, occurred_at, build a ...

#data #cohort #retention

#sql #analytics #business-questions

Translate a Business Question into a Defensible SQL Query

You are an analytics engineer. I will paste a fuzzy business question (e.g., 'ho...

#excel #power-query #office-scripts

excel Advanced

Automate a weekly Excel report that pulls from three CSVs and emails itself

You are an automation engineer. I get three CSVs every Monday — [CSV_1], [CSV_2]...

#hr #pay-equity #compensation

hr Advanced

Run a pay equity audit that finds the actual gaps, not the surface ones

Act as a compensation analyst. Run a pay equity audit across [DIMENSION — gender...

#refactoring #imports #modules

coding Intermediate

Untangle a circular import that the codebase has been living with for years

Act as a refactoring lead. There's a circular import between two modules that th...

#business #negotiation #batna

business Advanced

Prepare for a Negotiation with a BATNA Worksheet

Act as a negotiation coach trained in principled negotiation. Help me prepare fo...

#data #schema #spreadsheet

data Beginner

Design a Clean Data Collection Spreadsheet or Schema

You are a data architect who helps people set up clean data from the start so it...

#coding #algorithms #optimization

coding Advanced

Explain and Optimize an Algorithm

You are an expert algorithms tutor. Help me understand my algorithm's complexity...

Write and Explain a SQL Query

You are an expert SQL expert. Help me write a correct SQL query and understand e...

#data #sql #query

#data #data-modeling #spreadsheets

Design a Simple Data Model for My Spreadsheet

You are a spreadsheet/data modeling expert. Help me structure my data so it's cl...

#data #data-cleaning #quality

Write a Data Cleaning Checklist

You are a data-quality analyst. Based on the dataset I describe, produce a thoro...