Rather than apply new words or phrases to poor data architecture concepts, learn how a data strategy should influence effective data architecture, especially for analytics and business intelligence People love buzzwords. Sometimes people think the quality of a solution improves
Fact Qualifier Matrix capabilities can be expanded to improve the value of conformed dimensions in business intelligence and analytics systems Introduction The venerable Fact Qualifier Matrix (FQM) has been a tool long used for demonstrating for dimensional models how fact and
There are many benefits to implementing surrogate keys in a dimensional model design for a data warehouse data model Introduction There are many reasons for implementing surrogate keys in Dimensional Models (enterprise data modeling) such as insulating dimensions from changes
Independent data marts cause many problems in data warehouse architecture; combining to result in numerous issues for business intelligence and analytics solutions. Introduction A severe disease has spread to epidemic proportions throughout our society. This disease is particularly dangerous as
Introduction In the beginning were applications. And applications served the corporation well until there was a desire for integration of historical information. However, applications supported neither integration nor historical data. When it was noticed that applications – once built and
Fully architected solutions to data warehouse / analytics systems, not independent data marts, is the right way to ensure all the benefits of integrated data Introduction The need for an architected solution to decision support / analytics data, as opposed
Independent data marts create stranded, unusable data. Independent data marts can spread like a disease through an organization and must be eradicated. There is a severe disease that has spread to epidemic proportions throughout our society. This disease is particularly
