Information Management NewsCan anyone share some experience as to how to test a data warehouse? What kind of test cases needs to be written?
Information Management NewsThe good news is that information quality can be measured - via various data quality dimensions. A data quality dimension is a way to measure and manage data and information quality. I reference 12 data quality dimensions that I believe are the most practical and useful for the business to measure and manage.
Information Management NewsFirst of all, some reports can be predicted. The reports users get today that will be satisfied by the data warehouse will still need to be run, perhaps somewhat differently and delivered differently, but they will still be needed and can be predicted.
Information Management NewsHoping not be bombarded by emails, I still dont get the difference between Kimballs and Inmons approach.
Information Management NewsQuestion: Apart from bloated dimension, what are the negatives of using all known attributes in your slowly changing dimensions (SCD)?
Information Management NewsWhich method is the best to achieve my goal (staging database with changed data) taking into consideration the issues of performance, latency, impact on source database etc.?
Information Management NewsQuestions: I am interested to learn more about the difference between the recommendation engine and the predictive analytics.
Information Management NewsA well-designed set of KPIs is hierarchical. By this I mean that the top level KPIs are derived from lower level KPIs.
Information Management NewsI am assuming that you are referring to integrating new systems acquired with the merger or acquisition in a data warehouse, though the following tips apply to other situations.
Information Management NewsFirst, let me say that I am not a psychologist, psychiatrist, social worker or counselor of any kind when it comes to relationships. Just ask my wife! However, 60 to 70 hours per week a few times during major deployment times is not unreasonable.
Information Management NewsIt sounds, to me, that your boss is not ready for or does not comprehend what a DW can do for the organization.
Information Management NewsHow long did it take before you delivered the data? My guess is that it was longer than three months. Within three months, the requirements generally change and since you did not ask during the development if the requirements changed, you were not notified.
Information Management NewsTake a look at "Business Metadata," by William Inmon, Bonnie ONeil and Lowell Fryman. Also look at Dave Marcos books and columns.
Information Management NewsThere are different kinds of BI applications. Some BI applications are data marts. A data mart is defined as an environment containing a specialized collection of related data, customized for a specific community of knowledge workers, analysts or planners, to support their reporting and analysis needs.
Information Management NewsThe only packaged ODSs I know of are part of major ERP products like SAP, PeopleSoft, Oracle, etc.