Buy Now AED 171 + VAT

Monthly Subscription Starting at AED 99 + VAT

Exploring and Preparing your Data with BigQuery

عن

In this course, we see what the common challenges faced by data analysts are and how to solve them with the big data tools on Google Cloud. You’ll pick up some SQL along the way and become very familiar with using BigQuery and Dataprep to analyze and transform your datasets.

This is the first course of the From Data to Insights with Google Cloud series. After completing this course, enroll in the Creating New BigQuery Datasets and Visualizing Insights course.

الوحدات

Introduction: From Data to Insights with Google Cloud course series

    • 1 Videos
Show info about module content

1 Videos

  • Course series introduction

Data on Google Cloud

    • 4 Videos
Show info about module content

4 Videos

  • Analytics ​challenges ​faced ​by ​data ​analysts
  • Big ​data ​on-premises ​versus ​in ​the ​cloud
  • Real-world ​use cases
  • ​Google ​Cloud ​project ​basics

Module 1 Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • Introduction to Data on Google Cloud

Big data and Google Cloud tools

    • 4 Videos
Show info about module content

4 Videos

  • Data analyst tasks and challenges and Google Cloud data tools
  • 9 fundamental ​​BigQuery ​features
  • Walkthrough: Data architecture diagram
  • Google Cloud ​tools ​for ​analysts ​data ​scientists ​and data ​engineers

Lab: Exploring a BigQuery Public Dataset

    • 1 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Lab: Exploring an Ecommerce Dataset using SQL in Google BigQuery

1 Videos

  • Coursera: Getting Started with Google Cloud Platform and Qwiklabs

Module 2 Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • Big Data Tools Overview

Common data exploration techniques

    • 2 Videos
Show info about module content

2 Videos

  • Introduction to the Google Analytics ecommerce dataset
  • Common data exploration techniques

Code high-quality Standard SQL

    • 5 Videos
Show info about module content

5 Videos

  • Query basics
  • Introduction to functions
  • Filters, aggregates, and duplicates
  • Data types, date functions, and NULLs
  • Wildcard filters with LIKE

Lab: ​Troubleshooting ​Common ​SQL ​Errors with BigQuery

    • 1 ExternalTool
Show info about module content

1 External Tool

  • Lab: Troubleshooting Common SQL Errors with BigQuery

Module 3 Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • Exploring your Data with SQL

BigQuery ​pricing

    • 3 Videos
Show info about module content

3 Videos

  • BigQuery jobs
  • Sizing and cost management
  • Optimize ​queries ​for ​cost

Module 4 Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • BigQuery Pricing

Clean and transform your data

    • 4 Videos
Show info about module content

4 Videos

  • ​5 ​principles ​of ​dataset ​integrity
  • Dataset ​shape ​and ​skew
  • Clean ​and ​transform ​data ​using ​SQL
  • Clean ​and ​transform ​data ​using ​a ​new ​UI: ​Introducing ​Dataprep

Lab: ​Explore and Create an Ecommerce Analytics Pipeline with Cloud Dataprep

    • 1 ExternalTool
Show info about module content

1 External Tool

  • Exploring and Creating an Ecommerce Analytics Pipeline with Cloud Dataprep

Create data pipelines with Data Fusion

    • 3 Videos
Show info about module content

3 Videos

  • Components of Data Fusion
  • Building a Pipeline
  • Exploring Data using Wrangler

Lab: Creating Data Pipelines with Data Fusion

    • 1 ExternalTool
Show info about module content

1 External Tool

  • Lab: Building Transformations and Preparing Data with Wrangler in Cloud Data Fusion

Module 5 Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • Module 5 Quiz

Course summary

    • 1 Videos
Show info about module content

1 Videos

  • Course Summary

Auto Summary

"Exploring and Preparing your Data with BigQuery" is a foundational IT & Computer Science course on Coursera, taught by industry experts. It focuses on solving common data analysis challenges using Google Cloud's big data tools. Learners will gain proficiency in SQL, BigQuery, and Dataprep for data analysis and transformation. The course spans 480 minutes and offers various subscription options, including Starter, Professional, and Paid plans. Ideal for data analysts looking to enhance their skills in big data environments.