# Task 2: Data Visualization and Storytelling

## 📌 Objective
Build a Power BI dashboard using the **Ordersheet (Superstore)** dataset to visualize sales and profit trends, and derive business insights.

---

## 🛠 Tools Used
- Microsoft Power BI Desktop (Free)
- Dataset: Ordersheet.xls (Superstore sales dataset)

---

## 📊 Visuals Created
### 1. KPI Cards
- **Metrics:** Total Sales, Total Profit
- Purpose: Quick snapshot of overall business performance.

### 2. Sales by Category
- **X-Axis:** Category (Technology, Furniture, Office Supplies)  
- **Y-Axis:** Sales  
- Purpose: Compare revenue contribution of each product category.

### 3. Quantity by Sub-Category and Region
- **X-Axis:** Sub-Category  
- **Y-Axis:** Quantity  
- **Legend:** Region (Central, East, South, West)  
- Purpose: Show which product sub-categories sell most across regions.

### 4. Regional Sales and Profit
- **X-Axis:** Region (West, East, Central, South)  
- **Y-Axis:** Sales  
- **Tooltip:** Profit  
- Purpose: Compare performance across geographic regions.

### 5. Sales and Profit by Year, Category, and Region
- **X-Axis:** Year (2014–2017)  
- **Y-Axis:** Sales and Profit  
- **Legend:** Category  
- **Small Multiples:** Region  
- Purpose: Track sales and profit trends over years, across categories and regions.

---

## 📈 Key Insights
- 📊 **Technology**: Highest revenue-generating category.  
- 🪑 **Furniture** and **Office Supplies**: Contribute significantly but with varying profit margins.  
- 🌍 **West Region**: Consistently leads in sales and profit.  
- ⚠️ **South Region**: Lags behind in profitability.  
- 📆 **Yearly Trend**: Growth visible in both sales and profit over time, with some fluctuations by category.  

---