Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Data Analyst Bootcamp

Alex the Analyst via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Embark on a comprehensive 20-hour Data Analyst Bootcamp designed to equip you with essential skills in SQL, Excel, Tableau, Power BI, and Python. Begin with SQL basics, progressing through intermediate and advanced concepts, including joins, case statements, and stored procedures. Dive into Excel tutorials covering pivot tables, formulas, XLOOKUP, and data cleaning techniques. Explore Tableau and Power BI for data visualization, learning to create impactful charts and manage relationships. Delve into Python programming fundamentals, web scraping, and data analysis using pandas. Complete hands-on projects to build a robust data analyst portfolio, including SQL data exploration, web scraping, and API integration. Conclude with guidance on creating a standout resume, leveraging LinkedIn for job opportunities, and establishing a professional online presence through a portfolio website.

Syllabus

FREE Data Analyst Bootcamp!!
How to Become a Data Analyst in 2023 (Completely FREE!)
SQL Basics Tutorial For Beginners | Installing SQL Server Management Studio and Create Tables | 1/4
SQL Basics Tutorial For Beginners | Select + From Statements | 2/4
SQL Basics Tutorial For Beginners | Where Statement | 3/4
SQL Basics Tutorial For Beginners | Group By + Order By Statements | 4/4
Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases
Intermediate SQL Tutorial | Unions | Union Operator
Intermediate SQL Tutorial | Case Statement | Use Cases
Intermediate SQL Tutorial | Having Clause
Intermediate SQL Tutorial | Updating/Deleting Data
Intermediate SQL Tutorial | Aliasing
Intermediate SQL Tutorial | Partition By
Advanced SQL Tutorial | CTE (Common Table Expression)
Advanced SQL Tutorial | Temp Tables
Advanced SQL Tutorial | String Functions + Use Cases
Advanced SQL Tutorial | Stored Procedures + Use Cases
Advanced SQL Tutorial | Subqueries
Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4
Data Analyst Portfolio Project | Data Cleaning in SQL | Project 3/4
Pivot Tables in Excel | Excel Tutorials for Beginners
Formulas in Excel | Excel Tutorials for Beginners
XLOOKUP in Excel | Excel Tutorials for Beginners
Conditional Formatting in Excel | Excel Tutorials for Beginners
Charts in Excel | Excel Tutorials for Beginners
Cleaning Data in Excel | Excel Tutorials for Beginners
Full Project in Excel | Excel Tutorials for Beginners
How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners
How to use Calculated Fields and Bins in Tableau | Tableau Tutorials for Beginners
How to Create Visualizations in Tableau | Tableau Tutorials for Beginners
How to use Joins in Tableau | Tableau Tutorials for Beginners
Full Beginner Project in Tableau | Tableau Tutorials for Beginners
How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners
How to use Power Query in Power BI | Microsoft Power BI for Beginners
How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners
How to use DAX in Power BI | Microsoft Power BI for Beginners
How to use Drill Down in Power BI | Microsoft Power BI for Beginners
How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners
How to use Bins and Lists in Power BI | Microsoft Power BI for Beginners
Popular Visualizations in Power BI | Microsoft Power BI for Beginners
Full Power BI Guided Project | Microsoft Power BI for Beginners
Installing Jupyter Notebooks/Anaconda | Python for Beginners
Variables in Python | Python for Beginners
Data Types in Python | Python for Beginners
Comparison, Logical, and Membership Operators in Python | Python for Beginners
If Else Statements in Python | Python for Beginners
For Loops in Python | Python for Beginners
While Loops in Python | Python for Beginners
Functions in Python | Python for Beginners
Converting Data Types in Python | Python for Beginners
Building a BMI Calculator with Python | Python Projects for Beginners
Building an Automated File Sorter in File Explorer using Python | Python Projects for Beginners
Inspecting Web Pages with HTML | Web Scraping in Python
BeautifulSoup + Requests | Web Scraping in Python
Find and Find_All | Web Scraping in Python
Scraping Data from a Real Website | Web Scraping in Python
Reading in Files in Pandas | Python Pandas Tutorials
Filtering Columns and Rows in Pandas | Python Pandas Tutorials
Indexes in Pandas | Python Pandas Tutorials
Group By and Aggregate Functions in Pandas | Python Pandas Tutorials
Merging DataFrames in Pandas | Python Pandas Tutorials
Creating Visualizations using Pandas Library | Python Pandas Tutorials
Data Cleaning in Pandas | Python Pandas Tutorials
Exploratory Data Analysis in Pandas | Python Pandas Tutorials
Amazon Web Scraping Using Python | Data Analyst Portfolio Project
Automating Crypto Website API Pull Using Python | Data Analyst Project
How to Create a Portfolio Website for FREE
Create the Perfect Data Analyst Resume | Free Templates!
Top 3 Tips on Using LinkedIn to Land a Job
How To Download Your Data Analyst Bootcamp Certification (Congrats!!)

Taught by

Alex the Analyst

Reviews

4.3 rating, based on 6 Class Central reviews

Start your review of Data Analyst Bootcamp

  • Profile image for Abdul Rafy Khan
    Abdul Rafy Khan
    The Data Analyst Boot Camp exceeded my expectations. The curriculum was comprehensive, covering a wide range of analytical techniques and tools. The hands-on projects were particularly valuable, as they provided practical experience in real-world scenarios. The instructors were knowledgeable and supportive, always ready to assist. The collaborative learning environment and peer interaction added immense value to the program. Overall, the Boot Camp was a great investment for anyone looking to kickstart their career in data analysis.
  • Profile image for Mohamed Mostafa
    Mohamed Mostafa
    Very good explanation and I benefited from the lecturers
    I learned the field better. I hope to find a job in that field in the future
  • Michael L Kreischer
    Great information. Very hard to find the certificate after the course !!
    ..................................................................................................................
  • Profile image for MUHAMMAD ALEEM SHAIKH
    MUHAMMAD ALEEM SHAIKH
    Alex the Analyst's Data Analyst Bootcamp on YouTube is a comprehensive and insightful resource for anyone diving into the world of data analysis. The content is well-structured, easy to follow, and covers essential concepts in a beginner-friendly manner. Alex's teaching style is engaging, making complex topics more understandable. The practical examples and hands-on exercises are particularly helpful for gaining real-world skills. Overall, it's a fantastic resource for aspiring data analysts looking to build a strong foundation in the field.
  • Profile image for Victoria San Agustin
    Victoria San Agustin
    Great Bootcamp! I learnt so much in such a short time. I did notice that because its quite a few years old, some of the code or functions is outdated, so an updated one would be awesome.
  • Profile image for Jean
    Jean
    I have zero experience in data analyst but i really want to learn it, i found alex's channel and start doing the courses. never regret it

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.