Alex the Analyst Courses

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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• Free Video

SQL - From Beginner to Advanced: Database Operations and Analysis

Master SQL fundamentals through advanced concepts with hands-on practice in database management, queries, functions, and real-world projects for data cleaning and exploratory analysis.

• YouTube
• 4 hours 5 minutes
• Self-Paced
• Free Video

AWS Glue and DataBrew - Data Integration and Preparation Essentials

Discover how to leverage AWS Glue and Glue DataBrew for efficient data preparation, transformation, and ETL workflows in AWS cloud environment, with hands-on demonstrations and practical examples.

• YouTube
• 46 minutes
• Self-Paced
• Free Video

Building a Fully Interactive Housing Data Web App with Shiny for Python

Master the creation of interactive web applications with Shiny for Python by building a dynamic housing data dashboard from scratch, incorporating real-world data analysis and visualization techniques.

• YouTube
• 1 hour
• Self-Paced
• Free Video

Shiny for Python - Components and Layouts for Web App Customization

Master the art of customizing web applications with Shiny for Python by exploring essential components and layout techniques for creating dynamic, interactive interfaces.

• YouTube
• 24 minutes
• Self-Paced
• Free Video

MySQL Exploratory Data Analysis Project

Dive into hands-on exploratory data analysis using MySQL through a practical project that demonstrates essential data cleaning and analysis techniques.

• YouTube
• 33 minutes
• Self-Paced
• Free Video

Data Cleaning in MySQL - Full Project Tutorial

Master practical data cleaning techniques in MySQL through a hands-on project focused on processing and transforming layoff dataset using SQL queries and best practices.

• YouTube
• 51 minutes
• Self-Paced
• Free Video

Microsoft Copilot Review - AI Features in Office Applications

Discover how Microsoft Copilot enhances productivity across Word, PowerPoint, Excel and OneNote through practical demonstrations, real-world testing, and an in-depth analysis of its capabilities and limitations.

• YouTube
• 25 minutes
• Self-Paced
• Free Video

Solving Hard SQL Interview Questions - Technical Interview Practice

Master complex SQL interview challenges with hands-on practice solving hard technical questions, focusing on real-world scenarios like customer purchase analysis and temperature data manipulation.

• YouTube
• 21 minutes
• Self-Paced
• Free Video