AtliQ Grands, a prestigious chain of five-star hotels across India, has been a key player in the hospitality industry for the past 20 years. Facing market share and revenue losses due to strategic moves by competitors and ineffective management decisions, AtliQ Grands aims to regain its market position. The managing director has decided to incorporate "Business and Data Intelligence" to drive this revival. Without an in-house data analytics team, AtliQ Grands has enlisted a third-party service provider to derive insights from historical data.
-Analyze historical revenue data to identify trends and insights. -Develop metrics according to the provided metric list. -Design a dashboard based on the stakeholder-provided mock-up. -Generate additional relevant insights not specified in the metric list/mock-up.
-Data Analysis: Excel,Power Bi -Data Visualization: Power BI -Dashboard Design: Power BI
-Data Collection: Gather and understand the sample data provided. -Data Preparation: Clean and preprocess the data for analysis. -Metric Calculation: Develop metrics as per the provided list.
-Mock-up Dashboard: Design the dashboard according to the provided mock-up. -Visualization: Use charts, graphs, and other visual elements to present data. -Interactivity: Ensure the dashboard is interactive and user-friendly.
-Trend Analysis: Identify trends and patterns in the historical data. -Performance Metrics: Calculate key performance metrics. -Additional Insights: Generate additional insights beyond the provided metrics.
-Summary of Findings: Summarize the key insights and findings from the analysis. -Visualization: Create visual elements to support the findings. -Recommendations: Provide actionable recommendations based on the analysis.
-Sample Data: Historical revenue data for analysis. -Mock-up Dashboard: Design template provided by stakeholders. -Metric List: List of metrics to be calculated.