Introduction to Analytics Engineering

Overview

This course helps you build a strong foundation in analytics engineering and gives you the practical skills needed to work with modern data systems. You will begin by learning the core components of the modern data stack and the responsibilities of analytics engineers. From there, you will move into analytical SQL, dimensional modeling concepts, and the structure of ELT pipelines. The course concludes with hands-on development in dbt Core, where you will create, test, and document high-quality data models. With a practical, applied approach, the course covers essential topics such as writing effective SQL queries, organizing raw, staging, and mart layers, designing fact and dimension tables, and building automated transformations using dbt. You will learn how to structure data models, implement data quality checks, manage lineage, and support scalable analytics within modern data environments. • By the end of this course, you will be able to: • Understand the role of analytics engineering in modern data workflows • Design dimensional models using facts, dimensions, keys, and grain • Build structured ELT pipelines across raw, staging, and mart layers • Create, run, test, and document dbt Core models • Apply tests and documentation to strengthen data quality and transparency This course is designed for freshers, aspiring analytics engineers, data analysts, and data engineers who want to expand their skills in SQL, data modeling, ELT processes, and dbt development. It is ideal for anyone looking to build dependable, scalable, and well-documented analytics pipelines in today’s data-driven environments.

Syllabus

Modern Data Stack & SQL Foundations

This module introduces analytics engineering and the modern data stack. It explains ELT vs. ETL, essential analytical SQL skills, and core warehousing concepts. Learners work with PostgreSQL and dbt Docs to understand how modern data pipelines are structured.

Data Modeling and ELT Concepts

This module covers dimensional modeling and how ELT pipelines are organized across raw, staging, and mart layers. It introduces dbt Core, its project structure, and how it streamlines SQL transformations in modern analytics environments.

Building and Testing dbt Models

This module explores building dbt models using sources, refs, and layered transformations. Learners practice using materializations and seeds, and implement testing and documentation to improve data quality and model transparency.