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
- 01 Jun - Live 01 Intro to Data Science (189:06)
- 20 Jun - Live 01 Intro to Data Science Part 2 (159:30)
- 08 Jun - Live 02 Building A Second Brain (232:20)
- ❤️ Intro to replit.com (3:46)
- 15 Jun - Live 03 Google Sheets Part 1 (228:51)
- 18 Jun - Live 03 Google Sheets Part 2 (118:47)
- 22 Jun - Live 04 SQL Database (208:27)
- 02 Jul - Live 05 Programming Foundation
- 06 Jul - Live 06 Data Transformation (203:21)
- 17 Jul - Live 06 Data Transformation (Cont) (103:16)
- 20 Jul - Live 07 Data Visualization (194:27)
- 27 Jul - Live 08 Essential Statistics Day One (196:13)
- 10 Aug - Live 08 Essential Statistics Day Two (191:29)
- Deep Dive into Signficance Testing (97:05)
- 📝 Mini Quiz - Essential Statistics for Data Analyst
- 17 Aug - Live 09 Looker Studio Dashboard (197:35)
- 21 Aug - Live 10 WordPress 101 (134:53)
- 24 Aug - Essential ML for Data Analyst Part 1 (187:48)
- 24 Aug - Essential Economics for Data Analyst (180:15)
- 31 Aug - Essential ML for Data Analyst Part 2 (202:32)
- 31 Aug - Intro to Marketing & Business for DA 101 (173:24)
- 07 Sep - Python Foundation 101 (184:28)
- 14 Sep - Essential Python for Data Analyst (172:53)
- 21 Sep - Exclusive Live Behavioural Economics 101 (150:20)
- 28 Sep - Graduation Day (195:42)
- ❤️ A Message to AdToy
Bonus Classes Are Here! 📢
Available in
days
days
after you enroll
- Bonus Live Classes
- 02 Jun - Prompt Engineering 101 (116:14)
- 12 Jun - Data Analytics Sharing Session
- 19 Jun - Note Taking with Notion 101 ft. Fifa
- 01 Jul - Pomodoro 101 with Aj'Ohm (109:08)
- 03 Jul - Coffee and Content with Aj'Arm GoodSunday
- 07 Jul - Intro to Power Query (Excel) ft. P'Bew
- 13 Jul - Streamlit 101 with Aj'Earl Data Professor
- 13 Jul - Prompt Engineering II
- 14 Jul - Thinking 101 with Gui
- 15 Jul - Google Analytics with Yos
- 20 Jul - LINE Foundation with P'Oh LINE API Expert
- 30 Jul - Intro to API with JavaScript
- 03 Aug - Intro to Data Modeling in Microsoft Excel
- 03 Aug - Intro to Data Modeling in Power BI
- 04 Aug - UX UI 101 ft. P'First ODDS
- 07 Aug - The Laws of UX ft. P'Pom+
- 11 Aug - Intro to Web Development ft. Gatuk
- 18 Aug - Intro to Software Dev 101 ft. Man
- 25 Aug - Power BI Crash Course ft. P'Zue
- 01 Sep - Data Engineering 101 ft. Mil DE, GDE
- 03 Sep - Intro to ML Engineering 101 ft. Fon DataTH
- 08 Sep - BUJO with Ton
- 08 Sep - SEO Update 2024 ft. Tungmay
- 17 Sep - UX Design 101 with P'Pij
- 30 Sep - MBA Life ft. Non ex-Skooldio
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)
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