A pipeline is only as useful as the place it delivers data to. Before you load anything, you have to decide how the data will be organized so analysts and dashboards can query it quickly and get the right answers. That is the job of data modeling and data warehousing.
You'll start by separating the systems that run an application from the systems built for analysis, which is the difference between OLTP and OLAP, and by comparing data warehouses, data lakes, and the newer lakehouse idea. Then you'll learn dimensional modeling: splitting data into fact tables and dimension tables, and arranging them into star and snowflake schemas.
Finally, you'll see these ideas on real platforms. Snowflake and Google BigQuery are two of the most widely used cloud data warehouses, and working through each shows how a modern warehouse stores, scales, and queries data. Note that the Snowflake data platform and the snowflake schema are different things that happen to share a name.
With a target in mind, you'll be ready for the next module, ETL & ELT Pipelines, where you build the pipelines that fill it.
A simple explanation of how warehouses, lakes, and lakehouses differ, with a look at ETL and the difference between OLAP and OLTP systems.
A tutorial on the concepts and practice of dimensional modeling using the Kimball method, the standard approach to designing a data warehouse.
A clear comparison of the two schema designs you'll meet most often, and how to explain the difference, which is also one of the most common data warehouse interview questions.
An end-to-end introduction to the Snowflake cloud data warehouse, from the basics of warehouses, schemas, and databases through to more advanced features.
A fast crash course on Google BigQuery: what it is, how to get started, and how to work up to more advanced use.