Implement a Business Intelligence Competency Centre with Cornerstone Solution^®

A Business Intelligence investment takes time, money and effort to realise and so should be properly looked after. A Business Intelligence implementation should be designed to meet the strategic objectives of your BI strategy and these objectives should fulfil your vision. Your strategy will be realised through your tactics and BI operational model. A key component that will help you fulfil your vision is the Business Intelligence Centre of Excellence also known as a Business Intelligence Competency Centre or BICC. Cornerstone Solution^® from BISB includes a module of subsystems specifically designed to plan and set up a BI Centre of Excellence. The systems include processes, governance, templates, quick start documents, resourcing, and ticketing. If you already have a BI System in place you can opt for BISB to implement the Centre of Excellence systems without the full Cornerstone Solution^®.

The BI Centre of Excellence will help to ensure benchmark standards and formalised and documented BI process and the governance around it. As the BICC matures it becomes the stable BI mechanism for BI services and development and through which you can pilot and roll out new BI tools to the user community. It will also help you avoid the BI pitfalls such as BI silos.

To establish your BICC you will need to make decisions in several key areas. Here are some examples:

• Who will be the overall sponsor?
• What services will your BICC offer?
• What are your BI processes? For example, what is the process that a key user should follow in order to realise self-service BI?
• What governance surrounds your BICC process? For example, what should and should not key users do whilst practising Self-service BI?
• What is the development process within the BICC?
• How will your off-shore development model work?
• How will your BICC organisational structure work and who and how will you recruit?
• What is your communication strategy around the BICC?
• How will your funding model look?
• How will your training model look?

Your BICC should be scalable and will grow with you as your organisation grows. Your BICC should also be specifically designed to meet the needs of your organisation, and to this end the Cornerstone Solution^® systems are customised to meet your requirements.

Here are some example activities that your BICC might manage and conduct:

• New BI projects
• Change requests
• Encyclopaedia maintenance
• Standard report library management
• Universe maintenance
• Business analysis
• Dimensional modelling
• ETL strategy and development
• Report writing
• Data extracts
• Data mining and predictive algorithms
• Lifecycle management

As the organisation grows, the BI system develops and more and more users want a piece of the action. This can place a great burden on the IT department. Therefore, one of your key strategic BI objectives should be to help your user community realise Self-service BI. This means that they will be competent to log on to the BI system and help themselves to pertinent data for their analysis and then share the information with other users. The benefits of realising self-service BI are numerous but without process and governance it can become chaotic. The BICC should be the genesis of BI process.

With a clear BI process and communication everyone should understand what is going on. When the process is well managed, order will be maintained and lead to success. The process should be monitored so that if it starts to deviate it can be corrected (refer to Six Sigma process management for more information). If the process continues to deviate unchecked it will become a process out of control. This can lead to inefficiency, unnecessary stress and fire fighting.

If you’re a small to medium sized company establish your BICC footprint as early as possible and plan for it to grow with you. If you’re a medium sized to large company you may already have many BI users in your community. Mistakes in BI process and governance can be painful because BI has high visibility and happens directly in front of and is felt by end users. If you’re experiencing end user grumblings, IT backlogs or high and increasing Total Cost of Ownership revisit your BICC management strategy.

For more information on the The Cornerstone Solution^® or any of its subsystems you can reach BISB via the contact page here.

To find out more about establishing a BI Centre of Excellence or to have a go at doing it yourself watch BISB’s video on how to DIY your CoE below.