Hotel Reservations Project
Using a real-world hotel reservations scenario, you'll learn how to build a relational SQL database and deliver interactive dashboards according to a client's specifications
This project is designed by Business Intelligence consultant, Adam Finer. Using a real-world hotel reservations scenario, you'll learn loads of essential skills for delivering projects using relational SQL databases and Looker Studio (or you can use your BI tool of choice instead).
You'll learn how to build and normalise a relational SQL database, you'll design and build using Looker Studio (or your BI tool of choice).
You'll write SQL queries to create the data sources necessary for building your reports
You'll build interactive and shareable reports in Google's free-to-use Looker Studio BI tool
No subscriptions or course expiration date, just a single payment gives you unlimited, lifetime access to the project.
Take advantage of our limited time low price
Any questions? Please contact us from the site menu.
Get the Ultimate Guide To Looker Studio Course Add-On (regular combined price $98)
$79.00
Looker Studio Course & Project Bundle
Other courses available from Learn BI
Learn how to harness the power of data and build stunning interactive dashboards with Google's powerful Business Intelligence tool.
$49
Using a combination of CSV and Google Sheets data and equipped with a client brief, you have been tasked to build interactive dashboards to help a call centre monitor performance and improve agent training.
$49
Learn to solve the biggest pain point of any marketing agency or department by setting up ETL data pipelines to bring together data from multiple channels into a data warehouse and build dashboards that provide a global view of marketing performance.
$129
Designed to take you from zero to BI Analyst in just 12 weeks
Although not essential, as all the SQL code will be shown during the project, it is recommended that you have at least a basic knowledge of SQL querying.
You will need to have access to an instance of MySQL. If you do not, you can easily download and install one on your computer.
You will also need a database management tool like MySQL Workbench (free download) and a BI tool. This project uses Looker Studio but feel free to build the dashboards in whatever tool you prefer.
If you have any questions, comments or feedback, you can contact your instructor directly here.