Google BigQuery for Programmers: Analyze & Visualize

Focused View

Tim Buchalka's Learn Programming Academy,Shay Tavor

3:59:32

139 View

1 - Welcome to the Course

1 - Welcome to the Course.mp4

02:45

2 - Creating GCP Account.mp4

02:45

2 - Introduction to BigQuery

3 - Introduction.mp4

03:32

4 - Tables Structure.mp4

02:02

5 - Slots.mp4

01:04

6 - Data Structure.mp4

02:11

7 - Demo create a Data Set.mp4

02:53

8 - Create Empty Table.mp4

03:36

9 - Create Table from a Query.mp4

02:35

10 - Create Table from Source Data.mp4

03:54

11 - Exercise 1 Create Tables.mp4

03:55

11 - Exercise 1 Create Tablespdf.txt

11 - natality2020csv.txt

12 - Exercise 1 Solution.mp4

08:33

3 - SQL

13 - Introduction to SQL.mp4

02:36

14 - The Select Statement.mp4

02:38

15 - Join.mp4

02:52

16 - Aggregate Functions.mp4

02:23

17 - Group By.mp4

01:44

18 - Exercise 2 SQL Queries.mp4

00:58

18 - Exercise 2 SQL Queriespdf.txt

19 - Exercise 2 Solution.mp4

02:05

4 - Querying Data in BigQuery

20 - Section overview.mp4

00:58

21 - Dataset Overview.mp4

04:34

21 - heart2020csv.txt

22 - Run Query.mp4

04:43

23 - More Queries.mp4

05:46

24 - Union Queries.mp4

05:11

25 - Generating Codes Table.mp4

03:39

25 - Source code Querying Data in BigQuery Generating Codes Table.txt

26 - Exercise 3 Qurying in BigQuery.mp4

01:13

26 - Exercise 3 Qurying in BigQuerypdf.txt

27 - Exercise 3 Solution.mp4

02:57

27 - Source code Querying Data in BigQuery Exercise 3 Solution.txt

5 - Advanced Features

28 - Normallization.mp4

04:50

29 - Nested and Repeated Fields.mp4

02:35

30 - Creating Tables with Nested Values.mp4

06:36

30 - Source code Advanced Features Creating Tables with Nested Values.txt

31 - Querying Nested and Repeated Fields.mp4

09:39

32 - Partitioning.mp4

03:15

33 - Creating Partitioned Table.mp4

02:47

34 - Clustering.mp4

02:03

35 - Exercise 4 Nested and repeated Fields.mp4

03:31

35 - Exercise 4 Nested and repeated Fieldspdf.txt

35 - Source code Advanced Features Exercise 4 Nested and repeated Fields.txt

6 - Data Visualization

36 - Introduction to Data Visuallization.mp4

01:20

37 - Open Looker Studio.mp4

01:53

37 - PupilsGradescsv.txt

38 - Looker Studio UI.mp4

02:24

39 - Scoreboard.mp4

03:31

40 - Pie and Line Charts.mp4

05:50

41 - Calculated Fields.mp4

02:09

42 - Bar Chart.mp4

00:58

43 - Box Plot.mp4

04:24

44 - Exercise 5 Visualizing Data.mp4

01:26

44 - Exercise 5 Visualizing Datapdf.txt

44 - natality2020csv.txt

7 - Data Cleaning and Preperation

45 - Intro to data preperation.mp4

02:16

46 - Data Cleaning Challenges.mp4

07:09

47 - Dataset Overview.mp4

02:54

48 - Deleteing Columns.mp4

10:42

49 - Removing Duplications.mp4

03:09

50 - Remove Null Values.mp4

06:49

51 - Categorize Strings.mp4

07:03

52 - Visualizing the Data.mp4

10:33

53 - Removing Outliers.mp4

02:26

54 - Recap.mp4

04:25

54 - Source code Data Cleaning and Preperation Recap.txt

54 - UsedCarsCleancsv.txt

55 - Exercise 6 Cleaning Data.mp4

02:36

55 - Exercise 6 Data Preperationpdf.txt

8 - Machine Learning with BigQuery

56 - Introduction to Machine Learning.mp4

06:20

57 - Linear Regression.mp4

08:11

58 - Create Model.mp4

03:56

59 - Evaluate Model.mp4

03:12

60 - Running Evaluation in Bigquery.mp4

02:17

61 - Making Predictions.mp4

04:33

62 - Exercise 7 Create a Machine Learning Model.mp4

01:23

62 - Exercise 7 MLpdf.txt

9 - Course Summary

63 - Course Summary.mp4

01:36

10 - Extra Information Source code and other stuff

64 - Source Codes.html

65 - Bonus Lecture and Information.mp4

04:49

65 - Free-Course-and-Programming-Guide.pdf

Description

Advance your career with Google BigQuery: Become a sought-after data analyst with in-demand skills

What You'll Learn?

Master BigQuery data analysis using SQL, manipulating large datasets with ease.
Create compelling data visualizations to effectively communicate insights
Integrate BigQuery into programming projects for data-driven applications.
Understand the principles of data warehousing and BigQuery's advantages.
Apply basic machine learning models to data for predictive analysis.
Gain hands-on experience with real-world datasets through projects.

Who is this for?

A programmer ready to elevate your projects: You want to integrate robust data analysis, compelling visualizations, and even predictive capabilities into your applications. BigQuery offers the tools and scalability to make your projects truly data-driven.

A data analyst seeking efficiency and power: You work with large datasets and traditional tools are hindering your insights. You're eager to explore the speed, advanced analytics, and cloud-based scalability that BigQuery provides.

A business intelligence professional looking for an edge:. You want to go beyond basic reports and uncover deeper trends, create interactive dashboards, and confidently use data to drive strategic decisions.

What You Need to Know?

Basic SQL Knowledge: Understanding fundamental SQL concepts like SELECT, FROM, WHERE, JOIN, etc., is crucial to effectively query and manipulate data in BigQuery.

Active Google Cloud Platform (GCP) Account: Students need a GCP account to access BigQuery and follow along with the course.

More details

Description
In today's digital world, data is overwhelming. Businesses and individuals alike collect vast amounts of information, but often struggle to extract meaningful insights. Raw data holds incredible potential, but without the right tools and expertise, it remains untapped.

This comprehensive course empowers you to harness the power of Google Cloud Platform BigQuery. Learn to efficiently store massive datasets, perform complex analysis, create compelling visualizations, and even apply machine learning models.
Transform your data into actionable strategies that give you a competitive edge.
What you will learn in the course:
Master Data Warehousing: Understand the principles and advantages of a modern data warehouse, and how BigQuery revolutionizes data storage.
Unlock Data's Potential: Learn to look at your data as a goldmine of insights. Discover how to ask the right questions and extract patterns and trends.
Extract Meaningful Insights: Develop expertise in data manipulation and analysis, empowering you to uncover hidden patterns and correlations.
Visualize Your Data: Translate complex data into visually stunning graphs, charts, and dashboards that communicate information effectively.
Apply Machine Learning: Gain a practical understanding of how to build and apply machine learning models, enabling you to predict future outcomes.
Detailed information.

Introduction to BigQuery: Demystify data warehousing, explore BigQuery's interface, and learn how to set up your environment.
Data Loading and Manipulation: Import data from various sources, clean and prepare it for analysis, and master SQL queries for data exploration.
Advanced Analytics: Dive into statistical techniques, aggregations, and complex calculations to reveal deeper insights.
Data Visualization Best Practices: Create impactful dashboards that tell compelling stories, using color, design, and interactivity.
Machine Learning Fundamentals: Explore predictive modeling, understand common algorithms, and experiment with BigQuery ML capabilities.
Real-World Projects: Apply your newfound skills through hands-on projects, working with real-life datasets.
About Your Instructor:
Shay Tavor is a highly qualified and experienced Google Cloud Platform (GCP) expert, holding certifications as an engineer, architect, and trainer. With over two years of expertise in cloud consulting and training, he brings real-world insights and proven teaching methods to his courses. Shay's passion for data analytics is evident, and he empowers students to discover the hidden potential within their datasets using the powerful tools available within GCP BigQuery.

Ready to elevate your data analysis skills and unlock a world of exciting career opportunities? Enroll in our Google BigQuery course today and become a highly marketable data expert!

Master the art of extracting actionable insights from massive datasets, create stunning visualizations that tell compelling data stories, and even apply machine learning to predict future outcomes. With hands-on projects and expert guidance from Shay Tavor, you'll gain in-demand skills that set you apart in the competitive job market.

Don't miss out on this transformative opportunity â€“ enroll now and start building a powerful data-driven future!
Who this course is for:
A programmer ready to elevate your projects: You want to integrate robust data analysis, compelling visualizations, and even predictive capabilities into your applications. BigQuery offers the tools and scalability to make your projects truly data-driven.
A data analyst seeking efficiency and power: You work with large datasets and traditional tools are hindering your insights. You're eager to explore the speed, advanced analytics, and cloud-based scalability that BigQuery provides.
A business intelligence professional looking for an edge:. You want to go beyond basic reports and uncover deeper trends, create interactive dashboards, and confidently use data to drive strategic decisions.

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Big Data

Google BigQuery

Tim Buchalka's Learn Programming Academy

Instructor's Courses

The Learn Programming Academy was created by Tim Buchalka, a software developer with 35 years experience, who is also an instructor on Udemy, with over 1.67M+ students in his courses on Java, Python, Android, C# and the Spring framework. The Academy’s goal in the next three years, is to teach one million people to learn how to program.Apart from Tim’s own courses, which are all available here, we are working with the very best teachers, creating courses to teach the essential skills required by developers, at all levels.One other important philosophy is that our courses are taught by real professionals; software developers with real and substantial experience in the industry, who are also great teachers. All our instructors are experienced, software developers!Our team is busy creating new courses right now.Whether you are a beginner, looking to learn how to program for the very first time, or to brush up on your existing skills, or to learn new languages and frameworks, the Academy has you covered.

Shay Tavor

Instructor's Courses

I have more than 20 years of instructing experience - both in academy and industry. I teach students from all levels of knowledge and know how to explain everything to everyone. I teach and specialise in number of topics, include java, android os, web dev, big data and more, and know how to give the algorithmic way of thinking to my students.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.