Preferred method of contact:

Business Intelligence: Preparing for a BI Initiative

COURSE TYPE

Foundation

Course Number

901

Duration

2 Days

PDF Add to WishList

The focus of business intelligence is the transformation of data into value-added information: where to source it, how to integrate it, and how to enhance and deliver it as analytic insight to support business decision making.
—iiba.org/Home/BI.aspx

Effective implementation of a Business Intelligence (BI) programme results in better business decisions and increased success in achieving goals. In this BI training course, you will learn how to identify the maturity level of your BI solution, and articulate critical elements of your solution to maximise your organisation’s business opportunities. The facilitator will work with you through a case study in this hands-on training and you will be able to re-apply the template as soon as you’re back at work.

You Will Learn How To

  • Apply the BI Meta Model (BIMM) to turn desired outcomes into actions
  • Choose between a strategic and a tactical application of BI
  • Map operational data to a data warehouse
  • Design a BI solution for a business problem

Important Course Information

Who would benefit most from this course?

  • This course has been targeted to the Business Analysis community. BI Administrators, Developers, Analysts, Scientists, and End Users can find additional BI training opportunities here.

Does this course address Big Data and Data Analytics?

  • Learning Tree offers training more focused training on those topics here.

Recommended Experience

  • This course has been designed to focus on Preparing a Business Intelligence Initiative, and assumes the audience has come to the training with solid Business Analysis experience. The training will not address fundamental business analysis best practices. If you would like to gain that knowledge first, please consider a foundational course here.

Pre-course Preparation

  • You will be asked to spend a few minutes reviewing the case study before the first day of class.

Course Outline

  • Business Intelligence Basics

What Is Business Intelligence?

  • What Business Value Does BI Deliver?
  • BI Problems: Then and Now
  • Components of a BI Solution

BI Terminology

  • BI Terminology: OLTP and OLAP
  • BI Terminology: Dashboards and Scorecards
  • BI Terminology: Extract, Transform, Load and Reporting Tools

Business Intelligence Initiative Roadmap

  • The BA Process in Business Intelligence Initiatives
  • How the Business Analyst Delivers Business Value
  • Building Your BI Strategy

Business Intelligence Meta Model (BIMM)

  • Why a Business Intelligence Meta Model?
  • The BIMM as a Brainstorming Tool
  • Other Brainstorming Tools

Elements of the Business Intelligence Meta Model

  • Outcomes and Insights
  • Knowledge Acquisition
  • Information and Structure
  • Data

Strategic and Tactical Prioritization

  • Timeboxing
  • MoSCoW Analysis
  • 2 x 2 Matrix

Characteristics of Well-Formed Outcomes: SAVED

  • Example: A Poorly Formed Outcome
  • IIBA Requirement Definitions
  • Business Requirements
  • Example: Business Requirement
  • Evaluating Readiness for Business Intelligence

Assessing Project Feasibility

  • Strategy Analysis
  • Introducing Your Planning Spreadsheet
  • Every Business Has a BI System or Solution
  • Three Skill Sets Needed For Business Intelligence

Business Intelligence Maturity Levels

  • Level 1: Informal
  • Level 2: Defined
  • Level 3: Managed
  • Level 4: Controlled
  • Level 5: Optimized

Driving the BI Initiative Forward

  • What Are Business Drivers?
  • Evaluating Your Maturity Level

Business Intelligence Technologies

  • Example: Enabling Technologies for BI
  • Identifying Enterprise Systems and Data
  • How Is Enterprise Data Stored?
  • Understanding Your Data

Data Governance

  • Unstructured Data
  • Technical Infrastructure
  • Structured and Unstructured Data
  • Other Definitions of Data Governance

Data Governance Framework

  • Areas of Focus
  • Who Manages Data Governance?
  • Dealing With Data

Top-Down Data Analysis

  • Enterprise Information Architecture
  • Designing Standardized Business Metadata

Bottom-Up Source Data Analysis

  • Source Data Selection
  • Data Selection Issues

Data Cleansing

  • Extract, Transform, and Load (ETL)
  • Specifying ETL Rules
  • Moving Data to a Data Warehouse

Developing the Data Warehouse

  • Denormalization
  • OLTP vs. OLAP
  • OLAP Terminology
  • Value of OLAP
  • Organizing a Business Intelligence Competency Center

Defining Competence

  • Six Challenges of Business Intelligence
  • The Value of the BICC

How the BICC Addresses the Six Challenges of BI

  • Supporting Stakeholders
  • Supporting Business Strategy
  • Sharing Knowledge Throughout the Organization
  • Benefits and Disadvantages of the BICC

What Is the BICC?

  • Why Is a BICC Important?
  • The Goal of a BICC: Information Democracy
  • How Is a BICC Established?

Change Management and Transition Requirements

  • Functional Areas in the BICC
  • Job Roles in the BICC
  • BICC Scalability
  • Organizing the BICC
  • Solving Business Problems With BI

Overview of BI Tools

  • Organizational Issues
  • Reporting on BI Data

KPIs and BI Tools

  • KPI Elements
  • KPI Indicators
  • Digital Dashboards
  • Balanced Scorecards

Capstone Activity: Using BI to Solve Problems

Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition Fee due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition Fee — Standard: £995  

11 - 12 Jun (2 Days)
9:00 AM - 4:30 PM BST
London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

29 - 30 Oct (2 Days)
9:00 AM - 4:30 PM GMT
London / Online (AnyWare) London / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Private Team Training

Enroling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 0800 282 353 or Click here »

Tuition Fee

Standard

In Classroom or
Online

Standard

£995

Private Team Training

Contact Us »

Course Tuition Fee Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online any time after class.

Prev
Next

Training Hours

Standard class hours:
9:00 a.m. - 4:30 p.m.

Last day class hours:
9:00 a.m. - 3:30 p.m.

Free Course Exam – Last Day:
3:30 p.m. - 4:30 p.m.

Each class day:
Informal discussion with instructor about your projects or areas of special interest:
4:30 p.m. - 5:30 p.m.

AFTERNOON START class hours:
2:00 p.m. - 9:30 p.m.


Last day class hours:
2:00 p.m. - 8:30 p.m.


Free Course Exam – Last Day:
8:30 p.m. - 9:30 p.m.


Each class day:
Informal discussion with instructor about your projects or areas of special interest
9:30 p.m. - 10:30 p.m.

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

This course is endorsed by IIBA for Professional Development Hours (PD Hours) and Continuing Development Units (CDUs). For additional information and to confirm which courses are eligible towards your IIBA certification, click here.

Earn 11 PDUs


PMI, the Registered Education Provider logo, PMP, CAPM, PMI-ACP,
and PMBOK are marks of the Project Management Institute, Inc.

“There’s an excellent feedback loop that exists between course attendees and Learning Tree. I appreciate that because otherwise you end up getting what the training company thinks you should have rather than what you actually need”.

- C. Thorpe, Internet Manager
National Savings and Investments

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français