Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Science Bootcamp 8
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! 📢
🌵 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! 📢
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)
24 Sep 2023 - Bard AI Updated Sep'23 (82:41)
Building A Second Brain
What is Second Brain?
Notion is evolving over time
How to use Notion 101 (66:01)
Intro to Notion Database 2022 📢 (4:52)
Other Note-Taking Software
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
Sprint 01 - Google Sheets 104
Exercise File
📑 Pivot Table Formula
Intro to Pivot Table (Google Sheets) (73:35)
🅱️ Transfer Knowledge to Microsoft Excel
Sprint 01 - Google Sheets 105 (New!)
Common Data Format
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)
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!
📑 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?
📑 Optional Reading - Ridge & Lasso Explained by DataCamp
Quiz - Ridge vs. Lasso
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
The New Final Exam
It's The Moment of Truth
📝 Final Exam
Claim Your Badge
Now You've Become A Data Analyst Jedi
01 July 2023 - Data Visualization
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock