1. Establishing the business questions/goals:

2. Cleaning & Normalizing Database in Excel

The original dataset contained the following columns:

1. Appointment ID
2. Start Time
3. End Time
4. First Name
5. Last Name
6. Phone Number
7. Email Address
8. Booking Type
9. Room Type
10. Total Cost
11. Is Paid Upfront
12. Amount Paid Upfront
13. Package Code
14. Date Scheduled
15. Scheduled By
16. Notes

It was then normalized and transformed into the following tables:

3. Querying in SQL

Revenue By Service Type By Month

Occupancy Rate By Room

4. Creating Dashboard In Excel

5. Conclusion

• The studio is currently operating at about about 40% capacity and has huge potential to double that value with the right strategy.
• The studio could consider requiring users to first sign up for an account before making bookings as this will help ensure that data is cleaner at the source.

Recent Work

Final Placement Prediction With Machine Learning Using Python

Predict the final placement position of players in a battle royale shooting game from 1st place to 100th place.

Hotel Dashboard

Create a dashboard in Power BI showing occupancy rates and hotel KPIs. Dataset from Kaggle.

Music Studio Dashboard

Create a dashboard in Excel using a music studio dataset. Dataset provided by Tonehouse Studios.

Get In Touch