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

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 Charts
33:59:03 Ch 2 - Seaborn: Intro
34:13:04 Project #6 - Job & Skill Demand Analysis

₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋
𝗟𝗶𝗻𝗸𝘀 & 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
▔▔▔▔▔▔▔▔

𝗦𝗤𝗟 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
▔▔▔▔▔▔▔▔▔▔
📁 FREE Course Databases & Links 👉 https://lukebarousse.com/sql
🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/sql

Other Resources
💽 Main Database (1st Half Course) 👉 https://lukeb.co/sql_jobs_db
🏦 Invoice Dataset (1st Half Course) 👉 https://lukeb.co/sql_invoices_db
📱 My Job Market Analytics App 👉 https://datanerd.tech

𝗘𝘅𝗰𝗲𝗹 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
▔▔▔▔▔▔▔▔▔▔▔
📁 FREE Course Files & Projects 👉 https://lukeb.co/excel_files_alternate
🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/excel

Links by Chapter
₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋
0️⃣ Excel Setup
Run Windows on a Mac (VM) - https://lukeb.co/parallels
Microsoft 365 - https://www.microsoft.com/en-us/microsoft-365

📊 Project #1
Project #1: Excel Online Version - https://lukeb.co/excel_dashboard

7️⃣ Power Query
Wikipedia Table S&P 500 - https://en.wikipedia.org/wiki/List_of_S&P_500_companies

8️⃣ Power Pivot
Merges (SQL Joins) - https://lukeb.co/sql_joins

📚 Recommended Books
The Excel 365 Bible - https://geni.us/excel_bible
M is for (Data) Monkey (renamed: Master Your Data) - https://geni.us/power_query

𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
▔▔▔▔▔▔▔▔▔▔▔▔
📁 FREE Course Files & Projects 👉 https://lukeb.co/powerbi-files
🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/powerbi

Other Resources
Power BI Course Website 👉 https://www.lukebarousse.com/powerbi
📊 Project #1 - Live Dashboard 👉 https://lukeb.co/powerbi-project1
📉 Project #2 - Live Dashboard 👉 https://lukeb.co/powerbi-project2
Run Windows on a Mac (VM) 👉 https://lukeb.co/parallels

𝗖𝗵𝗮𝘁𝗚𝗣𝗧 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
▔▔▔▔▔▔▔▔▔▔▔▔
Data Jobs File 👉🏼 https://lukeb.co/jobs_file

𝗣𝘆𝘁𝗵𝗼𝗻 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
▔▔▔▔▔▔▔▔▔▔▔
📁 FREE Course Files & Project 👉 https://lukeb.co/python_repo
🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/python

Links by Chapter
₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋
1️⃣ Basics Links
- Dataset (Hugging Face) - https://huggingface.co/dataset....s/lukebarousse/data_

2️⃣ Advanced Links
- Software Jobs CSV - https://lukeb.co/software_csv
- Joins Explained (SQL for Data Analytics) - https://lukeb.co/sql_joins

𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀
▔▔▔▔▔▔▔▔▔▔▔▔
💽 SQL for Data Analytics 👉🏼 https://youtu.be/7mz73uXD9DA
🛠️ SQL for Data Engineering 👉🏼 https://youtu.be/UjhFbq4uU2Y
❎ Excel for Data Analytics 👉🏼 https://youtu.be/pCJ15nGFgVg
📊 Power BI for Data Analytics 👉🏼 https://youtu.be/FwjaHCVNBWA
🐍 Python for Data Analytics 👉🏼 https://youtu.be/wUSDVGivd-8
⚛️ ChatGPT for Data Analytics 👉🏼 https://youtu.be/uhyMqbZI6rM

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮
▔▔▔▔▔▔
📫 Newsletter: https://lukebarousse.com/crash-courses
👨🏼‍💼 LinkedIn: https://www.linkedin.com/in/luke-b/
👾 GitHub: https://github.com/lukebarousse
🅧 X/Twitter: https://twitter.com/LukeBarousse
🌄 Instagram: https://www.instagram.com/lukebarousse/
⏰ TikTok: https://www.tiktok.com/@lukebarousse

#dataanalyst #bootcamp #datanerd