Large Dataset Excel Analysis Cleanup
Budget: ₹12,500 – ₹37,500 INR
I have a spreadsheet containing well over 10,000 rows that needs to be transformed from a raw dump into an accurate, decision-ready file. The work is focused on data analysis, but it starts with rigorous data cleaning and organizing.
Here’s what I need from you:
• Clean and structure the raw data – remove duplicates, standardize formats, and flag anomalies.
• Build a clear, documented workflow in Excel (Power Query or traditional formulas/macros—use whichever is most efficient) so the process is repeatable.
• Produce summary analyses: pivot tables, key metrics, and a handful of intuitive charts that reveal trends and outliers.
• Deliver a finalized workbook plus a short “how-it-works” note so I can refresh the analysis when new data arrives.
The file is already in XLSX format and can be shared immediately. Accuracy, a logical worksheet layout, and easy-to-follow formulas are essential.
Here’s what I need from you:
• Clean and structure the raw data – remove duplicates, standardize formats, and flag anomalies.
• Build a clear, documented workflow in Excel (Power Query or traditional formulas/macros—use whichever is most efficient) so the process is repeatable.
• Produce summary analyses: pivot tables, key metrics, and a handful of intuitive charts that reveal trends and outliers.
• Deliver a finalized workbook plus a short “how-it-works” note so I can refresh the analysis when new data arrives.
The file is already in XLSX format and can be shared immediately. Accuracy, a logical worksheet layout, and easy-to-follow formulas are essential.