Develop a database for analyzing and visualizing hotel booking data, with the ability to track key performance indicators (KPIs) and trends. Use the data to answer business questions such as revenue growth by year and the need to increase parking lot size based on customer trends in personal car usage.
- Build a visual data story or dashboard using Power BI to present to your stakeholders
- Build a Database
- Develop the SQL Query
- Connect Power BI to the Database
- Visualize the data
- Summarize findings
After analyzing the trend line of car space usage in the Power BI report, I found that the slight increase in usage over time does not provide enough evidence to justify expanding the parking lot. Therefore, I do not recommend increasing the parking lot size based on this data.
- SQL Server
- Power BI
