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.

1. Welcome to From Data to Insights with Google Cloud - Exploring and Preparing your Data

1. Course series introduction

2. Introduction to Data on Google Cloud

1. Analytics challenges faced by data analysts

2. Big data on-premises versus in the cloud

3. Real-world use cases

4. Google Cloud project basics

3. Big Data Tools Overview

1. Data analyst tasks and challenges and Google Cloud data tools

2. 9 fundamental BigQuery features

3. Walkthrough - Data architecture diagram

4. Google Cloud tools for analysts data scientists and data engineers

5. Getting Started with GCP and Qwiklabs

4. Exploring your Data with SQL

1. Introduction to the Google Analytics ecommerce dataset

2. Common data exploration techniques

3. Query basics

4. Introduction to functions

5. Filters, aggregates, and duplicates

6. Data types, date functions, and NULLs

7. Wildcard filters with LIKE

5. BigQuery Pricing

1. BigQuery jobs

2. Sizing and cost management

3. Optimize queries for cost

6. Cleaning and Transforming Your Data

1. 5 principles of dataset integrity

2. Dataset shape and skew

3. Clean and transform data using SQL

4. Clean and transform data using a new UI - Introducing Dataprep

6. Components of Data Fusion

7. Build a pipeline

8. Explore data using wrangler

7. Course Summary

1. Course summary

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight