Customer Data Cleanup & Dashboard
Budget: ₹400 – ₹750 INR
I have a collection of customer information scattered across several spreadsheets and formats, and I need it transformed into one clean, insight-ready Excel workbook.
Here are the key tasks I need completed:
• Consolidate all customer records into a single, well-structured table.
• Standardize the phone numbers only—other fields can remain as they are for now.
• Remove duplicates and apply data-validation rules so future entries stay consistent.
• Build pivot tables, charts, and an interactive dashboard that lets me filter results by region, product, and date.
• Provide a step-by-step log of every cleaning action so I can reproduce or audit the process later.
Accuracy and clarity are essential; I want to be able to trust the numbers immediately and explore trends without fussing over data quality. If you’re comfortable handling customer data in Excel, automating phone-number formatting, and creating dashboards that make insights pop, I’m ready to get started.
Here are the key tasks I need completed:
• Consolidate all customer records into a single, well-structured table.
• Standardize the phone numbers only—other fields can remain as they are for now.
• Remove duplicates and apply data-validation rules so future entries stay consistent.
• Build pivot tables, charts, and an interactive dashboard that lets me filter results by region, product, and date.
• Provide a step-by-step log of every cleaning action so I can reproduce or audit the process later.
Accuracy and clarity are essential; I want to be able to trust the numbers immediately and explore trends without fussing over data quality. If you’re comfortable handling customer data in Excel, automating phone-number formatting, and creating dashboards that make insights pop, I’m ready to get started.