Sales Data Dashboard Build
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
I have raw sales data that first needs to be cleaned and properly formatted before any insights can be trusted. After the cleaning stage I want a focused analysis in Excel and SQL that zeroes in on revenue, profit, and sales-growth trends. The ultimate goal is to track overall business sales and performance, so the dashboard you build in Power BI must highlight monthly results alongside clear month-to-month growth indicators.
The workflow I envision is straightforward:
1. Clean and standardise all source tables.
2. Use SQL to create reproducible, well-commented queries that feed summary tables.
3. Carry out exploratory checks in Excel to validate the numbers.
4. Publish an interactive Power BI report that lets users slice by month while instantly seeing revenue, profit, and growth.
The report should load quickly, use intuitive visuals, and include tooltips or drill-through pages for deeper investigation. I value accuracy, transparent communication on progress, and timely delivery; if any data issues surface I expect them flagged early so we can solve them together.
If this first phase goes smoothly, there may be future extensions—perhaps breaking the view down further by product, geography, or salesperson—but for now the scope stays on the monthly revenue-profit-growth picture.
The workflow I envision is straightforward:
1. Clean and standardise all source tables.
2. Use SQL to create reproducible, well-commented queries that feed summary tables.
3. Carry out exploratory checks in Excel to validate the numbers.
4. Publish an interactive Power BI report that lets users slice by month while instantly seeing revenue, profit, and growth.
The report should load quickly, use intuitive visuals, and include tooltips or drill-through pages for deeper investigation. I value accuracy, transparent communication on progress, and timely delivery; if any data issues surface I expect them flagged early so we can solve them together.
If this first phase goes smoothly, there may be future extensions—perhaps breaking the view down further by product, geography, or salesperson—but for now the scope stays on the monthly revenue-profit-growth picture.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.