Alex the Analyst Courses

Data Analyst Bootcamp

16 ratings

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

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

1 rating

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

Amazon Athena Fundamentals in AWS

1 rating

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

Getting Started with Azure Data Factory - Azure Fundamentals

1 rating

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

Top 5 Essential Excel Functions for Data Analysis

1 rating

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

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

5 Essential Excel Functions for Advanced Data Analysis

1 rating

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

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

1 rating

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

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

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

1 rating

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

Tableau Tutorials for Beginners

1 rating

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