This project is part of coursework and focuses on financial analytics for Atliq Hardware.
Using Microsoft Excel, I designed structured reports and dashboards to analyze:
- 📈 Sales performance across years
- 🌍 Market-wise growth and profitability
- 👥 Customer contribution trends
- 💰 Profit & Loss statements at multiple levels (year, market, month)
The project demonstrates how raw financial data can be transformed into executive-level insights for decision-making.
📌 Identifies top revenue-generating customers and YoY growth
📊 Example: Amazon grew 218.9% in 2021 vs 2020
📌 Evaluates country-level performance against set targets
📌 Yearly breakdown of Net Sales, COGS, and Gross Margin
🚀 Sales grew 204.5% between 2020 → 2021
📌 FY 2021 Profitability analysis by market
🌟 High-margin regions: New Zealand (48.2%), Japan (46.5%)
📌 Monthly/Quarterly sales and margin analysis
📊 Captures seasonality and growth trends
🚀 Net Sales up 204.5% in FY 2021 vs FY 2020
- Microsoft Excel → PivotTables, Charts, Conditional Formatting, Data Modeling
- Finance Analytics → Sales & Margin tracking, Target vs Actual analysis
- Business Insights → Market evaluation, Customer contribution, Strategic growth
✔️ Revenue grew 6.8x in 3 years (87.5M → 598.9M)
✔️ Customer concentration shows reliance on e-commerce giants like Amazon & Flipkart
✔️ Profitability varies significantly across geographies
✔️ Margins declining despite revenue growth → highlights cost optimization needs
- Gained expertise in Excel-based dashboarding
- Developed ability to translate raw finance data into insights
- Learned to present executive-ready financial reports
“Comprehensive finance analytics project for Atliq Hardware – Excel-based dashboards and reports analyzing customers, markets, and profitability.”
👤 Author: Abhigyan Sarmah 📅 Coursework Project | 📍 Excel-based Analytics