📊 Mobile Phone Sales Analysis – Power BI

📌 Project Overview

This project presents an interactive Power BI dashboard developed to analyze mobile phone sales data.
The dashboard helps understand overall sales performance, product trends, and customer behavior using clear KPIs and visual analytics.

---

🛠 Tools & Technologies

• Power BI Desktop
• DAX (Data Analysis Expressions)
• Power Query (Data Cleaning & Transformation)

---

📂 Dataset Description

The dataset contains transactional mobile phone sales data with the following fields:

• TransactionID
• Date
• MobileModel
• Brand
• Price
• UnitsSold
• TotalRevenue
• CustomerAge
• CustomerGender
• Location
• PaymentMethod

---

📊 Report Structure (3 Pages)

🔹 Page 1: Sales Overview

• KPIs: Total Sales, Total Units Sold, Average Price, Estimated Profit
• Monthly Sales Trend
• Sales by Brand
• Revenue by Payment Method
• Interactive slicers for Date, Brand, and Payment Method

---

🔹 Page 2: Product Performance

• Units Sold by Mobile Model
• Average Price by Brand
• Product-level details table
• Slicers for Brand and Mobile Model

---

🔹 Page 3: Customer & Location Insights

• Revenue by Customer Gender
• Sales by Location
• Sales by Customer Age Group
• Slicers for Gender and Location

---

📐 Key DAX Measures

• Total Sales
• Total Units Sold
• Average Price
• Estimated Profit
• Profit Margin %
• Age Group (Calculated Column)

---

🎯 Key Insights

• Identified top-performing brands and mobile models
• Analyzed monthly sales trends
• Understood customer demographics and purchasing behavior
• Compared regional and payment method performance

---

📁 Repository Contents

• Power BI report file (.pbix)
• Dataset (CSV)
• Dashboard screenshots
• README documentation

---

🎓 Learning Outcomes

• Hands-on experience with Power BI and DAX
• Created interactive dashboards using slicers and visual interactions
• Improved data analysis and visualization skills