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 💽 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