Free book
Data Warehousing from Foundations to Modern Analytics
Reading access
Free book
This book teaches data warehousing from beginner to modern analytics engineering practice. It covers modeling, ELT, SQL patterns, warehouse governance, performance, semantic layers, and production analytics workflows.
Level: intermediateLanguage: EN EnglishRating: 0Reviews: 0
Book
Book contents
01Chapter 1: Introduction to Data Warehousing02Chapter 2: OLTP vs OLAP Thinking03Chapter 3: Dimensional Modeling and Star Schemas04Chapter 4: Fact Tables, Dimensions, and Slowly Changing Dimensions05Chapter 5: ELT Pipelines and Staging Layers06Chapter 6: SQL Patterns for Analytics Engineering07Chapter 7: Partitioning, Clustering, and Performance08Chapter 8: Data Quality, Contracts, and Testing09Chapter 9: Semantic Layers and Business Metrics10Chapter 10: Warehouse Security and Access Design11Chapter 11: Modern Warehouses and Lakehouse Patterns12Chapter 12: Cost Control and Query Governance13Chapter 13: dbt and Transformation Workflows14Chapter 14: Dashboard and BI Consumption Patterns15Chapter 15: Capstone: Build a Warehouse Model16Chapter 16: Capstone: Run and Govern the Warehouse17Appendix A: Commands and Workflow Cheat Sheet18Appendix B: Reference Architectures and Patterns19Appendix C: Common Mistakes and Fixes20Appendix D: Best Practices Summary
Reviews
No approved reviews are visible yet.
Featured Books
Discussion
0 commentsNo approved comments are visible yet. New community replies may wait for moderation.