Business Intelligence How Would An Ideal Semantic Layer Look Like? Most data practitioners I talked to agree on two things. 1/ We need an abstraction layer to define metrics consistently and rigorously. …
Data Modeling A 2020 Reader's Guide to The Data Warehouse Toolkit Ralph Kimball's classic book The Data Warehouse Toolkit introduce the world to the practice of data modeling. Here's how to read it in 2022.
Data Modeling Applying The Principles of Agile to Data Modeling In our third and final part on Agile Data Warehouse, we take a look at the origins of the Agile Manifesto, from which Corr and Stagnitto took inspiration.
Business Intelligence A Business Process Worth Measuring The second part of our series on Agile Data Warehouse Design, a 2011 attempt at applying the principles of agile to the practice of data modeling.
Data Modeling First Impressions from Agile Data Warehouse Design Agile Data Warehouse Design is a 2011 attempt at applying the principles of agile to the practice of data modeling. This is the first post in a series on the ideas from the book.
Data Modeling The Three Types of Fact Tables A concise tour of one of the basic components of Kimball dimensional data modeling. We explore the three types of fact tables, and then analyze why they have lasted the test of time.
Data Modeling Slowly Changing Dimensions (SCDs) In The Age of The Cloud Data Warehouse What a new approach to slowly changing dimensions tell us about the future of dimensional data modeling.
Business Intelligence OLAP != OLAP Cube There's a tendency for people to conflate OLAP with OLAP cube. We take a quick look at how this happens, why it shouldn't, and why it matters if you're a data practitioner.
Business Intelligence The Rise and Fall of the OLAP Cube A definitive history of the rise of the OLAP cube, how it's affected our industry, and what comes after.
Using Holistics Holistics Data Modeling, Explained Holistics's data modeling layer allows data teams to radically increase their productivity. No repeated queries. Self-serve reports and dashboards. Here's how it works.