Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)
via freeCodeCamp
Overview
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