Project Details

This project delivers a comprehensive Sales & Finance Analytics solution built entirely in Microsoft Excel for AtliQ Hardwares - a global hardware company selling keyboards, printers, and devices worldwide.

Using Power Query for ETL, Power Pivot for relational data modeling, DAX for custom measures, and PivotTables for dynamic reporting, I transformed raw multi-source data spanning fiscal years 2019–2021 into structured, decision-ready insights.

Key deliverables include a Customer Performance Report revealing growth leaders like Integration Stores (+887%) and Amazon (+219%), a Market vs Target Report exposing a -8.4% revenue shortfall across global markets, and P&L Statements by Fiscal Year, Month, and Market - uncovering a 204.5% revenue surge in 2021, peak demand in November–December, and India's dominance as the top-performing market.

This project demonstrates end-to-end analytical thinking: from messy raw data to boardroom-ready financial intelligence.

Project Details

AtliQ Hardwares, a global electronics company, struggled with poor decisions driven by guesswork—leading to failed market expansions and profit loss. To help the company shift to data-driven decision-making, I developed a centralized Power BI dashboard covering Finance, Sales, Marketing, and Supply Chain. I connected various data sources (SQL + Excel), cleaned and modeled the data, and built clear, interactive reports tailored to each team. The dashboard replaced outdated Excel files with live, auto-updating insights available on the Power BI Service. Executives can now track key metrics, like profitability and market share, in real-time, while managers can drill into customer and product-level performance. This project turned AtliQ’s raw data into a powerful decision-making tool—helping teams not just see what happened, but understand why, and what to do next.

Live Interactive Dashboard

Project Details

This project simulates real-world analytics for AtliQ Hardwares, a global manufacturer of computer peripherals. After a critical Excel failure, the company shifted to SQL-based analysis to address business challenges in finance and supply chain.

Core Deliverables & Technical Contributions:

• Developed 9 complex financial analytics reports analyzing product performance, customer behavior, and market dynamics
• Created 2 robust supply chain analytics solutions to optimize forecast accuracy and inventory management
• Engineered 7 SQL stored procedures enhancing reporting efficiency and data accessibility
• Designed custom SQL functions and optimized views to handle 4+ million records efficiently
• Implemented comprehensive sales pipeline analysis from gross price to net sales
• Built reusable analytics components for standardized business performance tracking

Live Interactive Dashboard

Project Details

AtliQ Grands, a leading Indian hotel chain, faced declining revenue and market share. I analyzed booking and revenue data using Python to uncover growth opportunities.

Performed end-to-end EDA on five datasets (bookings, revenue, rooms, ratings) using pandas and matplotlib. Key insights included higher weekend occupancy (72.34%) vs. weekdays (50.88%), Presidential rooms leading in occupancy (59.28%), and Mumbai as the top revenue generator (₹668.57M). Also found that “Others” booking platforms outperformed major channels.

Recommended Actions: Promote weekend leisure packages, form corporate tie-ups to lift weekday occupancy, upsell premium rooms, and improve service in low-rated cities like Bangalore.