Uploaded November 2024 | Updated November 2026, 2 hours ago
Join me for a real-time Power BI session and learn how to build a hotel reservation dashboard using Power Query, Power Pivot (DAX) and Power BI.
~ important links ~
πSample blank file - files.chandoo.org/pbix/blank-report-v2.pbix
π‘ Join Power BI Course - e-junkie.com/i/xbbt
π» Know more - chandoo.org/wp/power-bi-course
π In this video:
=============
π₯ Introduction to Live Streaming and Power BI: The session begins with a live streaming setup, greeting participants, and introducing the Power BI session.
π Setting Up the Power BI Report: A hotel reservation dashboard is created, illustrating step-by-step setup of metrics, slicers, and background for the report.
π‘ Exploring Data Preparation Techniques: Learn about data cleaning and preparation, including the calculation of relevant columns such as booking and stay dates.
π Visualization Techniques: Key visuals such as trend lines, slicers, heatmaps, and tables are used to display booking trends, customer segments, and insights.
π§ Adding Aesthetic Features: Background customization, theme setting, and color scheme creation in Power BI are demonstrated to enhance report visuals.
π Advanced Data Analysis: Insights on weekday vs. weekend bookings, loyalty levels, booking channels, and customer behaviour are included.
π DAX Calculation Guidance: Overview of using DAX functions like SUM, COUNT, AVERAGE for calculating metrics and deriving insights.
π Topic Timestamps:
===================
0:00 - Welcome to the livestream
8:03 - Starting with the blank (sample) file to build hotel reservation report
10:52 - A look at the Power Query to get the data
13:15 - A closer look at the model & measures
15:50 - KPI card construction explained
16:20 - How to build the reports (mock-up process) & what we are going to build
18:45 - Adding canvas background
20:45 - Stay trend over time
31:35 - Weekday wise stay trend
38:55 - Who stays with us? (by loyalty program)
47:32 - How far ahead the bookings are made?
53:05 - How I am using Power BI report themes?
55:47 - Customer Analysis (matrix visual)
1:01:10 - Adding conditional formatting to the matrix
1:03:02 - A look at the final report and extra story-telling bits
1:06:27 - How to learn Power BI properly?
1:27:00 - Q&A
π₯ My Power BI Course:
Save $100 on my Power BI course (pay $199 instead of $299, or Rs 13,500 instead of Rs 18,000). Offer valid until 30th of November only.
Get the course here π chandoo.org/wp/power-bi-course
~
#powerbi #chandoo #powerbidashboard
Join me for a real-time Power BI session and learn how to build a hotel reservation dashboard using Power Query, Power Pivot (DAX) and Power BI.
~ important links ~
πSample blank file - files.chandoo.org/pbix/blank-report-v2.pbix
π‘ Join Power BI Course - e-junkie.com/i/xbbt
π» Know more - chandoo.org/wp/power-bi-course
π In this video:
=============
π₯ Introduction to Live Streaming and Power BI: The session begins with a live streaming setup, greeting participants, and introducing the Power BI session.
π Setting Up the Power BI Report: A hotel reservation dashboard is created, illustrating step-by-step setup of metrics, slicers, and background for the report.
π‘ Exploring Data Preparation Techniques: Learn about data cleaning and preparation, including the calculation of relevant columns such as booking and stay dates.
π Visualization Techniques: Key visuals such as trend lines, slicers, heatmaps, and tables are used to display booking trends, customer segments, and insights.
π§ Adding Aesthetic Features: Background customization, theme setting, and color scheme creation in Power BI are demonstrated to enhance report visuals.
π Advanced Data Analysis: Insights on weekday vs. weekend bookings, loyalty levels, booking channels, and customer behaviour are included.
π DAX Calculation Guidance: Overview of using DAX functions like SUM, COUNT, AVERAGE for calculating metrics and deriving insights.
π Topic Timestamps:
===================
0:00 - Welcome to the livestream
8:03 - Starting with the blank (sample) file to build hotel reservation report
10:52 - A look at the Power Query to get the data
13:15 - A closer look at the model & measures
15:50 - KPI card construction explained
16:20 - How to build the reports (mock-up process) & what we are going to build
18:45 - Adding canvas background
20:45 - Stay trend over time
31:35 - Weekday wise stay trend
38:55 - Who stays with us? (by loyalty program)
47:32 - How far ahead the bookings are made?
53:05 - How I am using Power BI report themes?
55:47 - Customer Analysis (matrix visual)
1:01:10 - Adding conditional formatting to the matrix
1:03:02 - A look at the final report and extra story-telling bits
1:06:27 - How to learn Power BI properly?
1:27:00 - Q&A
π₯ My Power BI Course:
Save $100 on my Power BI course (pay $199 instead of $299, or Rs 13,500 instead of Rs 18,000). Offer valid until 30th of November only.
Get the course here π chandoo.org/wp/power-bi-course
~
#powerbi #chandoo #powerbidashboard










