Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
   Absolute and Relative Budgeting Keeping the lights-on  

ENCYCLOPEDIA→   Enterprise Intelligence  →   -  BI End-to-End  →   -  Business Intelligence Competency Centre  → 

BICC Governance- Process, Technology and Data

Governance is core to Business Intelligence Competency Centre. Process Compliance, Technology Governance and Data Governance are closely inter-linked. They provide robust vehicle to BI initiatives in terms of process quality and reliability, infrastructure management, vendor management, and an end-to-end data management frame-work.

Process Compliance

BICC will have defined set of processes for project execution, internal communication, estimation, project funding, etc. To achieve maturity in these processes, process indicators need to be defined, collected and monitored. These indicators can be categorised for Planning, Delivery, System Performance and Monitoring.

Process Indicator Category

Category Definition

Planning

Gives efficiency of project planning process

Delivery

Measures correctness of solution implemented

System Performance

Measures effectiveness of solution implemented

Monitoring

Analyses user satisfaction, ROI, etc

The following diagram gives examples of few process measures which can be defined by BICC for Process Compliance.

 

Business Intelligence Competency Centre Process Compliance

  • Planning: To efficiently manage number of associates and project deliveries, effort estimations are a key. Also, for on-time delivery of projects, defining boundaries for each project is a key. Hence, in planning phase of any project, realistic targets should be defined for effort and scope.
  • Delivery: Project teams are assumed to be operating in an optimal mode in a BICC. Delivery process measures are defined to record and improvise quality of delivery processes.
  • System Performance: For any BI application, refresh windows are critical for decision makers to get information on time. Hence measures like Query Performance and Data Load Window are recorded to ensure process is within boundary conditions.
  • Monitoring: All the process measures are to be monitored for any improvisation or change.

 

The table given below lists roles, which will define above process measures:

Phase

Process Measure

Who Defines?

Who Reports?

Planning

Estimation Accuracy

Design Authority

Delivery Manager

Scope Control

Design Authority

Project Architects

Release Control

Design Authority

ASG Manager

Delivery

First Time Right

Design Authority

Delivery Manager

Slippage

Design Authority

Delivery Manager

Defect Density

Design Authority

Delivery Manager

Level1-Level4 Support SLAs

Design Authority

ASG Manager

Ad-hoc/CR SLAs

Design Authority

Delivery Manager
ASG Manager

System Performance

System Availability

Business Analyst

Technical Architect
Design Authority

Concurrency

Business Analyst

Technical Architect
Design Authority

Query Performance

Business Analyst

Technical Architect
Design Authority

Data Load Window

Business  Analyst

Technical Architect
Design Authority

Monitoring

Cost/Budget

BICC Director

Planner

Defects

Design Authority

Delivery Manager

Business Users Satisfaction Index

Business Analyst

Delivery Manager

Compliance

BICC Director

Design Authority

Note: This is a sample Process Measures list. Elaborate list of process measures shall be defined as part of Strategize phase.

Technology Governance

BICC’s Technology Governance focuses on Infrastructure Management by

  • Standardizing technology
  • Planning the architecture
  • Reviewing Upgrades/Patches
  • Technical Troubleshooting

Vendor Management

  • Negotiations (first procurement, license augmentation, AMC)
  • Escalation procedures
  • Licensing

This helps maintaining overall rigor of strategic goals with standardized platform at reduced costs.

Any BI framework consists of multiple components like data-warehouse, ETL, enterprise reporting, etc. To design and develop these components, multiple technologies are packaged together. Let us take an example of an organization having various technologies such as Business Objects, Informatica, J2EE, Oracle, Teradata, MicroStrategy, etc. Each of these technologies can map to one or more of BI components (refer symbol X). Coverage or span of a technology across these components can be tabulated as below and then a decision on consolidation / rationalization can be taken.

BI Tools ->

BO

INFA

MicroStrategy

Oracle

Teradata

BI Components

Database

EDW

 

 

 

 

X

ADW

 

 

 

 

X

DW

 

 

 

 

X

ODS

 

 

 

X

 

DM

 

 

 

 

X

ETL

DQM

 

X

 

 

 

ETL

 

X

 

 

 

ELT

 

X

 

 

 

EII

 

 

 

 

 

EAI

 

X

 

 

 

CDC/RT

 

X

 

 

 

Reporting

OLAP

X

 

 

 

 

Enterprise

X

 

X

 

 

In a rapidly growing environment, in absence of strategic body for managing deployment architectures for multiple products and procurement of licenses, overall architecture can become random and may lead to added maintenance costs. A BICC can help standardizing technology stack by identifying coverage of a technology, measuring popularity and capability of technology. This analysis can be done by using ISO 9126 quality characteristics.

Data Governance

 

Data Governance

 

 

 

 

 

 

 

 

Data Governance is a very large framework which builds an organization-wide ability to precisely define, easily integrate, and effectively retrieve data for both internal applications and external communication. It needs the following six components in place.

 

   Absolute and Relative Budgeting Keeping the lights-on  
 
 

Was this page helpful?
 
 
More on BI Competency Centre
BI Competency Centre- A preface
BI Competency Centre- Organization Model
BICC- Competency Framework
BI Competency Centre- Services
BI Competency Centre Setup- Overview
BI Competency Centre- Strategize Phase
BI Competency Centre- Establish Phase
BI Competency Centre- Operate Phase
BUY BI & Data Management Vendors & Tools Evaluation Kit
Read more...
BUY largest on-line Data-Quality Management Kit
Read more...
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators



Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Channel SWOT
Sales strike rate
Sales Compensation administration
Sales Compensation Data Management
Sales Compensation Management
Read more...
  Customer Relationship Management
Exit barriers for Customer Retention
What is Customer Segmentation?
Customer Value and Profitability-Overview
Customer Service and Support Overview
Drivers for Customer Satisfaction & Retention
Read more...
  Human Resources & Leadership
What is Leadership?
Feedback does not mean only negative feedback
Act with Decisiveness
Roles and Level based Competency Segregation
Fitting leadership dimension in employee performance
Read more...
 
 
Business Performance & Planning
Performance Review should have no surprises
SWOT Assessment Report
Strategic Vision and Mission
A KPI should be simple -but it depends
strategy blueprint Rationalize Align and Publish
Read more...
  Business Intelligence & Data Quality
Super-flexible Data warehouse
Customer Data Correction and Techniques
Aggregation Queries on SCD
Individual Impact and Usage of BI
Data Management Standards for Data Entities
Read more...
  IT Vendors & Tools Management
Vendor Evaluation Matrix
Connectivity and Computing Support
Metadata Tool Architecture Features
Data Integration- Migration, Synch, Federation
Metadata Repository sharing
Read more...