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
💽 Database/Dataset (1st Half Course) 👉 https://lukeb.co/sql_jobs_db

𝗘𝘅𝗰𝗲𝗹 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
▔▔▔▔▔▔▔▔▔▔▔
📁 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/datasets/lukebarousse/data_jobs

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