I would like to consider simple maturity levels in Business Intelligence.
I see the maturity/progression as:
– Level 0
- Canned reports
- Parameterized reports
- Ad Hoc Queries
– Level 1
- Single source data warehouse
- BI Platform
- Analytics (OLAP Cubes, Reporting, Metrics, Dashboards)
– Level 2
- Predictive Analytics/Real-time Recommendations
- Dynamic Business Rules Engine
In this blog I will just focus on level 0, a place where many organizations find themselves. The most basic is BI is having a set of canned reports that can be run by privileged users or automatically. This reports are inflexible but do provide basic information to the user community. These canned reports are often generated periodically for the masses and easy to be consumed.
The parameterized reports provides limited user interact but more value. Along with giving more information to the user they also protect the system from boundless queries and locking situations. The parameters are usually related to the dimensional information that is used on other levels of the BI maturity model.
Ad-hoc queries allows users to have access the information and often are used to pull information into other data tools (Access DB and Excel). The queries are usually limited but still allow users more than enough rope to hang themselves. The flexibility is good but if accessing any operational information can be disastrous.
In BI Assessments I’ve been involved in, one of the challenges is that at this level organizations often have purchased a BI suite and are frustrated they cannot get more out of the tools. The reason for challenges is that the tools is not the problem the data sources and processes are.
Next time I will review Level 1 maturity and some more simple definitions.