Top "Dimensional-modeling" questions

Dimensional modeling (DM) is the name of a set of techniques and concepts used in data warehouse design.

What are the types of dimension tables in star schema design?

When reading about star schema design I have seen that many people uses various names for different types of dimension …

data-warehouse dimension dimensional-modeling star-schema
Handling multiple fact tables in Qlikview

I have a PostgreSQL database containing various education data such school-level test scores and enrollment figures. I need to separate …

database database-design data-warehouse qlikview dimensional-modeling
joining across multiple fact tables with a dimension in between

What's a good approach to data warehouse design if requested reports require summarized information about the same dimensions (and at …

sql-server data-warehouse business-intelligence dimension dimensional-modeling
Reporting Queries: Best Way to Join Multiple Fact Tables?

I'm working on a reporting system that allows the user to arbitrarily query a set of fact tables, constraining on …

sql performance olap fact-table dimensional-modeling
Naming standards for dimensional modeling

I am working on my first dimensional modeling assignment for a Data Warehouse project using Kimball's approach. As I prepare …

data-warehouse dimensional-modeling
How to handle late arriving dimension and NULL business key in Kimball Data Mart?

I'm trying to implement Kimball data mart which uses -1 and -2 rows in dimension table for late arriving dimension …

sql sql-server database-design data-warehouse dimensional-modeling
What's the Grain in the context of DW

According to The Data Warehouse Toolkit by Kimball "The grain must be declared before choosing dimensions or facts because every …

sql database oracle data-warehouse dimensional-modeling