Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "Power BI"

79 prompts matching "Power BI"

"Power BI" ✕ Clear all ✕
excel Intermediate

Convert a Messy Survey Export Into Clean Long-Format Data

I exported a survey to Excel. Each respondent is one row, each question is its o...

#excel #power query #survey
👁 11 views
excel Intermediate

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#excel #data-cleaning #power-query
👁 11 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
👁 10 views
excel Advanced

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

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...

#power-query #csv #data-cleaning
👁 10 views
excel Intermediate

Excel: Convert a Messy Paste-from-PDF Table Into a Clean Dataset

I pasted a table from a PDF and Excel split it badly — values are stuck together...

#excel #power-query #data-cleaning
👁 10 views
excel Advanced

Excel: Replace a Fragile VLOOKUP Chain With Power Query

I have a workbook stitched together by [N] VLOOKUPs across [M] sheets, and it br...

#excel #power-query #vlookup
👁 10 views
creative Advanced

Creative: Make This Villain More Than 'Wants Power Because Evil'

Here's my antagonist: [PASTE BRIEF]. Right now their motivation is basically 'wa...

#creative #character #antagonist
👁 10 views
excel Intermediate

Decide when to use Power Query vs formulas vs a real database

I keep solving the same data problem three different ways across my team's sprea...

#excel #power query #decision
👁 10 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

Reconcile two lists that should match but somehow never do

You are an Excel power user. I have two lists in Excel that are *supposed* to be...

#excel #vlookup #reconciliation
👁 10 views
data Advanced

Choose between A/B test variants when results are statistically tied

My A/B test ran for 3 weeks. Variant B is +0.4% on the primary metric, not stati...

#data #ab-testing #experimentation
👁 10 views
excel Intermediate

Excel: Clean a Messy Address Column Without Losing Edge Cases

I have a column of free-text addresses scraped from a form: [PASTE 20 SAMPLES]. ...

#excel #power-query #data-cleanup
👁 9 views
excel intermediate

Trace a broken cell reference across a workbook before fixing it blindly

Act as an Excel auditor. A formula on the summary tab is returning #REF! after a...

#excel #auditing #debugging
👁 9 views
business Intermediate

Stakeholder Map for a Cross-Functional Project

Build a stakeholder map for the following cross-functional project. Categorize e...

#business #stakeholder-management #project-management
👁 8 views
data Advanced

A/B Test Sample Size and Duration Calculator

Calculate the required sample size and test duration for an A/B test given: base...

#data #ab-testing #experimentation
👁 8 views
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 #automation #power-query
👁 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

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
creative Intermediate

Cut a dialogue scene by 30% without losing what the characters are doing to each other

Cut the dialogue scene below by ~30%. Preserve: the underlying power move (who i...

#dialogue #cutting #fiction
👁 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
data Intermediate

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-modeling #spreadsheets
👁 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
End-of-content Ad728 × 90AdSense placeholder — will activate after approval