Connect and build a database in Microsoft SQL Server using a sample hotel booking dataset that has multiple tables.
Used CTE, Joins, Groupby, and other functions as well for joining tables and analyzing data to meet the requirements.
Imported Data from the same SQL server to Power BI to create new columns using DAX functions and visualize it with table, line, donut charts, slicers, scorecards, and trend charts for the given problem statements.
There were not enough data available on the result generated, so, could not plan, whether to increase parking space or not.