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.
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
Related Courses
Related articles
Reviews
4.4 rating, based on 7 Class Central reviews
-
Abdul Rafy KhanThe 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. -
Mohamed MostafaVery 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 !!
.................................................................................................................. -
Victoria San AgustinGreat 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. -
MUHAMMAD ALEEM SHAIKHAlex 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. -
JeanI 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
