Apple Sales Analysis | Business Intelligence Project
An end-to-end Sales & Warranty Analytics Dashboard built using SQL, Excel, Power Query, and Power BI, transforming raw transactional data into executive-level business decisions.
🚀 Project Impact
✔ Identified declining revenue categories ✔ Detected underperforming stores and regions ✔ Calculated warranty claim rate to assess product quality ✔ Designed executive-ready interactive dashboards ✔ Built optimized Star Schema data model
🎯 Business Problem
Apple leadership needs visibility into:
Why revenue is declining in certain product lines
Which stores and countries are underperforming
Whether warranty claims are impacting profitability
Where to focus marketing and operational improvements
This project answers those questions with data.
🧠 Key Insights Delivered
🔻 Revenue decline detected in:
Smart Speaker
Streaming Device
Subscription Services
🌍 Low revenue markets:
Spain
Taiwan
Austria
Netherlands
🏬 Top 5 underperforming stores identified using dynamic DAX ranking
🛠 Warranty claim rate calculated to highlight quality-risk products
🏗 Technical Architecture
Data Modeling Approach: Star Schema
Fact_Sales
Dim_Product
Dim_Store
Dim_Date
Dim_Warranty
Optimized relationships to eliminate ambiguity paths and ensure accurate KPI reporting.
📊 Core KPIs Built (DAX)
Total Revenue
Total Orders
Quantity Sold
Warranty Claim Rate (%)
Total Warranty Claims
🛠 Tools Used
SQL → Data joins, filtering, aggregation
Excel → Quick ad-hoc analysis & validation
Power Query → Data cleaning & transformation
Power BI → Data modeling, DAX, interactive dashboard
📈 Dashboard Highlights
Executive Summary View
Product Performance Analysis
Store & Country Breakdown
Warranty Trend Monitoring
Designed for business stakeholders — not just analysts.
💼 Skills Demonstrated
Business Intelligence Development
Advanced SQL Querying
Data Modeling (Star Schema)
DAX Measure Engineering
KPI Design
Insight-to-Decision Thinking
🔥 Why This Project Stands Out
This is not just a dashboard.
It demonstrates:
Understanding of business problems
Clean modeling principles
Analytical depth
Decision-driven reporting
Executive communication clarity
📂 Dataset
This project uses a publicly available dataset from Kaggle.
Source: Kaggle – Apple Sales Dataset https://www.kaggle.com/datasets/amangarg08/apple-retail-sales-dataset/data