Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "KPI query"

147 prompts matching "KPI query"

"KPI query" ✕ Clear all ✕
data Intermediate

Diagnose Why a Dashboard Metric Suddenly Changed

You are a senior data analyst. Walk me through a structured investigation for: [...

#analytics #debugging #metrics
👁 8 views
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...

#excel #power-query #reconciliation
👁 8 views
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...

#excel #dates #data cleaning
👁 8 views
data Intermediate

Write a SQL Query from a Plain-English Question

You are a SQL expert and data analyst. I will describe a question in plain Engli...

#data #sql #query
👁 8 views
data Intermediate

Translate a Business Question into a Defensible SQL Query

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

#sql #analytics #business-questions
👁 7 views
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]...

#excel #power-query #office-scripts
👁 7 views
data Intermediate

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
👁 7 views
excel Intermediate

Build a Dynamic Excel Dashboard Summary

Act as an Excel analyst. I will paste a table of raw data with these columns: [L...

#excel #dashboard #pivottable
👁 7 views
coding Advanced

Optimize a SQL Query for Speed

You are a database performance engineer. I will paste a slow SQL query and the t...

#coding #sql #database
👁 7 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
data Advanced

Data: Write a SQL Query for a Cohort Retention Table

I want a SQL query that returns a cohort retention table — rows = signup month, ...

#data #sql #retention
👁 6 views
excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#excel #data cleaning #power query
👁 6 views
excel Intermediate

Excel: Detect Duplicate Rows Across Multiple Key Columns

I have an Excel sheet where 'duplicates' aren't exact matches — they share a cus...

#duplicates #dedupe #power-query
👁 5 views
data Intermediate

Data: Rewrite a Slow Query Without Changing What It Returns

I have a SQL query that's slow. Make it fast while keeping the result set identi...

#data #sql #query-optimization
👁 5 views
coding Advanced

Coding: Write the SQL Index I Actually Need (Not the One I Think I Need)

I have a slow query and I'm about to add an index. Before I do, help me think it...

#coding #sql #performance
👁 5 views
data Advanced

Data: Write a Backfill Query That Won't Take Down the Database

I need to backfill [COLUMN/TABLE] with [LOGIC]. The table has [N] rows. Write th...

#data #sql #backfill
👁 5 views
data Intermediate

Write a SQL query to find customers who used to engage but have quietly dropped off

I want to find 'silently churning' customers — users who used to be active and h...

#data #sql #churn
👁 5 views
data Advanced

Rewrite a slow correlated subquery as a window function

I have a query with a correlated subquery that runs once per row to find each cu...

#SQL #window functions #query optimization
👁 5 views
data Intermediate

Build a SQL Style Guide That Survives a Growing Team

Act as a data platform tech lead. Write me a SQL style guide tailored to a 10-pe...

#sql #style-guide #dbt
👁 5 views
writing Intermediate

Generate an SEO-Friendly Blog Outline from a Keyword

Act as an SEO content strategist. Given a target keyword that I provide, produce...

#writing #seo #blog
👁 5 views
data Intermediate

Write and Explain a SQL Query From Plain English

Act as a SQL expert. I will describe what I want in plain English and you will w...

#data #sql #databases
👁 5 views
excel Advanced

Plan an Excel Macro or Office Script

You are an Excel automation expert. I will describe a repetitive task and you wi...

#excel #automation #vba
👁 5 views
finance advanced

Pick the right metric for a unit that does not fit the company's KPI tree

Act as an FP&A leader. A new business unit does not fit the company's existing K...

#finance #metrics #fpna
👁 4 views
excel Intermediate

Reconcile two versions of a budget when the row labels don't match

You are an Excel modeler. I'll paste two budget extracts from different teams. T...

#reconciliation #budget #fuzzy-match
👁 4 views
excel Intermediate

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#power-query #data-cleaning #pivot
👁 4 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval