Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics
10. stakeholder management
and many more

Project video

Project Details

Designed a dashboard in Power BI as part of the monthly challenge to provide insights to the revenue team of Atliq Grands

Understand the real-world business scenario at Hotal Domain
✅

𝐒𝐨𝐦𝐞 𝐈𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐢𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐟𝐫𝐨𝐦 𝐭𝐡𝐞 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝

✅ Mumbai generates the highest revenue (669 M) followed by Bangalore, Hyderabad and Delhi

✅ AtliQ Exotica performs better compared to all 7 types of properties with 320 Million in revenue, a rating 3.82, occupancy percentage of 57 and a cancellation rate as 24.4%.

✅ AtliQ Bay has the highest occupancy of 66%

✅ Week 24 recorded the highest revenue among all, which is 139.6 Million

✅ Delhi tops both in occupancy and rating followed by Hyderabad, Mumbai, Bangalore

✅ AtliQ lost around 298 Million in cancellation

✅ Elite-type rooms have the most booking and as well higher cancellation rate

In response to need, I am thrilled to present a purpose-built solution: the Power BI dashboard designed to empower the revenue
AtliQ

Project video

Project Details

Objective 👍 : Create a comprehensive customer performance report and compare the
market Performance Vs Sales Targets

Highlights:
➡️ Sales Report
➡️ Finance Report
➡️ P&L Statement Report

🔄 ETL Methodology
🔄 Power Query
🔄 Power Pivot
🔄 DAX

✅ Determine effective customer discounts, facilitate negotiation and explore
Business expansion opportunities

Project video

Project Details

This is a project I have done as part of Codebasics SQL Project Challenge. Following are the key highlights of this project:

1. SQL - I have used SQL to query the database. Applied many important concepts in SQL like Subqueries, Multiple joins, CTE, Window functions, etc.

2. Power BI - Visualized the extracted data using Power BI. Used different visuals like Bar Chart, Line Chart, Donut Chart etc. to clearly communicate the insights from the data.

3. MS PowerPoint - The final output of the project was a video presentation I have created in PowerPoint. I explored various features in PowerPoint to make the presentation effective. You can find]the Presentation PDF on my GitHub profile.

Project video