Go to main content
Back to Courses
MODULE 9

Data Warehousing & Analytical Architecture

Truly understand how to design a scalable analytical system with correct grain, historization, and architectural trade-offs.

Editorial cover of the Data Warehousing & Analytical Architecture module
Data warehousing moderno: architettura e concetti - immagine ufficiale della lezione su GinnyTech, creata da AD
1
Advanced 22 min

Modern data warehousing: architecture and concepts

Data warehousing fundamentals: from Kimball to Snowflake, dimensional modeling.

Go to lesson
Data modeling for warehouse - official lesson image on GinnyTech, created by AD
2
Advanced 22 min

Data Modeling for Warehouse

Design dimensional models, manage hierarchies and slow changing dimensions.

Prerequisites: 1

Go to lesson
ClickHouse in the modern data warehouse - official lesson image on GinnyTech, created by AD
3
Advanced 22 min

ClickHouse in the modern data warehouse

ClickHouse as an alternative/supplement to traditional data warehouses for fast analytics.

Prerequisites: 1

Go to lesson
Schema evolution and change management - official lesson image on GinnyTech, created by AD
4
Advanced 18 min

Schema evolution and change management

How to manage schema evolution in a data warehouse without breaking dashboards and ETL.

Prerequisites: 1

Go to lesson
OLAP and advanced analytical modeling - official lesson image on GinnyTech, created by AD
5
Advanced 22 min

OLAP and advanced analytical modeling

OLAP cubes, window functions, and advanced analytical patterns for data warehouses.

Prerequisites: 1

Go to lesson
SQL for data warehouse: essential query patterns - official lesson image on GinnyTech, created by AD
6
Advanced 22 min

SQL for data warehouse: essential query patterns

Optimized query patterns for data warehouse: aggregations, windows, and pivots.

Prerequisites: 1

Go to lesson
Case study: building a data warehouse - official lesson image on GinnyTech, created by AD
7
Advanced 28 min

Case Study: Building a Data Warehouse

Practical Project: Design and implement a data warehouse from scratch with dimensional modeling.

Prerequisites: 1

Go to lesson

Module connections

Continue hereS3, Data Lake, and Lakehouse Architecture12 lessons

Move from buckets with files to a readable, governed data lake compatible with modern lakehouse patterns.

Same stage of the pathKafka & Event Streaming Engineering9 lessons

Teach data logic as a flow, with schema contracts, stream processing, and realistic failure handling.

Same stage of the pathReal-Time Analytics & ClickHouse Systems9 lessons

Turn realtime from slogan to robust system with ingestion patterns, MergeTree thinking, and cost control.

Same stage of the pathInfrastructure & Ops for Data Systems7 lessons

Bring operational discipline from serious engineering to data workloads, deploy, observability, security, and incident response.

Previous moduleCourse Overview and Study Method for Data Work8 lessons

Transform the course from catalog to cognitive system, with study method, technical memory, and professional output plan.

Previous moduleData Collection & Tracking Systems8 lessons

Move from isolated tags and tools to reliable, governed, and observable measurement systems.