Alex the Analyst Courses

Data Analyst Bootcamp

14 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

Getting Started with Azure Data Factory - Azure Fundamentals

1 review

Discover how to set up and navigate Azure Data Factory, learning essential fundamentals for data integration and workflow orchestration in the Azure cloud platform.

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

Top 5 Essential Excel Functions for Data Analysis

1 review

Master essential Excel functions including aggregates, date manipulation, formatting, logical operations, and lookup tools for data analysis.

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

5 Essential Excel Functions for Advanced Data Analysis

1 review

Discover five powerful yet lesser-known Excel functions including PMT, FORMULATEXT, LET, HYPERLINK, and EOMONTH to enhance your spreadsheet capabilities and efficiency.

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

Top 5 Most Popular Excel Functions - DateDif, TextSplit, If, Substitute, and XLookup

1 review

Master essential Excel functions including DateDif, TextSplit, If statements, Substitute, and XLookup to enhance your data analysis and spreadsheet manipulation capabilities.

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

Taking a Look at Real Healthcare Data - ICD11, CPT, HCPCS, Claims

1 review

Explore real healthcare data including ICD11, CPT, HCPCS, and claims in this walkthrough, with access to datasets via GitHub for hands-on learning and practice.

• YouTube
• 15 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

Basics of Git and Using VS Code with Git

Master Git fundamentals and integrate version control seamlessly with VS Code for efficient code management and collaboration workflows.

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

Working with Git and GitHub Together

Discover how to effectively integrate Git version control with GitHub for seamless collaboration and code management in data projects.

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

How to Become a Healthcare Analyst in 2025

Discover the essential steps and skills needed to launch a successful career in healthcare analytics, from technical requirements to industry insights and practical recommendations.

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