Power BI Sales Performance Analysis Project

Project Overview

This project simulates a real-world commercial sales analytics engagement where a Data Analyst is tasked with delivering executive-level insights into sales performance across regions, stores, products, and sales channels.

Using Power BI, the project focuses on analysing current-year sales, budget alignment, and year-on-year performance, enabling business leaders to quickly understand where the business is winning, underperforming, or at risk.

The final deliverable is an interactive Power BI dashboard designed for decision-makers, with clear KPIs, drill-down capabilities, and dynamic narratives that explain what is happening and why.

Business Objective

The purpose of this project is to support commercial and strategic decision-making by answering key business questions such as:

• Are we meeting our sales targets?

• How does current performance compare to last year?

• Which regions, stores, and channels are driving or dragging performance?

• Are sales changes driven by volume, price, or customer behaviour?

Target Audience

• Executives & Senior Leadership

• Regional & Store Managers

• Commercial & Finance Teams

Decisions Enabled

• Resource reallocation across regions or stores

• Channel investment decisions (online vs physical)

• Performance management and forecasting

  DATASET

  • Check the exercise files for the project Dataset