Summary

In this chapter, we learned how to use Looker Studio using BigQuery as the data source. We learned how to connect the data and create charts and reports for sharing it with other users.

Throughout the exercises in this chapter, we learned not only about how to create charts but also the point of view of our end users. In the exercises, we realized how important it is to create a proper data model in our datasets. Imagine if our tables didn’t have proper naming conventions, weren’t aggregated properly, or followed any other bad practices that can happen in a data warehouse. Since we already learned all the good data engineering practices and code from the previous chapters, it’s now very easy for us to use our example tables to visualize things in Looker Studio.

And lastly, as data engineers, we need to be the ones who understand and are aware of the cost implications in our data ecosystem. In this chapter, we learned about BigQuery INFORMATION_SCHEMA...