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
- Bootcamp 13 is Live
- Warm Welcome
- ⚡Brand New Day
- School Philosophy - Becoming Generalist
- How to attend LIVE classes
- How to study on-demand videos 🍟
- Free Software
- README - Data Analyst Career Guide
- README - Data Science Free Learning Path
- 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
- 💯 How to Use Our School [Must-Watch] (2:07)
- Main Live Classes
- 🌵 Sprint Homework
- Live 01 - Learning How to Learn (Welcome Session)
- Live 02 - AI Foundation ft. Gemini
- Live 01.2 - Intro to Data Science
- Live 03 - Building A Second Brain ft. Notion
- Live 01.3 - Intro to Data Science (Final Part)
- Live 04 - Google Sheets Sprint
- Live 04.2 - Google Sheets Sprint Masterclass (Exclusive) (98:34)
- Live 05 - SQL Sprint
- Live 06 - Google Data Studio
- Live 07 - R Programming
- Live 05.2 - SQL Masterclass (97:57)
- Live 08 - Data Transformation (88:29)
- Live 08.2 - Data Transformation Part 2 (111:17)
- Live 09 - Data Visualization (229:15)
- Live 10 - Building Traffic (219:52)
- Live 11.1 - Essential Statistics for DA Part One (201:05)
- Live 11.2 - Essential Statistics for DA Part Two
- Live 11.3 - Essential Statistics for DA Part Three
- Live 12 - AI + Automating Your Work Life (185:35)
- Live 13 - Essential ML for DA
- Live 14 - Python Programming for Absolute Beginners
- Live 15 - Essential Python for DA
- Live 16 - Becoming Pro Generalists
Bonus Classes Are Here! 📢
Available in
days
days
after you enroll
Introduction
Available in
days
days
after you enroll
The Mindset
Available in
days
days
after you enroll
The Tools
Available in
days
days
after you enroll
The Future
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
Prepare For Data Studio
Available in
days
days
after you enroll
- Data Studio Lecture from BC12
- The Fastest Guide to Data Studio on 🌍
- EP01 - Intro to Data Studio
- Quiz - First Principles
- EP02 - Common Data Sources
- Quiz - Data Sources
- EP03 - Let's Roll!
- Quiz - First Step
- EP04 - The Interface
- EP05 - Our First Visual
- Quiz - Visuals
- EP06 - Our Second Visual
- Quiz - Answer Questions
- EP07 - Change Theme
- EP08 - Add Text & Shape
- EP09 - Add Control (Interaction)
- EP10 - Share Report
- Quiz - Data Studio Primer
- 💛 Do You Like This Format
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
- 📑 Let's continue
- EP01 - Tibble (2:40)
- EP02 - Sample Data (2:29)
- EP03 - Slice (2:09)
- Quiz - Tibble
- 📢 More EP Coming Soon
- EP04 - Relocate
- EP05 - Distinct
- EP06 - Count
- 📑 Different Joins in R (dplyr)
- EP07 - Standard Join (Mutating Join)
- Quiz - Joins
- EP08 - Filtering Join
- EP09 - Cross Join
- EP10 - Row Number and Rank
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
Correlation and Regression for The Curious
Available in
days
days
after you enroll
Warm Up with Theory
Available in
days
days
after you enroll
Let's Do The Work
Available in
days
days
after you enroll
- 📒 Spreadsheets Functions
- Correlation Coefficient (3:29)
- Correlation Matrix (1:29)
- Correlation Test (1:43)
- 📝 Quiz - Correlation
- 📒 READ ME
- Basic Models (1:36)
- Simple Linear Regression (2:36)
- How to Compute R-Squared (2:16)
- Multiple Linear Regression (2:31)
- How to Read Regression Coefficients (1:52)
- Model Prediction (1:31)
- 📝 Quiz - Regression
Full Regression Result
Available in
days
days
after you enroll
Test Your Knowledge
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 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
Sprint 10 - Google Data Studio
Available in
days
days
after you enroll
Bootcamp Final Exam
Available in
days
days
after you enroll