title
End to End Data Analytics Project | Power BI Project | Hospitality Domain

description
How Data Analysts Build Dashboard in Real Time? You will understand how data analysts build dashboard in real time in this video featuring an industry expert Abhishek Anand (revenue manager in OYO) & Hemanand who is a data analytics expert. This is also a solution to the Resume Project Challenge #1 conducted by Codebasics. You can download all the resources and create your own dashboard for building knowledge and adding it to resume. Link to All resources: https://codebasics.io/resources/end-to-end-data-analyst-project 00:00:00 Introduction 00:05:44 Mockup review and business requirement discussion 00:23:17 Data transformation using power query 00:33:09 Building metrics using DAX 01:10:02 Stakeholder review 01:35:27 Closing Abhishek's LinkedIn Profile: https://www.linkedin.com/in/abhishekanand-nm/ Dhaval's Linkedin Profile: https://www.linkedin.com/in/dhavalsays/ Hemanand's LinkedIn Profile: https://www.linkedin.com/in/hemvad/ Do you want to learn technology from me? Check https://codebasics.io/?utm_source=description&utm_medium=yt&utm_campaign=description&utm_id=description for my affordable video courses. Need help building software or data analytics/AI solutions? My company https://www.atliq.com/ can help. Click on the Contact button on that website. 🎥 Codebasics Hindi channel: https://www.youtube.com/channel/UCTmFBhuhMibVoSfYom1uXEg #️⃣ Social Media #️⃣ 🔗 Discord: https://discord.gg/r42Kbuk 📸 Dhaval's Personal Instagram: https://www.instagram.com/dhavalsays/ 📸 Codebasics Instagram: https://www.instagram.com/codebasicshub/ 🔊 Facebook: https://www.facebook.com/codebasicshub 📱 Twitter: https://twitter.com/codebasicshub 📝 Linkedin (Personal): https://www.linkedin.com/in/dhavalsays/ 📝 Linkedin (Codebasics): https://www.linkedin.com/company/codebasics/ 🔗 Patreon: https://www.patreon.com/codebasics?fan_landing=true

detail
{'title': 'End to End Data Analytics Project | Power BI Project | Hospitality Domain', 'heatmap': [{'end': 2401.931, 'start': 2331.181, 'weight': 1}, {'end': 3685.683, 'start': 3620.15, 'weight': 0.721}, {'end': 4036.925, 'start': 3915.177, 'weight': 0.738}], 'summary': 'Tutorial on end-to-end data analytics project using power bi in hospitality domain covers executing a data analytics project for a company with multiple five-star hotels, including data transformation, relationship establishment, hotel weekend analysis, creating calculated columns and measures, data visualization, analysis of hotel revenue strategy, and pricing impact on hotel occupancy to aid in decision-making and maximize revenue gains.', 'chapters': [{'end': 377.317, 'segs': [{'end': 32.098, 'src': 'embed', 'start': 0.149, 'weight': 0, 'content': [{'end': 5.551, 'text': 'In this video, we will learn data analytics through a real life project in hospitality domain.', 'start': 0.149, 'duration': 5.402}, {'end': 9.212, 'text': "You don't need any prior background or knowledge of Power BI tool.", 'start': 5.671, 'duration': 3.541}, {'end': 11.352, 'text': "In this video, I'm going to teach you three things.", 'start': 9.292, 'duration': 2.06}, {'end': 14.593, 'text': 'Number one, data analytics through Power BI.', 'start': 11.853, 'duration': 2.74}, {'end': 17.194, 'text': 'Yes, so you will learn Power BI in this video.', 'start': 14.673, 'duration': 2.521}, {'end': 23.796, 'text': 'Number two, you will learn a lot of important business specific concepts in hotels business.', 'start': 17.554, 'duration': 6.242}, {'end': 32.098, 'text': 'We have invited Abhishek Anand, who is a revenue manager in a big multinational hotel chain called Oyo Rooms.', 'start': 24.156, 'duration': 7.942}], 'summary': 'Learn data analytics and power bi in hospitality domain with insights from a revenue manager from oyo rooms.', 'duration': 31.949, 'max_score': 0.149, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc149.jpg'}, {'end': 80.666, 'src': 'embed', 'start': 56.869, 'weight': 1, 'content': [{'end': 65.693, 'text': 'right from understanding requirement to coming up with mockups and solution design, data gathering and modeling, dashboarding,', 'start': 56.869, 'duration': 8.824}, {'end': 68.155, 'text': 'discussing stakeholders feedback, etc.', 'start': 65.693, 'duration': 2.462}, {'end': 72.939, 'text': 'project was published as a code basics resume challenge project few months back.', 'start': 68.755, 'duration': 4.184}, {'end': 75.842, 'text': 'many people participated and they won the prizes.', 'start': 72.939, 'duration': 2.903}, {'end': 80.666, 'text': 'this video is just a guided project where i will show you how i would build that project.', 'start': 75.842, 'duration': 4.824}], 'summary': 'Guided project based on code basics resume challenge, with many participants and prize winners.', 'duration': 23.797, 'max_score': 56.869, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc56869.jpg'}, {'end': 151.025, 'src': 'embed', 'start': 120.7, 'weight': 2, 'content': [{'end': 127.685, 'text': "They have multiple five-star hotels across India, and they're facing a lot of competition from their competitor hotels.", 'start': 120.7, 'duration': 6.985}, {'end': 131.967, 'text': 'And you want to build this dashboard that can generate insights for the management.', 'start': 128.365, 'duration': 3.602}, {'end': 134.209, 'text': 'So you can read the whole problem statement here.', 'start': 131.987, 'duration': 2.222}, {'end': 137.253, 'text': 'And you can also download this data set.', 'start': 135.009, 'duration': 2.244}, {'end': 142.242, 'text': 'So the data set that you download here will be a zip file.', 'start': 138.095, 'duration': 4.147}, {'end': 143.485, 'text': 'So let me just show you.', 'start': 142.563, 'duration': 0.922}, {'end': 151.025, 'text': 'And once you extract that zip file by just saying except all, you will find this directory.', 'start': 144.446, 'duration': 6.579}], 'summary': 'Multiple five-star hotels in india facing tough competition; dashboard needed for management insights.', 'duration': 30.325, 'max_score': 120.7, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc120700.jpg'}, {'end': 210.277, 'src': 'embed', 'start': 161.75, 'weight': 3, 'content': [{'end': 169.333, 'text': 'you want to generate this kind of dashboard where you have different visuals kpi, which means key performance indicator at the top,', 'start': 161.75, 'duration': 7.583}, {'end': 171.814, 'text': 'revenue occupancy percentage, etc.', 'start': 169.333, 'duration': 2.481}, {'end': 174.015, 'text': 'some weekly trends and so on.', 'start': 171.814, 'duration': 2.201}, {'end': 176.307, 'text': 'Let me show you all this data.', 'start': 174.946, 'duration': 1.361}, {'end': 179.208, 'text': "So let's first look at the hotels.", 'start': 176.327, 'duration': 2.881}, {'end': 182.41, 'text': 'So these are the hotels that Atlic Grants have.', 'start': 179.909, 'duration': 2.501}, {'end': 185.792, 'text': 'Locations, see Delhi, Mumbai, they have these hotels everywhere.', 'start': 183.011, 'duration': 2.781}, {'end': 191.656, 'text': 'These are the specific property names and their types, you know, business or luxury, et cetera.', 'start': 186.513, 'duration': 5.143}, {'end': 196.699, 'text': 'And then you have the room types.', 'start': 192.694, 'duration': 4.005}, {'end': 200.384, 'text': 'So they have total four type of rooms, RT1, RT2.', 'start': 197.08, 'duration': 3.304}, {'end': 202.707, 'text': 'These are just the codes for these rooms.', 'start': 200.504, 'duration': 2.203}, {'end': 206.171, 'text': "And let's look at the booking data that they have.", 'start': 202.967, 'duration': 3.204}, {'end': 210.277, 'text': "So if you look at booking data or before booking data, let's look at the dates.", 'start': 206.572, 'duration': 3.705}], 'summary': 'Dashboard displays kpis, revenue occupancy, weekly trends for atlic grants hotels in delhi, mumbai, with 4 room types.', 'duration': 48.527, 'max_score': 161.75, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc161750.jpg'}, {'end': 314.92, 'src': 'embed', 'start': 258.869, 'weight': 5, 'content': [{'end': 261.851, 'text': 'You have one last file, by the way, which is aggregated bookings.', 'start': 258.869, 'duration': 2.982}, {'end': 271.236, 'text': 'So, from bookings we are generating these aggregated bookings where, for a given property ID and check-in date,', 'start': 262.651, 'duration': 8.585}, {'end': 276.039, 'text': 'we have total number of successful bookings versus the capacity.', 'start': 271.236, 'duration': 4.803}, {'end': 287.503, 'text': 'So on this particular day for this property, It had total 30 RT1 rooms available, but 25 got booked successfully.', 'start': 276.599, 'duration': 10.904}, {'end': 294.186, 'text': 'So this aggregated data is kind of generated from this fact booking data.', 'start': 288.343, 'duration': 5.843}, {'end': 297.428, 'text': 'This is more fine granular data that we have.', 'start': 294.206, 'duration': 3.222}, {'end': 300.59, 'text': 'And you have a metric list as well, by the way.', 'start': 297.808, 'duration': 2.782}, {'end': 308.855, 'text': "So if you're looking for a formula or something, This list explains you the business concepts behind this.", 'start': 300.67, 'duration': 8.185}, {'end': 314.92, 'text': 'So occupancy percentage is basically total successful booking divided by total capacity.', 'start': 308.875, 'duration': 6.045}], 'summary': 'Aggregated bookings data: 25 out of 30 rt1 rooms booked, achieving 83% occupancy.', 'duration': 56.051, 'max_score': 258.869, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc258869.jpg'}, {'end': 389.75, 'src': 'embed', 'start': 356.211, 'weight': 7, 'content': [{'end': 357.912, 'text': 'Thank you for sharing this snippet, Eman.', 'start': 356.211, 'duration': 1.701}, {'end': 364.616, 'text': "I'm looking at the data and at a very high level, this data is very, very interesting.", 'start': 359.653, 'duration': 4.963}, {'end': 370.36, 'text': 'This data can help me into deep diving into different categories.', 'start': 366.097, 'duration': 4.263}, {'end': 376.336, 'text': 'I really like the filters you have created, the city filter, the status filter, the platform filter.', 'start': 371.17, 'duration': 5.166}, {'end': 377.317, 'text': 'They are very, very interesting.', 'start': 376.376, 'duration': 0.941}, {'end': 384.384, 'text': 'And you have also tried to break down the business from revenue to occupancy to rating, which is very, very helpful in our industry.', 'start': 378.298, 'duration': 6.086}, {'end': 389.75, 'text': 'There are a few key metrics which can be looked at in the level one.', 'start': 385.525, 'duration': 4.225}], 'summary': 'The data is very interesting, with useful filters and key metrics.', 'duration': 33.539, 'max_score': 356.211, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc356211.jpg'}], 'start': 0.149, 'title': 'Data analytics in hospitality domain and hotel dashboard data analysis', 'summary': 'Covers learning data analytics through power bi with a focus on hospitality business concepts, executing a data analytics project step by step, and discussing a problem statement for generating revenue insights for a company with multiple five-star hotels facing competition. additionally, it introduces the hotel dashboard data, including key visuals, hotel locations, room types, booking data, aggregated bookings, and metric list, which can be used to analyze the performance and trends at different hotel properties.', 'chapters': [{'end': 161.75, 'start': 0.149, 'title': 'Data analytics in hospitality domain', 'summary': 'Covers learning data analytics through power bi with a focus on hospitality business concepts, executing a data analytics project step by step, and discussing a problem statement for generating revenue insights for a company with multiple five-star hotels facing competition.', 'duration': 161.601, 'highlights': ['Learning Power BI and important business concepts in hotels business The video covers learning Power BI and important business concepts in the hospitality domain.', 'Executing a data analytics project step by step, including solution design, data gathering and modeling, dashboarding, and stakeholder feedback The chapter explains executing a data analytics project step by step, including solution design, data gathering, dashboarding, and stakeholder feedback.', 'Discussing a problem statement for generating revenue insights for a company with multiple five-star hotels facing competition The chapter discusses a problem statement for generating revenue insights for a company with multiple five-star hotels facing competition.']}, {'end': 377.317, 'start': 161.75, 'title': 'Hotel dashboard data analysis', 'summary': 'Introduces the hotel dashboard data, including key visuals, hotel locations, room types, booking data, aggregated bookings, and metric list, which can be used to analyze the performance and trends at different hotel properties.', 'duration': 215.567, 'highlights': ['The data includes different visuals, KPIs, and weekly trends for hotel locations, room types, booking data, aggregated bookings, and metric list. The dashboard includes key visuals, KPIs, and weekly trends for hotel locations, room types, booking data, aggregated bookings, and metric list, providing comprehensive insights for analysis.', 'The data covers specific hotel locations such as Delhi and Mumbai, along with property names, types, and room types. The data covers specific hotel locations such as Delhi and Mumbai, along with property names, types, and room types, providing detailed information about the hotel properties.', 'The aggregated bookings data provides insights into the total number of successful bookings versus the capacity for a given property ID and check-in date. The aggregated bookings data provides insights into the total number of successful bookings versus the capacity for a given property ID and check-in date, allowing for a detailed analysis of booking performance.', 'The metric list explains key business concepts, including the calculation of the occupancy percentage based on total successful bookings divided by total capacity. The metric list explains key business concepts, including the calculation of the occupancy percentage based on total successful bookings divided by total capacity, providing a clear understanding of the performance metrics.', 'The domain expert, Abhishek, finds the data very interesting and appreciates the filters created, including the city filter, status filter, and platform filter. The domain expert, Abhishek, finds the data very interesting and appreciates the filters created, including the city filter, status filter, and platform filter, indicating the potential usefulness of the data for in-depth analysis.']}], 'duration': 377.168, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc149.jpg', 'highlights': ['Covers learning Power BI and important business concepts in the hospitality domain.', 'Executing a data analytics project step by step, including solution design, data gathering, dashboarding, and stakeholder feedback.', 'Discussing a problem statement for generating revenue insights for a company with multiple five-star hotels facing competition.', 'The dashboard includes key visuals, KPIs, and weekly trends for hotel locations, room types, booking data, aggregated bookings, and metric list, providing comprehensive insights for analysis.', 'The data covers specific hotel locations such as Delhi and Mumbai, along with property names, types, and room types, providing detailed information about the hotel properties.', 'The aggregated bookings data provides insights into the total number of successful bookings versus the capacity for a given property ID and check-in date, allowing for a detailed analysis of booking performance.', 'The metric list explains key business concepts, including the calculation of the occupancy percentage based on total successful bookings divided by total capacity, providing a clear understanding of the performance metrics.', 'The domain expert, Abhishek, finds the data very interesting and appreciates the filters created, including the city filter, status filter, and platform filter, indicating the potential usefulness of the data for in-depth analysis.']}, {'end': 1266.054, 'segs': [{'end': 455.51, 'src': 'embed', 'start': 403.655, 'weight': 0, 'content': [{'end': 410.338, 'text': 'the other metric would be ADR, because that is a byproduct of refpar.', 'start': 403.655, 'duration': 6.683}, {'end': 417.081, 'text': 'okay, so, if you want me to explain refpar in layman terms, refpar is revenue per available room.', 'start': 410.338, 'duration': 6.743}, {'end': 423.311, 'text': 'okay, and the simple formula would be total revenue, divided by total rooms available to sell.', 'start': 417.081, 'duration': 6.23}, {'end': 425.772, 'text': "that's it all right, okay?", 'start': 423.311, 'duration': 2.461}, {'end': 431.855, 'text': 'there is another formula by which you can calculate the same number of repa, that is, adr, into occupancy.', 'start': 425.772, 'duration': 6.083}, {'end': 436.917, 'text': "okay, the occupancy metric is something which you're already showing on the screen, so that really works.", 'start': 431.855, 'duration': 5.062}, {'end': 444.741, 'text': 'yes, that is a simple calculation of number of rooms sold or utilized by the customers, divided by number of available rooms.', 'start': 436.917, 'duration': 7.824}, {'end': 446.302, 'text': 'so say, you have a 100 room hotel.', 'start': 444.741, 'duration': 1.561}, {'end': 450.425, 'text': 'on monday you had 50 customers check out.', 'start': 447.182, 'duration': 3.243}, {'end': 455.51, 'text': 'so for your occupancy for sunday would be 50, 50 rooms sold divided by 100 available.', 'start': 450.425, 'duration': 5.085}], 'summary': 'Adr and occupancy are key metrics for hotel revenue, with occupancy calculated as rooms sold divided by available rooms.', 'duration': 51.855, 'max_score': 403.655, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc403655.jpg'}, {'end': 504.388, 'src': 'embed', 'start': 480.091, 'weight': 1, 'content': [{'end': 490.538, 'text': 'So the relationship between the Revpar and ADR, if I understand it correctly, So your ADR is a is kind of the ideal state, right?', 'start': 480.091, 'duration': 10.447}, {'end': 491.979, 'text': 'Your ADR will be more always.', 'start': 490.558, 'duration': 1.421}, {'end': 498.884, 'text': "Right, And your Revpar is what it says like if your occupancy is a hundred percent, that's what you get in Revpar, correct?", 'start': 492.379, 'duration': 6.505}, {'end': 502.667, 'text': 'If your occupancy is a hundred percent, your ADR and Revpar will always be equal.', 'start': 499.004, 'duration': 3.663}, {'end': 504.388, 'text': 'Okay Got it.', 'start': 503.127, 'duration': 1.261}], 'summary': 'Relationship between adr and revpar explained with 100% occupancy, adr and revpar are equal.', 'duration': 24.297, 'max_score': 480.091, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc480091.jpg'}, {'end': 602.38, 'src': 'embed', 'start': 576.332, 'weight': 2, 'content': [{'end': 583.739, 'text': 'So available rooms, Abhishek, is there any business term that you use it for available rooms? Yes.', 'start': 576.332, 'duration': 7.407}, {'end': 590.024, 'text': 'So basically, like lightly mentioned, and this view would really benefit from that metric.', 'start': 583.919, 'duration': 6.105}, {'end': 592.751, 'text': 'In our industry, we call it SRNs.', 'start': 591.129, 'duration': 1.622}, {'end': 594.973, 'text': 'They are called Sellable Room Nights.', 'start': 593.411, 'duration': 1.562}, {'end': 598.496, 'text': 'And we look at it on a daily basis.', 'start': 596.114, 'duration': 2.382}, {'end': 602.38, 'text': 'So the metric is now called the SRN or Daily Sellable Room Nights.', 'start': 598.737, 'duration': 3.643}], 'summary': 'Daily sellable room nights (srns) are crucial in our industry.', 'duration': 26.048, 'max_score': 576.332, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc576332.jpg'}, {'end': 710.105, 'src': 'embed', 'start': 682.122, 'weight': 4, 'content': [{'end': 684.885, 'text': 'that will make things a bit hectic and congested.', 'start': 682.122, 'duration': 2.763}, {'end': 690.671, 'text': "And that's the reason why I've asked you this question so that we can keep only the key metrics that really, really matters to you.", 'start': 684.945, 'duration': 5.726}, {'end': 693.394, 'text': 'rather than trying to have so many metrics.', 'start': 691.272, 'duration': 2.122}, {'end': 697.696, 'text': 'So just to summarize that, Abhishek, and also to the people.', 'start': 693.834, 'duration': 3.862}, {'end': 702.72, 'text': 'So we will have RFA, occupancy percentage, and revenue.', 'start': 698.077, 'duration': 4.643}, {'end': 708.824, 'text': 'And apart from that, we will also have DSR, correct? So far, these are the top metrics.', 'start': 703.52, 'duration': 5.304}, {'end': 710.105, 'text': 'And ADR.', 'start': 708.904, 'duration': 1.201}], 'summary': 'Key metrics: rfa, occupancy percentage, revenue, dsr, adr', 'duration': 27.983, 'max_score': 682.122, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc682122.jpg'}, {'end': 1066.477, 'src': 'embed', 'start': 1042.005, 'weight': 6, 'content': [{'end': 1048.452, 'text': 'So when you take decisions, when taking decisions, you need to look at data movement.', 'start': 1042.005, 'duration': 6.447}, {'end': 1051.348, 'text': 'and data movement can give you.', 'start': 1049.267, 'duration': 2.081}, {'end': 1058.572, 'text': 'you will get a view of data moment only if you look at weekly trends or monthly trends, right so data to become information for me,', 'start': 1051.348, 'duration': 7.224}, {'end': 1064.856, 'text': "i need those trends which you mentioned, so the trends like, for example, you're showing me occupancy trends on the current screen right.", 'start': 1058.572, 'duration': 6.284}, {'end': 1066.477, 'text': 'this is very, very helpful.', 'start': 1064.856, 'duration': 1.621}], 'summary': 'Data movement reveals insights; focus on weekly and monthly trends for informed decision-making.', 'duration': 24.472, 'max_score': 1042.005, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc1042005.jpg'}, {'end': 1133.827, 'src': 'embed', 'start': 1104.366, 'weight': 5, 'content': [{'end': 1106.728, 'text': 'So we have different booking platforms.', 'start': 1104.366, 'duration': 2.362}, {'end': 1111.111, 'text': 'So the end of the level one analysis generally ends by the channel level views.', 'start': 1106.828, 'duration': 4.283}, {'end': 1118.256, 'text': 'So looking at RepR, ADR, Occupancy, BR, and URM, that gives you a holistic picture of what is happening at a property.', 'start': 1111.691, 'duration': 6.565}, {'end': 1123.94, 'text': 'However, again, using data as information, I need to look at channel level split.', 'start': 1118.956, 'duration': 4.984}, {'end': 1128.163, 'text': 'Like you mentioned, if you have channel level split, which channels the booking comes from?', 'start': 1124.46, 'duration': 3.703}, {'end': 1133.827, 'text': 'if there is a channel level issue, we can identify it only looking at that data.', 'start': 1128.983, 'duration': 4.844}], 'summary': 'Analysis of booking platforms and channel level data to understand property performance.', 'duration': 29.461, 'max_score': 1104.366, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc1104366.jpg'}], 'start': 378.298, 'title': 'Hospitality industry metrics', 'summary': 'Covers key metrics in the hospitality industry including refpar, adr, occupancy, and srns, with explanations and examples. it also emphasizes the importance of selecting key metrics for dashboarding and the significance of level one and level two analysis in hotel revenue management.', 'chapters': [{'end': 661.15, 'start': 378.298, 'title': 'Metrics in hospitality industry', 'summary': 'Discusses key metrics in the hospitality industry including refpar, adr, occupancy, and srns, with explanations and examples to understand their calculation and importance for business operations.', 'duration': 282.852, 'highlights': ['Refpar is a key metric in the hospitality industry, calculated as revenue per available room, and its formula is total revenue divided by total rooms available to sell. Refpar is a critical metric in hospitality, calculated as total revenue divided by total rooms available to sell, providing a measure of performance and productivity.', 'The relationship between ADR and Revpar is explained, with ADR representing the average rate per sold room and Revpar being influenced by both ADR and occupancy. The relationship between ADR and Revpar is clarified, with ADR representing the average rate per sold room and Revpar being influenced by both ADR and occupancy, impacting overall revenue performance.', 'The concept of Sellable Room Nights (SRNs) is introduced, providing insights into its importance for identifying room blocking and maintenance issues, and its calculation at daily and monthly levels is explained. The concept of Sellable Room Nights (SRNs) is introduced, highlighting its significance in identifying room blocking and maintenance issues, with detailed explanations of its calculation at daily and monthly levels.', 'Occupancy metric is defined as the ratio of rooms sold or utilized by customers to the total available rooms, showcasing its simplicity and importance in measuring hotel performance. The occupancy metric is defined as the ratio of rooms sold or utilized by customers to the total available rooms, providing a simple yet crucial measure of hotel performance.']}, {'end': 1266.054, 'start': 661.31, 'title': 'Metrics dashboarding and analysis', 'summary': 'Discusses the importance of selecting key metrics for dashboarding, such as rfa, occupancy percentage, revenue, dsr, adr, urn, brn, and realization percentage, and the significance of level one and level two analysis in identifying and solving problems in the hotel revenue management, focusing on data movement and trend analysis.', 'duration': 604.744, 'highlights': ['Metrics selection for dashboarding The chapter emphasizes the importance of selecting key metrics for dashboarding, such as RFA, occupancy percentage, revenue, DSR, ADR, URN, BRN, and realization percentage, to avoid overcrowding the dashboard and focus on essential data.', 'Realization percentage calculation It explains the calculation of the realization percentage as URN divided by BRN, and the exclusion of no-shows from the realization percentage, providing insights into the actual revenue realized from the bookings.', 'Level one and level two analysis It discusses the significance of level one and level two analysis in identifying and solving problems in hotel revenue management, enabling a focused approach to problem-solving by peeling the layers of data to pinpoint specific issues and take targeted actions.', "Trend analysis for decision-making It highlights the importance of trend analysis, including weekly and monthly trends, to understand data movement and make informed decisions in hotel revenue management, emphasizing the need for dashboards to enable asking 'why' questions to assess performance effectively.", 'Channel level split for holistic analysis It stresses the importance of channel level split in analyzing revenue performance, enabling the identification of specific issues related to booking channels and properties, emphasizing the need for targeted actions based on detailed data analysis.']}], 'duration': 887.756, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc378298.jpg', 'highlights': ['Refpar is a critical metric in hospitality, calculated as total revenue divided by total rooms available to sell, providing a measure of performance and productivity.', 'The relationship between ADR and Revpar is clarified, with ADR representing the average rate per sold room and Revpar being influenced by both ADR and occupancy, impacting overall revenue performance.', 'The concept of Sellable Room Nights (SRNs) is introduced, highlighting its significance in identifying room blocking and maintenance issues, with detailed explanations of its calculation at daily and monthly levels.', 'Occupancy metric is defined as the ratio of rooms sold or utilized by customers to the total available rooms, providing a simple yet crucial measure of hotel performance.', 'The chapter emphasizes the importance of selecting key metrics for dashboarding, such as RFA, occupancy percentage, revenue, DSR, ADR, URN, BRN, and realization percentage, to avoid overcrowding the dashboard and focus on essential data.', 'It discusses the significance of level one and level two analysis in identifying and solving problems in hotel revenue management, enabling a focused approach to problem-solving by peeling the layers of data to pinpoint specific issues and take targeted actions.', "It highlights the importance of trend analysis, including weekly and monthly trends, to understand data movement and make informed decisions in hotel revenue management, emphasizing the need for dashboards to enable asking 'why' questions to assess performance effectively.", 'It stresses the importance of channel level split in analyzing revenue performance, enabling the identification of specific issues related to booking channels and properties, emphasizing the need for targeted actions based on detailed data analysis.']}, {'end': 2159.233, 'segs': [{'end': 1525.454, 'src': 'embed', 'start': 1497.588, 'weight': 0, 'content': [{'end': 1504.674, 'text': 'So see, we connected with the source, which is an input folder, and then we expanded.', 'start': 1497.588, 'duration': 7.086}, {'end': 1508.232, 'text': 'we expanded that file.', 'start': 1506.471, 'duration': 1.761}, {'end': 1511.094, 'text': 'okay, and see promoted headers.', 'start': 1508.232, 'duration': 2.862}, {'end': 1512.035, 'text': 'so promoted header.', 'start': 1511.094, 'duration': 0.941}, {'end': 1515.338, 'text': 'what it did is it made date, mm yy, etc.', 'start': 1512.035, 'duration': 3.303}, {'end': 1520.561, 'text': 'the header for that particular table and so on.', 'start': 1515.338, 'duration': 5.223}, {'end': 1523.263, 'text': 'so now this can be renamed as dim date.', 'start': 1520.561, 'duration': 2.702}, {'end': 1525.454, 'text': 'So you got the idea right?', 'start': 1524.594, 'duration': 0.86}], 'summary': 'Connected to source, expanded file, promoted headers, renamed as dim date.', 'duration': 27.866, 'max_score': 1497.588, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc1497588.jpg'}, {'end': 1631.608, 'src': 'embed', 'start': 1599.842, 'weight': 1, 'content': [{'end': 1601.683, 'text': "so you're doing your transformation here.", 'start': 1599.842, 'duration': 1.841}, {'end': 1613.385, 'text': "you're realizing, right, we are already doing data transformation by doing promoting rows, deleting unnecessary stuff and so on.", 'start': 1601.683, 'duration': 11.702}, {'end': 1620.862, 'text': 'okay, if i look at my data, things are looking good right.', 'start': 1613.385, 'duration': 7.477}, {'end': 1627.025, 'text': 'uh, now i will just go over all the tables and just kind of quickly verify a few things.', 'start': 1620.862, 'duration': 6.163}, {'end': 1631.608, 'text': 'so if you are seeing any row being not promoted as a header, you can fix that.', 'start': 1627.025, 'duration': 4.583}], 'summary': 'Data transformation process includes promoting rows and verifying table headers.', 'duration': 31.766, 'max_score': 1599.842, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc1599842.jpg'}, {'end': 1795.92, 'src': 'embed', 'start': 1767.829, 'weight': 2, 'content': [{'end': 1772.771, 'text': 'so you can just say google star schema.', 'start': 1767.829, 'duration': 4.942}, {'end': 1774.731, 'text': 'so what is star schema?', 'start': 1772.771, 'duration': 1.96}, {'end': 1781.53, 'text': 'so if you look at images, You know in star schema you have fact table, which is your transaction.', 'start': 1774.731, 'duration': 6.799}, {'end': 1783.351, 'text': "Let's say your sales transaction, that is fact.", 'start': 1781.57, 'duration': 1.781}, {'end': 1787.834, 'text': 'And then you have time, day, you have customer, product.', 'start': 1783.871, 'duration': 3.963}, {'end': 1790.036, 'text': 'These are called dimensions.', 'start': 1788.355, 'duration': 1.681}, {'end': 1793.278, 'text': 'So you surround them and you kind of connect them.', 'start': 1790.336, 'duration': 2.942}, {'end': 1795.92, 'text': 'And sometimes it looks like a star schema.', 'start': 1794.059, 'duration': 1.861}], 'summary': 'Star schema organizes data into fact table and dimensions, forming a connected structure resembling a star.', 'duration': 28.091, 'max_score': 1767.829, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc1767829.jpg'}, {'end': 2003.518, 'src': 'embed', 'start': 1975.097, 'weight': 3, 'content': [{'end': 1983.623, 'text': 'so it is always the best idea To verify your relationship, make sure your relationships are established properly.', 'start': 1975.097, 'duration': 8.526}, {'end': 1989.047, 'text': 'If your relationships are not established properly, you know, in real life also, you always have a problem.', 'start': 1983.743, 'duration': 5.304}, {'end': 1997.433, 'text': 'Now we will be working in something called DAX, D-A-X, Data Analysis Expression.', 'start': 1991.949, 'duration': 5.484}, {'end': 2003.518, 'text': 'That is a way in Power BI by which you can create new columns and new measures.', 'start': 1998.134, 'duration': 5.384}], 'summary': 'Verify relationships for better functioning. use dax for new columns and measures in power bi.', 'duration': 28.421, 'max_score': 1975.097, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc1975097.jpg'}, {'end': 2082.539, 'src': 'embed', 'start': 2053.197, 'weight': 4, 'content': [{'end': 2064.746, 'text': 'okay, you can create a new column by going here as well and you will just say this is week number is equal to week number.', 'start': 2053.197, 'duration': 11.549}, {'end': 2074.655, 'text': 'you see this formula, this is the dax formula and you can hit tab to complete it and basically, from dim date, date, column,', 'start': 2064.746, 'duration': 9.909}, {'end': 2080.998, 'text': 'you can derive the week number and see, now i have 19 for this week and so on.', 'start': 2074.655, 'duration': 6.343}, {'end': 2082.539, 'text': 'i will create another column.', 'start': 2080.998, 'duration': 1.541}], 'summary': 'Using dax formula to derive week number from date column in power bi.', 'duration': 29.342, 'max_score': 2053.197, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2053197.jpg'}], 'start': 1266.094, 'title': 'Data transformation and relationship establishment in power bi', 'summary': 'Discusses the process of data transformation in power bi, emphasizing the steps involved in importing and cleaning data, including duplication, expanding files, and promoting headers. it also covers the process of establishing relationships using star schema in power bi, including the importance of managing relationships, creating new columns and measures using dax, and deriving week numbers and day types from date columns.', 'chapters': [{'end': 1711.706, 'start': 1266.094, 'title': 'Data transformation in power bi', 'summary': 'Discusses the process of data transformation in power bi, emphasizing the steps involved in importing and cleaning data, including duplication, expanding files, and promoting headers, along with the significance of the dim date and dim hotels tables for further analysis.', 'duration': 445.612, 'highlights': ['The process of importing and transforming data involves steps such as duplicating, expanding files, and promoting headers, while ensuring the significance of dim date and dim hotels tables for further analysis. The chapter details the steps involved in importing and transforming data, emphasizing the significance of tables like dim date and dim hotels for further analysis.', 'The importance of verifying data integrity and making necessary adjustments, such as correcting the day types in the date table, is highlighted for accurate analysis. The chapter emphasizes the importance of verifying data integrity and making necessary adjustments, such as correcting the day types in the date table, for accurate analysis.']}, {'end': 2159.233, 'start': 1711.766, 'title': 'Establishing relationships in power bi', 'summary': 'Discusses the process of establishing relationships using star schema in power bi, including the importance of managing relationships, creating new columns and measures using dax, and deriving week numbers and day types from date columns.', 'duration': 447.467, 'highlights': ['Establishing relationships using star schema The chapter explains the use of star schema to establish relationships between fact and dimension tables, with an emphasis on connecting tables and establishing one-to-many relationships.', 'Managing relationships and verifying their correctness The importance of managing and verifying relationships in Power BI is emphasized, including the significance of properly established relationships for accurate dashboard building and data analysis.', 'Creating new columns and measures using DAX The process of creating new columns and measures using Data Analysis Expression (DAX) in Power BI is demonstrated, including examples of deriving week numbers and day types from date columns.']}], 'duration': 893.139, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc1266094.jpg', 'highlights': ['The process of importing and transforming data involves steps such as duplicating, expanding files, and promoting headers, while ensuring the significance of dim date and dim hotels tables for further analysis.', 'The importance of verifying data integrity and making necessary adjustments, such as correcting the day types in the date table, is highlighted for accurate analysis.', 'Establishing relationships using star schema The chapter explains the use of star schema to establish relationships between fact and dimension tables, with an emphasis on connecting tables and establishing one-to-many relationships.', 'Managing relationships and verifying their correctness The importance of managing and verifying relationships in Power BI is emphasized, including the significance of properly established relationships for accurate dashboard building and data analysis.', 'Creating new columns and measures using DAX The process of creating new columns and measures using Data Analysis Expression (DAX) in Power BI is demonstrated, including examples of deriving week numbers and day types from date columns.']}, {'end': 2554.554, 'segs': [{'end': 2216.34, 'src': 'embed', 'start': 2159.233, 'weight': 0, 'content': [{'end': 2164.698, 'text': 'most of people stay in the hotel on friday evening and saturday evening.', 'start': 2159.233, 'duration': 5.465}, {'end': 2169.577, 'text': 'so here you can create this variable.', 'start': 2164.698, 'duration': 4.879}, {'end': 2174.641, 'text': "so control enter, or let's see, is it control enter or alter enter.", 'start': 2169.577, 'duration': 5.064}, {'end': 2175.883, 'text': 'alter enter.', 'start': 2174.641, 'duration': 1.242}, {'end': 2177.965, 'text': 'you can say variable wkd.', 'start': 2175.883, 'duration': 2.082}, {'end': 2180.407, 'text': 'this is how you can create a variable index.', 'start': 2177.965, 'duration': 2.442}, {'end': 2182.409, 'text': 'so this is a dax syntax.', 'start': 2180.407, 'duration': 2.002}, {'end': 2187.733, 'text': 'you can google, by the way, and get all the help on the syntax and how to write these expressions.', 'start': 2182.409, 'duration': 5.324}, {'end': 2191.737, 'text': 'so this is weekday and you can say there is something called um.', 'start': 2187.733, 'duration': 4.004}, {'end': 2194.384, 'text': 'Once again, alter enter.', 'start': 2193.283, 'duration': 1.101}, {'end': 2196.445, 'text': "If you hit enter, it's going to show you an error.", 'start': 2194.464, 'duration': 1.981}, {'end': 2207.353, 'text': 'If there is this if condition, correct? So if my WKD is greater than five, then it is weekend.', 'start': 2196.565, 'duration': 10.788}, {'end': 2210.276, 'text': 'Otherwise it is weekday.', 'start': 2208.174, 'duration': 2.102}, {'end': 2216.34, 'text': 'This is a formula and you can just say return.', 'start': 2210.296, 'duration': 6.044}], 'summary': "Most people stay in the hotel on friday and saturday evenings, creating a variable 'wkd' using dax syntax to classify weekdays and weekends based on the condition 'wkd > 5'.", 'duration': 57.107, 'max_score': 2159.233, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2159233.jpg'}, {'end': 2324.72, 'src': 'embed', 'start': 2295.51, 'weight': 2, 'content': [{'end': 2302.253, 'text': 'and then you come to dex and here you do these two things you create calculated columns and you create measures,', 'start': 2295.51, 'duration': 6.743}, {'end': 2305.695, 'text': 'and after that you do your dashboarding.', 'start': 2302.253, 'duration': 3.442}, {'end': 2307.256, 'text': 'so this is a typical flow.', 'start': 2305.695, 'duration': 1.561}, {'end': 2309.737, 'text': 'okay, so we are here at this step.', 'start': 2307.256, 'duration': 2.481}, {'end': 2314.918, 'text': "Alright, so now I'm going to click on this icon and I will start creating my measures.", 'start': 2310.077, 'duration': 4.841}, {'end': 2318.158, 'text': 'Now I can create my measures here in these tables.', 'start': 2314.978, 'duration': 3.18}, {'end': 2324.72, 'text': 'If you click on these three dots, or you can create new measure by just saying new measure,', 'start': 2318.398, 'duration': 6.322}], 'summary': 'In dax, create calculated columns, measures, then dashboard.', 'duration': 29.21, 'max_score': 2295.51, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2295510.jpg'}, {'end': 2401.931, 'src': 'heatmap', 'start': 2331.181, 'weight': 1, 'content': [{'end': 2338.682, 'text': 'so you can say enter data OK and you are creating key measures table.', 'start': 2331.181, 'duration': 7.501}, {'end': 2345.138, 'text': "And that is nothing but just a category that you're creating.", 'start': 2340.814, 'duration': 4.324}, {'end': 2347.02, 'text': 'You can remove this column by the way.', 'start': 2345.358, 'duration': 1.662}, {'end': 2349.482, 'text': "Anyways, I'll just create a new column.", 'start': 2347.781, 'duration': 1.701}, {'end': 2354.807, 'text': "Once again, click on new measure and I'll use that same formula.", 'start': 2349.983, 'duration': 4.824}, {'end': 2360.072, 'text': 'So revenue is equal to sum of this thing.', 'start': 2355.488, 'duration': 4.584}, {'end': 2362.675, 'text': 'Hit enter, drag and drop.', 'start': 2360.813, 'duration': 1.862}, {'end': 2365.788, 'text': 'and click on this card icon.', 'start': 2364.286, 'duration': 1.502}, {'end': 2370.015, 'text': 'And you see this kind of revenue, 2 billion revenue, and you can do quick verification.', 'start': 2365.909, 'duration': 4.106}, {'end': 2370.636, 'text': 'This is what I do.', 'start': 2370.055, 'duration': 0.581}, {'end': 2377.968, 'text': "So first I'll go here and go to general properties and, or maybe visual.", 'start': 2371.077, 'duration': 6.891}, {'end': 2384.397, 'text': 'and just show some decimal points so that you can see the exact decimal point.', 'start': 2379.032, 'duration': 5.365}, {'end': 2388.22, 'text': "so let's say my revenue is this, and this is the total revenue.", 'start': 2384.397, 'duration': 3.823}, {'end': 2392.223, 'text': 'so i can go to my excel and, you know, look at the total and verify it quickly.', 'start': 2388.22, 'duration': 4.003}, {'end': 2394.245, 'text': 'so i will go to fact bookings.', 'start': 2392.223, 'duration': 2.022}, {'end': 2401.931, 'text': 'okay, and if i select the whole thing right, so the way you can select it, you Put your mouse here, control,', 'start': 2394.245, 'duration': 7.686}], 'summary': 'Creating key measures table, 2 billion revenue, quick verification in excel.', 'duration': 70.75, 'max_score': 2331.181, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2331181.jpg'}, {'end': 2377.968, 'src': 'embed', 'start': 2349.983, 'weight': 3, 'content': [{'end': 2354.807, 'text': "Once again, click on new measure and I'll use that same formula.", 'start': 2349.983, 'duration': 4.824}, {'end': 2360.072, 'text': 'So revenue is equal to sum of this thing.', 'start': 2355.488, 'duration': 4.584}, {'end': 2362.675, 'text': 'Hit enter, drag and drop.', 'start': 2360.813, 'duration': 1.862}, {'end': 2365.788, 'text': 'and click on this card icon.', 'start': 2364.286, 'duration': 1.502}, {'end': 2370.015, 'text': 'And you see this kind of revenue, 2 billion revenue, and you can do quick verification.', 'start': 2365.909, 'duration': 4.106}, {'end': 2370.636, 'text': 'This is what I do.', 'start': 2370.055, 'duration': 0.581}, {'end': 2377.968, 'text': "So first I'll go here and go to general properties and, or maybe visual.", 'start': 2371.077, 'duration': 6.891}], 'summary': 'Using new measure, the revenue equals sum, achieving 2 billion revenue.', 'duration': 27.985, 'max_score': 2349.983, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2349983.jpg'}, {'end': 2506.832, 'src': 'embed', 'start': 2464.611, 'weight': 4, 'content': [{'end': 2466.753, 'text': 'Again, click new measure.', 'start': 2464.611, 'duration': 2.142}, {'end': 2468.454, 'text': 'This is total bookings.', 'start': 2467.353, 'duration': 1.101}, {'end': 2481.205, 'text': 'So total bookings is equal to sum of fact underscore bookings and booking ID.', 'start': 2468.815, 'duration': 12.39}, {'end': 2484.721, 'text': 'Let me see.', 'start': 2484.301, 'duration': 0.42}, {'end': 2490.984, 'text': 'So what is total number of bookings? So for that you can go to.', 'start': 2484.941, 'duration': 6.043}, {'end': 2493.726, 'text': 'Yes, so the booking ID represents one booking.', 'start': 2490.984, 'duration': 2.742}, {'end': 2496.687, 'text': 'So I should not do sum because this is sum ID.', 'start': 2493.786, 'duration': 2.901}, {'end': 2497.988, 'text': 'I should do actually count.', 'start': 2496.827, 'duration': 1.161}, {'end': 2500.409, 'text': 'So there is this thing called count.', 'start': 2498.148, 'duration': 2.261}, {'end': 2506.832, 'text': 'And I will do fact bookings.', 'start': 2504.15, 'duration': 2.682}], 'summary': 'Total bookings is the count of fact bookings and booking ids.', 'duration': 42.221, 'max_score': 2464.611, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2464611.jpg'}], 'start': 2159.233, 'title': 'Hotel weekend analysis and power bi data transformation', 'summary': 'Discusses creating a dax variable to differentiate between weekday and weekend hotel stays, with a focus on revenue and total bookings measures in power bi, emphasizing the importance of weekends as most popular days for hotel stays.', 'chapters': [{'end': 2216.34, 'start': 2159.233, 'title': 'Hotel weekend analysis', 'summary': 'Discusses creating a dax variable to differentiate between weekday and weekend hotel stays, with most people staying on friday and saturday evenings, and using a formula to classify days as either weekday or weekend based on the variable.', 'duration': 57.107, 'highlights': ["Creating a DAX variable 'WKD' to differentiate between weekday and weekend hotel stays based on the pattern of most people staying on Friday and Saturday evenings.", "Using a formula to classify days as either weekday or weekend based on the variable 'WKD'."]}, {'end': 2554.554, 'start': 2219.422, 'title': 'Power bi data transformation and dashboarding', 'summary': 'Covers the creation of calculated columns and measures in power bi, as well as the flow of data transformation, with a focus on creating revenue and total bookings measures and verifying their accuracy.', 'duration': 335.132, 'highlights': ['Creation of calculated columns and measures in Power BI The process involves creating calculated columns, similar to Excel formulas, and measures in Power BI, with a focus on the flow of data transformation and the subsequent creation of revenue and total bookings measures.', "Verification of revenue measure accuracy The accuracy of the revenue measure is verified by comparing the calculated revenue in Power BI with the total revenue in Excel, providing a comprehensive verification process for the measure's correctness.", 'Creation and validation of total bookings measure The process involves creating a measure for total bookings by counting the booking IDs, ensuring its accuracy by verifying the count and emphasizing the importance of accurate data measurement.']}], 'duration': 395.321, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2159233.jpg', 'highlights': ["Creation of a DAX variable 'WKD' to differentiate between weekday and weekend hotel stays based on the pattern of most people staying on Friday and Saturday evenings.", "Using a formula to classify days as either weekday or weekend based on the variable 'WKD'.", 'Creation of calculated columns and measures in Power BI with a focus on the flow of data transformation and the subsequent creation of revenue and total bookings measures.', "Verification of revenue measure accuracy by comparing the calculated revenue in Power BI with the total revenue in Excel, providing a comprehensive verification process for the measure's correctness.", 'Creation and validation of total bookings measure by counting the booking IDs, ensuring its accuracy by verifying the count and emphasizing the importance of accurate data measurement.']}, {'end': 3035.559, 'segs': [{'end': 2635.19, 'src': 'embed', 'start': 2581.412, 'weight': 0, 'content': [{'end': 2585.455, 'text': 'folks, read those instructions two times and you will get an idea.', 'start': 2581.412, 'duration': 4.043}, {'end': 2588.896, 'text': 'you should have all these files on your desktop.', 'start': 2586.315, 'duration': 2.581}, {'end': 2597.039, 'text': 'You should have downloaded these files, okay? And in these files, you will see this file called metricslist.xls.', 'start': 2588.916, 'duration': 8.123}, {'end': 2609.704, 'text': 'And when you open that, that file contains all the metrics that you need, okay? So remember, we created two calculated columns, w and datatype.', 'start': 2597.099, 'duration': 12.605}, {'end': 2619.235, 'text': 'We have given you all the measures So we created these four measures, okay? I want you to create the remaining measures.', 'start': 2609.884, 'duration': 9.351}, {'end': 2625.922, 'text': "Because if you want to learn Power BI and you sit on your sofa and watch me, you're not going to learn it.", 'start': 2620.657, 'duration': 5.265}, {'end': 2629.085, 'text': 'You can learn it only if you practice.', 'start': 2626.582, 'duration': 2.503}, {'end': 2635.19, 'text': "And I want to make sure you learn it, okay? For that reason, I'm not gonna do all these things.", 'start': 2629.885, 'duration': 5.305}], 'summary': 'Instructions for downloading and using metricslist.xls for power bi; emphasizes practice for learning.', 'duration': 53.778, 'max_score': 2581.412, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2581412.jpg'}, {'end': 2740.381, 'src': 'embed', 'start': 2706.65, 'weight': 3, 'content': [{'end': 2715.712, 'text': 'i want you to create all these formulas and in the next section we are going to cover the actual dashboard creation.', 'start': 2706.65, 'duration': 9.062}, {'end': 2722.433, 'text': 'We are all set to start our dashboarding process.', 'start': 2718.951, 'duration': 3.482}, {'end': 2728.655, 'text': 'So I will first create the table here, which can represent various metrics.', 'start': 2723.193, 'duration': 5.462}, {'end': 2733.418, 'text': 'So for example, we can drag and drop property ID.', 'start': 2728.715, 'duration': 4.703}, {'end': 2735.198, 'text': 'So property ID here.', 'start': 2733.458, 'duration': 1.74}, {'end': 2740.381, 'text': "Okay So let's say this is property ID.", 'start': 2737.74, 'duration': 2.641}], 'summary': 'Creating formulas and dashboard for various metrics and property id.', 'duration': 33.731, 'max_score': 2706.65, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2706650.jpg'}, {'end': 2894.941, 'src': 'embed', 'start': 2869.744, 'weight': 4, 'content': [{'end': 2875.048, 'text': 'okay, because see, when you select this visual, there is a separate filter when you click on a blank area.', 'start': 2869.744, 'duration': 5.304}, {'end': 2877.589, 'text': 'that is the filter on the entire page.', 'start': 2875.048, 'duration': 2.541}, {'end': 2879.711, 'text': 'okay, so i remove w32.', 'start': 2877.589, 'duration': 2.122}, {'end': 2881.532, 'text': 'everything else is checked.', 'start': 2879.711, 'duration': 1.821}, {'end': 2883.653, 'text': "let's go back to our main visual.", 'start': 2881.532, 'duration': 2.121}, {'end': 2886.976, 'text': 'so basically, i dragged and dropped all these columns.', 'start': 2883.653, 'duration': 3.323}, {'end': 2893.18, 'text': 'now, when you look at it, you know you have immediate thoughts in terms of formatting, for example revenue.', 'start': 2886.976, 'duration': 6.204}, {'end': 2894.941, 'text': 'it would be nice if there is.', 'start': 2893.18, 'duration': 1.761}], 'summary': 'Discussion about applying filters and formatting visuals in a data visualization tool.', 'duration': 25.197, 'max_score': 2869.744, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2869744.jpg'}], 'start': 2554.554, 'title': 'Creating calculated columns and power bi measures', 'summary': 'Covers creating two calculated columns in metricslist.xls and emphasizes the importance of creating 26 measures in power bi, guiding on dashboard creation and visualization formatting for revenue, rev power, occupancy percentage, and adr.', 'chapters': [{'end': 2609.704, 'start': 2554.554, 'title': 'Creating calculated columns in metricslist', 'summary': "Covers the process of creating two calculated columns, 'w' and 'datatype', using the file metricslist.xls, providing clear instructions for successful implementation.", 'duration': 55.15, 'highlights': ['The file metricslist.xls contains all the metrics needed for the calculated columns.', 'Clear instructions are provided in the video description and should be read twice for better understanding.', "Creating two calculated columns, 'w' and 'datatype', is essential for analyzing successful bookings."]}, {'end': 3035.559, 'start': 2609.884, 'title': 'Creating power bi measures and dashboarding', 'summary': 'Emphasizes the importance of creating all 26 measures in power bi, encourages practice and self-learning, provides guidance on creating a dashboard, and demonstrates formatting visualizations for revenue, rev power, occupancy percentage, and adr.', 'duration': 425.675, 'highlights': ['The chapter emphasizes the importance of creating all 26 measures in Power BI The speaker stresses the significance of creating all 26 measures in Power BI to facilitate learning and understanding of formulas.', 'Encourages practice and self-learning The speaker encourages the audience to practice and understand the formulas, highlighting the importance of self-learning for effective comprehension.', 'Provides guidance on creating a dashboard The speaker provides guidance on creating a dashboard by demonstrating the process of selecting and arranging necessary columns from tables in Power BI.', 'Demonstrates formatting visualizations for revenue, rev power, occupancy percentage, and ADR The speaker demonstrates the process of formatting visualizations in Power BI, including setting revenue to display in millions, removing decimals for rev power and ADR, and converting percentage numbers to the correct format for occupancy, realization, and cancellation.']}], 'duration': 481.005, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc2554554.jpg', 'highlights': ["Creating two calculated columns, 'w' and 'datatype', is essential for analyzing successful bookings.", 'The file metricslist.xls contains all the metrics needed for the calculated columns.', 'The chapter emphasizes the importance of creating all 26 measures in Power BI to facilitate learning and understanding of formulas.', 'Provides guidance on creating a dashboard and arranging necessary columns from tables in Power BI.', 'Demonstrates formatting visualizations for revenue, rev power, occupancy percentage, and ADR in Power BI.']}, {'end': 4345.266, 'segs': [{'end': 3088.136, 'src': 'embed', 'start': 3060.453, 'weight': 0, 'content': [{'end': 3064.515, 'text': "Let's say one is 100, another one is 50, this one is half of it.", 'start': 3060.453, 'duration': 4.062}, {'end': 3067.257, 'text': 'If you have that visual comparison, it helps.', 'start': 3064.575, 'duration': 2.682}, {'end': 3072.46, 'text': 'You can do that by clicking on this visual once again going here.', 'start': 3068.117, 'duration': 4.343}, {'end': 3082.409, 'text': 'then in revenue you can click on this down arrow and say conditional formatting and say data bar, and in that you can select the color of the bar.', 'start': 3073.619, 'duration': 8.79}, {'end': 3088.136, 'text': "let's see if you just say okay, it's gonna use the default color, i mean i i want to use a different color.", 'start': 3082.409, 'duration': 5.727}], 'summary': 'Visual comparisons with revenue data using data bars can aid in decision-making.', 'duration': 27.683, 'max_score': 3060.453, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc3060453.jpg'}, {'end': 3173.133, 'src': 'embed', 'start': 3109.301, 'weight': 1, 'content': [{'end': 3113.143, 'text': 'And when you say hit OK, you will see that color here.', 'start': 3109.301, 'duration': 3.842}, {'end': 3116.205, 'text': 'And you can do the same thing with the rating, by the way.', 'start': 3113.524, 'duration': 2.681}, {'end': 3122.09, 'text': 'So for rating also, I will say conditional formatting, data bar.', 'start': 3116.746, 'duration': 5.344}, {'end': 3129.609, 'text': 'more colors and use the same color.', 'start': 3123.22, 'duration': 6.389}, {'end': 3132.694, 'text': 'okay. so everything looks kind of nice.', 'start': 3129.609, 'duration': 3.085}, {'end': 3133.775, 'text': 'and see these ratings now.', 'start': 3132.694, 'duration': 1.081}, {'end': 3138.802, 'text': 'visually, you can kind of compare based on the the length of the horizontal bar.', 'start': 3133.775, 'duration': 5.027}, {'end': 3148.57, 'text': "Uh, let's maybe reduce a font a little bit, so you can just go to selectable values.", 'start': 3140.723, 'duration': 7.847}, {'end': 3154.996, 'text': 'Okay You can go to values, maybe reduce the size of the font a little bit, not too much.', 'start': 3148.85, 'duration': 6.146}, {'end': 3159.63, 'text': 'And now my chart kind of looks nice and tidy.', 'start': 3156.189, 'duration': 3.441}, {'end': 3162.05, 'text': 'Now let me add some filters here at the top.', 'start': 3159.89, 'duration': 2.16}, {'end': 3173.133, 'text': 'So you want to add a filter for maybe cities, correct? I mean, if you looked at our mock-ups, I think mock-ups had, let me see.', 'start': 3162.67, 'duration': 10.463}], 'summary': 'Applied conditional formatting for data bars and adjusted font size, resulting in a visually appealing and tidy chart.', 'duration': 63.832, 'max_score': 3109.301, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc3109301.jpg'}, {'end': 3233.795, 'src': 'embed', 'start': 3205.455, 'weight': 4, 'content': [{'end': 3210.519, 'text': 'So if you go to here, you can see what kind of visual you want to have here.', 'start': 3205.455, 'duration': 5.064}, {'end': 3214.602, 'text': 'And the kind of visual you want to have here is slicer.', 'start': 3210.999, 'duration': 3.603}, {'end': 3217.925, 'text': 'So click on slicer here and see now you have filter.', 'start': 3214.622, 'duration': 3.303}, {'end': 3219.326, 'text': 'So you can now filter results.', 'start': 3217.945, 'duration': 1.381}, {'end': 3223.469, 'text': "So you can say Delhi, now you're seeing only properties from Delhi, Hyderabad and so on.", 'start': 3219.346, 'duration': 4.123}, {'end': 3227.292, 'text': 'I will make this a dropdown.', 'start': 3225.05, 'duration': 2.242}, {'end': 3230.254, 'text': 'So you can just go to slicer setting, make it dropdown.', 'start': 3227.352, 'duration': 2.902}, {'end': 3233.795, 'text': 'You know, that way I can just select it.', 'start': 3231.274, 'duration': 2.521}], 'summary': 'Demonstrating how to use slicer feature to filter data, including making it a dropdown.', 'duration': 28.34, 'max_score': 3205.455, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc3205455.jpg'}, {'end': 3324.643, 'src': 'embed', 'start': 3288.673, 'weight': 2, 'content': [{'end': 3293.715, 'text': 'You can remove this city here and see now allied premium, et cetera.', 'start': 3288.673, 'duration': 5.042}, {'end': 3296.456, 'text': 'And you can just change the title pretty quickly here.', 'start': 3293.775, 'duration': 2.681}, {'end': 3300.858, 'text': 'You can say filter by room type.', 'start': 3297.217, 'duration': 3.641}, {'end': 3312.951, 'text': 'And you can decrease the font size just in case.', 'start': 3307.685, 'duration': 5.266}, {'end': 3318.359, 'text': '11, and here also you can make it 11.', 'start': 3312.971, 'duration': 5.388}, {'end': 3324.643, 'text': 'See now, because of the data model that we created, we created this data model and we established all this relationship here.', 'start': 3318.359, 'duration': 6.284}], 'summary': 'Data model created with established relationships, font size adjusted, and city removed.', 'duration': 35.97, 'max_score': 3288.673, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc3288673.jpg'}, {'end': 3567.33, 'src': 'embed', 'start': 3474.574, 'weight': 5, 'content': [{'end': 3486.197, 'text': 'but overall you know you can just do some rough work to kind of position these controls nicely and then you can kind of give a finishing touch later on.', 'start': 3474.574, 'duration': 11.623}, {'end': 3492.478, 'text': 'But when you select any month, see, this other filter will also get impacted.', 'start': 3486.817, 'duration': 5.661}, {'end': 3493.518, 'text': 'So you can say W19, W20, and so on.', 'start': 3492.678, 'duration': 0.84}, {'end': 3502.862, 'text': 'Okay, you can do quick data validation by going to your CSV file and filtering.', 'start': 3497.918, 'duration': 4.944}, {'end': 3506.625, 'text': "Let's say you are filtering by Delhi and you want to make sure these numbers are correct.", 'start': 3502.922, 'duration': 3.703}, {'end': 3510.969, 'text': 'You can go to CSV file filter and do that kind of data validation.', 'start': 3506.665, 'duration': 4.304}, {'end': 3517.694, 'text': "As a next step, we'll start putting our key performance indicator such as revenue at the top.", 'start': 3511.649, 'duration': 6.045}, {'end': 3519.155, 'text': "So let's do that.", 'start': 3518.335, 'duration': 0.82}, {'end': 3523.439, 'text': 'So here I will type in revenue, drag and drop here.', 'start': 3519.395, 'duration': 4.044}, {'end': 3529.893, 'text': 'and this i want as a card visual so that you can see the number.', 'start': 3524.79, 'duration': 5.103}, {'end': 3532.175, 'text': 'i will unselect it and it will just show you the whole number.', 'start': 3529.893, 'duration': 2.282}, {'end': 3540.1, 'text': 'i will go to the properties and we will change the decimals.', 'start': 3532.175, 'duration': 7.925}, {'end': 3544.663, 'text': 'so maybe we can just do like two decimals here and you can change the color as well.', 'start': 3540.1, 'duration': 4.563}, {'end': 3554.982, 'text': 'Okay, you can put some nice color here.', 'start': 3552.56, 'duration': 2.422}, {'end': 3558.784, 'text': 'You can say category label off.', 'start': 3556.223, 'duration': 2.561}, {'end': 3561.266, 'text': "So I don't have the category label.", 'start': 3559.585, 'duration': 1.681}, {'end': 3567.33, 'text': 'You can, by the way, create custom title as well.', 'start': 3564.809, 'duration': 2.521}], 'summary': 'Demonstrates data validation and visualization in power bi, using filters and kpis for revenue with customization options.', 'duration': 92.756, 'max_score': 3474.574, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc3474574.jpg'}, {'end': 3685.683, 'src': 'heatmap', 'start': 3620.15, 'weight': 0.721, 'content': [{'end': 3624.415, 'text': 'so i want to put the change amount below revenue.', 'start': 3620.15, 'duration': 4.265}, {'end': 3626.018, 'text': 'title. okay.', 'start': 3624.415, 'duration': 1.603}, {'end': 3639.359, 'text': 'so let me convert this to, first of all, a card and here see, when you click on any week, this number shows a week on week change.', 'start': 3626.018, 'duration': 13.341}, {'end': 3646.661, 'text': 'okay, so this label is kind of very big.', 'start': 3639.359, 'duration': 7.302}, {'end': 3649.522, 'text': "so i'll just rename it and i'll just call it dot.", 'start': 3646.661, 'duration': 2.861}, {'end': 3656.024, 'text': "the reason i'm calling it dot is because let me just show you the final dashboard so that you get a clear idea.", 'start': 3649.522, 'duration': 6.502}, {'end': 3657.464, 'text': 'see, i want to have this kind of visual.', 'start': 3656.024, 'duration': 1.44}, {'end': 3663.306, 'text': 'this is 0.2 percentage and if the number is going up, you can have up and down and all that.', 'start': 3657.464, 'duration': 5.842}, {'end': 3666.268, 'text': "That is the reason I'm doing all this.", 'start': 3664.847, 'duration': 1.421}, {'end': 3674.014, 'text': 'So you will go here and change the size.', 'start': 3667.129, 'duration': 6.885}, {'end': 3679.978, 'text': 'So maybe 88, you know, make it a small size.', 'start': 3674.454, 'duration': 5.524}, {'end': 3685.683, 'text': "Also, let's see.", 'start': 3682.02, 'duration': 3.663}], 'summary': 'Change amount displayed as week-on-week percentage for a dashboard with 0.2% visual representation.', 'duration': 65.533, 'max_score': 3620.15, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc3620150.jpg'}, {'end': 3737.792, 'src': 'embed', 'start': 3706.401, 'weight': 8, 'content': [{'end': 3720.929, 'text': 'you can put this number here again, reduce the size a little more and then now see.', 'start': 3706.401, 'duration': 14.528}, {'end': 3724.53, 'text': 'what i want is when, when this number is changing from week to week.', 'start': 3720.929, 'duration': 3.601}, {'end': 3730.871, 'text': "if there is a negative change, i want to show some down arrow and if it's a, for example, here's a positive change.", 'start': 3724.53, 'duration': 6.341}, {'end': 3734.372, 'text': 'so it will help if we can show up arrow here is negative.', 'start': 3730.871, 'duration': 3.501}, {'end': 3736.152, 'text': 'so it will help if we show the down arrow.', 'start': 3734.372, 'duration': 1.78}, {'end': 3737.792, 'text': 'so how do you do that?', 'start': 3736.152, 'duration': 1.64}], 'summary': 'Requesting visual indicators for positive and negative changes in numbers.', 'duration': 31.391, 'max_score': 3706.401, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc3706401.jpg'}, {'end': 4036.925, 'src': 'heatmap', 'start': 3906.791, 'weight': 9, 'content': [{'end': 3914.737, 'text': 'So basically, if I hold my mouse cursor here, it will be nice if I see a nice tooltip where I can see week by week revenue trend.', 'start': 3906.791, 'duration': 7.946}, {'end': 3918.039, 'text': 'And the way to do that will be to create a new page.', 'start': 3915.177, 'duration': 2.862}, {'end': 3920.901, 'text': 'And you can say tooltip.', 'start': 3918.92, 'duration': 1.981}, {'end': 3929.135, 'text': 'Okay, revenue, and here you can drag and drop your revenue.', 'start': 3921.682, 'duration': 7.453}, {'end': 3930.356, 'text': 'but i will not drag and drop.', 'start': 3929.135, 'duration': 1.221}, {'end': 3932.017, 'text': "i'll probably create a line chart first.", 'start': 3930.356, 'duration': 1.661}, {'end': 3933.898, 'text': "so i'll just say line chart.", 'start': 3932.017, 'duration': 1.881}, {'end': 3940.982, 'text': 'and in that line chart my y-axis is revenue but my x-axis is weak number.', 'start': 3933.898, 'duration': 7.084}, {'end': 3943.244, 'text': 'so my x-axis is weak number.', 'start': 3940.982, 'duration': 2.262}, {'end': 3949.118, 'text': 'okay, so i see a nice line chart.', 'start': 3945.814, 'duration': 3.304}, {'end': 3951.32, 'text': 'i want to have a category as well.', 'start': 3949.118, 'duration': 2.202}, {'end': 3955.744, 'text': 'uh, so that i know, like business versus normal residential.', 'start': 3951.32, 'duration': 4.424}, {'end': 3958.347, 'text': 'so you, you can drag and drop this into legion.', 'start': 3955.744, 'duration': 2.603}, {'end': 3962.431, 'text': 'so business versus luxury, what is that breakdown?', 'start': 3958.347, 'duration': 4.084}, {'end': 3972.275, 'text': 'so you see two different lines and then, uh, you can turn on your data labels, maybe, and also turn on your data markers.', 'start': 3962.431, 'duration': 9.844}, {'end': 3981.698, 'text': 'And in the page setting, you can say that allow to use this as a tooltip.', 'start': 3972.355, 'duration': 9.343}, {'end': 3984.839, 'text': 'Allow to use this as a tooltip in some other visual.', 'start': 3981.818, 'duration': 3.021}, {'end': 4006.059, 'text': 'So now, when you go here and when you click this and when you say tooltips okay, tooltips, this see, it may take some time like,', 'start': 3985.299, 'duration': 20.76}, {'end': 4009.641, 'text': 'but now it is showing kind of that nice tooltip.', 'start': 4006.059, 'duration': 3.582}, {'end': 4016.043, 'text': "here you can adjust the dimension of this page, by the way, so that the tooltip doesn't look too big.", 'start': 4009.641, 'duration': 6.402}, {'end': 4036.925, 'text': 'All right, so I can have this kind of tooltip and I can just change my filter and tooltip and everything will get changed accordingly.', 'start': 4026.98, 'duration': 9.945}], 'summary': 'Create a tooltip with revenue trend and category breakdown using line chart and filters.', 'duration': 27.107, 'max_score': 3906.791, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc3906791.jpg'}, {'end': 4350.15, 'src': 'embed', 'start': 4323.049, 'weight': 10, 'content': [{'end': 4327.232, 'text': 'So I want to show you an MVP here a minimum viable product.', 'start': 4323.049, 'duration': 4.183}, {'end': 4327.933, 'text': 'This is functional.', 'start': 4327.252, 'duration': 0.681}, {'end': 4329.014, 'text': 'You can use it right away.', 'start': 4327.973, 'duration': 1.041}, {'end': 4331.736, 'text': 'And you can use it and give me some feedback.', 'start': 4329.734, 'duration': 2.002}, {'end': 4335.739, 'text': 'Then I would do some beautifications, and I would do some final touch-ups and give you the final version.', 'start': 4331.816, 'duration': 3.923}, {'end': 4337.801, 'text': 'So this is not 100% complete.', 'start': 4336.439, 'duration': 1.362}, {'end': 4340.202, 'text': 'So you might see some things which are not finished.', 'start': 4337.821, 'duration': 2.381}, {'end': 4342.584, 'text': 'And this is like a preview for you.', 'start': 4340.803, 'duration': 1.781}, {'end': 4345.266, 'text': 'Sure, sure.', 'start': 4343.785, 'duration': 1.481}, {'end': 4348.069, 'text': 'And of course, you have the monthly filters here.', 'start': 4345.887, 'duration': 2.182}, {'end': 4350.15, 'text': 'You can basically move between the play between the months.', 'start': 4348.169, 'duration': 1.981}], 'summary': 'Preview mvp; functional, needs beautification; monthly filters available.', 'duration': 27.101, 'max_score': 4323.049, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc4323049.jpg'}], 'start': 3036.459, 'title': 'Data visualization and customization', 'summary': 'Covers excel conditional formatting for visual comparison, data visualization filters and slicers, creation of date and week filters, customization of visuals and icons in a dashboard, and dashboarding tips. it includes methods for enhancing visual comprehension and analysis, adjusting font size and visual types, creating date and week filters, and customizing visuals and icons in a dashboard. the content aims to provide a minimum viable product for user feedback and demonstrates the impact of filters on data validation and key performance indicators.', 'chapters': [{'end': 3138.802, 'start': 3036.459, 'title': 'Excel conditional formatting for visual comparison', 'summary': 'Explains how to use conditional formatting in excel to create horizontal data bars for revenue and rating comparison, enhancing visual comprehension and analysis of the data.', 'duration': 102.343, 'highlights': ['Conditional formatting in Excel can be used to create horizontal data bars for revenue and rating comparison, aiding in the visual comprehension and analysis of the data.', 'The visual comparison through data bars helps in understanding the relative values, for example, if one revenue is 100 and another is 50, the latter is half of the former.', 'Hexadecimal values can be used to customize the color of the data bars, enhancing the visual appeal and differentiation of the bars.', 'The visual comparison feature improves data analysis by allowing for quick and easy relative comparisons of revenue and rating values.']}, {'end': 3346.409, 'start': 3140.723, 'title': 'Data visualization filters and slicers', 'summary': 'Discusses adding filters and slicers for data visualization, including city and room type filters, and adjusting font size and visual types to improve data analysis and user experience.', 'duration': 205.686, 'highlights': ['Adding filters for city and room type to the data visualization dashboard. The transcript discusses adding filters for city and room type to the data visualization dashboard, enhancing the ability to analyze data by specific criteria.', 'Adjusting font size and visual types for improved data analysis and user experience. The speaker emphasizes the importance of adjusting font size and visual types to ensure a tidy and user-friendly data visualization dashboard, potentially improving user experience and data analysis efficiency.', 'Utilizing slicers and dropdown menus to manage space and enhance user interaction. The transcript highlights the use of slicers and dropdown menus to manage space efficiently and enhance user interaction, potentially improving the overall usability of the data visualization dashboard.', 'Impact of data model on filter functionality and data analysis. The speaker explains how the established data model influences the functionality of filters, indicating that the data model plays a crucial role in enabling effective data analysis and filter functionality.']}, {'end': 3529.893, 'start': 3346.809, 'title': 'Creating date and week filters in data visualization', 'summary': 'Demonstrates creating date and week filters for data visualization, adjusting formatting to display shorter date styles, and using tile slicers to filter data, impacting other filters, enabling quick data validation by filtering in a csv file, and placing revenue as a key performance indicator in a card visual.', 'duration': 183.084, 'highlights': ['Creating date and week filters for data visualization, adjusting formatting to display shorter date styles, and using tile slicers to filter data, impacting other filters.', 'Enabling quick data validation by filtering in a CSV file to ensure correct numbers and data.', 'Placing revenue as a key performance indicator in a card visual for clear display and analysis.']}, {'end': 3774.241, 'start': 3529.893, 'title': 'Customizing visuals and icons in dashboard', 'summary': 'Explains the process of customizing visuals and icons in a dashboard, including changing decimal points, color, creating custom titles, adjusting font size, and adding up/down arrows for positive and negative changes in numbers.', 'duration': 244.348, 'highlights': ['By customizing visuals, users can change decimal points and colors, and create custom titles to enhance the appearance of the dashboard.', 'Adjusting font size and alignment allows for better presentation of visual elements, such as label and title positioning.', 'Adding up and down arrows to represent positive and negative changes in numbers provides visual cues for data interpretation.']}, {'end': 4345.266, 'start': 3774.241, 'title': 'Dashboarding tips & visualization demo', 'summary': 'Discusses creating visualizations in power bi, including using arrows to represent data trends, creating tooltips for revenue trends, and building a dashboard with key metrics and filters, aiming to provide a minimum viable product for user feedback.', 'duration': 571.025, 'highlights': ['Creating visualizations in Power BI, using arrows to represent data trends and creating tooltips for revenue trends The speaker explains how to use conditional formatting to display up, down, or no change arrows based on the value of the data, and demonstrates creating a tooltip to show week-by-week revenue trend using a line chart and category breakdown.', 'Building a dashboard with key metrics and filters to provide a minimum viable product for user feedback The speaker emphasizes the importance of creating a functional dashboard with key metrics and filters, allowing for user feedback to further refine and finalize the dashboard.']}], 'duration': 1308.807, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc3036459.jpg', 'highlights': ['Conditional formatting in Excel aids visual comprehension and analysis of data.', 'Customizing data bar colors enhances visual appeal and differentiation.', 'Adding filters for city and room type enhances data analysis by specific criteria.', 'Adjusting font size and visual types improves data analysis and user experience.', 'Utilizing slicers and dropdown menus enhances user interaction and usability.', 'Creating date and week filters impacts other filters and enables quick data validation.', 'Placing revenue as a key performance indicator in a card visual allows for clear display and analysis.', 'Customizing visuals allows for changing decimal points, colors, and creating custom titles.', 'Adding up and down arrows provides visual cues for data interpretation.', 'Creating visualizations in Power BI using arrows and tooltips represents data trends and revenue analysis.', 'Building a dashboard with key metrics and filters provides a minimum viable product for user feedback.']}, {'end': 4942.116, 'segs': [{'end': 4413.3, 'src': 'embed', 'start': 4384.051, 'weight': 1, 'content': [{'end': 4390.636, 'text': 'Based on my understanding, I understood occupancy percentage, ref power and realization percentage are like the super key metrics out of the six.', 'start': 4384.051, 'duration': 6.585}, {'end': 4399.902, 'text': 'Would you like to add something more here and how do you like this representation? So the weekday weekend split becomes very critical.', 'start': 4391.817, 'duration': 8.085}, {'end': 4401.772, 'text': 'in our level two analysis.', 'start': 4400.791, 'duration': 0.981}, {'end': 4405.554, 'text': 'And you have successfully captured the key metrics.', 'start': 4402.652, 'duration': 2.902}, {'end': 4413.3, 'text': 'There is one metric, which is basically a combination of reference and occupancy, that is ADR, which if added here, can give slightly more details.', 'start': 4406.515, 'duration': 6.785}], 'summary': 'Occupancy percentage, ref power, and realization percentage are key metrics. adr can provide more details.', 'duration': 29.249, 'max_score': 4384.051, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc4384051.jpg'}, {'end': 4534.221, 'src': 'embed', 'start': 4461.65, 'weight': 0, 'content': [{'end': 4468.674, 'text': "I would say it's more like how it behaves across different platforms, different channels during bookings and realisation.", 'start': 4461.65, 'duration': 7.024}, {'end': 4469.854, 'text': "Okay, you're good.", 'start': 4469.014, 'duration': 0.84}, {'end': 4473.336, 'text': "Can you filter it without the city? I'd like to see the overall data.", 'start': 4469.955, 'duration': 3.381}, {'end': 4474.877, 'text': 'Yes, sure.', 'start': 4473.696, 'duration': 1.181}, {'end': 4482.121, 'text': 'So for filtering the city, just to let you know, you can just come to this place and click this button, it just clears the selections.', 'start': 4475.297, 'duration': 6.824}, {'end': 4484.302, 'text': 'So you basically see everything back now.', 'start': 4482.701, 'duration': 1.601}, {'end': 4490.485, 'text': "Fantastic And we were looking at a month level data or let's just pick one month.", 'start': 4486.121, 'duration': 4.364}, {'end': 4492.967, 'text': "Yeah, I'll just pick June.", 'start': 4490.905, 'duration': 2.062}, {'end': 4496.53, 'text': 'Fantastic Great.', 'start': 4494.288, 'duration': 2.242}, {'end': 4498.752, 'text': 'This view is helpful.', 'start': 4497.43, 'duration': 1.322}, {'end': 4503.676, 'text': 'So I think you successfully covered all the level one data.', 'start': 4499.732, 'duration': 3.944}, {'end': 4511.903, 'text': 'And also, I think this dashboard helps me do some sort of analysis where I can already take decisions.', 'start': 4504.416, 'duration': 7.487}, {'end': 4513.884, 'text': 'this is very helpful for me.', 'start': 4512.603, 'duration': 1.281}, {'end': 4515.766, 'text': 'i will give you a quick example, right?', 'start': 4513.884, 'duration': 1.882}, {'end': 4524.893, 'text': 'yes, so we have different levers to improve revenue business in the hotel industry, and one of the biggest levers we have is pricing.', 'start': 4515.766, 'duration': 9.127}, {'end': 4527.635, 'text': "i'll just give you a quick example what i mean by that.", 'start': 4524.893, 'duration': 2.742}, {'end': 4534.221, 'text': 'so, for example, you go on amazon, you want to buy a pair of shoes right, and today those shoes are worth 10 000..', 'start': 4527.635, 'duration': 6.586}], 'summary': 'Analyzing booking data to make revenue decisions in hotel industry.', 'duration': 72.571, 'max_score': 4461.65, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc4461650.jpg'}, {'end': 4780.825, 'src': 'embed', 'start': 4754.616, 'weight': 4, 'content': [{'end': 4760.36, 'text': 'The second is weekday weekend pricing wherein we have a different rate for weekdays and different rate for weekends.', 'start': 4754.616, 'duration': 5.744}, {'end': 4767.185, 'text': 'And the third would be dynamic pricing wherein your pricing would change basis occupancy, could change basis competition rates.', 'start': 4760.86, 'duration': 6.325}, {'end': 4769.526, 'text': 'There could be multiple subsets of dynamic pricing.', 'start': 4767.385, 'duration': 2.141}, {'end': 4777.043, 'text': 'I want to check whether this hotel is on flat pricing or is he even using weekday weekend pricing?', 'start': 4770.78, 'duration': 6.263}, {'end': 4780.825, 'text': 'And to see that we should look at the table on the left.', 'start': 4777.783, 'duration': 3.042}], 'summary': 'Hotel pricing includes flat, weekday weekend, and dynamic pricing based on occupancy and competition rates.', 'duration': 26.209, 'max_score': 4754.616, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc4754616.jpg'}], 'start': 4345.887, 'title': 'Data analysis and hotel revenue strategy', 'summary': 'Discusses data analysis, visualization, and revenue strategy, emphasizing monthly filters, key metric representation, platform trend analysis, dynamic pricing, and weekday-weekend pricing to aid decision-making and maximize revenue gains.', 'chapters': [{'end': 4513.884, 'start': 4345.887, 'title': 'Data analysis and visualization discussion', 'summary': 'Discusses the process of data analysis and visualization, covering key points such as monthly filters, representation of key metrics, and platform trend analysis, ultimately aiding in decision-making.', 'duration': 167.997, 'highlights': ['The chapter discusses the process of data analysis and visualization, covering key points such as monthly filters, representation of key metrics, and platform trend analysis, ultimately aiding in decision-making.', 'The representation of key metrics like occupancy percentage, revpar, and realization percentage is highlighted as crucial for level two analysis, with the suggestion to include ADR for more detailed insights.', 'The process of filtering data without the city is explained, providing a comprehensive overview of overall data.', 'The discussion emphasizes the capability of the dashboard to aid in decision-making through analysis and visualization of data.', 'The conversation includes considerations for adjusting the order of key metrics and the addition of booking platforms for trend analysis.']}, {'end': 4942.116, 'start': 4513.884, 'title': 'Hotel revenue strategy analysis', 'summary': 'Highlights the importance of pricing strategy in the hotel industry, emphasizing the potential revenue gains from dynamic pricing and weekday weekend pricing, supported by concrete examples and data analysis.', 'duration': 428.232, 'highlights': ['The rule of demand and supply and price elasticity is very different for the travel and tourism industry versus the product industry, and dynamic pricing can lead to significant revenue increases.', 'The data analysis reveals that the hotel does not use any pricing strategy, evidenced by flat ADR and lack of fluctuation in rates, indicating a substantial opportunity for revenue optimization through dynamic pricing.', 'The transcript emphasizes the potential impact of pricing strategy on occupancy, highlighting the importance of adjusting pricing based on demand and seasonal trends to maximize revenue potential.']}], 'duration': 596.229, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc4345887.jpg', 'highlights': ['Dynamic pricing can lead to significant revenue increases in the travel and tourism industry.', 'The representation of key metrics like occupancy percentage, revpar, and realization percentage is crucial for level two analysis.', 'The process of filtering data without the city provides a comprehensive overview of overall data.', 'The chapter discusses the process of data analysis and visualization, covering key points such as monthly filters and platform trend analysis.', 'The potential impact of pricing strategy on occupancy is highlighted, emphasizing the importance of adjusting pricing based on demand and seasonal trends.']}, {'end': 5838.881, 'segs': [{'end': 4975.259, 'src': 'embed', 'start': 4942.116, 'weight': 0, 'content': [{'end': 4942.716, 'text': 'to be honest, right?', 'start': 4942.116, 'duration': 0.6}, {'end': 4950.041, 'text': 'but it is a fact that when you drop rates, you do see a pickup in occupancy.', 'start': 4943.456, 'duration': 6.585}, {'end': 4953.063, 'text': 'when you increase rates, you do see a drop in occupancy.', 'start': 4950.041, 'duration': 3.022}, {'end': 4954.464, 'text': 'that is a fact.', 'start': 4953.063, 'duration': 1.401}, {'end': 4958.147, 'text': 'there are few markets that are inelastic and few markets that are elastic.', 'start': 4954.464, 'duration': 3.683}, {'end': 4960.408, 'text': 'this is a slightly more complicated concept.', 'start': 4958.147, 'duration': 2.261}, {'end': 4964.791, 'text': 'but most hotels, if you drop rates, you will see a pickup in occupancy.', 'start': 4960.408, 'duration': 4.383}, {'end': 4965.432, 'text': 'that is true.', 'start': 4964.791, 'duration': 0.641}, {'end': 4965.952, 'text': "got it, that's.", 'start': 4965.432, 'duration': 0.52}, {'end': 4968.394, 'text': "that's a very simple, you know, straightforward funder.", 'start': 4965.952, 'duration': 2.442}, {'end': 4970.936, 'text': "i think that's that's basic, okay.", 'start': 4968.394, 'duration': 2.542}, {'end': 4975.259, 'text': "and uh, so like please, i'd like to take one opportunity to pick.", 'start': 4970.936, 'duration': 4.323}], 'summary': 'Lower rates increase occupancy, while higher rates decrease it in most hotel markets.', 'duration': 33.143, 'max_score': 4942.116, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc4942116.jpg'}, {'end': 5068.228, 'src': 'embed', 'start': 5043.867, 'weight': 3, 'content': [{'end': 5052.852, 'text': 'Today, the market is such that you, me, all of us, anybody who buys anything online, we are drastically affected by ratings and reviews.', 'start': 5043.867, 'duration': 8.985}, {'end': 5058.197, 'text': 'and in our industry, and most of the channels you have picked are online channels right.', 'start': 5053.772, 'duration': 4.425}, {'end': 5065.805, 'text': 'so most of the products that are sold online have a higher probability of selling if your rating is higher,', 'start': 5058.197, 'duration': 7.608}, {'end': 5068.228, 'text': 'and it is evident that this hotel is not work,', 'start': 5065.805, 'duration': 2.423}], 'summary': 'Online ratings significantly impact purchasing decisions; higher ratings correlate with increased sales.', 'duration': 24.361, 'max_score': 5043.867, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc5043867.jpg'}, {'end': 5142.717, 'src': 'embed', 'start': 5110.222, 'weight': 1, 'content': [{'end': 5112.203, 'text': 'That is evident by the data you have created.', 'start': 5110.222, 'duration': 1.981}, {'end': 5116.64, 'text': 'Yeah, and I also see that coincidence with the cancellation rates as well.', 'start': 5112.737, 'duration': 3.903}, {'end': 5121.303, 'text': 'So when the occupancy is low and the rating is low, the cancellation is also quite high.', 'start': 5117.12, 'duration': 4.183}, {'end': 5128.549, 'text': 'I feel that people kind of book this hotel just to secure a place and they just keep it as a second option.', 'start': 5121.964, 'duration': 6.585}, {'end': 5131.591, 'text': "Probably they just cancel it after they find a better option and that's the reason.", 'start': 5128.789, 'duration': 2.802}, {'end': 5134.513, 'text': "The hotel is the best, probably they don't cancel it.", 'start': 5131.611, 'duration': 2.902}, {'end': 5142.717, 'text': 'So what you are mentioning is a very common thing in the hotel industry.', 'start': 5138.595, 'duration': 4.122}], 'summary': 'Low occupancy and rating correlate to high cancellation rates in hotel industry.', 'duration': 32.495, 'max_score': 5110.222, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc5110222.jpg'}, {'end': 5395.839, 'src': 'embed', 'start': 5366.578, 'weight': 2, 'content': [{'end': 5373.542, 'text': 'Because they are not giving commission, they can actually drop the rates by a few hundred rupees more to generate more revenue from their channel.', 'start': 5366.578, 'duration': 6.964}, {'end': 5376.004, 'text': "That's a very good strategy and most hotels use it.", 'start': 5373.883, 'duration': 2.121}, {'end': 5383.048, 'text': 'This view has helped me understand that they are not even using differential pricing on their own channel, which most people do.', 'start': 5376.284, 'duration': 6.764}, {'end': 5387.852, 'text': 'Okay, I think the major issue that that can help this order changes is the pricing strategy.', 'start': 5383.368, 'duration': 4.484}, {'end': 5395.839, 'text': "So they don't have a weekend big day pricing strategy or dynamic pricing strategy or the differential pricing strategy between the channels.", 'start': 5388.212, 'duration': 7.627}], 'summary': 'Hotels can increase revenue by dropping rates without commission. lack of differential pricing is a major pricing strategy issue.', 'duration': 29.261, 'max_score': 5366.578, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc5366578.jpg'}, {'end': 5571.186, 'src': 'embed', 'start': 5540.36, 'weight': 4, 'content': [{'end': 5545.583, 'text': "always ask right questions to your stakeholder to understand how they're going to use the dashboard.", 'start': 5540.36, 'duration': 5.223}, {'end': 5550.832, 'text': "Without understanding how they're going to use the dashboard, what impact it will create on the business,", 'start': 5546.303, 'duration': 4.529}, {'end': 5555.601, 'text': 'you will not be able to create the best possible dashboard or best possible analytics tool for them.', 'start': 5550.832, 'duration': 4.769}, {'end': 5560.999, 'text': "it's always important that you ask the right questions to them and to understand the impact.", 'start': 5556.315, 'duration': 4.684}, {'end': 5563.641, 'text': "after delivery of the dashboard, what's going to happen?", 'start': 5560.999, 'duration': 2.642}, {'end': 5571.186, 'text': 'so that will form as a feedback loop to help you in preparing a better dashboard and, uh, you know, serving the business better,', 'start': 5563.641, 'duration': 7.545}], 'summary': 'Ask the right questions to understand dashboard use and impact for better delivery and feedback loop.', 'duration': 30.826, 'max_score': 5540.36, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc5540360.jpg'}, {'end': 5658.361, 'src': 'embed', 'start': 5630.199, 'weight': 5, 'content': [{'end': 5633, 'text': 'The successful strategy is always going to be a mix of both of them.', 'start': 5630.199, 'duration': 2.801}, {'end': 5635.022, 'text': 'So that is what I really liked about your approach.', 'start': 5633.321, 'duration': 1.701}, {'end': 5644.112, 'text': "that's an amazing, i think, summary of this session, because most of the times the business stakeholders won't know the art of possible,", 'start': 5635.442, 'duration': 8.67}, {'end': 5647.996, 'text': "what's possible in a dashboard, what can be created in a dashboard, so they can't say everything.", 'start': 5644.112, 'duration': 3.884}, {'end': 5649.218, 'text': 'and the same goes for the data analyst.', 'start': 5647.996, 'duration': 1.222}, {'end': 5650.96, 'text': "they won't know everything that the business would need.", 'start': 5649.218, 'duration': 1.742}, {'end': 5658.361, 'text': 'so the the right strategy is always a mix, the the conversation, where both their insights blend and create this final product right,', 'start': 5651.46, 'duration': 6.901}], 'summary': 'Successful strategy is a blend of business stakeholder and data analyst insights to create a final product.', 'duration': 28.162, 'max_score': 5630.199, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc5630199.jpg'}, {'end': 5688.555, 'src': 'embed', 'start': 5665.103, 'weight': 6, 'content': [{'end': 5672.044, 'text': 'as a data analyst, please make sure that you have enough conversations with your stakeholder, make them your best friend and uh and vice versa,', 'start': 5665.103, 'duration': 6.941}, {'end': 5675.385, 'text': 'so so that you can can create the best possible outcome.', 'start': 5672.044, 'duration': 3.341}, {'end': 5677.927, 'text': 'uh, you know with this, with this collaboration.', 'start': 5675.985, 'duration': 1.942}, {'end': 5680.449, 'text': "so i think that's it from our end.", 'start': 5677.927, 'duration': 2.522}, {'end': 5682.27, 'text': 'thanks a lot for watching uh.', 'start': 5680.449, 'duration': 1.821}, {'end': 5687.114, 'text': 'so any any closing comments from anyone before we, you know, kind of wrap this up.', 'start': 5682.27, 'duration': 4.844}, {'end': 5688.555, 'text': "nope, i'm all good.", 'start': 5687.114, 'duration': 1.441}], 'summary': 'Data analyst should have enough conversations with stakeholders to create the best outcome.', 'duration': 23.452, 'max_score': 5665.103, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc5665103.jpg'}], 'start': 4942.116, 'title': 'Pricing impact on hotel occupancy', 'summary': 'Discusses how dropping rates can increase hotel occupancy, the correlation between low occupancy and low ratings, and the opportunity for differential pricing strategies. it emphasizes the significance of customer ratings and reviews in influencing booking decisions and the need for accurate and updated online content to match customer expectations. it also highlights the importance of collaborative communication between data analysts and business stakeholders to create effective dashboards.', 'chapters': [{'end': 5523.832, 'start': 4942.116, 'title': 'Impact of pricing on hotel occupancy', 'summary': 'Discusses the impact of pricing on hotel occupancy, highlighting that dropping rates increases occupancy, the correlation between low occupancy and low ratings, and the opportunity for differential pricing strategies to generate more revenue. it also emphasizes the significance of customer ratings and reviews in influencing booking decisions and the need for accurate and updated online content to match customer expectations.', 'duration': 581.716, 'highlights': ['Dropping rates leads to increased hotel occupancy, while increasing rates results in decreased occupancy, demonstrating the impact of pricing on hotel demand. The speaker emphasizes the direct impact of rate changes on hotel occupancy, providing a quantifiable understanding of the relationship between pricing and demand.', 'Correlation between low hotel occupancy and low ratings, indicating the influence of customer ratings on occupancy levels. The discussion highlights a clear correlation between low occupancy and low average ratings, suggesting the impact of customer feedback on hotel bookings.', 'Opportunity for differential pricing strategies to maximize revenue, particularly by adjusting rates on different channels to optimize revenue generation. The chapter emphasizes the potential for hotels to implement channel-specific pricing strategies to enhance revenue, providing a specific actionable insight for revenue optimization.', 'Importance of customer ratings and reviews in influencing booking decisions and the significant impact of online content accuracy on customer expectations. The discussion underscores the influence of ratings and reviews on customer booking decisions and the critical need for accurate and updated online content to align with customer expectations, highlighting the importance of customer feedback and content management.']}, {'end': 5838.881, 'start': 5523.832, 'title': 'Dashboard feedback and collaboration', 'summary': 'Highlights the importance of understanding stakeholder needs for creating effective dashboards, emphasizing the necessity of collaborative communication between data analysts and business stakeholders to achieve the best possible outcome.', 'duration': 315.049, 'highlights': ["Always ask the right questions to your stakeholder to understand how they're going to use the dashboard. Emphasizes the importance of understanding stakeholder needs, ensuring the dashboard is tailored to their specific usage, leading to better outcomes.", 'The successful strategy is always a mix of insights from both data analysts and business stakeholders. Underlines the significance of collaborative communication between data analysts and business stakeholders, leading to a balanced and effective dashboard strategy.', 'Emphasizes the necessity of collaborative communication between data analysts and business stakeholders to achieve the best possible outcome. Stresses the importance of continuous communication and collaboration between data analysts and business stakeholders to create effective dashboards.']}], 'duration': 896.765, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tT4V7zguCnc/pics/tT4V7zguCnc4942116.jpg', 'highlights': ['Dropping rates leads to increased hotel occupancy, while increasing rates results in decreased occupancy, demonstrating the impact of pricing on hotel demand.', 'Correlation between low hotel occupancy and low ratings, indicating the influence of customer ratings on occupancy levels.', 'Opportunity for differential pricing strategies to maximize revenue, particularly by adjusting rates on different channels to optimize revenue generation.', 'Importance of customer ratings and reviews in influencing booking decisions and the significant impact of online content accuracy on customer expectations.', "Always ask the right questions to your stakeholder to understand how they're going to use the dashboard.", 'The successful strategy is always a mix of insights from both data analysts and business stakeholders.', 'Emphasizes the necessity of collaborative communication between data analysts and business stakeholders to achieve the best possible outcome.']}], 'highlights': ['The dashboard includes key visuals, KPIs, and weekly trends for hotel locations, room types, booking data, aggregated bookings, and metric list, providing comprehensive insights for analysis.', 'The process of importing and transforming data involves steps such as duplicating, expanding files, and promoting headers, while ensuring the significance of dim date and dim hotels tables for further analysis.', "Creation of a DAX variable 'WKD' to differentiate between weekday and weekend hotel stays based on the pattern of most people staying on Friday and Saturday evenings.", 'Dynamic pricing can lead to significant revenue increases in the travel and tourism industry.', "Always ask the right questions to your stakeholder to understand how they're going to use the dashboard."]}