Unlock Your Data Journey: Become a Data Analyst for Free with Alex The Analyst!
4.0(15)
103 learners
What you'll learn
Understand database installation and management using MySQL
Learn data visualization techniques in Excel and Tableau
Develop basic programming skills in Python for data analysis
Gain knowledge in using Azure and AWS for data storage and processing
This course includes
23.5 hours of video
Certificate of completion
Access on mobile and TV
Course content
1 modules
• 84 lessons
• 23.5 hours of video
Master Data Analysis: Your Free Bootcamp Journey
84 lessons
• 23.5 hours
▶
FREE Data Analyst Bootcamp!!06:52
How to Become a Data Analyst in 2023 (Completely FREE!)13:58
Installing MySQL and Creating Databases | MySQL for Beginners12:04
Select Statement in MySQL | Beginner MySQL Series11:00
Where Clause in MySQL | Beginner MySQL Series12:27
Group By + Order By in MySQL | Beginner MySQL Series10:46
Having vs Where in MySQL | Beginner MySQL Series03:45
Limit + Aliasing in MySQL | MySQL Beginner Series03:57
Joins in MySQL | Intermediate MySQL17:10
Unions in MySQL | Intermediate MySQL07:22
String Functions in MySQL | Intermediate MySQL Series11:53
Case Statements in MySQL | Intermediate MySQL08:53
Subqueries in MySQL | Intermediate MySQL11:00
Window Functions in MySQL | Intermediate MySQL13:28
CTEs in MySQL | Advanced MySQL Series10:31
Temp Tables in MySQL | Advanced MySQL Series07:46
Stored Procedures in MySQL | Advanced MySQL Series12:36
Triggers and Events in MySQL | Advanced MySQL Series14:42
Data Cleaning in MySQL | Full Project51:10
MySQL Exploratory Data Analysis | Full Project32:43
Pivot Tables in Excel | Excel Tutorials for Beginners17:35
Formulas in Excel | Excel Tutorials for Beginners33:53
XLOOKUP in Excel | Excel Tutorials for Beginners18:46
Conditional Formatting in Excel | Excel Tutorials for Beginners20:59
Charts in Excel | Excel Tutorials for Beginners15:10
Cleaning Data in Excel | Excel Tutorials for Beginners21:04
Full Project in Excel | Excel Tutorials for Beginners40:50
How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners17:04
How to use Calculated Fields and Bins in Tableau | Tableau Tutorials for Beginners06:25
How to Create Visualizations in Tableau | Tableau Tutorials for Beginners14:04
How to use Joins in Tableau | Tableau Tutorials for Beginners14:28
Full Beginner Project in Tableau | Tableau Tutorials for Beginners44:17
How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners12:50
How to use Power Query in Power BI | Microsoft Power BI for Beginners13:07
How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners08:36
How to use DAX in Power BI | Microsoft Power BI for Beginners15:43
How to use Drill Down in Power BI | Microsoft Power BI for Beginners06:02
How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners09:53
How to use Bins and Lists in Power BI | Microsoft Power BI for Beginners09:31
Popular Visualizations in Power BI | Microsoft Power BI for Beginners14:14
Full Power BI Guided Project | Microsoft Power BI for Beginners42:37
Installing Jupyter Notebooks/Anaconda | Python for Beginners10:03
Variables in Python | Python for Beginners13:17
Data Types in Python | Python for Beginners21:58
Comparison, Logical, and Membership Operators in Python | Python for Beginners07:14
If Else Statements in Python | Python for Beginners06:40
For Loops in Python | Python for Beginners09:17
While Loops in Python | Python for Beginners05:40
Functions in Python | Python for Beginners12:43
Converting Data Types in Python | Python for Beginners06:36
Building a BMI Calculator with Python | Python Projects for Beginners14:22
Building an Automated File Sorter in File Explorer using Python | Python Projects for Beginners16:50
Inspecting Web Pages with HTML | Web Scraping in Python05:54
BeautifulSoup + Requests | Web Scraping in Python06:58
Find and Find_All | Web Scraping in Python12:09
Scraping Data from a Real Website | Web Scraping in Python25:22
Reading in Files in Pandas | Python Pandas Tutorials19:16
Filtering Columns and Rows in Pandas | Python Pandas Tutorials11:48
Indexes in Pandas | Python Pandas Tutorials11:22
Group By and Aggregate Functions in Pandas | Python Pandas Tutorials11:05
Merging DataFrames in Pandas | Python Pandas Tutorials22:09
Creating Visualizations using Pandas Library | Python Pandas Tutorials16:50
Data Cleaning in Pandas | Python Pandas Tutorials38:37
Exploratory Data Analysis in Pandas | Python Pandas Tutorials32:13
Amazon Web Scraping Using Python | Data Analyst Portfolio Project47:13
Automating Crypto Website API Pull Using Python | Data Analyst Project51:13
How to Create a Portfolio Website for FREE35:29
Create the Perfect Data Analyst Resume | Free Templates!17:37
Solving Easy SQL Interview Questions on Analyst Builder12:17
Solving Medium SQL Interview Questions on Analyst Builder12:24
Solving HARD SQL Interview Questions on Analyst Builder21:26
Solving VERY HARD SQL Interview Questions on Analyst Builder17:03
