Completed
Introduction
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)
Automatically move to the next video in the Classroom when playback concludes
- 1 Introduction
- 2 How to Become a Data Analyst in 2023 Completely FREE!
- 3 SQL Basics Tutorial | Installing SQL Server Management Studio and Create Tables
- 4 SQL Basics Tutorial | Select + From Statements
- 5 SQL Basics Tutorial | Where Statement
- 6 SQL Basics Tutorial | Group By + Order By Statements
- 7 Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases
- 8 Intermediate SQL Tutorial | Unions | Union Operator
- 9 Intermediate SQL Tutorial | Case Statement | Use Cases
- 10 Intermediate SQL Tutorial | Having Clause
- 11 Intermediate SQL Tutorial | Updating/Deleting Data
- 12 Intermediate SQL Tutorial | Aliasing
- 13 Intermediate SQL Tutorial | Partition By
- 14 Advanced SQL Tutorial | CTE Common Table Expression
- 15 Advanced SQL Tutorial | Temp Tables
- 16 Advanced SQL Tutorial | String Functions + Use Cases
- 17 Advanced SQL Tutorial | Stored Procedures + Use Cases
- 18 Advanced SQL Tutorial | Subqueries
- 19 Data Analyst Portfolio Project | SQL Data Exploration
- 20 Data Analyst Portfolio Project | Data Cleaning in SQL
- 21 Pivot Tables in Excel | Excel Tutorial
- 22 Formulas in Excel | Excel Tutorial
- 23 XLOOKUP in Excel | Excel Tutorial
- 24 Conditional Formatting in Excel | Excel Tutorial
- 25 Charts in Excel | Excel Tutorial
- 26 Cleaning Data in Excel | Excel Tutorial
- 27 Full Project in Excel | Excel Tutorial
- 28 How to Install Tableau and Create First Visualization | Tableau Tutorial
- 29 How to use Calculated Fields and Bins in Tableau | Tableau Tutorial
- 30 How to Create Visualizations in Tableau | Tableau Tutorial
- 31 How to use Joins in Tableau | Tableau Tutorial
- 32 Full Beginner Project in Tableau | Tableau Tutorial
- 33 How to Install Power BI | Building First Visualization | Microsoft Power BI
- 34 How to use Power Query in Power BI | Microsoft Power BI
- 35 How to Create and Manage Relationships in Power BI | Microsoft Power BI
- 36 How to use DAX in Power BI | Microsoft Power BI
- 37 How to use Drill Down in Power BI | Microsoft Power BI
- 38 How to use Conditional Formatting in Power BI | Microsoft Power BI
- 39 How to use Bins and Lists in Power BI | Microsoft Power BI
- 40 Popular Visualizations in Power BI | Microsoft Power BI
- 41 Full Power BI Guided Project | Microsoft Power BI
- 42 Installing Jupyter Notebooks/Anaconda | Python
- 43 Variables in Python | Python
- 44 Data Types in Python | Python
- 45 Comparison, Logical, and Membership Operators in Python | Python
- 46 If Else Statements in Python | Python
- 47 For Loops in Python | Python
- 48 While Loops in Python | Python
- 49 Functions in Python | Python
- 50 Converting Data Types in Python | Python
- 51 Building a BMI Calculator with Python | Python Project
- 52 Building an Automated File Sorter in File Explorer using Python | Python Project
- 53 Inspecting Web Pages with HTML | Web Scraping in Python
- 54 BeautifulSoup + Requests | Web Scraping in Python
- 55 Find and Find_All | Web Scraping in Python
- 56 Scraping Data from a Real Website | Web Scraping in Python
- 57 Reading in Files in Pandas | Python Pandas Tutorials
- 58 Filtering Columns and Rows in Pandas | Python Pandas Tutorials
- 59 Indexes in Pandas | Python Pandas Tutorials
- 60 Group By and Aggregate Functions in Pandas | Python Pandas Tutorials
- 61 Merging DataFrames in Pandas | Python Pandas Tutorials
- 62 Creating Visualizations using Pandas Library | Python Pandas Tutorials
- 63 Data Cleaning in Pandas | Python Pandas Tutorials
- 64 Exploratory Data Analysis in Pandas | Python Pandas Tutorials
- 65 Amazon Web Scraping Using Python | Data Analyst Portfolio Project
- 66 Automating Crypto Website API Pull Using Python | Data Analyst Project
- 67 How to Create a Portfolio Website
- 68 Create the Perfect Data Analyst Resume
- 69 Top 3 Tips on Using LinkedIn to Land a Job
- 70 Get Your Data Analyst Bootcamp Certification
