The Analyst Masterclass Course

Welcome To The Course

• Let's Get Started (4:23)

The Modern Data Stack

• Introduction to the modern data stack (1:27)
• The "Big 4" Framework (5:55)
• Introduction to ETL (12:28)
• In-house vs. Out-of-the-box ETL (13:30)
• Introduction to the data warehouse (7:23)
• The databases you're most likely to work with (12:31)
• Introduction to data modeling (6:59)
• Introduction to data visualization (7:01)
• Quiz: The modern data stack
• Final thoughts on the modern data stack (1:21)

Let's Learn SQL

• Introduction to the "Let's Learn SQL" section (2:38)
• What is SQL? (7:08)
• Introduction to data types (10:12)
• SQL Commands (SELECT VS. INSERT VS. DELETE) (5:27)
• The format of an SQL query (13:37)
• GROUP BY, ORDER BY, COUNT ROWS, DISTINCT, LIMIT, AND THE WHERE CLAUSE (15:38)
• Joins and unions (27:17)
• Introduction to CTEs (15:13)
• The power of functions in SQL (10:12)
• Quiz: SQL Basics
• Quiz: Fixing a broken query
• Answers to the quizzes (9:00)
• Final thoughts on learning SQL (4:53)

Let's Learn dbt

• Introduction to dbt (2:13)
• Getting started with dbt (27:50)
• Creating your first model in dbt (28:58)
• Creating your first model in dbt (continued) (6:28)
• Building the production layer, table references and our first custom model (22:07)
• Enhancing our dbt project using jinga and variables (24:27)
• Merging our code to the main branch, and setting up a job in dbt (23:51)
• Introduction to dbt docs & persistent docs (16:57)
• Introduction to dbt seeds (14:36)
• Reviewing a complete dbt project (9-figure DTC brand example) (9:08)
• Quiz: Introduction to dbt
• Answers to the quizzes (7:20)
• Final thoughts on dbt (1:09)

Useful concepts and frameworks for business analysts

• Introduction to KPIs (10:22)
• It's all about the funnels: User Onboarding Example (16:21)
• 4 common traps that analysts fall into (28:01)

Product Analytics Fundamentals

• Introduction to product analytics fundamentals (2:14)
• Introduction to product KPIs and the user lifecycle (25:00)
• The importance of event data in product analytics (8:49)
• Introduction to CDPs (Segment, Rudderstack, etc) (13:25)
• Some thoughts on BI infrastructure for product analytics (9:18)
• The Product Core Funnel (12:01)
• The Feature Adoption Funnel (7:51)

The Data Consultancy Business

• My story: How I generated $1M in revenue in 8 years selling data-related services (31:54)
• Why you probably should (or shouldn't) start your own data consultancy (18:31)
• Behind the scenes at projectBI: The tools we use to serve our clients (17:34)