Course: Data Analyst Bootcamp by Alex The Analyst
Daily Time: 1.5 Hours
Phase 1: SQL & Excel Foundations (Days 1-10)
| Day | Video | Focus | Videos / Topics to Cover |
|---|---|---|---|
| 1-6 | 1-16 | SQL Skills | Videos on SQL Installation, Queries, Joins, and Functions |
| 7 | 17 | SQL Project 1 | SQL Data Exploration Project |
| 8 | 18 | SQL Project 2 | Data Cleaning in SQL Project |
| 9-10 | 19-24 | Excel Skills | Videos on Pivot Tables, Formulas, Charts, and Data Cleaning |
Phase 2: Visualization with Tableau & Power BI (Days 11-17)
| Day | Video | Focus | Videos / Topics to Cover |
|---|---|---|---|
| 11-13 | 25-28 | Tableau Skills | Videos on Tableau Fundamentals and a Full Beginner Project |
| 14-17 | 29-36 | Power BI Skills | Videos on Power BI Fundamentals, DAX, and Visualizations |
Phase 3: Python for Data Analysis (Days 18-26)
| Day | Video | Focus | Videos / Topics to Cover |
|---|---|---|---|
| 18-21 | 37-43 | Python Logic | Videos on Python Fundamentals and Small Projects |
| 22-23 | 44-47 | Web Scraping | Videos on BeautifulSoup and Scraping a Real Website |
| 24-26 | 48-52 | Pandas Skills | Videos on Pandas for Data Manipulation and Merging |
Phase 4: Advanced Project - Python Web Scraping & Analysis (Days 27-31)
| Day | Video | Focus | Videos / Topics to Cover |
|---|---|---|---|
| 27 | 53-54 | Project Setup | - Create Project in PyCharm & Scrape Multiple Pages |
| 28 | 55-56 | Data Cleaning | - Clean Data from Scraped Website & Handle Missing Data |
| 29 | 57-58 | Automation | - Automate File Appending & Use Try/Except |
| 30 | 59-60 | Finalizing | - Final Script Overview & Running the File |
| 31 | 61 | Project Review | - Full Python Project for your Portfolio |
Phase 5: Advanced Project - Tableau Visualization (Days 32-34)
| Day | Video | Focus | Videos / Topics to Cover |
|---|---|---|---|
| 32 | 62-64 | Data & Dashboard | - Get Data for Project, Create Calculated Fields & Dashboard |
| 33 | 65-67 | Advanced Viz | - Create Bar, Scatter, and Box Plots |
| 34 | 68-69 | Final Touches | - Create Map and Finalize Dashboard |
Phase 6: Career Preparation & Portfolio (Days 35-40)
| Day | Video | Focus | Videos / Topics to Cover |
|---|---|---|---|
| 35 | 70-72 | Portfolio Build | - Create a Portfolio Website from Scratch (No Code) |
| 36 | 73-75 | Resume Writing | - How to Write a Data Analyst Resume (with template) |
| 37 | 76-78 | Job Searching | - How to Land a Data Analyst Job & Where to Apply |
| 38 | 79-81 | Interview Prep | - Data Analyst Interview Questions (Behavioral & Technical) |
| 39 | 82-83 | Salary & Beyond | - Salary Negotiation & What to do After Getting a Job |
| 40 | 84 | Final Advice | - Things I Wish I Knew Before Becoming a Data Analyst |
FreeCodeCamp Free Certification : Data Analysis with Python Course
Happy Coding!
Top comments (0)