Sales Data Descriptive Analysis
Budget: ₹750 – ₹1,250 INR
I have a raw export of sales transactions and want to understand what the numbers are actually saying. Using Power BI and Excel, please transform the dataset into an easy-to-read snapshot of performance so I can see totals, averages, trends over time, and key segments at a glance.
Scope
– Clean and structure the file so every column is usable.
– Produce descriptive statistics that highlight overall revenue, units sold, average order value, growth by month or quarter, and any noticeable seasonality.
– Build an interactive Power BI dashboard (with filters for date ranges, product categories, regions, and sales channels) and a companion Excel workbook that mirrors the same insights for quick offline reference.
– Include a brief written summary that calls out the headline findings, unusual patterns, and suggestions for what to explore next.
Acceptance
The work is complete when the dashboard refreshes without errors from the prepared data source, the Excel file contains matching figures, and your summary answers the fundamental questions: What happened? Where did it happen? How much did it happen?
Scope
– Clean and structure the file so every column is usable.
– Produce descriptive statistics that highlight overall revenue, units sold, average order value, growth by month or quarter, and any noticeable seasonality.
– Build an interactive Power BI dashboard (with filters for date ranges, product categories, regions, and sales channels) and a companion Excel workbook that mirrors the same insights for quick offline reference.
– Include a brief written summary that calls out the headline findings, unusual patterns, and suggestions for what to explore next.
Acceptance
The work is complete when the dashboard refreshes without errors from the prepared data source, the Excel file contains matching figures, and your summary answers the fundamental questions: What happened? Where did it happen? How much did it happen?