Skip to main content
00:00/00:00
Lecture 22 of 33

Solution Financial analysis

Download Course (Free)

Course Content

0 / 33 completed
Section 1: Introduction3 videos

What you should know

1m

Kick-start your BigQuery journey

1m

Introduction to Google BigQuery

3m
Section 2: Google BigQuery Setup3 videos

Case study introduction

1m

Set up BigQuery sandbox

3m

Loading data into BigQuery

5m
Section 3: Data Exploration9 videos

SELECT statement

8m

ORDER BY clause

4m

WHERE clause conditional logic

5m

Fuzzy string matching

4m

WHERE clause BETWEEN and IN

6m

COUNT function

5m

Calculation functions

6m

Challenge Wisdom Pet, quiz 1

1m

Solution Wisdom Pet, quiz 1

12m
Section 4: Data Aggregation6 videos

GROUP BY clause

8m

Challenge Financial analysis

1m

PIVOT function

6m

COUNTIF function

8m

CASE WHEN statements

8m

Solution Financial analysis

10mNow Playing
Section 5: Table Joins5 videos

Introduction to table joins

3m

INNER JOIN

7m

LEFT JOIN

9m

Challenge Wisdom Pet, quiz 2

1m

Solution Wisdom Pet, quiz 2

10m
Section 6: Window Functions6 videos

Introduction to window functions

4m

Ranking functions

5m

Cumulative metrics

7m

Challenge Wisdom Pet, quiz 3

1m

Moving averages

9m

Solution Wisdom Pet, quiz 3

10m
Section 7: Conclusion1 videos

Next steps

1m