Or how to leverage BigQuery, Cloud DataPrep, and Data Studio to turn your raw data into a beautiful report without the help of anyone but you. And all in less than 30 minutes thanks to Google Cloud Platform smart analytics suite.

But, before you start your timer, make sure you are familiar with the basic concepts of self-service analytics on Google Cloud Platform. This blog “Getting Started with Self-Service Analytics on BigQuery with Cloud Dataprep” will give you this knowledge.

Then, you need to have at your disposal a GCP project. We will refer to “my-self-service-analytics” project in this blog. Please follow these instructions to create your GCP project if you do not have one yet.

For your first self-service analytics project, your objective is to create a Data Studio dashboard reporting on your eCommerce website performance and the best web channels driving revenue. It will tell you where to invest more and which products need more focus.

You will have to clean and combine multiple data sources within Cloud Dataprep, output it to BigQuery to make it consumable within Google Data Studio and create your dashboard.

3…2…1 you can start your timer now. 30 min stopwatch in hand!