Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)

via freeCodeCamp

Start learning Write review

Embark on a comprehensive data analyst bootcamp designed for beginners, covering essential tools and skills including SQL, Tableau, Power BI, Python, Excel, and Pandas. Learn through hands-on projects and practical applications, starting with SQL basics and progressing to advanced techniques. Master Excel functionalities, from pivot tables to data cleaning. Explore data visualization with Tableau and Power BI, creating impactful dashboards and reports. Dive into Python programming, covering fundamentals, web scraping, and data analysis with Pandas. Build a portfolio with real-world projects, including SQL data exploration, web scraping, and API integration. Conclude with career-focused guidance on creating a standout resume, leveraging LinkedIn, and developing a portfolio website. Access provided datasets and resources to enhance your learning experience and kickstart your data analyst career.

Syllabus

Introduction
How to Become a Data Analyst in 2023 Completely FREE!
SQL Basics Tutorial | Installing SQL Server Management Studio and Create Tables
SQL Basics Tutorial | Select + From Statements
SQL Basics Tutorial | Where Statement
SQL Basics Tutorial | Group By + Order By Statements
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
Data Analyst Portfolio Project | Data Cleaning in SQL
Pivot Tables in Excel | Excel Tutorial
Formulas in Excel | Excel Tutorial
XLOOKUP in Excel | Excel Tutorial
Conditional Formatting in Excel | Excel Tutorial
Charts in Excel | Excel Tutorial
Cleaning Data in Excel | Excel Tutorial
Full Project in Excel | Excel Tutorial
How to Install Tableau and Create First Visualization | Tableau Tutorial
How to use Calculated Fields and Bins in Tableau | Tableau Tutorial
How to Create Visualizations in Tableau | Tableau Tutorial
How to use Joins in Tableau | Tableau Tutorial
Full Beginner Project in Tableau | Tableau Tutorial
How to Install Power BI | Building First Visualization | Microsoft Power BI
How to use Power Query in Power BI | Microsoft Power BI
How to Create and Manage Relationships in Power BI | Microsoft Power BI
How to use DAX in Power BI | Microsoft Power BI
How to use Drill Down in Power BI | Microsoft Power BI
How to use Conditional Formatting in Power BI | Microsoft Power BI
How to use Bins and Lists in Power BI | Microsoft Power BI
Popular Visualizations in Power BI | Microsoft Power BI
Full Power BI Guided Project | Microsoft Power BI
Installing Jupyter Notebooks/Anaconda | Python
Variables in Python | Python
Data Types in Python | Python
Comparison, Logical, and Membership Operators in Python | Python
If Else Statements in Python | Python
For Loops in Python | Python
While Loops in Python | Python
Functions in Python | Python
Converting Data Types in Python | Python
Building a BMI Calculator with Python | Python Project
Building an Automated File Sorter in File Explorer using Python | Python Project
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
Create the Perfect Data Analyst Resume
Top 3 Tips on Using LinkedIn to Land a Job
Get Your Data Analyst Bootcamp Certification

Taught by

freeCodeCamp.org

Reviews

5.0 rating, based on 7 Class Central reviews

Start your review of Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)

Ashok

The Class Central Bootcamp was a well-structured and motivating learning experience. The weekly roadmap, curated resources, and community support made it easier to stay consistent while learning new skills. I especially liked the focus on practical projects and the guidance provided through discussions and live sessions. It’s a great program for beginners who want a structured path and accountability while learning online.
Youssef Ahmed Abourehab

ok success it is very usefull ssssssssssssssssssssssssssssssssssssss ssssssssssssssssdddddddddddddddddddddddweeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeel
eeeeeeeeeeeeeeeeeee
Anonymous

I have very good experience with Alex the analyst and they teach probably data analyst fundamentals with tools, problem solving,real work project some of the tools explain how to use and why and one of the best data analyst mentor and teachers and i appreciated it's totally good bootcamp as a data analyst
Paseka Phogole

The Data Analyst Bootcamp was an excellent learning experience that provided a strong foundation in data analytics. It covered essential tools such as Excel, SQL, Python, and Power BI, while emphasizing real-world applications and problem-solving. The hands-on projects helped reinforce key concepts in data cleaning, visualization, and statistical analysis. The instructors were knowledgeable and supportive, offering clear explanations and practical insights. Overall, it’s a well-structured program ideal for anyone looking to start or advance a career in data analytics.
Gauri Sharma

An outstanding and comprehensive course for aspiring Data Analysts!
This bootcamp covers everything a beginner needs—starting from SQL and Excel to Tableau, Power BI, Python, and Pandas. The structure is well-designed and beginner-friendly, with real-world projects that help solidify your understanding. I loved how the instructors broke down each topic in simple language, making even complex concepts easy to grasp. The best part is that it's completely free, which is incredible considering the quality and depth of content provided. Whether you're starting from scratch or refreshing your skills, this course is perfect. I'm really grateful to Class Central and freeCodeCamp for offering such valuable learning!
Lawal Muhammad Kabir

"I recently completed a data analysis course and it was a game-changer! The course covered essential tools like Excel, SQL, and Tableau, and provided hands-on experience with real-world projects. The instructor was knowledgeable and supportive, offering valuable feedback and guidance throughout the course. I gained practical skills in data visualization, statistical analysis, and data storytelling. The course boosted my confidence in working with data and opened up new career opportunities. I highly recommend this course to anyone looking to start or advance their career in data analysis." Rating: 5/5
Thanks you sir we really appreciate
Nishtha Juneja

I found it to be a highly informative and well-structured course. The content was thorough, covering all the necessary topics with clear explanations. I especially appreciated the practical examples, which helped me better understand the concepts an…

I found it to be a highly informative and well-structured course. The content was thorough, covering all the necessary topics with clear explanations. I especially appreciated the practical examples, which helped me better understand the concepts and apply them in real-world scenarios.

The instructor did an excellent job of presenting the material in an engaging and accessible manner, and the pacing was comfortable, though there were moments where some sections felt a bit rushed. The course could benefit from additional interactive exercises or quizzes to reinforce the concepts learned.

Overall, I would highly recommend this course to anyone looking to [insert learning goal] and would be interested in taking more courses from this instructor in the future.

Pros:

Comprehensive content
Clear, engaging teaching style
Useful practical examples
Cons:

Some sections felt rushed
Limited direct feedback opportunities
Would recommend!