Overview
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
-
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.
-
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 -
Great information. Very hard to find the certificate after the course !!
.................................................................................................................. -
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.
-
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.
-
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