🏛️ 𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞 𝐎𝐯𝐞𝐫𝐯𝐢𝐞𝐰
AtliQ Grands, a luxury hotel chain, faced market share decline and revenue loss due to competitive pressure and internal inefficiencies.
🛠️ 𝐓𝐞𝐜𝐡 𝐒𝐭𝐚𝐜𝐤
Power BI, Excel, Power Query, DAX
📈 𝐋𝐞𝐚𝐫𝐧𝐭 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐭𝐞𝐜𝐡𝐧𝐢𝐪𝐮𝐞𝐬
Data Gathering
Data Cleaning
Creating calculated columns
Creating measures using the DAX language
Data modeling
Using the selection tab to create Bookmarks
Using Bookmarks to switch between two visuals
Creating page navigation with buttons and tabs
Applying filters to the visuals
Using KPI indicators
Live Dashboard link - https://shorturl.at/iyQGh
📊 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐌𝐞𝐭𝐫𝐢𝐜𝐬 𝐄𝐱𝐩𝐥𝐨𝐫𝐞𝐝
➡ Revenue
➡ Total Capacity, Total Bookings , Total Check Out
➡ Total Cancellation, Total No Show
➡ Average Rating , Average Daily Bookings
➡ RevPar, ADR , DSRN
➡ Occupancy %, Realisation %