Free 10-Day Data Engineer Crash Course 👉 https://lukeb.co/de-crash-course Data Engineer Course Bundle (470+ interview problems, certificates, & more) 👉 https://lukeb.co/data-engineer-bundle 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 𝗕𝗼𝗼𝘁𝗰𝗮𝗺𝗽 ▔▔▔▔▔▔▔▔▔▔▔▔ 0:00:00 Bootcamp Intro 0:11:01 Fundamentals: Intro 0:13:24 Fundamentals: Stages - DE Lifecycle 0:35:16 Fundamentals: Undercurrents - DE Lifecycle 0:42:42 Fundamentals: Top DE Skills to Focus 𝗦𝗤𝗟 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 ▔▔▔▔▔▔▔▔▔▔▔ 0:47:22 SQL Intro 1:06:01 Ch 1 - Setup & Basics 1:39:28 Ch 1 - Operators & Functions 2:42:23 Ch 1 - Terminal Intro 3:15:54 Ch 1 - Local DuckDB Intro 3:53:46 Ch 1 - VS Code Intro 4:16:18 Ch 1 - Data Modeling & JOINs 5:18:13 Project #1 - Exploratory Data Analysis 6:57:49 Ch 2 - Data Types 7:14:39 Ch 2 - DDL & DML 8:17:50 Ch 2 - Subqueries & CTEs 9:32:17 Ch 2 - Data Modeling Pt.2 10:16:15 Ch 2 - Functions (Date, Text, & NULL) 11:13:38 Ch 2 - Window Functions 11:47:26 Ch 2 - Nested Functions 13:19:58 Project #2 - Data Warehouse & ETL Pipeline 𝗖𝗵𝗮𝘁𝗚𝗣𝗧 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 15:32:34 ChatGPT Tutorial 𝗣𝘆𝘁𝗵𝗼𝗻 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 ▔▔▔▔▔▔▔▔▔▔▔ 16:10:14 Python Intro 16:18:56 Ch 1 - Getting Started 16:48:20 Ch 1 - Data Types 17:44:38 Ch 1 - Lists, Dictionaries, Sets, Tuples 18:31:20 Ch 1 - Loops, List Comprehensions 19:02:26 Ch 1 - Functions, Library, Classes 20:20:58 Ch 1 - NumPy: Intro 20:33:10 Ch 1 - Pandas: Intro 21:27:33 Ch 1 - Matplotlib: Intro 22:01:10 Ch 2 - Python Local Install (Anaconda) 22:37:29 Ch 2 - Pandas: Advanced 24:27:35 Ch 2 - Matplotlib: Format Charts 25:41:53 Ch 2 - Seaborn: Intro 25:55:54 Project #3 - Job & Skill Pipeline Analysis ₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋₋ 𝗟𝗶𝗻𝗸𝘀 & 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 ▔▔▔▔▔▔▔▔ 𝗦𝗤𝗟 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 ▔▔▔▔▔▔▔▔▔▔▔ 📁 FREE Course Files & Project 👉 https://lukeb.co/sql-de-github 🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/sql-de Attach the data_jobs database using ONE of the following: -- us-east-1 or eu-central-1 region ATTACH 'md:_share/data_jobs/87603155-cdc7-4c80-85ad-3a6b0d760d93' AS data_jobs; -- us-west-2 region ATTACH 'md:_share/data_jobs/a94f9b8a-2b8a-473f-bb86-de09552f052d' AS data_jobs; -- eu-west-1 region ATTACH 'md:_share/data_jobs/058ad1f4-939b-4998-95e1-0df8f8644f3c' AS data_jobs; ⚠️ MotherDuck free trial expired? No worries — just go to Settings → Plans in the UI and select the Lite plan (still 100% free, no credit card needed) My Job Market Analytics App 👉 https://datanerd.tech Project #1 👉 https://lukeb.co/sql-de-project1 Project #2 👉 https://lukeb.co/sql-de-project2 MotherDuck Signup 👉 https://lukeb.co/motherduck DuckDB Install 👉 https://lukeb.co/duckdb 𝗖𝗵𝗮𝘁𝗚𝗣𝗧 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 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 1️⃣ Basics Links - Dataset (Hugging Face) - https://huggingface.co/datasets/lukebarousse/data_jobs - Python Docs - https://docs.python.org - Matplotlib Docs - http://matplotlib.org/ - Matplotlib CheatSheet - https://matplotlib.org/cheatsheets/ 2️⃣ Advanced Links - VS Code Install - https://code.visualstudio.com/download - Anaconda Install - https://anaconda.com/download/success - Anaconda Docs - https://docs.conda.io - Software Jobs CSV - https://lukeb.co/software_csv - Joins Explained (SQL for Data Analytics) - https://lukeb.co/sql_joins - Pandas Cheat Sheet - https://pandas.pydata.org/Pandas_Cheat_Sheet.pdf - Seaborn Docs - https://seaborn.pydata.org/ 3️⃣ Project Links - Git Download - https://git-scm.com/downloads - GitHub Signup - http://github.com/signup - Markdown CheatSheet - https://www.markdownguide.org/cheat-sheet/ 𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 💽 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 🙌 Course Bundles 👉🏼 https://lukeb.co/courses 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫 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 #dataengineer #bootcamp #datanerd

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/Dataset (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/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

My FREE Course to be a Data Analyst 👉 https://lukeb.co/da-crash-course My Data Skills App 👉 https://datanerd.tech 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔ 💽 SQL for Data Analytics 👉🏼 https://youtu.be/7mz73uXD9DA ❎ 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 🛠️ SQL for Data Engineering 👉🏼 https://youtu.be/UjhFbq4uU2Y 🙌 Course Bundles 👉🏼 https://lukeb.co/courses 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫 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 #datanerd #dataanalyst #dataengineer

My FREE Course to be a Data Engineer 👉 https://lukeb.co/de-crash-course My Job Market Analytics App 👉 https://datanerd.tech 𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 🛠️ SQL for Data Engineering 👉🏼 https://youtu.be/UjhFbq4uU2Y 🐍 Python for Data Analytics 👉🏼 https://youtu.be/wUSDVGivd-8 💽 SQL for Data Analytics 👉🏼 https://youtu.be/7mz73uXD9DA ❎ Excel for Data Analytics 👉🏼 https://youtu.be/pCJ15nGFgVg 📊 Power BI for Data Analytics 👉🏼 https://youtu.be/FwjaHCVNBWA ⚛️ ChatGPT for Data Analytics 👉🏼 https://youtu.be/uhyMqbZI6rM 🙌 Course Bundles 👉🏼 https://lukeb.co/courses 𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗲𝗱 𝗕𝗼𝗼𝗸𝘀 ▔▔▔▔▔▔▔▔▔▔ Fundamentals of Data Engineering 👉 https://amzn.to/3Qdamzh The Data Warehouse Toolkit 👉 https://amzn.to/426zevq 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫 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 00:00 - Intro 01:37 - What Does a DE Do? 03:33 - Top Tools of Data Engineers 05:01 - Data Engineering Lifecycle (Intro) 06:22 - Storage (Warehouse vs Lake vs Lakehouse) 09:14 - Storage (Tools) 11:45 - Generation & Ingestion (Batch vs Stream) 13:25 - Generation & Ingestion (Tools) 14:40 - Transformation (Data Modeling 101) 19:50 - Transformation (Tools) 23:50 - Serving (Concepts & Tools) 25:32 - ETL vs ELT 27:08 - Undercurrents (Intro) 27:38 - Orchestration (Concepts) 28:46 - Orchestration (Airflow) 30:01 - Software Engineering (Terminal, Bash, Git) 32:36 - DataOps (CI/CD) 34:10 - Data Architecture (Putting it all together) 34:34 - Top DE Skills to Learn 38:16 - How to Learn Skills #datanerd #dataanalyst #dataengineer

The app 👉 https://datanerd.tech/ My FREE courses to become a DA👨🏼‍💻, DE👩🏻‍🔧 or DS🧑‍🔬 👉 https://lukebarousse.com/crash-courses 𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 💽 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 🙌 Support my FREE Courses 👉🏼 https://lukeb.co/courses 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫 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 #datanerd #dataanalyst #dataanalytics

Power your data pipelines with SerpApi 👉 https://serpapi.link/luke 🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/sql-de My FREE Crash Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse 𝗖𝗼𝘂𝗿𝘀𝗲 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 ▔▔▔▔▔▔▔▔ GitHub Repo 👉 https://lukeb.co/sql-de-github Project #1 👉 https://lukeb.co/sql-de-project1 Project #2 👉 https://lukeb.co/sql-de-project2 MotherDuck Signup 👉 https://lukeb.co/motherduck DuckDB Install (Don't use DuckDB.org) 👉 https://lukeb.co/duckdb Attach the data_jobs database using ONE of the following: -- us-east-1 or eu-central-1 region ATTACH 'md:_share/data_jobs/87603155-cdc7-4c80-85ad-3a6b0d760d93' AS data_jobs; -- us-west-2 region ATTACH 'md:_share/data_jobs/a94f9b8a-2b8a-473f-bb86-de09552f052d' AS data_jobs; -- eu-west-1 region ATTACH 'md:_share/data_jobs/058ad1f4-939b-4998-95e1-0df8f8644f3c' AS data_jobs; ⚠️ MotherDuck free trial expired? No worries — just go to Settings → Plans in the UI and select the Lite plan (still 100% free, no credit card needed) 0️⃣ 𝗖𝗼𝘂𝗿𝘀𝗲 𝗜𝗻𝘁𝗿𝗼 00:00:00 Course Intro 00:06:11 What is SQL? 00:12:15 Data & Pipeline Intro 1️⃣ 𝗦𝗤𝗟 𝗙𝗼𝘂𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 00:18:39 SQL & Dataset Setup 00:32:39 Basic Keywords 00:52:06 Comparison & Logical Operators 01:14:52 Wildcards & Aliases 01:26:10 Arithmetic Operators 01:38:10 Aggregate Functions 01:55:01 Terminal Intro 02:28:32 Local DuckDB Intro 03:06:24 VS Code Intro 03:28:56 Data Modeling Pt.1 03:49:10 JOINs 04:11:34 Order of Execution 📊 𝗘𝘅𝗽𝗹𝗼𝗿𝗮𝘁𝗼𝗿𝘆 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝘄/ 𝗦𝗤𝗟 — 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 #1 04:30:51 Project #1 Intro 04:38:54 EDA #1 In-Demand Skills 04:47:27 EDA #2 Highest Paying Skills 04:56:02 EDA #3 Most Optimal Skills 05:10:58 README.md Build 05:27:27 Git & GitHub Pt.1 06:03:49 Share Project #1 2️⃣ 𝗣𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝗼𝗻 𝗦𝗤𝗟 06:10:27 Data Types 06:27:17 DDL & DML Pt.1 07:04:57 DDL & DML Pt.2 07:30:28 Subqueries and CTEs 08:06:07 DDL & DML Pt.3 08:44:55 Data Modeling Pt.2 09:08:07 CASE Expressions 09:28:54 Date Functions 09:51:19 SET Operators 10:08:04 Text & NULL Functions 10:26:16 Window Functions 11:00:04 Nested Functions 11:50:17 Git & GitHub Pt.2 🏗️ 𝗗𝗮𝘁𝗮 𝗪𝗮𝗿𝗲𝗵𝗼𝘂𝘀𝗲 & 𝗘𝗧𝗟 𝗣𝗶𝗽𝗲𝗹𝗶𝗻𝗲 — 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 #2 12:32:36 Project #2 Intro 12:43:08 Build Data Warehouse 13:21:00 Build Flat Table Mart 13:40:03 Build Skills Mart 14:07:45 Build Priority Mart 14:29:40 README.md Build 14:40:58 Share Project #2 𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 💽 SQL for Data Analytics 👉🏼 https://youtu.be/7mz73uXD9DA ❎ 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 🙌 Support my FREE Courses 👉🏼 https://lukeb.co/courses 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫 Newsletter: https://lukebarousse.com/5daycourse 👨🏼‍💼 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 𝗧𝗲𝗮𝗺’𝘀 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔▔▔▔ 🎬 Course Producer: Kelly Adams 👉 https://www.linkedin.com/in/kellyjianadams 💻 Content Developer: Rikki Singh 👉 https://www.linkedin.com/in/rikkisingh 📺 Video Editor: Brannon Linder 👉 https://www.linkedin.com/in/brannonlinder #datanerd #dataengineering #sql

📁 FREE Course Files & Projects 👉 https://lukeb.co/powerbi-files 🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/powerbi My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse 𝗢𝘁𝗵𝗲𝗿 𝗖𝗼𝘂𝗿𝘀𝗲 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 ▔▔▔▔▔▔▔▔▔▔▔ 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 Parallels VM - Run Windows on a Mac 👉 https://lukeb.co/parallels 𝗖𝗼𝘂𝗿𝘀𝗲 𝗢𝘂𝘁𝗹𝗶𝗻𝗲 ▔▔▔▔▔▔▔ 0️⃣ 𝗜𝗻𝘁𝗿𝗼 00:00 - Welcome 03:58 - What is Power BI? 09:19 - Course Intro 1️⃣ 𝗚𝗿𝗮𝗻𝗱 𝗧𝗼𝘂𝗿 13:07 - Power BI Desktop 35:05 - Dashboard Build 58:29 - Power BI Service 2️⃣ 𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻𝘀 1:13:27 - Column & Bar Charts 1:32:16 - Line & Area Charts 1:48:33 - Common Charts 2:04:59 - Map Charts 2:17:45 - Uncommon Charts 2:30:24 - Tables 2:47:48 - Cards 2:57:23 - Slicers 3:11:00 - Buttons & Bookmarks 📊 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 #𝟭 3:26:17 - Main Dashboard 3:39:49 - Job Drill Through 3:49:35 - Share Dashboard 3️⃣ 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 4:11:47 - Power Query Intro 4:34:12 - Power Query Editor 4:57:50 - Project #2: Data Import 5:19:33 - Advanced Transformations 5:44:00 - Append Vs Merge 6:10:04 - M Language 4️⃣ 𝗗𝗔𝗫 6:32:37 - DAX Intro 7:04:03 - Explicit Measures 7:34:35 - Parameters 📉 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 #𝟮 7:49:15 - Dashboard Build 8:11:03 - Share Dashboard 𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 💽 SQL for Data Analytics 👉🏼 https://youtu.be/7mz73uXD9DA ❎ Excel for Data Analytics 👉🏼 https://youtu.be/pCJ15nGFgVg 🐍 Python for Data Analytics 👉🏼 https://youtu.be/wUSDVGivd-8 ⚛️ ChatGPT for Data Analytics 👉🏼 https://youtu.be/uhyMqbZI6rM 🙌 Support my FREE Courses 👉🏼 https://lukeb.co/courses 𝗠𝘆 𝗗𝗮𝘁𝗮𝗖𝗮𝗺𝗽 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔ DAX Functions 👉 https://lukeb.co/dax-datacamp Intermediate DAX 👉 https://lukeb.co/int-dax-datacamp Power BI Case Study 👉 https://lukeb.co/powerbi-case-datacamp 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫 Newsletter: https://lukebarousse.com/5daycourse 👨🏼‍💼 LinkedIn: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse 𝗞𝗲𝗹𝗹𝘆'𝘀 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔▔▔▔ 👩🏻‍💼 Kelly’s LinkedIn 👉 https://www.linkedin.com/in/kellyjianadams/ 🌐 Kelly’s Website 👉 https://www.kellyjadams.com As a DataCamp and Parallels Affiliate Program member, I earn a commission from qualifying purchases on the links above. This does not cost you anything but helps support making more content. #datanerd #dataanalyst #dataanalytics

📁 FREE Course Files & Resources 👉 https://www.lukebarousse.com/int-sql 🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/int-sql 🗒️ Blank SQL Notebook 👉 https://lukeb.co/int-sql-colab My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse 𝗖𝗼𝘂𝗿𝘀𝗲 𝗢𝘂𝘁𝗹𝗶𝗻𝗲 ▔▔▔▔▔▔▔ 0️⃣ Intro 00:00 - About Course: Welcome 04:41 - About Course: Q&A 08:34 - Colab Notebooks 19:19 - Database Overview `net_revenue` Calculation Correction 👉 https://youtu.be/B9HJGN07FrQ 1️⃣ Pivot With Case Statements 37:44 - Basic Aggregation 52:24 - Statistical Aggregations 1:04:47 - Advanced Segmentation 2️⃣ Date Time 1:25:28 - Date Format 1:33:13 - Date Filtering 1:42:19 - Date Differences 3️⃣ Window Functions 1:53:36 - Syntax 2:11:59 - Aggregation 2:32:36 - Ranking 2:47:16 - Lag Lead 3:01:28 - Frame Clause 4️⃣ Local DB Setup 3:14:21 - Install PostgreSQL 3:25:38 - Install DBeaver 5️⃣ Views 3:45:59 - View Intro 4:06:27 - Project Cohort Revenue 4:16:17 - Install VSCode 6️⃣ Data Cleaning 4:36:22 - Conditional Handle Nulls 4:49:05 - String Formatting 4:55:52 - Project Customer Segmentation 7️⃣ Query Optimization 5:10:55 - Explain Intro 5:26:29 - Optimization Techniques 5:42:10 - Project Customer Retention 8️⃣ Share Project 6:04:16 - Create GitHub Repo 6:22:27 - Share on LinkedIn 𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 💽 SQL for Data Analytics 👉🏼 https://youtu.be/7mz73uXD9DA ❎ 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 🙌 Support my FREE Courses 👉🏼 https://lukeb.co/courses 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫 Newsletter: https://lukebarousse.com/5daycourse 👨🏼‍💼 LinkedIn: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse 𝗞𝗲𝗹𝗹𝘆'𝘀 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔▔▔▔ Kelly’s LinkedIn: https://www.linkedin.com/in/kellyjianadams/ Kelly’s Website: https://www.kellyjadams.com As an Amazon, Coursera, and Parallels Affiliate Program member, I earn a commission from qualifying purchases on the links above. This does not cost you anything but helps support making more content. #datanerd #dataanalyst #dataanalytics

My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔ 💽 SQL for Data Analytics 👉🏼 https://youtu.be/7mz73uXD9DA ❎ 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 🙌 Support my FREE Courses 👉🏼 https://lukeb.co/courses 𝗥𝗲𝗳𝗲𝗿𝗲𝗻𝗰𝗲𝘀 𝗶𝗻 𝗩𝗶𝗱𝗲𝗼 ▔▔▔▔▔▔▔▔▔ 📲 My app - datanerd.tech 👉 https://datanerd.tech 📈 Future of Jobs Report 2025 👉https://reports.weforum.org/docs/WEF_Future_of_Jobs_Report_2025.pdf 💻 StackOverflow Developer Survey 👉 https://survey.stackoverflow.co/2024/ 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔▔ 📜 Google Data Analytics Certificate 👉🏼 https://lukeb.co/GoogleCert ➕ Coursera Plus Subscription (7-day free trial) 👉🏼 https://lukeb.co/CourseraPlus 📚 Book Recommendations 👉🏼 https://lukeb.co/recommendations 🪟 Windows Virtual Machine for Mac (Parallels) 👉🏼 https://lukeb.co/ParallelsFreeTrial 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫 Newsletter: https://www.lukebarousse.com/ 👨🏼‍💼 LinkedIn: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse 𝗧𝗶𝗺𝗲𝘀𝘁𝗮𝗺𝗽𝘀 ▔▔▔▔▔▔ 00:00 - Intro 01:15 - What Are Top Skills? 02:49 - About Top Skills 02:57 - Databases - SQL 03:33 - Spreadsheet - Excel 04:13 - BI - Power BI & Tableau 04:38 - Programming - Python & R 05:06 - My Roadmap 07:03 - How to Learn? 08:53 - How to Learn Faster? As an Amazon, Coursera, and Parallels Affiliate Program member, I earn a commission from qualifying purchases on the links above. This does not cost you anything but helps support making more content. #datanerd #dataanalyst #dataanalytics

Google Data Analytics Certificate 👉🏼 https://lukeb.co/GoogleCert Google Career Certificates 👉🏼 https://lukeb.co/GoogleCerts 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔▔ 🗣️ Google Prompting Essentials 👉🏼 https://lukeb.co/GooglePrompt 📈 PowerBI for Data Viz 👉🏼 https://lukeb.co/powerbi-cert 📊 Tableau for Data Viz 👉🏼 https://lukeb.co/Tableau_UCDavis 🐍 Python for Everybody 👉🏼 https://lukeb.co/PythonForEverybody 💿 SQL for Data Science 👉🏼 https://lukeb.co/SQLdataScience 🧾 Excel Skills for Business 👉🏼 https://lukeb.co/ExcelBusinessAnalyst 🏴‍☠️ Data Science: Foundations using R 👉🏼 https://lukeb.co/RforDataScienceJH 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫Newsletter: https://www.lukebarousse.com/ 👨🏼‍💼 LinkedIn: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse 00:00 What is Copilot in Excel? 01:16 Copilot's Biggest Flaw - Data Cleaning 04:09 Copilot's Strength - Text Analysis 06:04 Copilot's Secret Weapon - Python in Excel 07:41 Data Cleaning - 2nd Attempt - Small Dataset 08:57 Data Cleaning - 3rd Attempt - Larger Dataset 10:16 Final Conclusion As a Coursera Program member, I earn a commission from qualifying purchases on the links above. This does not cost you anything but helps support making more content. #datanerd #dataanalyst #dataanalytics

Coursera Plus 👉🏼 https://lukeb.co/CourseraPlus (40% Off Expired Dec. 12th) Cheat Sheet & Newsletter Sign-up 👉🏼 https://lukeb.co/newsletter Data Jobs File 👉🏼 https://lukeb.co/jobs_file 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔▔ 📜 Google Data Analytics Certificate 👉🏼 https://lukeb.co/GoogleCert 🗣️ Google Prompting Essentials 👉🏼 https://lukeb.co/GooglePrompt 📈 PowerBI for Data Viz 👉🏼 https://lukeb.co/powerbi-cert 📊 Tableau for Data Viz 👉🏼 https://lukeb.co/Tableau_UCDavis 🐍 Python for Everybody 👉🏼 https://lukeb.co/PythonForEverybody 💿 SQL for Data Science 👉🏼 https://lukeb.co/SQLdataScience 🧾 Excel Skills for Business 👉🏼  https://lukeb.co/ExcelBusinessAnalyst 🏴‍☠️ Data Science: Foundations using R 👉🏼 https://lukeb.co/RforDataScienceJH 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫Newsletter: https://www.lukebarousse.com/ 👨🏼‍💼 LinkedIn: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse 00:00 Intro 04:18 Setup ChatGPT 10:04 Search the Web 12:55 Project Objectives 15:12 Import Data 19:14 Exploratory Data Analysis 22:09 Visualizations / Graphs 25:40 Median Salary Analysis 28:11 Top Skills / Data Cleaning 31:17 GPTs 34:09 Canvas / Final Report As a Coursera Program member, I earn a commission from qualifying purchases on the links above. This does not cost you anything but helps support making more content. #datanerd #dataanalyst #dataanalytics

Get started with Notion for FREE, and unlock Notion AI for $10/month 👉 https://ntn.so/lukebarousse Notion Cheat Sheet 👉 https://lukebarousse.notion.site/notion-cheat-sheet Notion Template 👉 https://lukebarousse.notion.site/notion-template 𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀 ▔▔▔▔▔▔▔▔▔▔▔▔ 💽 SQL for Data Analytics 👉🏼 https://youtu.be/7mz73uXD9DA ❎ 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 🙌 Support my FREE Courses 👉🏼 https://lukeb.co/courses 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫Newsletter: https://www.lukebarousse.com/ 👨🏼‍💼 LinkedIn: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse 00:00 Intro 03:38 Notion 101 06:18 Pages 101 11:05 Notion AI 17:04 Databases 101 29:13 Sharing 101 As an Amazon, Coursera, and Parallels Affiliate Program member, I earn a commission from qualifying purchases on the links above. This does not cost you anything but helps support making more content. #datanerd #dataanalyst #dataanalytics

📁 FREE Course Files & Projects 👉 https://lukeb.co/excel_files 🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/excel ⚠️ Use "Download Zip" to get all GitHub files (downloading individually corrupts files) Still having issues downloading the Course Files & Projects? Try Google Drive instead 👉 https://lukeb.co/excel_files_alternate My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse 𝗖𝗼𝘂𝗿𝘀𝗲 𝗢𝘂𝘁𝗹𝗶𝗻𝗲 ▔▔▔▔▔▔▔ 👋 Intro 0:00:00 - Welcome 0:03:53 - What is Excel? 0:07:19 - About Course 0️⃣ Excel Setup 0:11:19 - Excel Install 1️⃣ Spreadsheets Intro 0:22:42 - Worksheets 0:39:15 - Workbooks 0:52:06 - Ribbon 2️⃣ Formulas & Functions 1:06:39 - Formulas Intro 1:18:08 - Function Intro 1:29:14 - Logical Functions 1:39:54 - Math Functions 1:49:46 - Statistical Functions 2:01:14 - Array Formulas 2:21:28 - Lookup Function 2:39:25 - Text Functions 2:53:19 - Date and Time Functions 3️⃣ Charts 3:01:33 - Charts Intro 3:22:05 - Charts Advanced 3:35:37 - Charts Statistics 3:47:59 - Sparklines 4️⃣ Spreadsheet Advanced 3:51:57 - Tables 4:09:28 - Formatting 4:26:00 - Collaboration 📊 Project #1 - Salary Dashboard 4:40:30 - Project #1: Build Dashboard 5:26:43 - Project #1: Share Projects 5️⃣ PivotTables 5:33:46 - PivotTable Intro 5:54:53 - PivotTable Advanced 6:09:33 - PivotCharts 6️⃣ Advanced Data Analysis 6:19:43 - Analysis Add-ins 6:39:00 - Data Tables 6:48:06 - Analysis ToolPak 7️⃣ Power Query 7:03:04 - Power Query Intro 7:23:26 - Power Query Editor 7:53:13 - Advanced Transformations 8:14:58 - Append vs Merge 8:39:13 - M Language 8️⃣ Power Pivot / DAX 9:03:11 - Power Pivot Intro 9:29:01 - Power Pivot Window 9:48:18 - DAX Intro 10:09:34 - DAX Advanced 📈 Project #2 - Salary Analysis 10:27:40 - Project #2: Share w/ Git & GitHub 10:45:13 - Project #2: Document w/ README.md 𝗟𝗶𝗻𝗸𝘀 𝗠𝗲𝗻𝘁𝗶𝗼𝗻𝗲𝗱 (𝗯𝘆 𝗖𝗵𝗮𝗽𝘁𝗲𝗿) ▔▔▔▔▔▔▔▔▔▔▔▔▔▔ 👋 Intro Kelly’s LinkedIn: https://www.linkedin.com/in/kellyjianadams/ Kelly’s Website: https://www.kellyjadams.com 0️⃣ Excel Setup Run Windows on a Mac (Virtual Machine) - https://lukeb.co/parallels Microsoft 365 (Recommended) - https://www.microsoft.com/en-us/microsoft-365 Office Home & Student 2024 - https://www.microsoft.com/en-us/microsoft-365/p/office-home-2024/cfq7ttc0pqvj 📊 Project #1 - Salary Dashboard One Drive Folder - https://onedrive.live.com Project #1: Excel Online Version - https://lukeb.co/excel_dashboard 7️⃣ Power Query What is Power Query? - https://learn.microsoft.com/en-us/power-query/power-query-what-is-power-query Wikipedia Table S&P 500 - https://en.wikipedia.org/wiki/List_of_S&P_500_companies 8️⃣ Power Pivot / DAX Merges (SQL Joins) - https://lukeb.co/sql_joins DAX Guide - https://learn.microsoft.com/en-us/dax/ 📈 Project #2 - Salary Analysis Git Download - https://git-scm.com/downloads GitHub Sign-up - https://github.com/signup GitHub Desktop - https://desktop.github.com/download/ Markdown Cheatsheet - https://markdownguide.org/cheat-sheet/ 📚 Recommended Books & Courses SQL for Data Analytics - https://youtu.be/7mz73uXD9DA The Excel 365 Bible - https://geni.us/excel_bible M is for (Data) Monkey (renamed: Master Your Data) - https://geni.us/power_query 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫Newsletter: https://www.lukebarousse.com/ 👨🏼‍💼 Linkedin: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse As an Amazon, Coursera, and Parallels Affiliate Programs member, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation. #datanerd #dataanalyst #datascience

📁 FREE Course Files & Project 👉 https://lukeb.co/python_repo 🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/python My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse 📌💬 See pinned comment for troubleshooting tips. 𝗖𝗵 0️⃣ - 𝗜𝗻𝘁𝗿𝗼 ▔▔▔▔▔ 0:00:00 - Welcome 0:03:12 - What is Python? 0:04:51 - Intro to Course 𝗖𝗵 1️⃣ - 𝗕𝗮𝘀𝗶𝗰𝘀 ▔▔▔▔▔▔ 0:08:42 - Getting Started 0:18:52 - Variables 0:24:25 - Python Terms 0:38:06 - Data Types 0:48:41 - Strings 1:02:04 - ChatBot Help 1:05:06 - String Formatting 1:15:10 - Operators Part 1 1:26:20 - Conditional Statements 1:34:24 - Lists 1:49:42 - Dictionaries 1:59:54 - Sets 2:05:15 - Tuples 2:12:26 - Operators Part 2 2:21:06 - Loops 2:36:31 - List Comprehensions 2:44:16 - Exercise: Basics 2:52:12 - Functions 3:02:03 - Lambda 3:12:46 - Modules 3:28:16 - Exercise: Python Library 3:40:05 - Library 3:52:33 - Classes 4:10:44 - NumPy: Intro 4:22:56 - Pandas: Intro 4:33:09 - Pandas: Inspection 4:47:20 - Pandas: Cleaning 4:58:46 - Pandas: Analysis 5:08:26 - Exercise: Pandas Basics 5:17:19 - Matplotlib: Intro 5:21:23 - Matplotlib: Plotting 5:34:41 - Matplotlib: Labeling 5:40:34 - Matplotlib: Pandas Plotting 5:46:00 - Exercise: Matplotlib Basics 𝗖𝗵 2️⃣ - 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 ▔▔▔▔▔▔▔▔ 5:50:56 - Python Install (Anaconda) 6:00:34 - VS Code Install 6:10:49 - Virtual Environments (See Pinned Comment) 6:27:15 - Pandas: Accessing Data 6:35:38 - Pandas: Data Cleaning 6:42:54 - Pandas: Data Management 6:49:35 - Pandas: Pivot Tables 6:57:00 - Pandas: Index Management 7:04:50 - Exercise: Job Demand 7:15:37 - Pandas: Merge DataFrames 7:25:53 - Pandas: Concat DataFrames 7:34:31 - Pandas: Exporting Data 7:40:56 - Pandas: Applying Functions 7:56:39 - Pandas: Explode 8:08:27 - Exercise: Trending Skills 8:17:21 - Matplotlib: Format Charts 8:30:06 - Matplotlib: Pie Plots 8:40:04 - Matplotlib: Scatter Plots 8:50:35 - Matplotlib: Advanced Customization 9:06:00 - Matplotlib: Histograms 9:10:36 - Matplotlib: Box Plots 9:22:01 - Exercise: Skill Pay Analysis 9:31:39 - Seaborn: Intro 𝗖𝗵 3️⃣ - 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 ▔▔▔▔▔▔ 9:45:40 - Project: Intro 9:56:23 - Git & GitHub Setup 10:09:50 - Skill Demand 10:29:33 - Skills Trend 10:42:30 - Salary Analysis 10:50:57 - Optimal Skills 11:03:22 - Share on GitHub 11:06:04 - Share on LinkedIn 🔗 𝗟𝗶𝗻𝗸𝘀 𝗠𝗲𝗻𝘁𝗶𝗼𝗻𝗲𝗱 ▔▔▔▔▔▔▔▔▔ 1️⃣ 𝗕𝗮𝘀𝗶𝗰𝘀 𝗟𝗶𝗻𝗸𝘀 - Dataset (Hugging Face) - https://huggingface.co/datasets/lukebarousse/data_jobs - Functions Python Docs - https://docs.python.org/3/library/functions.html - Python Standard Library - https://docs.python.org/3/library/index.html - DateTime Docs - https://docs.python.org/3/library/datetime.html - AST Docs - https://docs.python.org/3/library/ast.html - Format String Literals - https://docs.python.org/3/reference/lexical_analysis.html#formatted-string-literals - Pandas Docs - https://pandas.pydata.org/pandas-docs/stable/reference/index.html - Matplotlib Docs - http://matplotlib.org/ - Matplotlib CheatSheet - https://matplotlib.org/cheatsheets/ 2️⃣ 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗟𝗶𝗻𝗸𝘀 - VS Code Install - https://code.visualstudio.com/download - Anaconda Install - https://anaconda.com/download/success - Anaconda Docs - https://docs.conda.io - Software Jobs CSV - https://lukeb.co/software_csv - Joins Explained (SQL for Data Analytics) - https://lukeb.co/sql_joins - Pandas Cheat Sheet - https://pandas.pydata.org/Pandas_Cheat_Sheet.pdf - Seaborn Docs - https://seaborn.pydata.org/ 3️⃣ 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗟𝗶𝗻𝗸𝘀 - Git Download - https://git-scm.com/downloads - GitHub Signup - http://github.com/signup - Markdown CheatSheet - https://www.markdownguide.org/cheat-sheet/ 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫Newsletter: https://www.lukebarousse.com/ 👨🏼‍💼 Linkedin: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse Connect with Kelly Adams, the course producer: 👩🏻‍💼 Kelly’s LinkedIn: https://www.linkedin.com/in/kellyjianadams 🌐 Kelly’s Website: https://www.kellyjadams.com As an Amazon, Coursera, and Parallels Affiliate Programs member, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation. #datanerd #dataanalyst #datascience

My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse SQL Course 👉 https://youtu.be/7mz73uXD9DA Courses for Data Nerds ================================== 📜 Google Data Analytics Certificate 👉🏼 https://lukeb.co/GoogleCert 🐍 Python for Everybody 👉🏼 https://lukeb.co/PythonForEverybody 💿 SQL for Data Science 👉🏼 https://lukeb.co/SQLdataScience 🧾 Excel Skills for Business 👉🏼  https://lukeb.co/ExcelBusinessAnalyst 📈 PowerBI for Data Viz 👉🏼 https://lukeb.co/powerbi-cert 📊 Tableau for Data Viz 👉🏼 https://lukeb.co/Tableau_UCDavis 🏴‍☠️ Data Science: Foundations using R 👉🏼 https://lukeb.co/RforDataScienceJH ➕ Coursera Plus Subscription (7-day free trial) 👉🏼 https://lukeb.co/CourseraPlus 🙋🏼‍♂️ My Courses 👉🏼 https://lukeb.co/courses Books for Data Nerds ================================== 📚 Book Recommendations 👉🏼 https://lukeb.co/recommendations 📗 Data Analyst Must Read 👉🏼 https://geni.us/StorytellingWithData Tech for Data Nerds ================================== ⚙️ Tech Recommendations 👉🏼 https://lukeb.co/recommendations 🪟Windows Virtual Machine for Mac (Parallels) 👉🏼 https://lukeb.co/ParallelsFreeTrial Social Media / Contact Me ====================== 📫Newsletter: https://www.lukebarousse.com/ 👨🏼‍💼 Linkedin: https://www.linkedin.com/in/luke-b/ 🅧 X/Twitter: https://twitter.com/LukeBarousse 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse As an Amazon, Coursera, and Parallels Affiliate Programs member, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation. #datanerd #dataanalyst #datascience