Back to projects

Data · BI May to Jun 2024

Sales Performance Dashboard

Abstract.From raw sales data to interactive KPIs and trends that support business decisions.

Role
Developer
Period
May to Jun 2024
Context
Personal project
Team
Solo
Table 1Results.
DAX KPI measures with category, region and customer drill-downs

01How it works

  1. Input Connect data Combine several sales datasets into one model.
  2. Step 02 Clean (Power Query) Cleanse and transform the data for analysis.
  3. Step 03 Model & DAX KPIs Revenue, quantity and repeat rate defined in DAX.
  4. Step 04 Visualize Interactive views by category, region and customer.
  5. Output Insights Surface the trends that drive decisions.
Fig. 1Sales Performance Dashboard, step by step.

02What I built

  1. Integrated multiple sales datasets into one data model in Power BI Desktop.
  2. Cleaned and transformed the data with Power Query.
  3. Defined KPIs (revenue, quantity, average price and repeat rate) with DAX, and analysed trends by category, region and customer.
Power BI sales dashboard with KPIs, charts and a sales map
Fig. 2Power BI sales dashboard with KPIs, charts and a sales map

03Technologies

  • Power BI
  • Power Query
  • DAX
  • SQL Server

On request

Request my resume

I share my resume on request. Tell me a little about yourself, and I'll email it to you once I've reviewed your request.

I am a…

Which document?

0 / 100 words

Your details are used only to handle this request and are never shared.