Intensive Program
We design this program to help you acquire new skills to become a Data Analyst.
Welcome to the course!
Available in
days
days
after you enroll
- Warm Welcome
- School Philosophy - Becoming Generalist
- How to attend LIVE classes
- How to study on-demand videos 🍟
- Free Pre-Sessional Course
- Free Software
- README - Data Analyst Career Guide
- README - Data Science Free Learning Path (2023)
- Kata - Monkeytype
- Believe Then Act
- Join Our Discord 🍻
- Quiz - School Philosophy
Community
Available in
days
days
after you enroll
Live Classes Are Here! 📢
Available in
days
days
after you enroll
Bonus Classes Are Here! 📢
Available in
days
days
after you enroll
Building A Second Brain
Available in
days
days
after you enroll
Notion Primer
Available in
days
days
after you enroll
- 💯 New Content Alert (0:25)
- EP01 - Getting Started with Notion (1:38)
- EP02 - Template (1:48)
- No Workspaces, No Worries
- EP03 - Your First Notion Page (3:37)
- EP04 - Common Blocks (3:28)
- EP05 - Quick Setting (2:43)
- EP06 - Design Structure (3:07)
- EP07 - What is Notion Database? (2:41)
- EP08 - Work Like Spreadsheets, But Cooler! (2:19)
- EP09 - Database View (2:13)
- EP10 - Sharing (2:00)
- Quiz - Notion Primer
- 📝 What Would You Like to Build?
Sprint 01 - Google Sheets 101
Available in
days
days
after you enroll
- Exercise File
- EP01 - Why Google Sheets (2:12)
- EP02 - Manually Input Data (6:01)
- EP03 - Cell References (3:03)
- EP04 - What is Function? (3:22)
- 📑 Google Sheets Shortcuts
- EP05 - If and Array (3:42)
- EP06 - Nested IF and IFS (4:28)
- EP07 - AND OR NOT (3:52)
- EP08 - SWITCH (2:56)
- EP09 - AVERAGE SUM MEDIAN (5:37)
- EP10 - AVERAGEIF and SUMIF (3:30)
- Quiz - Google Sheets 101
Sprint 01 - Google Sheets 102
Available in
days
days
after you enroll
Sprint 01 - Google Sheets 103
Available in
days
days
after you enroll
- Exercise File
- EP01 - Query Functions (4:03)
- EP02 - Select Data (4:37)
- EP03 - Filter Data (4:45)
- EP04 - Filter NULL (1:55)
- 📑 How to filter DATE
- EP05 - Aggregate Functions (1:54)
- EP06 - Group By (2:30)
- EP07 - Label (3:13)
- EP08 - Pivot (2:24)
- EP09 - Order By (2:44)
- Review Core Concepts in Google Sheets
- 🌵 New - How to Create Drop Down List (2023) (1:00)
- EP10 - Dynamic Query (5:10)
- Then, What SQL Looks Like?
- 🌭 Secret Sauce - How to Get Better at Google Sheets
- Quiz - QUERY Function
Sprint 01 - Google Sheets 104
Available in
days
days
after you enroll
Sprint 02 - SQL References
Available in
days
days
after you enroll
Sprint 02 - Intro to Database and CRUD
Available in
days
days
after you enroll
- EP01 - SQLite Online Editor (3:36)
- EP02 - Create Table (2:37)
- EP03 - Insert Data (2:28)
- 📑 Common SQL Errors
- EP04 - Select Data (1:35)
- EP05 - Transform Columns (2:51)
- EP06 - Filter Data (5:19)
- EP07 - Update Data (1:57)
- EP08 - Delete Data (1:41)
- EP09 - Alter Table (3:21)
- EP10 - Copy and Drop Table (2:52)
Sprint 02 - SQL for Data Analyst 101
Available in
days
days
after you enroll
- Download Database and ER Diagram
- EP01 - Database and ER Diagram (7:13)
- EP02 - DB Browser Installation (Optional) (6:01)
- EP03 - Select Columns (2:20)
- EP04 - Create New Columns (6:54)
- EP05 - CASE WHEN (2:29)
- EP06 - Working with DateTime in SQLite (5:29)
- EP07 - Select Data From Multiple Tables (3:05)
- EP08 - INNER vs. LEFT JOIN (3:46)
- EP09 - More JOIN Examples (4:35)
- EP10 - Random Rows (3:06)
Sprint 02 - SQL for Data Analyst 102
Available in
days
days
after you enroll
- 📑 How to use WHERE clause?
- EP01 - Filter Data Part 1 (6:52)
- EP02 - Filter Data Part 2 (6:33)
- EP03 - Filter Data Part 3 (4:50)
- EP04 - COALESCE (4:37)
- EP05 - JOIN Data using WHERE (6:44)
- EP06 - Aggregate Functions (3:32)
- EP07 - COUNT Distinct (1:19)
- EP08 - GROUP BY (3:41)
- EP09 - HAVING (1:49)
- EP10 - ORDER BY (3:13)
Sprint 02 - SQL for Data Analyst 103
Available in
days
days
after you enroll
- EP01 - JOIN using WHERE clause (6:59)
- EP02 - Convert WHERE to INNER JOIN (2:48)
- EP03 - Review JOIN Concepts (3:39)
- EP04 - Review CREATE TABLE (2:20)
- EP05 - INNER vs. LEFT JOIN (2:40)
- EP06 - CROSS JOIN (3:13)
- EP07 - SELF JOIN (5:14)
- EP08 - Intersect and Except (2:57)
- EP09 - UNION (2:55)
- EP10 - Intro to Subqueries (4:55)
SQL Workshops (Optional)
Available in
days
days
after you enroll
Coming Soon
Available in
days
days
after you enroll
Sprint 03 - R101 / Getting Started with R
Available in
days
days
after you enroll
- Meet RStudio Cloud
- Quiz - Have You Tried RStudio Cloud
- EP01 - Download and Install Software (3:36)
- 📑 How to use setwd() on RStudio Cloud (0:23)
- EP02 - Create and Remove Variables (7:41)
- EP03 - Compare Values (2:23)
- EP04 - Data Types (7:37)
- Quiz - Data Types
- EP05 - Convert Data Types (2:28)
- EP06 - Vector (4:44)
- EP07 - Matrix (3:24)
- EP08 - List (2:27)
- EP09 - Data Frame (3:33)
- Quiz - Data Frame
- EP10 - Subset (7:15)
- We're NOT done yet!
Sprint 03 - R102 / Control Flow and Function
Available in
days
days
after you enroll
- 📑 Common Errors in RStudio
- What is control flow?
- Quiz - Control Flow
- EP01 - IF (4:29)
- EP02 - ifelse() (2:16)
- EP03 - FOR (4:31)
- EP04 - WHILE (2:20)
- EP05 - Function (1:44)
- EP06 - Create Our First Function (3:19)
- Quiz - Function
- EP07 - Function Parameter & Argument (3:22)
- EP08 - Function Kata (5:10)
- EP09 - Looping over a dataframe (7:06)
- EP10 - apply() coolest function (3:06)
- Quiz - Loop and Apply
- 📑 Reading - Hands On Programming with R
Sprint 03 - R103 / Working with Data
Available in
days
days
after you enroll
- 💯 R superpower!
- 📝 Upload File
- 📑 How to install R packages (3:21)
- EP01 - Text File (3:58)
- EP02 - CSV (2:10)
- EP03 - Excel File (4:42)
- Quiz - Read Data
- EP04 - Google Sheets (1:59)
- EP05 - JSON (3:26)
- Quiz - Google Sheets & JSON
- EP06 - Bind Rows (UNION ALL) (2:30)
- EP07 - Bind Cols (!= JOIN) (2:05)
- 📑 We will learn about JOIN in the next sprint
- Quiz - Bind Rows & Columns
- EP08 - SQL (4:27)
- EP09 - SQLite (4:23)
- EP10 - How to save data in R (2:18)
- ⭐ Now you are a Data Analyst Star [Lord]!
Sprint 04 - Data Transformation
Available in
days
days
after you enroll
- ⭐ The Most Important Skill
- EP01 - Intro to Data Transformation (3:27)
- EP02 - Read CSV Files (7:26)
- EP03 - Select Columns (5:33)
- EP04 - Filter Data Part I (7:52)
- EP05 - Filter Data Part II (5:10)
- Quiz - Basic Transformation I
- EP06 - Create New Colunms (4:18)
- EP07 - Arrange Data (2:28)
- EP08 - Summary Statistics (3:45)
- EP09 - Join Tables (2:49)
- Quiz - Basic Transformation II
- EP10 - Export CSV File (2:34)
- Quiz - Based vs. Modern R Functions
- 📑 Reading - R for Data Science Chapter 5
Sprint 04 - Data Transformation (Intermediate)
Available in
days
days
after you enroll
Sprint 04 - Windows Terminal (Optional)
Available in
days
days
after you enroll
- EP01 - Windows Terminal (2:28)
- EP02 - Echo (Print Text) (3:00)
- EP03 - Quick Start (3:27)
- EP04 - Change Directory (1:56)
- EP05 - Create Text File (4:13)
- EP06 - Delete Files and Folders (4:57)
- EP07 - Rename Files (1:38)
- EP08 - Find String (3:12)
- EP09 - Download Data with Curl (3:54)
- EP10 - Ping (2:27)
- EP11 - Move Files (3:13)
- EP12 - Install WSL (3:10)
- EP13 - Nano Editor (3:16)
- EP14 - Intro to Ubuntu Command Line (3:33)
- EP15 - Run Python Script (3:25)
- EP16 - Free REPL Online (3:50)
Sprint 05 - Intro to Data Visualization
Available in
days
days
after you enroll
Sprint 05 - Data Visualization in Excel
Available in
days
days
after you enroll
- Exercise File
- EP01 - Sparklines (3:27)
- EP02 - Histogram (2:21)
- EP03 - Boxplot (3:40)
- EP04 - Bar (2:37)
- EP05 - Line (2:29)
- EP06 - Pie (1:45)
- EP07 - Scatter (2:05)
- EP08 - Stacked Bar (2:03)
- EP09 - Summary Bar (2:10)
- EP10 - Pareto (3:03)
- EP11 - Waterfall (2:21)
- EP12 - Treemap (2:18)
- EP13 - Bubble (1:50)
- EP14 - Bing Maps (2:11)
- EP15 - Pivot Chart (3:53)
Sprint 06 - STAT101 / Intro to Statistics
Available in
days
days
after you enroll
Sprint 06 - STAT102 / Descriptive Statistics
Available in
days
days
after you enroll
Sprint 07 - Essential ML 101
Available in
days
days
after you enroll
- Download Lecture Slide
- What we are going to learn! (1:34)
- EP01 - What is ML (5:16)
- EP02 - Model = Algorithm + Data (3:15)
- Quiz - Model vs. Algorithm
- EP03 - Types of ML (1:19)
- EP04 - Supervised Learning (2:47)
- EP05 - Unsupervised Learning (3:06)
- Quiz - Types of ML
- EP06 - Reinforcement Learning (2:14)
- EP07 - Basic ML Workflow (3:20)
- EP08 - Regression Example (9:27)
- 📑 How to train model using caret
- EP09 - Classification Example (1:53)
- EP10 - Course Summary (1:31)
- Quiz - Basic ML Workflow
Sprint 07 - Essential ML 102
Available in
days
days
after you enroll
Sprint 08 - Intro to Python
Available in
days
days
after you enroll
Sprint 09 - Essential Python for Data Science
Available in
days
days
after you enroll
- Download Files
- 📑 Pandas Documentation
- EP11 - Intro to Pandas 🐼 (1:51)
- EP12 - Create DataFrame (2:25)
- EP13 - Add a new column (1:40)
- EP14 - Drop column (3:19)
- EP15 - Rename columns (1:39)
- EP16 - Series vs DataFrame (4:36)
- EP17 - Write CSV file (1:29)
- EP18 - Upload data to datalore (1:46)
- EP19 - Read Excel data (2:10)
- EP20 - JSON (2:39)
Sprint 09 - Intermediate Pandas I
Available in
days
days
after you enroll
- EP21 - Preview penguins dataframe (4:05)
- EP22 - Select columns (1:28)
- EP23 -iloc (2:40)
- EP24 - Filter dataframe with one condition (2:23)
- EP25 - Filter dataframe more than one condition (2:08)
- EP26 - Query (1:53)
- EP27 - Missing Values (2:53)
- EP28 - Fill missing values (2:34)
- EP29 - Sort dataframe (3:05)
- EP30 - Unique and Count (3:05)
Sprint 09 - Intermediate Pandas II
Available in
days
days
after you enroll
- EP31 - Describe (2:14)
- EP32 - Group by (2:26)
- EP33 - Group by aggregation (2:39)
- EP34 - If your code is long (0:47)
- EP35 - Map (2:14)
- EP36 - Numpy (2:29)
- EP37 - Where (3:09)
- EP38 - Merge (1:54)
- EP39 - Intro to Pandas Plots (5:28)
- EP40 - DataLore Visualization (1:36)
- EP41 - Course Review (0:48)
- EP42 - Say Hi to Final Project 🐼 (1:18)
- 🐼 Pandas Project
Intro to Web Scraping - Python Edition
Available in
days
days
after you enroll
Bootcamp Final Exam
Available in
days
days
after you enroll