Retail Sales Insights Dashboard

# 🛒 Retail Sales Insights Dashboard (Power BI)
An interactive and visually engaging dashboard built using **Power BI** to analyze and extract actionable insights from the [UCI Online Retail Dataset](https://archive.ics.uci.edu/ml/datasets/online+retail). This project highlights the power of data storytelling and business intelligence to support strategic decision-making in retail.
---
## 📊 Key Features
- **Interactive KPI Cards** for Total Sales, Quantity, Invoices, and Customers- **Time-Series Trend Analysis** of monthly sales- **Top 10 Selling Products** with dynamic filtering- **Geographic Sales Distribution** using a map visual- **Customer and Country Slicers** for personalized views- Clean, dark-themed UI inspired by modern BI dashboards
---
## 📈 Technologies Used
- **Power BI Desktop** – Data transformation, modeling, and visualization- **Excel / CSV** – Initial data storage- **DAX** – Custom calculations for TotalPrice and Month formatting- **UCI Machine Learning Repository** – Source of transactional data
---
## 🧠 Analytical Workflow
![Flowchart](./assets/RetailDashboard_Flowchart.png)
---
## 🔁 Project Workflow
1. **Data Cleaning** (Power BI Power Query) - Remove cancelled orders - Filter out invalid entries - Add `TotalPrice` column2. **Data Modeling** - Created calculated columns (e.g., Month) - Set correct data types3. **Visual Design** - Built KPI cards, charts, and maps - Styled dashboard with a dark background theme4. **Interactivity** - Added slicers for Country, Customer, Month - Enabled drill-down and filtering
---
## 📷 Dashboard Screenshot

---
## 🚀 How to Use
1. Clone/download this repo2. Open `Retail_Sales_Insights.pbix` in Power BI Desktop3. Explore and interact with the visuals4. Modify the file with your own data if needed
---
## 🔗 Dataset Source
- [UCI Online Retail Dataset](https://archive.ics.uci.edu/ml/datasets/online+retail)
---
## 📬 Connect with Me
I'm actively seeking data analytics opportunities. Let’s connect on [https://www.linkedin.com/in/sai-krishna-sharabu-b114b0a2/)!

Google Sites

Report abuse

Page details

Page updated

Google Sites

Report abuse