Business Intelligence Maturity Model

As the Business Intelligence Maturity of a company evolves, it goes from reactive questioning - "What happened?" to Analysis - "Why did it happen?" and finally "What will happen and what can we do about it?"

Shadowing this evolution are its systems which are usually spreadsheets and some basic web reporting in Level 1, consolidated data marts in Level 2, Scorecards and a defined metrics framework in Level 3 and finally EDW and multi-dimensional drill-downs in Level 4.

Here is a comprehensive map of the Business Intelligence Maturity Model of an enterprise.

The challenge is not to go from Level 1 (usually the case) to Level 4 - such an ambitious leap will kill you, and your people will not be ready. The trick is to deliver a tactical project which is not throwaway and create a foundation for the strategic vision.

 The steps to do this are not as formidable as they seem if you follow a good design process.

  1. Envisioning session with Executives to design the most effective reporting (ignoring current limitations)
  2. Create Enterprise Data Model of data elements (metadata)
  3. Logical mapping of all input sources to the EDM
  4. Create Data Warehouse schema with multi-dimensional modeling derived from the Data Dictionary and report requirements
  5. Create ETL Data Flow tasks to map input sources to the Data Warehouse
  6. Create web forms to capture data which are also mapped to the EDM
  7. Cleanse, merge, normalise data going into the data warehouse
  8. Design agreed reports in Report Builder
  9. QA and Release