Module 1: Welcome to Analytics Engineering!

Instructor Intro

What is Analytics Engineering?

The Rise of the Analytics Engineer

Real World Impact

Analytics Engineer vs Data Engineer

Analytics Engineer vs Data Scientist

Analytics Engineer vs Data Analyst

Technical Skills Required

Soft Skills Required

Analytics Engineering Workflow

A Day in the Life of an Analytics Engineer

Module 2: Data Fundamentals

Data Types and Stuctures

Data Warehouse Concepts

Data Warehouse Architecture

API Fundamentals

Module 3: SQL for Analytics Engineers

SQL: Select, Filtering, Limiting

SQL: Aggregations, String Filtering, Having

SQL: Inner, Left, and Complex Joins

SQL: Subqueries in FROM and WHERE

SQL: CASE Statements

SQL: Set Operators & DateTime Functions

SQL: String Functions

SQL: Scalar and Numeric Functions

SQL: Performance Optimizations

SQL: Styling and Formatting

SQL: Interview Questions & Tips

Module 4: Data Modeling and Architecture

Dimensional Modeling

Normalization and Denormalization

Data Modeling Exercise

Module 5: dbt and Github

dbt Advanced Concepts

dbt Cloud Orchestration

dbt Walkthrough

Github Pull Requests

Github Walkthrough

Github Branches

Module 6: Data Quality and Testing

Data Quality Standards

Unit, Integration, and Acceptance Tests

dbt Testing & Notifications

Business Intelligence Monitoring

Module 7: Programming for Analytics Engineers

Python for Analytics

Python Data Structures

Data Manipulation with pandas

NumPy for Numerical Computations

Python Best Practices

Module 8: Visualization and Reporting

Intro to Business Intelligence (BI) Tools

Overview of Tableau, Looker, and Power BI

Looker Studio Walkthrough

Setting Up Data Sources and Connections

Intro to Dashboard and Report Building

Module 9: ChatGPT Mastery

Module 10: Analytics Engineering Capstone Project

Accounts and Access

SQL: Inner, Left, and Complex Joins