Project Details

The project involves analyzing historical data from AtliQ Grands, a hospitality company, to help them regain market share and revenue in the luxury/business hotel category.
As a data analyst, the tasks includes

Metric Creation: Developed key metrics based on the provided data, such as revenue generated, occupancy rates, and customer ratings, to assess the company's performance.

Dashboard Design: Created a comprehensive dashboard that visualizes these metrics in an intuitive and user-friendly manner.And to track performance trends.

Insights Generation: Beyond the metrics, identify actionable insights from the data. This involve discovering patterns in customer behavior, identifying peak booking periods, and understanding which room categories contribute most to revenue.

Business and Data Intelligence: Utilize data-driven insights to inform strategic decisions, helping AtliQ Grands improve revenue management, customer satisfaction, and overall market competitiveness.

Live Interactive Dashboard

Project Details

Impact of 5G on Revenue:
Evaluated the revenue changes before and after the 5G launch to comprehend its impact. Highlighted any percentage increase or decrease.

Underperforming KPI:
Identified the KPI (Key Performance Indicator) displaying subpar performance after the 5G implementation. Analyzed factors contributing to this underperformance.

Plan Performance Post-5G:
Assessed the revenue performance of telecom plans after the 5G rollout. Identified high-performing plans and those lagging behind, providing insights into customer preferences.

5G's Impact on Specific Plan:
Examined if any plan was significantly affected by the 5G launch. Offered recommendations on whether to continue or discontinue it based on its performance.

Discontinued Plans:
Explored plans that were discontinued after the 5G launch and revealed the reasons behind their discontinuation, including factors such as low demand or other relevant considerations.

Live Interactive Dashboard

Project Details

AtliQ Hardwares, a prominent computer hardware producer, seeks to enhance data-driven decision-making. To achieve this, they're expanding their data analytics team and As junior data analysts with a blend of technical and soft skills.

I'll tackle a Codebasics SQL Challenge, involving 10 Ad Hoc requests that demand insights to benefit the company's top-level management.

Executed SQL queries to address these requests comprehensively. This will involve extracting data, analyzing it, and transforming it into actionable insights.

By successfully executing these SQL queries and crafting presentations, Demonstrated my technical and soft skills, meeting AtliQ Hardwares' requirements for expanding their data analytics team. This will contribute to better-informed, data-driven decisions in the company's consumer goods domain, enhancing their leadership's capabilities.

Project Details

Sales Report & Finance Report for AtliQ Hardware Project objective
Sales Report: To evaluate their sales activities and performance. Importance of analysing sales data to Identify sales patterns and track key performance indicators (KPIs).
• Customer performance report
• Top products by Net Sales Top and Bottom Products by Sold quantity
• Conduct a comprehensive comparison between market performance with sales targets.
Finance Report: To evaluate financial performance by sales that support decision-making and helps to set benchmarks for budgeting and forecasting.
• Profit and Loss (P&L) reports by Fiscal Year & Months
• Profit and Loss (P&L) reports by Markets.
Technical Skills Gained: Proficiency in ETL methodology (Extract, Transform, Load)
Skills to generate a date table using Power Query
Ability to derive fiscal months and quarters.
Establishing data model relationships with Power Pivot.
Proficiency in incorporating supplementary data into an existing data model.