Sales Analytics Dashboard – Power BI

An interactive end-to-end sales analytics dashboard built in Power BI to analyze, visualize, and forecast retail sales performance. The project transforms raw CSV data into actionable business insights with clean visuals and advanced interactivity.

---

📊 Project Overview

This project showcases my ability to work with data cleaning, transformation, DAX calculations, and visualization in Power BI. The dashboard allows stakeholders to explore sales performance, identify trends, and make data-driven decisions.

Key Features:

• Data Source: Retail dataset in CSV format.

• Data Cleaning & Transformation: Handled missing values, corrected data types, and optimized dataset using Power Query Editor.

• DAX Calculations: Created calculated columns and measures for metrics like Total Sales, Profit, and Year-over-Year growth.

• Visual Design:

  • Maps for regional sales analysis
  • Line & bar charts for trend tracking
  • KPIs for quick business health overview
  • Slicers & filters for interactive data exploration

• Forecasting Analysis: Predicted future sales trends based on historical patterns.

• Report Export: Dashboard exported as PDF for ready-to-use business presentations.

---

🛠 Tools & Technologies

• Power BI Desktop – for dashboard design and analytics
• Power Query Editor – for ETL (Extract, Transform, Load) operations
• DAX (Data Analysis Expressions) – for custom metrics and calculations
• Microsoft Excel / CSV – as the primary dataset source

---

📌 Project Workflow

1. Import Data: Loaded CSV dataset into Power BI.

2. Clean & Transform:

   • Removed duplicates
   • Handled missing values
   • Changed data types

3. Data Modeling:

   • Established relationships between tables
   • Created calculated columns and measures with DAX

4. Visualization:

   • Added KPIs, charts, maps, and filters
   • Applied themes for better readability

5. Forecasting: Used built-in analytics features to predict future sales trends.

6. Export & Share: Published and exported the dashboard for business reporting.

---

📷 Dashboard Preview

(Add a screenshot of your Power BI dashboard here)

---

📂 How to Use

1. Download the .pbix file from this repository.
2. Open it in Power BI Desktop.
3. Connect to your dataset if you wish to test with new data.
4. Explore insights using the interactive visuals and filters.

---

💡 Key Insights from Analysis

• Seasonal spikes in sales during festive months.
• Certain regions consistently outperform others.
• Positive correlation between advertising spend and sales growth.

---