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
- 🌵 Sprint Homework
- 04 May 2023 - Hello World (Kick Off Session) (73:11)
- 06 May 2023 - Intro to Data Science (198:05)
- 13 May 2023 - Building A Second Brain [Notion] (204:35)
- 20 May 2023 - Spreadsheets Part 1 (182:05)
- 21 May 2023 - Spreadsheets Part 2 (200:46)
- 03 June 2023 - SQL Databases (234:16)
- 10 June 2023 - Programming Foundation (209:03)
- 17 June 2023 - Data Transformation (185:11)
- 01 July 2023 - Data Visualization (166:18)
- 08 Jul 2023 - Essential Statistics for Data Analyst Part 1 (206:09)
- 15 Jul 2023 - Essential Statistics for Data Analyst Part 2 (185:56)
- 22 Jul 2023 - Essential Statistics for Data Analyst Part 3 (207:00)
- 26 Jul 2023 - Essential Statistics for Data Analyst Part 4 (97:05)
- 29 July 2023 - Building Personal Portfolio (204:16)
- 05 August 2023 - Essential ML for Data Analyst Part 1 (180:02)
- 10 August 2023 - Essential ML for Data Analyst Part 2 (156:58)
- 19 Aug 2023 - ML Final & Programming Foundation [Python] (239:58)
- 26 Aug 2023 - Essential Python for Data Analyst (254:52)
- 02 Sep 2023 - Dashboard with Looker Studio (191:02)
Bonus Classes Are Here! 📢
Available in
days
days
after you enroll
- 28 May 2023 - Data Engineering 101 with Mils (145:52)
- 29 May 2023 - Personal Branding with P'Bow (125:17)
- 04 June 2023 - Figma and UX 101 with P'First (134:12)
- 11 June 2023 - The Future of Data Engineering with P'Paul
- 24 June 2023 - Intro to Data Model (Excel 365) (70:43)
- 25 June 2023 - Intro to Data Model (Power BI) (86:18)
- 02 July 2023 - Data Science 101 with P'Mai NERD
- 09 July 2023 - Power BI 101 with P'Zue (147:29)
- 16 July 2023 - Google Analytics GA4 with Yos (145:33)
- 03 Aug 2023 - Growth Marketing with Non Skooldio (111:02)
- 09 Aug 2023 - UX 101 with P'Pij (121:33)
- 14 Aug 2023 - Google Data Studio Quick Intro (76:32)
- 20 Aug 2023 - Power Query with P'Bew (187:32)
- 27 Aug 2023 - Data Cleansing with N'Aor (94:20)
- 23 Sep 2023 - Tableau Public 101 with Gap (133:40)
Building A Second Brain
Available in
days
days
after you enroll
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
Sprint 01 - Google Sheets 104
Available in
days
days
after you enroll
Sprint 01 - Google Sheets 105 (New!)
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!
- 📑 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
Sprint 10 - Looker Studio (Former Data Studio)
Available in
days
days
after you enroll
Sprint 10 - Tableau Public
Available in
days
days
after you enroll