Business Intelligence X-Ray – Calibrating Your BI Infrastructure: Part 2

Posted by Karthikeyan Sankaran
August 9th, 2009

In my last post, I introduced the concept of a BI X-Ray that helps assess & calibrate the state of the current BI landscape within the organization. First part of the BI X-Ray is on Business Profiling, which was already discussed. The second part involves an evaluation of the BI technology components and at Hexaware, we call it the 10 Point Framework.

10 Point Framework looks at the BI technology infrastructure from ten different dimensions and provides a set of recommendations for each of the areas. The coverage is as tabulated below:

  1. Reporting and Delivery
    • Determine user groups, audience data characteristics and reporting requirements of users
    • Study the challenges involved in reporting and delivery mechanism across the current and the desired environment
    • Identify the security requirements for reports
    • Identify the performance and frequency requirements for reports
  2. Data Integration
    • Study the current data integration process
    • Analyze the existing tools that are used for data extraction
    • Understand the Error handling and auditing process
  3. Data Sources
    • Understand various sources of data
    • Analyze the source system data
    • Understand source system dependency, feed layout, frequency and mechanism of data transfer
    • Understand the change data capture process
  4. Data Quality
    • Audit current databases
    • Study the accuracy of data
  5. Enteprise Data Model
    • Study the existing conceptual, logical and physical data models
    • Study the entity relationships
  6. Reference Data Strucuture
    • Understand existing system process and data flow
    • Study the existing data architecture
  7. Security Framework
    • Study the existing data security
  8. Metadata Availability
    • Study the existing metadata
    • Study the metadata capture process
  9. Standards & Process
    • Study existing business process and problems
    • Study the current information flow
    • Analyze existing business requirements
  10. Infrastructure
    • Study the current IT Infrastructure
    • Study the existing applications
    • Review the existing ETL tools
    • Review current BI Architecture

The following are key highlights of Ten Point Framework:
1) Covers all aspects of application process, technology, requirements and infrastructure
2) Helps in prioritizing and bucketing the requirements
3) Identifies critical positives and negatives
4) Evaluates against industry best practices
5) Provides a roadmap and recommendation

Hexaware delivers the Ten Point Framework as a consulting engagement spanning 6-8 weeks with distinct Understand, Analyze and Recommend phases

Once the Business Profiling and 10 Point assessment is completed, the organization has a pretty good handle on their current BI environment which is the starting point for newer initiatives.

Thanks for reading. Please do share your thoughts

Comments (0)