This course is the second of three in the Google Business Intelligence Certificate program. It teaches the fundamental skills that business intelligence professionals need to succeed, including data modeling, ETL processes, and data pipelines.
Data modeling is the process of designing databases to store and organize data in a way that makes it easy to query and analyze. You will learn about different types of data models and how to choose the right model for your specific needs.
ETL processes extract data from source systems, transform it into a format that can be analyzed, and load it into analytical systems. You will learn about the different components of an ETL process and the tools that are used to implement ETL.
Data pipelines automate the process of extracting, transforming, and loading data into analytical systems. You will learn how to design and implement data pipelines to automate your BI processes.
This course is designed for learners who want to prepare for a career in business intelligence. It assumes prior knowledge of foundational analytical principles, skills, and tools.
In addition to the fundamental skills mentioned above, this course also teaches learners how to apply these skills to real-world business problems. You will learn from Google employees who currently work in BI, and you will have the opportunity to complete hands-on activities that simulate job tasks.
By the end of this course, you will be able to:
- Design databases to store and organize data in a way that makes it easy to query and analyze
- Extract data from source systems, transform it into a format that can be analyzed, and load it into analytical systems
- Automate the process of extracting, transforming, and loading data into analytical systems
- Apply data modeling, ETL processes, and data pipelines to solve real-world business problems
This course is an essential step for anyone who wants to pursue a career in business intelligence. It will give you the skills and knowledge you need to succeed in this growing field.
| Week 1 | Data models and pipelines |
| Week 2 | Dynamic database design |
| Week 3 | Optimize ETL processes |
| Week 4 | Course 2 end-of-course project |