A Data Warehouse/Lakehouse Primer
If you're interested in learning about Data Warehouse/Lakehouse architecture, design and modeling, start here! A guided tour of my principal articles.
If you read the following articles and topics in order, you will gain a good grounding in data warehouse/lakehouse architecture, design, and modelling, as well as insight into ETL patterns and project management.
An Introduction to Dimensional Modeling, then dig further into the Star Schema topic.
Now you are ready to understand Slowly Changing Dimensions and Fact tables.
A Semantic Layer is essential to your overall architecture.
Last but certainly not least are the ETL and Staging topics.
And as a bonus:
Some articles on Project approach, method and management.