00:00/00:00
Lecture 22 of 33
Solution Financial analysis
Course Content
0 / 33 completedSection 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