See Full Course Curriculum (All 200+ Lessons)

Module 1: Data Career Fundamentals + The LinkedIn Profile Mastery

Welcome To The Program

• Welcome to the Course
• What You'll Do In Module 1
• 👋 Hi, I'm Avery | Introduce Yourself
• 💪 Take Action
• Download The Course App
• Community / Coaching (Heartbeat) 💚
• Live Calls ☎️
• Knowledge Checks
• 📆 Bi-Weekly Check In
• How To Use The Search Bar Inside The Course
• 🎓 Graduation Event
• Podcast - Episode 1
• [Live Replay] Welcome Feast
• ❓ FAQ's
• ⛔ How NOT to Succeed
• 🆘 Need Help? Here's What To Do!
• 📆 Course Calendar
• 📞 Schedule Your Roadmap Call w/ Avery
• 📞 Need Extra 1:1 Calls?

Data Career Fundamentals

• 5 Reasons You Should Have a Data Career
• How I Broke Into Data Science | My Story
• Data Careers
• Cheating The System
• Your Path to a Data Career
• Your Pivot Starts Today
• Internal vs External Transfers
• Setting Goals & Expectations
• 🚀 Career Transition Use Cases

The LinkedIn Profile Mastery

• Update Your LinkedIn Profile Picture
• Update Your LinkedIn Headline
• Update Your LinkedIn Cover Photo
• Add Data Career Jumpstart to LinkedIn Education
• About Section on LinkedIn
• 🔔 The LinkedIn Notification Bell
• Saving Posts On LinkedIn
• Turn On LinkedIn Creator Mode
• Update Your LinkedIn Settings

Knowledge Check

• End of Week 1: Knowledge Check

Module 2: Data Analysis w/ Excel + Data Projects 101 + The Online Networking Blueprint

• Intro To Module 2
• Member Only Podcast - Episode 2

Data Fundamentals

• Circle of Data
• Data Vocabulary
• Cleaning Data
• What To Do When You Get Stuck Doing Data Analytics

🍔 The DoorDash Project (Data Analysis w/ Excel)

• Why Excel?
• 🚨 Excel Warning (Versions)
• The Excel Skill Checklist
• DoorDash Case Study
• Intro To The DoorDash Data
• Add New Column
• Data Filtering
• Data Sorting
• Data Aggregation (Min, Max, Count, Average, Sum)
• General Formulas
• Scatter Plots In Excel
• Histogram in Excel
• Advanced Formula: If Statements
• Advanced Formulas: Month & Bar Chart
• Pivot Table
• VLOOKUP
• Supplemental Excel Resources

Intro to Data Projects

• Learn About Projects
• Best Data Project + Ask Avery Episode (Podcast Episodes)
• Project Write Up Guide
• How To Post a Project (LinkedIn Article)
• Write Your Project from Last Module
• 3 Different Types of Projects
• Demo Of How I'd Write Up The Excel Project
• Featured Section of LinkedIn

The Online Networking Blueprint

• Commenting on LinkedIn
• Posting on LinkedIn
• 8 Prompts for LinkedIn Posts
• Scared of Posting on LinkedIn? Do this.
• LinkedIn Posting Masterclass
• Commenting on LinkedIn Masterclass
• Scheduling Posts on LinkedIn
• Networking Masterclass from Albert Bellamy

Knowledge Check

• End of Week 2: Knowledge Check

Module 3: Data Viz in Tableau (Beginner) + Resume Mastery

• Podcast - Episode 3
• Live Module 3 Session

Data Viz 101

• Why Data Viz? 📊
• Data Viz: Preattentive Attributes
• An Intro to Dashboards
• Boring PowerPoints or Data Storytelling?
• Supplemental Data Viz / Tableau Resources
• PODCAST: How To Create Stunning Data Visualizations - Interview with Roshaan Kahn

🏫 The Education Project (Data Visualization with Tableau)

• Massachusetts School Project
• The Tableau Checklist
• Downloading Tableau Public
• Tableau Interface Overview
• Connecting Data to Tableau Public
• Bar Chart In Tableau
• Scatter Plot
• Line Charts
• BAN / KPI / Metric
• Combining in Dashboard

Resume Mastery

• How A Creative Resume Landed Emily Vu a Dream Job
• Add SQL Project 1 To Your Portfolio
• Update Your Resume
• My Resume Template
• Creative Resumes
• More Simple Resume Template
• Resume Review Session

Knowledge Check

• End of Week 3: Knowledge Check

Module 4: Data Analysis w/ SQL (Beginner) + Building GitHub Pages Portfolio

• Podcast - Episode 4

SQL 101

• SQL Write Up Tips (Carbon.now.sh)
• SQL Cheatsheet 1
• When Would You Use SQL?
• What is a Database?
• Database Jargon

💵 The Finance Project (SQL - Beginner)

• SQL Banking Project
• Getting Started with CSVFiddle.io (SQL Editor)
• SELECT * FROM table;
• Spacing, CAPITALIZATION, & ; in SQL
• LIMIT
• Alias (AS)
• WHERE
• Financial Data Analyst
• COUNT
• GROUP BY
• MIN / MAX
• SUM
• AVG
• ORDER BY
• AND / OR / NOT
• Project Summary

Creating a GitHub Pages Portfolio

• 🎧 Building Fun Data Projects [Podcast Episode]
• Learn About Portfolios
• The One Click Portfolio
• Add Module 1 Project To Portfolio (as a link)
• Add Module 2 Project To Portfolio (internally)
• Share Your Portfolio on LinkedIn
• GitHub Pages Live Session
• Reviewing Students' Projects

Knowledge Check

• End of Week 4: Knowledge Check

Module 5: Data Analysis w/ SQL (Intermediate) + Cold Message Secrets

• Podcast - Episode 5

🏥 The Healthcare Project (SQL - Intermediate)

• Healthcare Data Analyst
• SQL Cheatsheet 2
• SQL Healthcare Project
• What is MySQL /Installation / Demo / Tour
• MySQL Errors
• MySQL Data Files
• Getting Started With This Project
• HISTOGRAMS
• HAVING & DISTINCT
• JOIN
• CASE WHEN
• UNION
• Subqueries + WITH (CTE's)
• CONCAT
• Ranking

Cold Messaging Secrets + The Hidden Job Market

• Find Jobs Where You Can Talk To A Human (LinkedIn Posts)
• Cold Messages (Live Call)
• My Cold Message Examples
• Writing Cold Message Examples
• Cold Message Scripts
• Live Call - Networking + LinkedIn Hidden Job Market
• Coffee Chats

Knowledge Check

• End of Week 5: Knowledge Check

Module 6: Data Viz in Tableau (Intermediate) + Ace The Data Interview

• Podcast - Episode 6
• Post Your Previous Project

Data Visualization Drill Down

• How To Present Data
• The Best Data Visualization Ever?
• The Power of Animated Data Viz + Storytelling
• I Studied 365 Data Visualizations in 2020

🏀 The Sports Project (Data Visualization w/ Tableau II)

• Sports Case Study - Basketball
• Sports Data Analyst
• 💩 Dirty Data Warning
• Heatmap / Highlight Table
• Bubble Plot
• Stacked Bar Chart
• Treemap
• Putting it all together; Stories

Ace The Data Interview

• Mock Interview Practice
• Mock Interview Questions
• Tesla Tableau Question (Mock Interview Tuesday)
• NASA Data Analyst Experience (Mock Interview Tuesday)

Job-Hunting Strategies

• Looking for jobs...
• My Connections + Leads
• Volunteering for Jobs
• Good Questions to Ask in Interview
• Best Places to Look For Jobs
• Interviews
• Start Thinking About What Job You Want
• Job Scams To Look Out For

Knowledge Check

• End of Week 6: Knowledge Check

Module 7: Python + 🏭 The Engineering Project

• Podcast Episode 7

Python 101

• Python Cheatsheet
• Python Project - Manufacturing
• Manufacturing Data Analyst
• 🐍 What is Python?
• A Note On Programming
• Getting Access to Python (Deepnote)
• Basic Python Operations
• Python Packages 101
• What is a Variable?
• What is a Function?
• What are Loops? ♼

Hands-On Python

• Starting Your Project (With DeepNote)
• My Deepnote Notebook
• Libraires in Deepnote (Pandas, Seaborn, Matplotlib)
• Pandas - Read CSV & Head
• How Many Rows & Columns (df.shape)
• Indexing Dataframe (Rows & Columns)
• Working with Dates
• Descriptive Analytics
• Focusing In On Our Data (Masking)
• Pair Plot (Multiple Scatters) & Correlation
• Line Charts
• Making This Project Your Own

Knowledge Check

• End of Week 7: Knowledge Check

Module 8: Stats + R + 👔 The HR Analytics Project

• Podcast Episode 8

Hands-On R & Statistics

• Stats / R Project - HR Analytics
• Downloading R + R Studio
• Getting Starting With The Data In R + Studio
• Correlation Matrix
• Scatterplots in R
• HR Data Analyst
• Hypothesis Testing, p-values, Statistical Significance
• Linear Regression

Knowledge Check

• End of Week 8: Knowledge Check

Module 9: 🚀 The Quick Projects (Power BI, SAS, BigQuery)

• Welcome To Module 9
• Capstone Project Coming Up

Power BI

• Power BI
• The Supply Chain Project (Power BI)
• Live Power BI Intro
• Marketing Giveaway Dashboard (Power BI Demo)

BigQuery

• BigQuery

Pipelines

• ETL / Data Pipelines

SAS

• SAS

Flourish

• Flourish
• Bitcon vs COVID (Flourish Project)

Knowledge Check

• End of Week 9: Knowledge Check

Module 10: ⭐ The Capstone Project

• Graduation Application

Capstone Project

• Choose a Capstone Project
• Publish Your Capstone Project
• Summary of Capstone Final

Job Landing

• Landing a Job Checklist

Knowledge Check

• End of Week 10: Knowledge Check

BONUS

• New Community Heartbeat Tour

Guest Live Lectures

• How To Find Transferrable Skills with Chris French
• From Teacher to Business Analyst with Beth Pearson (How to Bear imposter Syndrome)
• Tiffany Teasley Live

Project Mastery

• Data Project Write Up Explained
• Project Get You Hired
• Project Get You Hired

Job Hunting

• Specific Job Hunting Tips

Linkedin

• How To Create Good Posts For LinkedIn

Showcases & Graduation

• 🏆 DAA Showcase
• Presenting Data (Showcase Prep)
• Graduation 1Q23