Project

Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. 

Due to strategic moves from other competitors and ineffective decision-making in management, Atliq Grands are losing its market share and revenue in the luxury/business hotels 

Excel’s advanced features (Pivot Tables and DAX) were used to create a P&L report for AtliQ Hardware FY 2022 with granular insights.

The data cleaning process was automated with Power Query.

Designed and implemented a DAX measure, enhancing overall performance by 25%

Designed a Power BI dashboard to track employee data for the HR team, including working hours, attendance, performance, and leaves. The dashboard streamlined HR processes and increased efficiency.

This Dashboard can save 3-4hrs of work for the HR daily.  

Delivered key insights through analysis, addressing 10 ad hoc requests, contributing to strategic decisionmaking for stakeholders. 

Transitioned from Excel to SQL, optimizing efficiency and reducing analysis time by 60-70%. 

Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. 

Due to strategic moves from other competitors and ineffective decision-making in management, Atliq Grands are losing its market share and revenue in the luxury/business hotels