3 Day(s)


Setting up a business intelligence programme takes more than just installing the technology. A successful BI programme involves a set of concepts and methods designed to improve the business decision-making process by putting targeted information into the hands of those who need it most. This course details the critical variables needed to implement an effective BI programme that maximises your organisation's business opportunities.


Anyone interested in implementing a BI programme in their organisation, including programme and project managers, business and statistical analysts, and marketing directors. Prior BI experience is not needed.

Hand-on Training

An interactive and evolving case study immerses you in a challenging environment where you explore the concepts and methods behind a business intelligence implementation. Activities include:

  • Applying a BI metamodel
  • Analysing successful systems to identify what works
  • Deploying a road map for building and implementing a BI programme
  • Translating management directives into defined outcomes
  • Turning defined outcomes into data collection specifications
  • Organising a Business Intelligence Competency Center (BICC)
  • Incorporating BI tools to identify business trends
  • Mapping operational data to a data warehouse

Skills Gained

You Will Learn How To

  • Implement the key elements of a successful business intelligence (BI) programme
  • Apply a BI metamodel that turns outcomes into actions
  • Extract and transform data from an operational database to a data warehouse
  • Exploit business analytics and performance measurement tools
  • Organise a Business Intelligence Consistency Center (BICC)
  • Integrate BI into your daily business decisions

Course Specifics

Course Outline

Defining Business Intelligence (BI)
  • Components of a BI programme
  • Mapping the business intelligence process
  • Identifying the business needs for BI
  • New BI taxonomy
  • BI-specific management issues
  • Driving business agility and efficiency
Building a Road Map
  • Applying BI to solve business problems
  • Assessing the business problem
  • Distinguishing major components of a BI process
  • Focusing on pertinent information using the BI process
  • Stating desired outcome for a given situation
  • Overcoming common BI challenges
  • Iterating the BI metamodel
  • Starting BI with simple processes
  • Proposing secondary uses for transactional data
  • Scaling the BI process to fit your organisational needs
  • Enabling repeatable and successful BI processes
  • Discovering possibilities
  • Listing the major components of a BI system
  • Investigating the business advantages of strategic vs. tactical applications of BI
  • Reviewing successful systems
  • Selecting capabilities for your organisation
  • Identifying critical and variable attributes of a BI programme
  • Connecting processes
  • Realising the desired outcome from a specific organisational situation
  • Targeting the process to achieve the desired outcome
  • Deriving actions and decisions from the desired outcome
  • Designing and Planning BI Processes
Defining business requirements
  • Generating an initial data warehouse matrix
  • Aggregating business processes
  • Selecting dimensions
  • Modelling the dimensional business process
  • Navigating facts and dimensions
  • Strengthening relationships
  • Creating the appropriate schema
  • Traversing hierarchies
  • Constructing the data warehouse
  • Extracting data from multiple sources
  • Transforming data during migration
  • Loading data into a data warehouse
Implementing and Fine-Tuning the BI Solution
  • Evaluating business analytic tools
  • Selecting criteria for business analytics
  • Exploring online analytic processing (OLAP) tools
  • Slicing and dicing your data using multidimensional cubes
  • Examining the characteristics of a data mine
  • Reviewing data mining tools
  • Leveraging performance measurement tools
  • Observing information using dashboards
  • Assessing the current state of your business with key performance indicators (KPIs)
  • Communicating to stakeholders through scorecards
  • Organising a Business Intelligence Consistency Center (BICC)
  • Promoting expertise within your organisation
  • Producing a BICC functional checklist
  • Clarifying the roles of the BICC
  • Organising the BICC
Putting BI to Work for You
  • Applying the BI process across the organisation
  • Making predictive analytics work for your bottom line
  • Blending BI process into daily management activities

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Course Location Days Cost Date
3 1695 £1695 2018-07-17
3 1695 £1695 2018-01-24
3 1500 £1500 2017-11-06
3 1500 £1500 2017-10-30
3 1500 £1500 2017-10-20
3 1500 £1500 2017-10-11
3 1500 £1500 2017-09-28
3 1500 £1500 2017-09-18
3 1500 £1500 2017-09-12
3 1500 £1500 2017-09-11
3 1500 £1500 2017-09-11
3 1695 £1695 2017-08-30
3 1500 £1500 2017-08-23