This course has been certified by the CPD Certification Service as conforming to continuing professional development principles. Find out more.

Empower your business with smarter data and BigQuery skills

Every great decision starts with great data. To get ahead, you need the tools to bring it all together and the knowledge to use them effectively.

On this two-week course, you’ll master Google BigQuery and learn to build efficient data warehouses that turn information into insight. You’ll discover how data engineers and analysts use querying and automation to support data-driven decision making.

Build and manage your own data warehouse

Start by exploring the BigQuery platform and learning how to create a data warehouse through its interface and SQL.

You’ll see how to structure, query, and govern data effectively, transforming raw information into insights your team can put into action immediately.

Automate and transform data with Python ETL

Discover how to use Python ETL to extract, transform, and load data from multiple sources.

Through practical exercises, you’ll streamline workflows, automate repetitive tasks, and gain skills that make your data processes faster and more reliable.

Turn insights into business performance

Once your data is organised, you’ll explore advanced querying and analysis in Google BigQuery to uncover patterns and trends.

You’ll learn how to combine results, generate reports, and interpret outputs that directly inform business strategy.

By the end of the course, you’ll be able to apply your findings to support decisions, optimise processes, and identify new opportunities for your organisation.

You may like to undertake more sustained study on this topic through our ExpertTrack: AI and Data Engineering

Syllabus

Week 1
Exploring BigQuery and Building Data Warehouses
- Lesson 1: Understanding BigQuery Platform
  Gain a solid introduction to Google BigQuery, exploring what makes it a powerful cloud data warehouse. You’ll learn how to set up and access the platform, navigate its interface.
- Lesson 2: Creating a Data Warehouse using UI and SQL
  Learn the principles of data warehouse creation within BigQuery. You’ll organise datasets, define tables with schemas and settings, and apply partitioning and clustering strategies.
Week 2
Python, ETL, Querying, and Governance
- Lesson 3: Creating a Data Warehouse using Python
  Build your skills in using Python to automate data warehouse creation. You’ll set up your environment, work in Jupyter Notebook, and use Pandas for manipulating tables. The lesson covers clustering into Python workflows.
- Lesson 4: ETL with Python from External Sources
  Discover how to perform ETL (Extract, Transform, Load) tasks to bring in external data. You’ll practice extracting and transforming CSV, Excel, and JSON files, then loading them into BigQuery to integrate different data sources.
- Lesson 5: Querying and Governance
  Strengthen your query skills with BigQuery’s SQL features. You’ll explore examples of data retrieval, apply aggregate and window functions, and create custom transformations with UDFs.

Who is this accredited by?

The CPD Certification Service:

The CPD Certification Service was established in 1996 and is the leading independent CPD accreditation institution operating across industry sectors to complement the CPD policies of professional and academic bodies.

When would you like to start?

Start straight away and join a global classroom of learners. If the course hasn’t started yet you’ll see the future date listed below.

Available now
Join - $69

Learning on this course

On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.

What will you achieve?

By the end of the course, you‘ll be able to...

Understand and Navigate BigQuery: Learn the ins and outs of BigQuery's interface, set up your environment, and access datasets with ease.
Learn the Principles of Creating Data Warehouses: Create and organize datasets, define tables, and utilize partitioning and clustering for efficient data storage.
Perform ETL with Python: Build dynamic ETL pipelines using Python, replace and append tables, and configure schema, partitioning, and clustering.
Comprehend Essential Query Techniques: Understand querying with SQL, exploring aggregate and window functions, and understanding data security and governance.

Who is the course for?

This course is ideal for data analysts, engineers, BI professionals, and developers who want to master Google BigQuery and Python ETL. Also suited for managers and learners ready to build confidence in data-driven decision making.

Who will you learn with?

Paul Siegel

Who developed the course?

Starweaver

Starweaver is a next generation platform that engages your workforce as no other. Combining business and technical skills, Starweaver provides real-time skill building that is in line with your business objectives and strategies, and in your associates day to day tasks and jobs.

What's included?

This is a premium course. These courses are designed for professionals from specific industries looking to learn with a smaller group of like-minded individuals.

Unlimited access to this course
Includes any articles, videos, peer reviews and quizzes
Certificate of Achievement to prove your success when you're eligible
Download and print your Certificate of Achievement anytime

Join - $69

Still want to know more? Check out our FAQs

Learning on FutureLearn

Your learning, your rules

Courses are split into weeks, activities, and steps to help you keep track of your learning
Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
Stay motivated by using the Progress page to keep track of your step completion and assessment scores

Join a global classroom

Experience the power of social learning, and get inspired by an international network of learners
Share ideas with your peers and course educators on every step of the course
Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others

Map your progress

As you work through the course, use notifications and the Progress page to guide your learning
Whenever you’re ready, mark each step as complete, you’re in control
Complete 90% of course steps and all of the assessments to earn your certificate

Want to know more about learning on FutureLearn? Using FutureLearn