KPIs-Sales-Performance-Dashboard

📊 KPIs Performance Dashboard – Power BI Project

🔹 Project Overview

This project is a Sales Performance Dashboard built in Power BI to analyze how actual sales performed against targets.
It provides insights at monthly, YTD, and salesperson levels, enabling management to track progress and identify performance gaps.

---

🔹 Files in This Repository

• 📂 Dataset
• 📂 Power BI File
• 📂 Dashboard Snapshot

---

🔹 Key Features

✅ KPI Cards – Actual Sales, Target Sales, Variance, Variance %, YTD Numbers
✅ Monthly Performance Chart – Actual vs Target with variance indicators
✅ Target Achievement Tracker – Highlights how many months reached targets
✅ Salesperson Performance – Actual vs Target with variance % and trends
✅ Team Performance Comparison – Breakdown by groups (Delish, Jucies, Tempo, Yummies)
✅ Trend Analysis – Identifies declining sales periods

---

🔹 Insights Derived

• Total Sales Actual = $19M
• Total Sales Target = $19M
• Variance = -367K (-1.9%)
• Only 2 out of 14 months met the target
• Sales declined by 24.87% in 3 months (Nov 2023 – Jan 2024)
• Top Performer: Kaine Padly (+9.0%)
• Lowest Performer: Marney O’Breen (-11.6%)

---

🔹 Tools & Techniques Used

• Power BI
  • Data Modeling
  • DAX Measures (Variance, Variance %, Target Achievements)
  • Interactive Visualizations
• Excel
  • Data Cleaning
  • Pre-processing before loading to Power BI

---

🔹 How to Use This Project

1. Download the dataset: actual-vs-target-dataset.xlsx
2. Open the Power BI file: KPIs Performance Dashboard.pbix
3. Connect dataset and refresh to see live insights

---

🔹 Learning Outcomes

• Enhanced DAX formula writing skills
• Built a KPI-driven business dashboard
• Improved storytelling with data visualization
• Practical experience in connecting Excel to Power BI

---

🔹 Dashboard Preview

---

👉 This project demonstrates how data-driven insights help businesses track performance and improve decision-making.

---