Sales Data Analysis & Dashboard
Publicada el 2026-07-21
Descripción de la oferta
I have a historical sales dataset that first needs to be put through a solid data-hygiene routine—removing duplicates, patching or flagging missing values, and deciding how to handle the inevitable outliers. Once the numbers are trustworthy, I want to dig into them with SQL to uncover trends and relationships, then surface the story in an interactive Power BI dashboard. The dashboard should let any stakeholder slice performance by date, product, and region while keeping three headline KPIs front and centre: Sales Revenue, Customer Acquisition, and Profit Margin. Basic time-series visuals are fine, but I’m expecting drill-throughs, dynamic filters, and a clean layout that works on both desktop and tablet. I usually move data between Excel and a SQL environment, so fluency in both is essential. If you prefer staging the data elsewhere, that’s fine as long as the workflow is repeatable and well documented. Deliverables • A cleaned, documented dataset (Excel/CSV + SQL table) • The SQL scripts or stored procedures used for analysis • An editable Power BI .pbix file with all visuals, DAX measures, and data model • A short hand-off note or Loom-style walkthrough explaining how to refresh everything Please add one or two links or screenshots of dashboards you’ve built that highlight similar KPIs or data-quality challenges. I’ll review portfolios as they come in and plan to choose quickly so we can get started.
Skills
Fuente original: freelancer