Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Science Bootcamp 9
Welcome to the course!
Warm Welcome
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 (2023)
Join Our Discord 🍻
Kata - Monkeytype
Believe Then Act
Quiz - School Philosophy
Live Classes Are Here! 📢
💯 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! 📢
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
New Content Update (2023)
What is Second Brain?
Notion is evolving over time
How to use Notion 101 (66:01)
Intro to Notion Database 📢 (4:52)
Other Note-Taking Software
Quiz - Building A Second Brain
Notion Primer (Update 2023)
💯 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
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
Exercise File
EP01 - Import Data (6:08)
EP02 - COUNTIFS (4:52)
EP03 - SUMIFS (3:22)
EP04 - Filter (5:29)
EP05 - Sort Sheets (4:12)
EP06 - VLOOKUP (6:34)
EP07 - VLOOKUP Part 2 (3:27)
EP08 - Index and Match (7:10)
EP09 - DATE (4:54)
EP10 - DATEDIF (3:40)
Sprint 01 - Google Sheets 103
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
Exercise File
📑 Pivot Table Formula
Intro to Pivot Table (Google Sheets) (73:35)
🅱️ Transfer Knowledge to Microsoft Excel
Sprint 02 - SQL References
Code for SQL Classes
W3schools SQL References
SQLite Online Editor
Sprint 02 - Intro to Database and CRUD
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
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
📑 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
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)
Coming Soon
SQL Workshops (Optional)
SQL Workshop Part 1 (73:26)
SQL Workshop Part 2 (73:21)
Coming Soon
You are awesome!
Sprint 03 - R101 / Getting Started with R
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
📑 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
💯 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
⭐ 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)
📑 Let's continue
EP01 - Tibble (2:40)
EP02 - Sample Data (2:29)
EP03 - Slice (2:09)
Quiz - Tibble
📢 More EP Coming Soon
Sprint 04 - Windows Terminal (Optional)
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
🌭 Secret Sauce - How to get better at programming
Exercise File
Data Visualization in Google Sheets (75:11)
Data Visualization in R (89:56)
📑 Data Visualization in R Cheat Sheet
Sprint 05 - Data Visualization in Excel
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
📑 Read Me First
EP01 - Intro to Statistics (110:36)
EP02 - Intro to AB Testing (105:08)
EP03 - Correlation and Linear Regression (175:06)
EP04 - Logistic Regression (112:29)
Sprint 06 - STAT102 / Descriptive Statistics
Coming Soon
Sprint 07 - Essential ML 101
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
📑 New Way of Teaching | Learn Faster
Quiz - Reading vs. Speaking
📑 Review - What is Algorithm?
Coming Soon
Sprint 08 - Intro to Python
Download Slide
Download Code
EP01 - Intro (2:18)
EP02 - DataFrame (2:09)
EP03 - DataLore (3:12)
EP04 - Variable (3:29)
EP05 - String (3:12)
EP06 - String Methods (2:58)
EP07 - List (3:38)
EP08 - Dictionary (4:36)
EP09 - Function (3:38)
EP10 - OOP (6:07)
Sprint 09 - Essential Python for Data Science
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
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
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
🍟 The Fastest Intro
EP01 - What is Web Scraping
EP02 - Gazpacho
EP03 - GET request web page (0:08)
Quiz - Essential HTML
EP04 - Find the element you want
EP05 - Using strip() to get clean texts
📝 Optional Reading - Gazpacho
Bootcamp Final Exam
The Moment of Truth
Warm Up Test Exam
📝 Final Exam
Claim Your Badge
Now You've Become A Data Analyst Jedi
💯 New Content Alert
Notion Primer
📝 มาเรียนพื้นฐาน Notion อัพเดทเนื้อหาใหม่สำหรับปี 2023 ด้วยกันนะครับ
Complete and Continue