This project is designed by Business Intelligence consultant, Adam Finer. Using a real-world pizzeria 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
This project is also included as bonus content with the below courses and projects
A busy hotel needs you to upgrade their existing Excel reporting. Your job is to design and create a SQL database then write SQL queries to create data sources for the dashboards the client has asked for.
$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
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
