Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "data-warehouse"

624 prompts matching "data-warehouse"

"data-warehouse" ✕ Clear all ✕
excel Intermediate

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

#excel #sumifs #debugging
👁 4 views
data Intermediate

Choose the chart that fits my data and my question

I'll tell you what data I have and the question I'm trying to answer with it. Re...

#data #charts #visualization
👁 4 views
excel Beginner

Clean and Deduplicate a Messy Excel Contact List

Act as an Excel data-cleaning specialist. I have a contact list with inconsisten...

#excel #data cleaning #deduplicate
👁 4 views
data Intermediate

Turn Raw Numbers into a Clear Data Story

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

#data #storytelling #insights
👁 4 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
👁 4 views
excel Beginner

Convert a Business Question into an Excel Formula

You are an Excel formula expert. I want to answer this question from my spreadsh...

#excel #formulas #xlookup
👁 4 views
data Intermediate

Clean and Deduplicate a Raw Dataset

Act as a data engineer. I have a raw dataset with these issues: [DESCRIBE — dupl...

#data #cleaning #etl
👁 4 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
👁 4 views
excel Intermediate

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...

#excel #data-validation #dropdown
👁 4 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
data Advanced

Interpret the Results of an A/B Test

You are an experimentation analyst. I will give you the numbers from an A/B test...

#data #ab-testing #statistics
👁 4 views
data Intermediate

Data Quality Audit Checklist for New Dataset

Run a data quality audit on the dataset described below. Check for: missing valu...

#data #quality #audit
👁 3 views
excel Intermediate

Excel: Rebuild a Pivot That Lies to Stakeholders

Look at this pivot table setup: [PASTE COLUMNS, FILTERS, AND VALUES]. Tell me wh...

#excel #pivot-tables #analysis
👁 3 views
excel Intermediate

Clean up a sheet where dates are stored in five different formats

I inherited a spreadsheet where the 'Date' column has dates entered as '3/5/26',...

#excel #data cleaning #dates
👁 3 views
legal Intermediate

Figure out which privacy regulations actually apply to a small business

I run a small business. I keep getting told I 'need to be GDPR compliant' and 'C...

#legal #privacy #compliance
👁 3 views
excel Advanced

Write a VBA macro that does one boring task perfectly instead of ten things badly

I want to automate a small, repetitive Excel task with VBA. The task is: [DESCRI...

#excel #vba #macro
👁 3 views
data Intermediate

Clean a messy dataset without losing the rows that actually mattered

I have a dataset with [N] rows and [LIST PROBLEMS: missing values, duplicates, m...

#data #cleaning #preprocessing
👁 3 views
legal Intermediate

Write a privacy notice users might actually read

Write a user-facing privacy notice for [PRODUCT]. I'll separately have lawyers w...

#legal #privacy #transparency
👁 3 views
data Intermediate

Fix a column where 30% of values are 'kind of right but not parseable'

I have a column in a dataset that's supposed to be a phone number, date, or addr...

#data #cleaning #etl
👁 3 views
legal Advanced

Figure out if a new data flow needs a privacy review or just a note in the doc

We're about to start collecting [type of data] from [type of user] for [purpose]...

#legal #compliance #privacy
👁 3 views
excel Intermediate

Detect mixed date formats in one column and pick the safest fix

Act as a spreadsheet auditor. I will paste 20 cells from a date column that came...

#dates #data cleaning #DATEVALUE
👁 3 views
data Beginner

Pick the right chart when you can't decide between a bar and a line

I want to show how 4 product lines have grown over 12 months. I keep flip-floppi...

#charts #visualization #chart selection
👁 3 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
👁 3 views
excel Advanced

Build a Cohort Retention Heatmap Workbook in Excel

Act as a senior analytics engineer. I will paste a list of user signup events wi...

#cohort #retention #heatmap
👁 3 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
👁 3 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval