Главная
Study mode:
on
1
FREE Data Analyst Bootcamp!!
2
How to Become a Data Analyst in 2023 (Completely FREE!)
3
SQL Basics Tutorial For Beginners | Installing SQL Server Management Studio and Create Tables | 1/4
4
SQL Basics Tutorial For Beginners | Select + From Statements | 2/4
5
SQL Basics Tutorial For Beginners | Where Statement | 3/4
6
SQL Basics Tutorial For Beginners | Group By + Order By Statements | 4/4
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 | Project 1/4
20
Data Analyst Portfolio Project | Data Cleaning in SQL | Project 3/4
21
Pivot Tables in Excel | Excel Tutorials for Beginners
22
Formulas in Excel | Excel Tutorials for Beginners
23
XLOOKUP in Excel | Excel Tutorials for Beginners
24
Conditional Formatting in Excel | Excel Tutorials for Beginners
25
Charts in Excel | Excel Tutorials for Beginners
26
Cleaning Data in Excel | Excel Tutorials for Beginners
27
Full Project in Excel | Excel Tutorials for Beginners
28
How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners
29
How to use Calculated Fields and Bins in Tableau | Tableau Tutorials for Beginners
30
How to Create Visualizations in Tableau | Tableau Tutorials for Beginners
31
How to use Joins in Tableau | Tableau Tutorials for Beginners
32
Full Beginner Project in Tableau | Tableau Tutorials for Beginners
33
How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners
34
How to use Power Query in Power BI | Microsoft Power BI for Beginners
35
How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners
36
How to use DAX in Power BI | Microsoft Power BI for Beginners
37
How to use Drill Down in Power BI | Microsoft Power BI for Beginners
38
How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners
39
How to use Bins and Lists in Power BI | Microsoft Power BI for Beginners
40
Popular Visualizations in Power BI | Microsoft Power BI for Beginners
41
Full Power BI Guided Project | Microsoft Power BI for Beginners
42
Installing Jupyter Notebooks/Anaconda | Python for Beginners
43
Variables in Python | Python for Beginners
44
Data Types in Python | Python for Beginners
45
Comparison, Logical, and Membership Operators in Python | Python for Beginners
46
If Else Statements in Python | Python for Beginners
47
For Loops in Python | Python for Beginners
48
While Loops in Python | Python for Beginners
49
Functions in Python | Python for Beginners
50
Converting Data Types in Python | Python for Beginners
51
Building a BMI Calculator with Python | Python Projects for Beginners
52
Building an Automated File Sorter in File Explorer using Python | Python Projects for Beginners
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 for FREE
68
Create the Perfect Data Analyst Resume | Free Templates!
69
Top 3 Tips on Using LinkedIn to Land a Job
70
How To Download Your Data Analyst Bootcamp Certification (Congrats!!)
Description:
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.

Data Analyst Bootcamp

Alex the Analyst
Add to list
#Data Science #Data Analysis #Programming #Programming Languages #Python #Domain-Specific Languages (DSL) #SQL #Data Visualization #Tableau #pandas #Software Development #Web Scraping
0:00 / 0:00
1 of 70

FREE Data Analyst Bootcamp!!