Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "data cleaning"

636 prompts matching "data cleaning"

"data cleaning" ✕ Clear all ✕
marketing Advanced

Spot Which Channel Is Quietly Eating Your CAC and Lying About It

My overall CAC has crept up over the last [period]. Here's the channel mix: [lis...

#marketing #cac #attribution
👁 8 views
coding Advanced

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database
👁 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
data Beginner

Data: Cut a Dashboard Down to the 5 Metrics Anyone Actually Uses

I have a dashboard that's grown to 30 charts and nobody knows where to look. Aud...

#data #dashboards #metrics
👁 8 views
excel Advanced

Excel: Write a VBA Macro That Emails a Filtered Report to Each Manager

I have a master sheet with sales data tagged by manager. I want a VBA macro that...

#excel #vba #automation
👁 8 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
👁 8 views
legal Advanced

Legal: Decide Whether a New Feature Triggers a Privacy Review

We're shipping [FEATURE DESCRIPTION]. Help me decide whether this needs to go th...

#legal #privacy #compliance
👁 8 views
coding Advanced

Coding: Decide Whether to Split a Service Before It Hurts

Our [MONOLITH/SERVICE] is growing and the team is debating splitting it: [SYMPTO...

#coding #architecture #microservices
👁 8 views
data Advanced

Data: Design a Schema That Won't Need a Migration in 6 Months

I'm designing a schema for [DOMAIN] from scratch. The team wants to ship fast, b...

#data #database-design #schema
👁 8 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

I have an Excel sheet with about 4,000 customer records. The Name column is a di...

#excel #data-cleaning #names
👁 8 views
excel Advanced

Build a Weekly KPI Dashboard in Excel That Doesn't Break When Someone Renames a Tab

I'm building a weekly KPI dashboard in Excel for a small operations team. The so...

#excel #dashboard #kpi
👁 8 views
business Advanced

Decide Whether to Launch a Feature Customers Asked For But Nobody on the Team Believes In

My team has a feature request that 12 customers have explicitly asked for over t...

#business #strategy #product
👁 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
data Intermediate

Write a query that survives the source table being renamed in six months

I need to write a SQL query that pulls weekly metrics for a dashboard. The sourc...

#sql #data #query
👁 8 views
finance Intermediate

Find the 3 expense lines that drifted up while no one was watching

I'm reviewing the last 6 months of company expenses. I want to find the 3 line i...

#finance #expenses #budget
👁 8 views
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 Intermediate

Build a self-updating commission tracker for a sales team in Excel

Act as a RevOps analyst. Help me design an Excel commission tracker that auto-ca...

#commission #sales #formulas
👁 8 views
excel Advanced

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda
👁 8 views
excel Advanced

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

#excel #fuzzy-match #deduplication
👁 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
data advanced

Decide which metric to make the team's North Star without flattening the work

Act as a data leader who has watched teams pick the wrong North Star and live wi...

#data #metrics #north-star
👁 8 views
data intermediate

Write a metric definitions document that survives one analyst quitting

Act as a head of data preparing for an analyst's last day. I want the metric def...

#data #documentation #metrics
👁 8 views
coding Advanced

Review a pull request for the thing the author didn't realize they were doing

You're a senior engineer doing a code review. I'll paste the diff. Don't comment...

#code-review #pr #reviews
👁 8 views
data intermediate

Analyze a Dataset and Find Insights

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

#data #analysis #insights
👁 8 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval