This project is based on Atliq Hardwares, a global tech manufacturer operating across multiple markets and product divisions. The dataset contains 1 million+ rows of historical sales and financial data for the years 2020 and 2021.
As part of this analysis, I:
- Cleaned and transformed large datasets using Power Query
- Built structured data models using Power Pivot
- Created interactive dashboards in Excel
- Delivered insights that align with business KPIs
📊 Sales Report
Project Objectives:
- Create a Customer Performance Report
- Compare Market Performance vs. Sales Targets
Key Business Insights:
- 🔟 Top 10 products by percentage increase in net sales from 2020 to 2021
- 📈 Division-wise net sales for 2020 & 2021 with growth percentage
- 🔝 Top 5 and bottom 5 products based on quantity sold
- 🆕 New products launched in 2021 (identified using 0% in "21 vs 20" column)
- 🌍 Top 5 countries by net sales in 2021
Purpose of Sales Analytics:
Enable data-driven decisions by tracking sales trends, identifying opportunities, and optimizing performance.
Business Impact:
Informed customer discount strategies, negotiation support, and expansion planning into high-potential markets.
Project Objectives:
- Create P&L reports by Fiscal Year
- Create P&L reports by Months
- Create P&L reports by Markets
Purpose of Financial Analytics:
Evaluate financial performance, benchmark against industry and past periods, and support forecasting and budgeting.
Business Impact:
Aligns financial planning with strategic goals and builds stakeholder confidence.
- ✅ ETL process (Extract, Transform, Load)
- ✅ Power Query: date table creation, fiscal months & quarters
- ✅ Power Pivot: data modeling & relationship building
- ✅ DAX: calculated columns and performance metrics
- ✅ Integration of supplementary data into existing models
- ✅ Clear understanding of Sales & Finance KPIs
- ✅ Designing user-centric, insightful reports
- ✅ Report optimization and automation
- ✅ Strategic planning and analytical problem-solving