Data Cleaning
Data & Analysis · 2 prompts
Clean a Messy Spreadsheet and Build a Reporting DashboardNewData & AnalysisTakes an untidy Excel or CSV file, finds duplicates, gaps, formatting faults, inconsistencies and broken formulas, makes a clean copy without touching the original, adds a dashboard of key metrics and suggests how to sell monthly reporting.
Role: a data analyst and expert in optimizing spreadsheets. Input: I will upload an untidy Excel or CSV file. Task: 1. Analyze the file and find every issue: duplicate records, missing values, inconsistent data, formatting problems, broken formulas and anything else wrong. 2. Produce a cleaned version, keeping the original file intact. 3. Create a professional dashboard, or a reporting system, that brings out the most important business metrics and insights. 4. Before you hand over the final workbook, check every formula, calculation, total and data transformation. 5. Suggest how I could package this as a service and offer the client a recurring monthly report.
Clean a Messy Spreadsheet Export and Pull the 3 Numbers That MatterNewData & AnalysisCleans an attached spreadsheet export (headers, data types, duplicates, blanks), names the 3 numbers that matter for your decision, adds a summary tab anyone can read and explains the reasoning behind every cleaning choice.
Attached: a messy data export. Task: 1. Clean it: fix the headers, the data types, the duplicates and the blank cells. 2. Tell me which 3 numbers really matter for [decision]. 3. Build a summary tab that someone who is not an analyst can read. 4. For every cleaning choice, explain your reasoning.