📌 Project Overview
This project showcases an end-to-end sales analytics solution built entirely in Microsoft Excel using the Adventure Works Cycles dataset. The goal of this project is to transform raw transactional, product, and customer data into insightful, interactive dashboards that support business decision-making. The project consists of two dashboards:
1. Time Analysis Dashboard – focuses on trends, growth, and performance over time
2. Detail Performance Dashboard – deep dives into products, customers, demographics, and profitability drivers
This project demonstrates strong skills in Excel analytics, business intelligence, and data storytelling.
🛠 Tools & Technologies Used
- Microsoft Excel
- Power Query
- Power Pivot
- DAX (Data Analysis Expressions)
- Pivot Tables & Pivot Charts
- Slicers & Interactive Filters
✨ Key Features & Skills Demonstrated
📊 Power Query Magic
- Cleaned and transformed raw data (Customers, Products, Sales, Dates)
- Created calculated columns (Age, Profit, Profit Margin, Size Range)
- Standardized formats and removed inconsistencies
📈 Power Pivot & Data Modeling
- Built relationships between Fact and Dimension tables
- Created a star schema for efficient analysis
- Enabled dynamic filtering across all visuals
📊 DAX Measures
- Total Revenue, Total Cost (COGS), Total Profit
- Profit Margin %
- Year-over-Year Growth %
- Transaction Count
- Profit Contribution %
- Top N calculations (Top 5 Products & Customers)
🔍 Excel Functions
- Logical conditions for KPIs
- Date intelligence for Year, Quarter, Month analysis
- Categorization (Income Groups, Age Groups, Size Ranges)
📊 Visual Storytelling
- KPI cards with growth indicators
- Trend lines, bar charts, donut charts
- Clean dark-theme UI for professional presentation
- Clear insights written directly on the dashboard
❓ Key Business Questions Answered
This project answers real-world business questions, including:
⏱ Time-Based Insights
- How has revenue and profit changed year over year?
- Which year generated the highest profit?
- Which months contribute the most to total profit?
- Which quarters are the most and least profitable?
- Do weekdays or weekends drive higher profit?
💰 Profitability Insights
- What is the overall profit margin?
- How much profit comes from highlighted weekdays?
- Which quarter contributes the highest share of profit?
🛒 Product Insights
- Which are the Top 5 most profitable products?
- How much profit do Top 5 products contribute vs others?
- Which product colors generate the highest profit?
- Which size ranges generate the most profit?
- How many products are sold vs unsold?
👥 Customer Insights
- Who are the Top 5 most profitable customers?
- How much profit comes from Top 5 customers vs the rest?
- What is the average customer age?
- Which age group contributes the most profit?
- How does profit vary by income group?
- How does profit split by gender?
🌍 Geographic Insights
- Which countries contribute the highest profit?
- How does performance vary by region and year?
✅ Conclusion
This project demonstrates a complete Excel-based data analytics workflow, from raw data preparation to interactive dashboard delivery. Using the AdventureWorks Cycles dataset, I applied Power Query for data transformation, Power Pivot for data modeling, and DAX measures for analytical calculations to build scalable, insight-driven dashboards. The project highlights strong capabilities in time-series analysis, product profitability, customer segmentation, and KPI reporting, making it a practical example of real-world business intelligence and data analyst skills suitable for production-level reporting.