Data Analyst Bootcamp

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.

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!!)