Guest Attendance Analysis 2021 05-11-2023 07:46 AM

[ryancPowerBI2]

This report is a Power BI dashboard that presents insights into a hospitality company in Melbourne, Australia. The extracted data in 2021 that was used in the report has been de-identified, and actual numbers have been randomised to protect the privacy of the company and its customers. The report provides valuable information on the peak time in a day when the most visits occur, the total guest count by weekday, and the average number of hours customers spent in the venue. Additionally, the report offers details on the top 10 most and least popular packages at the company. This report is designed to provide actionable insights to the hospitality company, enabling them to optimize their business operations and improve customer experience.

eyJrIjoiNTBjZDZjODktMzEzZi00ZjkzLWJiZGItOTE0MWJjMjdhYmY2IiwidCI6IjIwMGFlOWJhLThmN2ItNGI4YS05NGZkLWJlN2I1MTMyNmE4YSJ9

[nkassym]

Excellent work
Could you explain, how did you connect bar chart and line charts ?
Or could you share pbix file please ?

nursultan.kasym8@gmail.com

[klpierce562]

I am new to PowerBi an R, but I really like the 10 Most/Least Popular Visualization. DO you have any tutorials or help guides you can point me to? 

[ryancPowerBI]

It is actually two bar charts placed side by side. I remove the chart title for both. For the "least popular" chart, I make the y-axis on the right, and sort the bars in ascending order, so that it aligns with the left chart nicely.

I added a text box on the top left, to make the title of the two bar charts.

All placeholders are an image in the background, which I created using Power point.

There are many free online resources. I like a youtube channel called "How to Power BI" with Baz where he shows many tips and tricks for the most beginners to the most advance.