Project Details

Situation
Sales and financial data lacked structured visibility, making it difficult to track KPIs, compare sales vs targets, and analyze profitability across customers and markets.

Task
Build a comprehensive analytics solution to monitor customer performance, market trends, and Profit & Loss reporting by fiscal year and market.

Action
• Performed ETL using Power Query
• Built a structured data model in Power Pivot
• Created dynamic date logic with fiscal calculations
• Developed advanced DAX measures for variance, YoY growth, and margin analysis
• Designed interactive dashboards for KPI tracking

Result
Delivered automated, model-driven dashboards that improved visibility into revenue, targets, margins, and market performance — enabling data-driven business decisions and stronger financial planning.

Project Details

Situation - 
AtliQ Hardware incurred financial losses during a U.S. expansion due to fragmented Excel-based reporting across 1.8M+ records, inconsistent KPI definitions, and lack of visibility into sales decline, marketing ROI, and forecast accuracy.

Task - Build a centralized, scalable BI solution to eliminate manual consolidation, standardize KPIs across Sales, Finance, Marketing, and Supply Chain, and provide real-time executive insights.

Action - Extracted data using MySQL, transformed it in Power Query, and designed an optimized Snowflake schema in Power BI. Developed standardized KPIs (Net Sales, GM%, P&L, Marketing ROI, Forecast Accuracy) using advanced DAX and optimized performance with DAX Studio.

Result -
 Reduced reporting delays, improved KPI alignment and forecast monitoring, and enabled data-driven expansion and investment decisions.

Live Interactive Dashboard

Project Details

Situation: AtliQ Grands, a luxury hotel chain, was facing declining market share and revenue due to increasing competition and limited use of data-driven decision-making.

Task: The goal was to analyze historical hospitality data to identify booking trends and support the revenue management team in improving pricing and occupancy strategies.

Action: Used Power BI to analyze hotel performance data and built an interactive dashboard tracking key KPIs such as Total Revenue, Occupancy Rate, Average Daily Rate (ADR), Revenue per Available Room (RevPAR), Daily Sellable Room Nights (DSRN), and Realisation %.

Result: Generated actionable insights that helped stakeholders monitor hotel performance, identify revenue opportunities, and support data-driven business decisions

Live Interactive Dashboard

Project Details

🔹 About Company
• AtliQ Hardwares is a computer hardware company leveraging data-driven strategies for growth
🔹 Problem Statement
• Solved 10 ad-hoc business requests using SQL to enable faster decision-making
🔹 Key Insights
• Achieved 36% product growth 📈
• Notebook (129) & Accessories (116) lead in product count
• Accessories added highest unique products (34)
• Manufacturing cost ranged from $0.91 to $241 💰
• Retailer channel generated highest revenue ($121,908 Million 🚀)
🔹 My Learnings
• Applied Joins, CTEs, Window Functions, Subqueries, UNION, CASE Statements
• Derived insights & trends from data 📊
• Translated business problems into SQL queries
• Delivered insights for management decision-making

Project Details

Analyzed historical hospitality data for AtliQ Grands to identify demand patterns and revenue opportunities using Python (Pandas, NumPy, Matplotlib). Performed end-to-end EDA including data cleaning, transformation, deduplication, and dataset merging, along with appending new monthly data.

Generated key insights such as occupancy trends by room category (~58–59%), city-wise performance (Delhi highest occupancy; Mumbai highest revenue ~668M), higher weekend occupancy (~72%), peak revenue in July, and revenue contribution by luxury hotel segments. Evaluated booking platform performance and customer ratings (~3.4–3.7) using visualizations.

Proposed actionable recommendations including dynamic pricing for weekends, targeted city-level strategies, focus on luxury segment growth, optimization of booking platforms, and improvements in customer experience to enhance occupancy and revenue performance.