Alex the Analyst Courses

Data Analyst Bootcamp

15 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

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

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

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

How to Practice for General Technical Interviews

Discover effective strategies for preparing for general technical interviews with practical examples and resources from Analyst Builder to enhance your interview readiness.

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