Monthly Subscription Starting at AED 99 + VAT

The Path to Insights: Data Models and Pipelines
  • Level Expert
  • Duration 24 hours
  • Course by Google
  • Offered by

About

This is the second of three courses in the Google Business Intelligence Certificate. In this course, you'll explore data modeling and how databases are designed. Then you’ll learn about extract, transform, load (ETL) processes that extract data from source systems, transform it into formats that enable analysis, and drive business processes and goals. Google employees who currently work in BI will guide you through this course by providing hands-on activities that simulate job tasks, sharing examples from their day-to-day work, and helping you build business intelligence skills to prepare for a career in the field. Learners who complete the three courses in this certificate program will have the skills needed to apply for business intelligence jobs. This certificate program assumes prior knowledge of foundational analytical principles, skills, and tools covered in the Google Data Analytics Certificate. By the end of this course, you will: -Determine which data models are appropriate for different business requirements -Describe the difference between creating and interacting with a data model -Create data models to address different types of questions -Explain the parts of the extract, transform, load (ETL) process and tools used in ETL -Understand extraction processes and tools for different data storage systems -Design an ETL process that meets organizational and stakeholder needs -Design data pipelines to automate BI processes

Modules

Get started with data modeling, schemas, and databases

    • 7 Videos
    • 4 Readings
    • 1 Quiz
    • 1 Plugin
Show info about module content

7 Videos

  • Introduction to Course 2
  • Ed: Overcome imposter syndrome
  • Welcome to module 1
  • Data modeling, design patterns, and schemas
  • Get the facts with dimensional models
  • Dimensional models with star and snowflake schemas
  • Different data types, different databases

4 Readings

  • Helpful resources and tips
  • Course 2 overview
  • Design efficient database systems with schemas
  • Database comparison checklist

1 Quiz

  • Test your knowledge: Data modeling, schemas, and databases

Choose the right database

    • 2 Videos
    • 2 Readings
    • 1 Quiz
    • 1 Plugin
Show info about module content

2 Videos

  • The shape of the data
  • Design useful database schemas

2 Readings

  • Four key elements of database schemas
  • Review a database schema

1 Quiz

  • Test your knowledge: Choose the right database

How data moves

    • 3 Videos
    • 2 Readings
    • 1 Quiz
    • 1 Plugin
Show info about module content

3 Videos

  • Data pipelines and the ETL process
  • Maximize data through the ETL process
  • Choose the right tool for the job

2 Readings

  • Business intelligence tools and their applications
  • ETL-specific tools and their applications

1 Quiz

  • Test your knowledge: How data moves

Data-processing with Dataflow

    • 2 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

2 Videos

  • Introduction to Dataflow
  • Coding with Python

2 Readings

  • Guide to Dataflow
  • Python applications and resources

2 Quiz

  • [Optional] Activity: Create a Google Cloud account
  • [Optional] Activity: Create a streaming pipeline in Dataflow

Organize data in BigQuery

    • 1 Videos
    • 4 Readings
    • 2 Quiz
Show info about module content

1 Videos

  • Gather information from stakeholders

4 Readings

  • Merge data from multiple sources with BigQuery
  • Unify data with target tables
  • Activity Exemplar: Create a target table in BigQuery
  • Case study: Wayfair - Working with stakeholders to create a pipeline

2 Quiz

  • Activity: Set up a sandbox and query a public dataset in BigQuery
  • Activity: Create a target table in BigQuery

Review: Data models and pipelines

    • 1 Videos
    • 1 Readings
    • 1 Quiz
Show info about module content

1 Videos

  • Wrap-up

1 Readings

  • Glossary terms from module 1

1 Quiz

  • Module 1 challenge

[Optional] Review Google Data Analytics Certificate content

    • 3 Videos
    • 1 Readings
Show info about module content

3 Videos

  • [Optional] Review Google Data Analytics Certificate content about data types
  • [Optional] Review Google Data Analytics Certificate content about primary and foreign keys
  • [Optional] Review Google Data Analytics Certificate content about BigQuery

1 Readings

  • [Optional] Review Google Data Analytics Certificate content about SQL best practices

Database performance

    • 5 Videos
    • 6 Readings
    • 1 Quiz
    • 2 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Test your knowledge: Database performance

5 Videos

  • Welcome to module 2
  • Data marts, data lakes, and the ETL process
  • The five factors of database performance
  • Optimize database performance
  • The five factors in action

6 Readings

  • ETL versus ELT
  • A guide to the five factors of database performance
  • Indexes, partitions, and other ways to optimize
  • Activity Exemplar: Partition data and create indexes in BigQuery
  • Case study: Deloitte - Optimizing outdated database systems
  • Determine the most efficient query

1 Quiz

  • Activity: Partition data and create indexes in BigQuery

Review: Dynamic database design

    • 1 Videos
    • 1 Readings
    • 1 Quiz
Show info about module content

1 Videos

  • Wrap-up

1 Readings

  • Glossary terms from module 2

1 Quiz

  • Module 2 challenge

Optimizing pipelines and ETL processes

    • 3 Videos
    • 2 Readings
    • 1 Quiz
    • 1 Plugin
Show info about module content

3 Videos

  • Welcome to module 3
  • The importance of quality testing
  • Mana: Quality data is useful data

2 Readings

  • Seven elements of quality testing
  • Monitor data quality with SQL

1 Quiz

  • Test your knowledge: Optimize pipelines and ETL processes

Data schema validation

    • 2 Videos
    • 3 Readings
    • 2 Quiz
Show info about module content

2 Videos

  • Conformity from source to destination
  • Check your schema

3 Readings

  • Sample data dictionary and data lineage
  • Schema-validation checklist
  • Activity Exemplar: Evaluate a schema using a validation checklist

2 Quiz

  • Activity: Evaluate a schema using a validation checklist
  • Test your knowledge: Data schema validation

Business rules and performance testing

    • 2 Videos
    • 4 Readings
    • 1 Quiz
    • 1 Plugin
Show info about module content

2 Videos

  • Verify business rules
  • Burak: Evolving technology

4 Readings

  • Business rules
  • Database performance testing in an ETL context
  • Defend against known issues
  • Case study: FeatureBase, Part 2: Alternative solutions to pipeline systems

1 Quiz

  • Test your knowledge: Business rules and performance testing

Review: Optimize ETL processes

    • 1 Videos
    • 1 Readings
    • 1 Quiz
Show info about module content

1 Videos

  • Wrap-up

1 Readings

  • Glossary terms from module 3

1 Quiz

  • Module 3 challenge

[Optional] Review Google Data Analytics Certificate content

    • 2 Videos
Show info about module content

2 Videos

  • [Optional] Review Google Data Analytics Certificate content about data integrity
  • [Optional] Review Google Data Analytics Certificate content about metadata

Apply your skills to a workplace scenario

    • 2 Videos
    • 1 Readings
Show info about module content

2 Videos

  • Welcome to module 4
  • Continue your end-of-course project

1 Readings

  • Explore Course 2 end-of-course project scenarios

Cyclistic scenario

    • 4 Readings
    • 1 Quiz
Show info about module content

4 Readings

  • Course 2 workplace scenario overview: Cyclistic
  • Cyclistic datasets
  • Observe the Cyclistic team in action
  • Activity Exemplar: Create your target table for Cyclistic

1 Quiz

  • Activity: Create your target table for Cyclistic

Google Fiber scenario

    • 4 Readings
    • 1 Quiz
Show info about module content

4 Readings

  • Course 2 workplace scenario overview: Google Fiber
  • Google Fiber datasets
  • [Optional] Merge Google Fiber datasets in Tableau
  • Activity Exemplar: Create your target table for Google Fiber

1 Quiz

  • Activity: Create your target table for Google Fiber

End-of-course project wrap-up

    • 2 Videos
    • 1 Quiz
Show info about module content

2 Videos

  • Tips for ongoing success with your end-of-course project
  • Luis: Tips for interview preparation

1 Quiz

  • Assess your Course 2 end-of-course project

Course review: The Path to Insights: Data Models and Pipelines

    • 1 Videos
    • 3 Readings
Show info about module content

1 Videos

  • Course wrap-up

3 Readings

  • Reflect and connect with peers
  • Course 2 glossary
  • Get started on Course 3

Auto Summary

Embark on a data-driven journey with "The Path to Insights: Data Models and Pipelines," the second course in the Google Business Intelligence Certificate. Dive into data modeling, database design, and ETL processes guided by experienced Google BI professionals. Through hands-on activities and real-world examples, you'll gain crucial business intelligence skills to advance your career. Perfect for those with foundational analytics knowledge, this expert-level course spans 1440 minutes and offers Starter and Professional subscription options. Ideal for aspiring BI professionals seeking comprehensive, practical training.

Google Career Certificates
Instructor

Google Career Certificates