
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 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.
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.
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.