E-Commerce Data Cleanup & Dashboard

Customer: AI | Published: 04.12.2025

My online store has outgrown its current spreadsheets and I’m running into a familiar trio of headaches within the product catalogue: duplicate rows, missing attributes, and the occasional price or SKU that simply isn’t correct. I need a detail-oriented data specialist who can transform that messy inventory file into a single source of truth and then turn those clean numbers into a sales-performance dashboard I can rely on every day. The workflow I have in mind is straightforward: • Clean the product dataset – deduplicate, fill or flag blanks, validate key fields, and standardise naming conventions so every item lines up with the right category and variant. • Deliver the polished master file (CSV or Excel) plus any scripts or queries you used so I can rerun the process later. • Build an interactive sales-performance dashboard (Power BI, Tableau, or a similar modern tool) that surfaces revenue trends, units sold, top products and categories, and lets me slice by date, channel, and region. • Provide a short written report that summarises the main data issues you found, the cleaning steps taken, and any sales insights that leap off the page once the numbers are trustworthy. I’ll share the raw export as soon as we agree on the stack you prefer. If you can work quickly, document your process, and present the final visuals in a clean, branded layout, we’re a perfect match.