After building a DWH, we need to deliver information to business users. This is usually done with flat tables or star/snowflake schemas. However, this is highly inefficient,
Event Details
After building a DWH, we need to deliver information to business users. This is usually done with flat tables or star/snowflake schemas. However, this is highly inefficient, because it requires a long process of requirements gathering, developing, testing, maintaining, etc… Furthermore, these solutions are usually mono-thematic, because they can only use one fact table at a time.
On the other hand, if we let business users access the entire data set, they will be lost in complexity.
Graph theory can be the solution. They give us directions within the complexity of data, exactly as Google Maps guides us through a network of roads.