Using SQL and Power Bi to analyze hotel data

I used a raw dataset which is a hotel dataset from 2018-2020. I created a database in MySQL Workbench and imported the data as a CSV file. I used a SQL query to join the sheets 2018, 2019, and 2020 into a single table. I then used a SQL function to left-join a column each from 2 different additional tables with data on Meal costs, Market segment, and Discounts respectively, to be appended to the columns in the initially created single table. I saved it as a CSV and imported it into Power Bi for visualization. Before Visualization, I created 2 custom columns: Total nights stayed and a Revenue column using formulas. (Rooms booked during the weekdays + rooms booked during the weekend to get Total stays & Rate/night * discount * total stays to get the actual revenue) My data was then ready. I created Visualizations showing: -The hotel that had more regulars -The hotel that was more family-friendly (had more children) -The revenue derived from Meals, Wines, and Snacks per hotel -The revenue created by each hotel in each year, and lastly. -The type of customer that generated the most revenue.