"Revenue and Booking Insights Dashboard: Uncovering Trends to Drive Profitability"

"This Revenue and Booking Analysis Dashboard was created as part of my final project for Maven Analytics' Advanced Excel Dashboard Design course. The dashboard provides a deep dive into revenue performance, booking trends, and cancellation patterns, focusing on key metrics like gross revenue, average daily rate, cancellation rates, and revenue loss.

Key Highlights:

• Revenue and Cancellation Trends: Insights into high-revenue months and cancellation rates, with a focus on understanding the impact of booking lead times.
• Monthly Peaks and Losses: Identifying patterns in months with the highest revenue and analyzing associated losses to support better decision-making.
• Lead Time Analysis: Revealing the premium value associated with advanced reservations and how it affects the average daily rate.

Skills Applied:

• Data Visualization: Created easy-to-interpret visuals, including pie charts, bar graphs, and trend lines.
• Advanced Excel Techniques: Used formulas, conditional formatting, and interactive filters for a dynamic dashboard experience.
• Power Query Proficiency: Leveraged Power Query to transform and connect data sources, creating essential fields like Month, Quarter, Date, and Weekending for deeper analysis.

This project allowed me to apply advanced Excel and data transformation skills to create actionable insights, making complex data accessible and informative.

Link: Revenue and Booking Analysis Dashboard.xlsm