Crossing the Mountain to Establish a BICC

Presented by: Sharon Bainbridge

22 August 2013

Business Intelligence Competency Centre

1. Setting the Scene 2. What is a BICC?

3. Why do I need a BICC?

4. When should I start to form a BICC?

5. How do I start a BICC?

6. Who is involved in a BICC?

7.Where does a BICC belong?

8. Challenges?

What is a BICC?

Is your organisation ready to embark on the BICC journey?

Could your organisation use one – WHY?

Where would the BICC be located in your organisation?

Who would be in your BICC?

Are you already close to having a BICC?

Ponder Points

ANU The primary campus is located at

Acton(ACT) with other smaller

specialised campuses at

• Mt Stromlo Observatory, ACT

• Siding Spring Observatory, NSW

• North Australia Research Unit,

Northern Territory

• Kioloa Coastal Campus, NSW

ANU Colleges

Acton Campus has 7 Academic Colleges:

• College of Arts and Social Sciences

• College of Asia and the Pacific

• College of Law

• College of Business and Economics

• College of Engineering and Computer Science

• College of Physical and Mathematical Sciences

• College of Medicine, Biology and Environment

ANU - At A Glance

Students

Total: 18,737

Undergraduate: 60%

Graduate: 40%

Domestic: 75%

International: 25%

Male: 9,145

Female: 9,592

.

Staff

Total: 3,819

Academic: 40%

Professional: 60%

BICC Definitions

A BICC is a cross-functional team with a permanent, formal organisation structure. It has defined task, roles, responsibilities and processes for supporting and promoting effective use of BI across an organisation…. The BICC is tasked with driving the use of BI throughout an organisation.”

Gloria Miller, Dagmar Brautigan, Stefanie Gerlach

“ A business intelligence competency centre(BICC) is a team of people that, is responsible for managing all aspects of an organisation’s BI strategy, projects and systems. This includes developing a BI strategy, implementing BI tools and applications and then training and supporting the business users who rely on them. It is the BICC’s responsibility to oversee back-end data management tasks such as data integration, data governance, data quality and metadata management.”

Search Business Analytics

Working teams of IT and BI users that help promote BI expertise across an organisation…a BICC helps establish best practices for BI integration by bringing together people across an organisation with various backgrounds and areas of expertise”

Leah McMillan

Central

Best Practice

Business Standards

Team

What is a BICC?

BICC - Business Focus

Gartner: ”The BICC should be the “center of

gravitation”, where different skills are

combined for one common goal: To better

understand the business and interpret

current business results and to more

accurately predict the future.”

BICC – Team Oriented

A team with defined responsibilities

• That guides – promotes BI expertise • That advises - establishes best practice • That facilitates – brings people together

A team

ANU – Journey to a BICC

2008 2009 2010 2011 2013

Initial BI/DW

initiative with Data

Manager and

Cognos BI

Continue building data warehouse

Increase Cognos BI

licensing from

executive to

enterprise reporting

Develop Program

Charter

BI Strategy and

Roadmap

Engage Executive

sponsorship

Identify BICC

framework and

processes to

support delivery

.

Continue building data warehouse

2012 ANU Strategic

Plan

Why a BICC?

Provides better alignment and collaboration between business units

Reduced time to decision

Standardized data and tools

Reduced time to solution

Consistent definitions, processes and methodologies

Why a BICC for ANU

Cognos user licenses increased from 50 to 1000 users provides a foundation for reporting

Lack of standardization of definitions and business rules causes inconsistent reporting

Implementation of enterprise data warehouse not fully utilised

Inability to compare common reports delivered from different areas of the University

Why - ANU Drivers for Change

ANU by 2020 – Strategic Plan

ANU Management Information Strategy and Roadmap

Business Intelligence Services Program Charter

When – the organisation has:

A BI Executive Champion

An appetite for standardised management information

Accountability for strategic goals

How – ANU Business Intelligence Competency Centre Framework

How – BICC Functional areas

Business Intelligence

Services (BICC)

Data Acquisition

Information Delivery

Data Stewardship

Training Support

Vendor Management

BI Programs

BI Programs

Develop BI Strategy – keep aligned with ANU’s strategic and operational goals

Provide advice to users on best use of tools and interpreting the data (In association with SME’s)

Keep abreast of new technologies and techniques

Define access to BI Delivery

Define best-practice infrastructures, methodologies and standards

Establish and maintain corporate knowledgebase

Promote the BICC and it’s services at ANU

B

D

I

D

T S

V

B

Data Acquisition

Provide the interface to the source systems

Develop data integration processes

Establish common data definitions across ANU

Promote the definition and use of metadata

B

D

I

D

T S

V

B

Information Delivery

Determine Presentation Layer

Gather user requirements

Establish development, testing and promotion processes

Collaborate with IT Services

Publish documentation and usage guidelines

Monitor access to reports

Develop and implement organisational reporting standards

B

D

I

D

T S

V

B

Data Stewardship

Provide accurate, consolidated information which can be trusted

Facilitate agreement on data definitions and standards

Establish definition verification process

Define metadata and business rules

Facilitate data quality improvement processes

B

D

I

D

T S

V

B

Training

Core Team training – need to ensure keep up with latest technology to provide best advice to deployment

Develop and manage Report Author training and user group

Develop and maintain Consumer training and community of practice

Determine the best mix of training approaches

Liaise with IBM Education to ensure access to appropriate tool training

B

D

I

D

T S

V

B

Support B

D

I

D

T S

V

B

Provide support framework for report authors

Establish support mechanism for consumers

Provide support for data warehouse refresh and issues

Establish interfaces with IT services and vendors

Vendor Management B

D

I

D

T S

V

B

Collaborate with strategic vendors

Monitor adherence to license regulations

Review and optimize license usage

Renegotiate contracts

Review and provide input to proposals and contracts

Conduct vendor evaluations and approval

Who - Roles in the BICC Model

Reporting Community

• Report Authors • Subject Matter

experts • Stakeholders • Report Consumers

Organisational Support

• Stakeholders • Data Stewards • Executive Sponsors • IT Support

• Project Manager • Program Manager • Business Analysts • ETL Developers • Data Modelers • BI Developers • Training and

Communications

Our BICC Team

BICC Manager

Data Acquisition

Architect

BI Analyst

BI Developer

Data Delivery Architect

ANU – Governance Structure

Where does a BICC belong?

IT

Finance

Planning

Business area

Challenges

Who does the BICC report to?

Where does it belong in the organisation?

What value will it bring to the organisation?

Data Quality – Identifying Data Stewards

Business Rules – who defines these

Challenges continued

Ensuring that reports are not duplicated across Colleges(departments)

Ensuring that you are endorsed at an executive level to provide the standards

Ensuring that the report consumer feel empowered and have access to appropriate data and tools for their role whilst still maintaining the trust of the data owners that their data has been secured and used according to the security policy governing the data

In Summary

A BICC can be a powerful

option in leveraging the best

value from your BI initiative.

Need to consider

– the BI cultural maturity of your institution

– Appropriate resourcing/funding availability

– Executive sponsorship

Further Reading and References

TDWI BI Program Management: A Competency Center Approach to BI Excellence

Business Intelligence Strategy: A Practical Guide for Achieving BI Excellence

IBM Solution Brief: Standardization and the value of the BI Competency Centre

IBM Presentation: Driving BI Across the Enterprise (Oct 2007)

IBM White Paper: Building a Business Intelligence Competency Center: Establishing a culture of best practice

Strategic Intelligence with BI Competency Center: Rodica Maria Bogza, The Bucharest Academy of Economic Studies

BICC Business Intelligence Competency Centre: Hanne Breddam & Susan Day, Business Minds

http://download.101com.com/tdwi/Webinar/Business-Intelligence-Competency-Center-Best-Practices-to-Deliver-REAL-Business-Value.wmv

http://fr.slideshare.net/timoelliott/tdwi-business-objects-webinar-maturity-modelgulf

http://www.slideshare.net/timoelliott/business-intelligence-competency-centers-australia

sharon.bainbridge@anu.edu.au

“Intelligence without ambition is a bird

without wings.” Salvador Dali