Data Analyst Bootcamp

Alex the Analyst via YouTube

Start learning Write review

Details

Start learning

Provider

YouTube
Pricing

Free Video
Languages

English
Duration & workload

20 hours
Sessions

On-Demand
Level

Beginner

Found in

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.4 rating, based on 14 Class Central reviews

Start your review of Data Analyst Bootcamp

Ashish Kashyap

I recently completed the Data Analyst Bootcamp by Alex The Analyst on YouTube, and I must say it’s one of the best free resources available for anyone aspiring to start a career in data analytics. The bootcamp is well-structured, beginner-friendly,…

I recently completed the Data Analyst Bootcamp by Alex The Analyst on YouTube, and I must say it’s one of the best free resources available for anyone aspiring to start a career in data analytics.

The bootcamp is well-structured, beginner-friendly, and covers all the fundamental tools and skills required for a data analyst role, including Excel, SQL, Tableau, and Python. Alex’s teaching style is clear, practical, and easy to follow, making complex concepts much more approachable. I particularly appreciated the real-world projects and hands-on exercises, which gave me the confidence to apply what I learned to actual datasets.

Another highlight is the career guidance Alex provides—tips on resumes, LinkedIn, and interview preparation—which makes this bootcamp stand out compared to other purely technical tutorials.

Overall, this bootcamp is perfect for anyone looking to transition into data analytics or strengthen their foundational skills. I would highly recommend it to students, career changers, and professionals who want to upskill.
Umar Ali

I just love the way this man teach each part when I start I don't even know the basic knowledge of data analysis now I know each and every part of it so thanks
Abdul Rafy Khan
3

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.
Nirmala Elangovan

Great course! Clear explanations and practical projects. Perfect for beginners in data analytics.Very helpful bootcamp with hands-on exercises. Alex explains every concept in a simple way.Excellent course for beginners! Covers SQL, Python, and dashboards with easy-to-follow lessons.
Bhawna Chauhan

I’m excited to share that I have successfully completed a comprehensive Data Analyst course, equipping me with the essential skills and practical experience needed to thrive in data-driven environments. Throughout the course, I gained hands-on expe…

I’m excited to share that I have successfully completed a comprehensive Data Analyst course, equipping me with the essential skills and practical experience needed to thrive in data-driven environments.

Throughout the course, I gained hands-on expertise in:

Data Analysis & Visualization using tools like Excel, SQL, Power BI, and Python (Pandas, Matplotlib, Seaborn)

Data Cleaning, Manipulation, and Exploratory Data Analysis (EDA)

Dashboard design and effective communication of insights to stakeholders

Real-world project experience that enhanced my problem-solving and analytical thinking

This journey has strengthened my confidence in working with complex datasets and extracting actionable insights. I’m now ready to apply these skills in a professional setting and contribute to data-informed decision-making.
Michael L Kreischer
2

Great information. Very hard to find the certificate after the course !!
..................................................................................................................
Victoria San Agustin
1

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.
Anour Hossain

I really enjoyed taking this course. In this course, small things have been highlighted and from here, I learned that you can make yourself a lot different. The best thing here is that the projects you are doing have been seen very clearly. Through this course, your career development will happen.
Santosh Chitakarsaka Mishra

I have completed it and I gain more knowledge about data analytics. I think that this knowledge bright my future and show my inner confidence.
ARJUN THORLIKONDA

Excellent bootcamp by Alex. The way he doing and explanation top notch and easy to learn and explanation
Dolani Otu

Great course, Alex makes Data Analytics learning easy to follow and understand.............................
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
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.
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