Overview

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