A critical aspect of successful development of a BI centre of excellence is appropriate human resource planning and allocation. This investment in people is non-negotiable. Without it you cannot align the centre of excellence to an organisational BI strategy.
The following table highlights a typical human resource structure for the BI centre of excellence. Clearly the level of resourcing will depend on the size of your organisation and the investment in BI, but it cannot be emphasised enough how critical sustained investment is.
Employee time requirement
|BI Competency Centre Leader||100% (One resource)||Manage BI competency centre. Aligns BI projects with overall BI strategy. Facilitates and manages engagement and contribution from business units. Core contact point for vendor and external partner relationships|
|Executive Owner||10% (One resource)||Provides executive leadership overview, and connection with the overall organisational objectives. In order for the centre of excellence to function most effectively, this resource must be CEO, or a direct report of the CEO.|
|Business Analysts||20-50% of multiple resources||Provide direct business support to identify and manage requirements|
|Data “Owner”||20% of multiple resources||Manage data quality and ownership issues, coordinate Master Data Management requirements|
|Data Warehouse Architect||100% of multiple resources||Manage data design and input meeting organisational requirements|
|BI Specialists||100% of multiple resources||Designs, develops and coordinates solutions for BA, and data integration|
|Training Coordinator||50% of resource||Co-ordinates BI related training programs, both internal and externally delivered.|
|System and Database Administrators||20% of multiple resources||Defined resources to coordinate hardware, software, database requirements and availability.|
What is clear, is that whilst the centre of excellence is responsible for co-ordination of the organisation BI strategy, it is not necessary responsible to deliver all capabilities. This still may be better placed to sit within the individual business units. Determination of this is an essential part of the centre of excellence plan activity.
I look forward to your feedback on the Centre of Excellence series. Development of a COE is vital to align BI to business needs.