Data Analyst Bootcamp (FREE 35+ Hour Full Course) - SQL, Excel, Power BI, Python, AI & GitHub

Luke Barousse · Beginner ·📊 Data Analytics & Business Intelligence ·1mo ago

Key Takeaways

Covers data analysis with SQL, Excel, Power BI, Python, AI, and GitHub in a bootcamp

Original Description

Free 5-Day Data Analyst Crash Course 👉 https://lukeb.co/da-crash-course Data Analyst Course Bundle (400+ interview problems, certificates, & more) 👉 https://lukeb.co/data-analyst-bundle 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗕𝗼𝗼𝘁𝗰𝗮𝗺𝗽 ▔▔▔▔▔▔▔▔▔▔ 0:00:00 Bootcamp Intro 𝗦𝗤𝗟 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 ▔▔▔▔▔▔▔▔▔▔ 0:10:20 SQL Intro 0:27:11 Ch 1 - The Basics 1:04:21 Ch 1 - Operations & Aggregation 1:20:27 Ch 1 - JOINS & Order of Execution 1:36:38 Ch 2 - Install PostgreSQL & VS Code 1:54:28 Ch 2 - Data Types & Manipulation 2:10:20 Ch 2 - Load Database 2:26:52 Ch 2 - Functions & CASE Expression 2:47:14 Ch 2 - SubQueries and CTEs 3:15:01 Project #1 - Optimal Skills Analysis 𝗘𝘅𝗰𝗲𝗹 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 ▔▔▔▔▔▔▔▔▔▔▔ 4:25:30 Excel Intro 4:36:49 Ch 0 - Excel Install 4:48:12 Ch 1 - Spreadsheets Intro 5:32:09 Ch 2 - Formulas & Functions 7:27:03 Ch 3 - Charts Intro 8:17:27 Ch 4 - Spreadsheet Advanced 9:06:00 Project #2 - Data Jobs Dashboard 9:59:16 Ch 5 - PivotTables 10:45:13 Ch 6 - Advanced Data Analysis 11:28:34 Ch 7 - Power Query 13:28:41 Ch 8 - Power Pivot 14:53:10 Project #3 - Data Jobs Analysis 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 15:25:13 Power BI Intro 15:38:20 Ch 1 - Grand Tour 16:38:40 Ch 2 - Charts, Cards, Slicers 18:51:30 Project #4 - Drill Through Dashboard 19:37:00 Ch 3 - Power Query 21:57:50 Ch 4 - DAX 23:14:28 Project #5 - Data Jobs Dashboard 𝗖𝗵𝗮𝘁𝗚𝗣𝗧 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 23:49:44 ChatGPT Tutorial 𝗣𝘆𝘁𝗵𝗼𝗻 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 ▔▔▔▔▔▔▔▔▔▔▔ 24:27:24 Python Intro 24:36:06 Ch 1 - Getting Started 25:05:30 Ch 1 - Data Types 26:01:48 Ch 1 - Lists, Dictionaries, Sets, Tuples 26:48:30 Ch 1 - Loops, List Comprehensions 27:19:36 Ch 1 - Functions, Library, Classes 28:38:08 Ch 1 - NumPy: Intro 28:50:20 Ch 1 - Pandas: Intro 29:44:43 Ch 1 - Matplotlib: Intro 30:18:20 Ch 2 - Python Local Install (Anaconda) 30:54:39 Ch 2 - Pandas: Advanced 32:44:45 Ch 2 - Matplotlib: Format Cha
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related Reads

📰
Classroom vs Online Data Science Training in Hyderabad | Coding MastersClassroom vs Online Data…
Learn why data science is in high demand and how to get trained in Hyderabad, whether through classroom or online modes, to boost your career
Medium · Data Science
 📰
SciDraw Alternative: Paper Banana for Scientific Figures
Discover Paper Banana as a SciDraw alternative for creating scientific figures, and learn how to use it for your data visualization needs
Medium · Data Science
 📰
“Missão: Risco da Carteira”.
Learn to assess portfolio risk using data science techniques and tools
Medium · Data Science
 📰
When Ten Analysts Agree and Two Are Right — What Numbers 13 Knew About Groupthink
Learn how to identify and avoid groupthink in analysis and decision-making, and why it's crucial for accurate threat assessments
Medium · AI

Chapters (43)

Bootcamp Intro
10:20 SQL Intro
27:11 Ch 1 - The Basics
1:04:21 Ch 1 - Operations & Aggregation
1:20:27 Ch 1 - JOINS & Order of Execution
1:36:38 Ch 2 - Install PostgreSQL & VS Code
1:54:28 Ch 2 - Data Types & Manipulation
2:10:20 Ch 2 - Load Database
2:26:52 Ch 2 - Functions & CASE Expression
2:47:14 Ch 2 - SubQueries and CTEs
3:15:01 Project #1 - Optimal Skills Analysis
4:25:30 Excel Intro
4:36:49 Ch 0 - Excel Install
4:48:12 Ch 1 - Spreadsheets Intro
5:32:09 Ch 2 - Formulas & Functions
7:27:03 Ch 3 - Charts Intro
8:17:27 Ch 4 - Spreadsheet Advanced
9:06:00 Project #2 - Data Jobs Dashboard
9:59:16 Ch 5 - PivotTables
10:45:13 Ch 6 - Advanced Data Analysis
11:28:34 Ch 7 - Power Query
13:28:41 Ch 8 - Power Pivot
14:53:10 Project #3 - Data Jobs Analysis
15:25:13 Power BI Intro
15:38:20 Ch 1 - Grand Tour
16:38:40 Ch 2 - Charts, Cards, Slicers
18:51:30 Project #4 - Drill Through Dashboard
19:37:00 Ch 3 - Power Query
21:57:50 Ch 4 - DAX
23:14:28 Project #5 - Data Jobs Dashboard
23:49:44 ChatGPT Tutorial
24:27:24 Python Intro
24:36:06 Ch 1 - Getting Started
25:05:30 Ch 1 - Data Types
26:01:48 Ch 1 - Lists, Dictionaries, Sets, Tuples
26:48:30 Ch 1 - Loops, List Comprehensions
27:19:36 Ch 1 - Functions, Library, Classes
28:38:08 Ch 1 - NumPy: Intro
28:50:20 Ch 1 - Pandas: Intro
29:44:43 Ch 1 - Matplotlib: Intro
30:18:20 Ch 2 - Python Local Install (Anaconda)
30:54:39 Ch 2 - Pandas: Advanced
32:44:45 Ch 2 - Matplotlib: Format Cha
Up next
This could be the most perfect data frontend
Matt Williams
Watch →