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
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
- 14 Oct - Live 01 Intro to Data Science Part 1 (193:45)
- 21 Oct - Live 01 Intro to Data Science Part 2 (91:59)
- 21 Oct - Live 02 Building A Second Brain (198:53)
- 28 Oct - Live 03 Google Sheets Part 1 (191:42)
- 29 Oct - Live 04 Google Sheets Part 2 (200:53)
- 04 Nov - Live 05 SQL Database (216:37)
- 11 Nov - Live 06 Programming Foundation (197:28)
- 18 Nov - Live 07 Data Transformation (186:48)
- 02 Dec - Live 08 Data Visualization (178:23)
- 09 Dec - Live 09 Essential Statistics Day One (195:37)
- 10 Dec - Live 10 Essential Statistics Day Two (218:07)
- 📝 Mini Quiz - Essential Statistics for Data Analyst
- Deep Dive into Signficance Testing (97:05)
- 16 Dec - Live 11 Building Portfolio Website (223:54)
- 06 Jan - Live 12 Looker Studio Dashboard (204:09)
- 13 Jan - Essential ML for Data Analyst Part 1 (190:02)
- 20 Jan - Essential ML for Data Analyst Part 2 (197:55)
- 27 Jan - Python Programming
- 03 Feb - Essential Python for Data Analyst (230:52)
- 19 Feb - Essential ML for Data Analyst Part 3 (97:13)
- 24 Feb - Graduation Day (114:36)
Bonus Classes Are Here! 📢
Available in
days
days
after you enroll
- Bonus Live Classes
- 05 Nov - Design Thinking 101 with Kamin
- 19 Nov - Google Analytics with Yos CJ (139:49)
- 26 Nov - Power BI for Data Analyst with P'Zue (134:16)
- 02 Dec - Data Discussion with Book (110:19)
- 03 Dec - Power Query with P'Bew (194:47)
- 17 Dec - UX 101 and Figma with P'First ODDS
- 19 Dec - Teach and Learn How to Code with N'Aom CodeKids
- 24 Dec - Data Engineering 101 with Mils
- 25 Dec - Functional Programming with P'Roof ODDS
- 27 Dec - UX Career with Nat
- 25 Jan - Business Strategy with Non NYU
- 10 Feb - Intro to Data Modeling in Microsoft Excel
- 11 Feb - Intro to Data Modeling in Power BI
- 13 Mar - SEO 101 with Ice NerdOptimize (107:44)
Building A Second Brain
Available in
days
days
after you enroll
Notion Primer (Update 2023)
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)
Sprint 02 - SQL for Data Analyst 104 (Window Functions)
Available in
days
days
after you enroll
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