10 Commandments for Business Intelligence (BI) Teams
Posted by Bruce Worobec on July 20, 2011
1. Understand data in transactional systems
2. Efficiently extract data from transactional sources
3. Preserve a single version of the transactional data to serve as the Enterprise’s memory
4. Preserve as metadata a lineage from source system to eventual presentation, including documentation for all calculations, transformations, and abstractions
5. Rationalize and govern the replication of data across the variety of reporting data structures such as star schema based data marts and multi-dimensional cubes
6. Ensure semantic and temporal consistency across data structures (conformed dimensions) and abstraction layers (catalogs, views, and universes)
7. Provision and govern a data dictionary available to the user community
8. Serve as the first level of support for all presentation-layer tools available to the user community
9. Participate in programs related to master data management and data stewardship and governance, recognizing that success of these programs is a necessary precondition for the accuracy and consistency of BI results
10. Create a requirement-based engagement model with the user community in terms of the questions to be answered, problems to be solved, or opportunities to be discovered
