In this liveProject, you’ll create a data pipeline that can enrich source data with currency exchange rates and converted totals. As this pipeline is updated daily, you’ll need to create a scheduled query to enrich your data. You’ll learn to load essential data into BigQuery from both CSVS and JSON, and use it to generate a daily business intelligence report for your colleagues.
This project is designed for learning purposes and is not a complete, production-ready application or solution.
This liveProject is for complete beginners to data engineering, with a basic understanding of SQL. To begin this liveProject you will need to be familiar with:
- BigQuery Standard SQL/ul>
you will learn
In this liveProject, you’ll learn how to utilize an effective cloud data warehouse as the heart of your data architecture.
- Creating tables from CSV
- Creating tables from nested JSON data
- Tables partitioning and clustering
- Scheduling your queries and dataset updates
- Creating views
- Creating materialized views and aggregated activity tables