Alex the Analyst Courses

Basics of R - Environment, Variables, Data Types - R for Data Analytics Series

Discover R programming fundamentals including environment setup, variable creation, and essential data types for effective data analysis workflows.

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

Reading and Writing Files in R - R for Data Analytics Series

Master file input/output operations in R to efficiently read data from various sources and write results back to files for data analysis workflows.

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

Filtering and Ordering Data in R - R for Data Analytics Series

Master filtering and ordering techniques in R to efficiently manipulate and organize datasets for data analysis workflows.

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

Operators in R - R for Data Analytics Series

Master essential R operators for data analytics including arithmetic, logical, and comparison operations to manipulate and analyze data effectively.

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

Learn Git and GitHub in 1 Hour

Master Git and GitHub fundamentals in under an hour - from setup and basic commands to branching, merging, and connecting repositories for version control mastery.

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

Introduction to Databricks Free Edition - UI Walkthrough

Discover Databricks Free Edition through account setup and comprehensive UI walkthrough, exploring big data and AI features available at no cost for hands-on learning and practice.

• YouTube
• 11 minutes
• 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

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
• On-Demand
• Free Video