Alex the Analyst Courses

Data Analyst Bootcamp

11 reviews

Master SQL, Excel, Tableau, Power BI, and Python for data analysis. Gain practical skills through hands-on projects and build a professional portfolio to launch your career.

• YouTube
• 20 hours
• On-Demand
• Free Video

Tableau Tutorials for Beginners

1 review

Learn to create visualizations, use calculated fields, build maps and graphs, perform joins, and complete a full project in this comprehensive beginner's guide to Tableau.

• YouTube
• 1 hour 30 minutes
• On-Demand
• Free Video

Amazon Athena Fundamentals in AWS

1 review

Discover how to leverage Amazon Athena for querying data directly from S3 buckets using SQL, making data analysis in AWS more efficient and cost-effective.

• YouTube
• 25 minutes
• On-Demand
• Free Video

SQL Basics for Data Analysts

Learn essential SQL commands for data analysis: Select, From, Where, Group By, and Order By. Create tables, insert data, and prepare for intermediate SQL concepts.

• YouTube
• 30 minutes
• On-Demand
• Free Video

Intermediate SQL Tutorials

Explore advanced SQL concepts like joins, unions, case statements, and data manipulation to enhance your database querying skills and data analysis capabilities.

• YouTube
• 30 minutes
• On-Demand
• Free Video

Advanced SQL Tutorials

Enhance SQL skills with CTEs, temp tables, string functions, stored procedures, and subqueries for advanced database management and analysis.

• YouTube
• 30 minutes
• On-Demand
• Free Video

Data Analyst Portfolio Projects

Comprehensive guide to building a data analyst portfolio through hands-on projects in SQL, Tableau, Python, and Excel, covering data exploration, visualization, cleaning, and analysis.

• YouTube
• 7 hours
• On-Demand
• Free Video

Data Analytics Bootcamp - SQL, Excel, Tableau, Power BI, Python, and Cloud Technologies

Master essential data analysis tools and skills across SQL, Excel, Tableau, Power BI, Python, and cloud platforms while building a professional portfolio and preparing for job interviews in tech.

• YouTube
• 23 hours 33 minutes
• On-Demand
• Free Video

Learn AWS Analytics - S3, Athena, Glue, DataBrew, and QuickSight

Master AWS analytics tools through hands-on practice with S3 buckets, Athena queries, Glue data processing, and QuickSight visualizations - all essential skills for modern data analysis.

• YouTube
• 1 hour 42 minutes
• On-Demand
• Free Video

Learn Azure Analytics - Azure Synapse, SQL Databases, and Data Factory

Master Azure analytics essentials through hands-on practice with storage accounts, SQL databases, Data Factory, and Synapse Analytics for building robust data solutions.

• YouTube
• 1 hour 17 minutes
• On-Demand
• Free Video

Power BI Fundamentals - Formatting, Visualizations, and Dashboard Development

Master Power BI fundamentals through hands-on practice with data formatting, DAX calculations, interactive visualizations, and a complete project implementation for effective business intelligence reporting.

• YouTube
• 2 hours 5 minutes
• On-Demand
• Free Video

Tableau for Data Visualization - Dashboards, Relationships, and Projects

Master data visualization fundamentals in Tableau through hands-on practice with real datasets, from basic interface navigation to creating interactive dashboards and managing data relationships.

• YouTube
• 1 hour 30 minutes
• On-Demand
• Free Video

Excel Data Analysis: Pivot Tables, Lookups, and Data Cleaning - 3 Hour Course

Master essential Excel skills from data cleaning to pivot tables, lookups, and conditional formatting through hands-on practice and a complete analytics project walkthrough.

• YouTube
• 2 hours 39 minutes
• On-Demand
• Free Video

Pandas for Data Analysis - Data Filtering, Joins, Indexing, Cleaning and Visualization

Master essential Pandas operations for data analysis, from basic file handling to advanced data cleaning, manipulation, and visualization techniques - perfect for aspiring data analysts.

• YouTube
• 2 hours 40 minutes
• On-Demand
• Free Video

Python Programming Fundamentals - From Variables to Web Scraping with Projects

Master Python fundamentals from variables to web scraping, including hands-on projects like BMI calculator and data extraction. Perfect for beginners wanting practical programming skills.

• YouTube
• 2 hours 32 minutes
• On-Demand
• Free Video