Project Details

AtliQ Grands, a renowned luxury hotel chain in India with a prosperous two-decade history in hospitality, is currently grappling with declining market share and revenue in both luxury and business hotel segments, attributed to competitive pressures and managerial decisions. To combat these challenges, the managing director has launched a strategic initiative to integrate "Business and Data Intelligence" into their operations, with the aim of reclaiming market dominance and enhancing revenue streams.

Achievements:

Formulated metrics in accordance with provided directives.
Developed a dashboard aligned with stakeholder expectations.
Unearthed actionable insights extending beyond initial metrics and mock-ups.
Skills Utilized:
4. Applied Power BI expertise.

Utilized SQL for data management.
Leveraged Excel for comprehensive analysis.
Employed DAX Studio for advanced modelling and calculations.

Project Details

At AtliQ Hardware, a global electronics leader, we're transitioning to a data-driven approach with Power BI and SQL to tackle operational challenges. Over-reliance on Excel caused setbacks in certain regions, prompting a data analytics initiative by senior management. Leveraging last year's data, our goal is to enhance performance.

💼Financial Insights: Presents a comprehensive profit and loss statement with key metrics like GM, NP, NS, visualizing performance trends.

📣Sales Analysis: Provides insights into customer and product performance, unit economics, NS, and GM% for strategic decisions.

📣Marketing Overview: Highlights regional and product performance metrics, aiding in refining marketing strategies.

🚚Supply Chain Evaluation: Showcases metrics like forecast accuracy, Net Error, and trends to optimize operations.

👨‍🎓Executive Summary: Offers a high-level view of market share, emerging trends, and revenue breakdown for strategic planning.

Live Interactive Dashboard

Project Details

⭐ Sales Report:
Objective: Generate customer performance & market comparison reports.
Purpose: Empower businesses in monitoring sales activities, tracking KPIs.
Importance: Identify sales patterns, facilitate customer negotiations, pinpoint expansion opportunities.
Role of Reports: Determine discounts, support negotiations, identify growth areas.

⭐ Finance Report:
Objective: Develop P&L reports by FY, Markets, Months.
Purpose: Evaluate financial performance, aid decision-making, communicate with stakeholders.
Importance: Benchmark against peers, facilitate budgeting, forecasting.
Role of Reports: Align financial planning, instill confidence in financial outlook.

Project Details

🔍 The Challenge: Facing a decline in market share and revenue amidst competitive shifts and management changes. Objective? Revitalize customer retention and drive revenue growth.

📈 Key Discoveries:

Room Preference: Presidential suites lead with a 59.28% occupancy rate, closely followed by Premium and Elite options. A clear guest favorite!

Weekend vs Weekday: Weekends boast a remarkable 72.34% occupancy, surpassing weekdays at 50.88%. Weekends reign supreme!

Revenue Highlights: Mumbai emerges as the revenue leader, generating a remarkable 668.56M, outshining Bangalore, Hyderabad, and Delhi.

City-Specific Ratings: Delhi shines with an average rating of 3.78, setting a service excellence benchmark.

Booking Trends: 'Makeyourtrip' emerges as the preferred booking platform among customers.