
Explore the analytics engineering role in modern data teams, data architectures, pipelines, and the modern data stack, with terms like databases, data warehouses, data lakes, OLTP, OLAP, ETL, ELT.
Meet the instructor, Alice Zhao, an author of SQL Pocket Guide and Maven Analytics staff instructor, who introduces data science, analytics engineering, Python, and SQL concepts for beginners.
Explore the analytics engineering field, differentiate analytics engineers from data engineers and data analysts, and learn key terms, the modern data stack, OLTP vs OLAP, and ETL vs ELT.
Define analytics engineering, outline its role and history, and set the foundation for the rest of the course.
Analytics engineers transform raw data into analytics ready datasets for analysts and data scientists, structuring it systematically with SQL and data modeling to enable reproducible analytics.
Explore how data moves through a company before and after analytics engineering, from ingestion to warehouse to analysis, highlighting the shift to DBT for a dedicated data transformation stage.
Explore how data architectures shape the data flow and how pipelines implement that design, from SQLite to Excel to cloud data warehouses and BI tools.
Explore modern data stack architecture, popular tools like Fivetran, Snowflake, dbt, Tableau, and Airflow, and how data engineers, analytics engineers, and data analysts transform raw data into analytics insights.
Analytics engineers convert raw event data into BI ready analytics data by building pipelines that transform granular, messy data into clean, structured tables for analysts and end users.
Update the key metric definition (monthly active users) and its impact on dashboards, emphasizing the importance of documenting changes and preserving history with versioned logic in dbt.
Shift into the second half of the course to explore the key terms analytics engineers need to know on the job.
Explore how databases organize data with structured tables and sql, and contrast with flexible nosql formats using lego analogies to show differing data structures.
Explore how OLTP records day-to-day transactions in SQL databases, powering website interactions and customer orders, while OLAP stores data for analysis and reporting in a data warehouse.
Explore how ETL and ALT transform data between OLTP and OLAP systems, moving and shaping it from one system to another.
Discover how analytics engineering sits between data engineering and data analysis, turning raw data into analytics-ready data for analysts and dashboards, ensuring governance and a single source of truth.
This course is designed to give you a clear, practical understanding of what analytics engineering is, why it exists, and what you need to know to get started.
We'll kick things off by defining the analytics engineering role: its history, how it fits into a modern data team, and why it's become essential as companies deal with more data, more tools, and more complexity than ever before.
From there, we'll get into the technical foundations. You'll learn about data architectures, pipelines, and the modern data stack — the collection of tools and technologies that analytics engineers work with every day.
To make things concrete, we'll walk through three real-world scenarios where an analytics engineer adds value. These are the kinds of problems you'll actually encounter on the job, and they'll help you see how the role shows up in practice.
Next, we'll shift gears and dig into the key data terms and acronyms that every analytics engineer needs to know — from the difference between databases, data warehouses and data lakes, to OLTP vs. OLAP and ETL vs. ELT. We'll break down what each one means, why it matters, and how they describe data movement between systems in the real world.
Whether you're exploring analytics engineering as a career path, transitioning from an analyst or engineering role, or just trying to understand how modern data teams operate, this is the course for you.