CA flag CA
888-843-8733
888-843-8733

Business Intelligence Training Course

Course 901

  • Duration: 2 days
  • Language: English
  • 17 IIBA CDUs
  • 17 PMI PDUs
  • Level: Foundation

The Business Intelligence Training Course teaches attendees how to implement a BI solution that helps them transform data into valuable business insights. Whether delivered in-person or online, attendees should have solid business analytics knowledge and experience to benefit from this course. Topics covered include the BI Meta Model (BIMM), strategic and tactical application of BI, mapping operational data to a data warehouse, designing a BI solution, BI maturity levels, data governance, data cleansing, and organizing a business intelligence competency center. The course concludes with a capstone activity focused on using BI to solve problems.

Business Intelligence Training Course Delivery Methods

  • In-Person

  • Online

Business Intelligence Training Benefits

In this BI Training, you will learn how to:

  • Identify the maturity level of your BI solution.
  • Articulate critical elements of your solution to maximize your organization’s business opportunities.
  • Deliver data as an analytical insight to support business decision-making.
  • 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.

Prerequisites

Attendees should have solid business analytics knowledge and experience to benefit from this course. You can ensure you're up to speed by first taking Learning Tree's foundational business analytics course, Introduction to Business Analysis Training: Defining Successful Projects.

Business Intelligence Training Outline

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

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
  • Must Have, Should Have, Could Have, Won't Have this time (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

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?

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

Defining Competence

  • Six Challenges of Business Intelligence
  • The Value of the Business Intelligence Competency Center (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

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

Get This Course $2,225 $1,950 For Team Prices Call: 888-843-8733
  • 2-day instructor-led training course

  • After-course coaching available

  • Learning Tree end-of-course exam included
#901
  • Nov 27 - 28 9:00 AM - 4:30 PM EST
    Ottawa or Virtual
  • Feb 26 - 27 9:00 AM - 4:30 PM EST
    Herndon, VA or Virtual
  • May 28 - 29 9:00 AM - 4:30 PM EDT
    Ottawa or Virtual
  • Aug 26 - 27 9:00 AM - 4:30 PM EDT
    Herndon, VA or Virtual
  • 2-day instructor-led training course

  • After-course coaching available

  • Learning Tree end-of-course exam included
#901
  • Nov 27 - 28 9:00 AM - 4:30 PM EST
    Ottawa or Virtual
  • Feb 26 - 27 9:00 AM - 4:30 PM EST
    Herndon, VA or Virtual
  • May 28 - 29 9:00 AM - 4:30 PM EDT
    Ottawa or Virtual
  • Aug 26 - 27 9:00 AM - 4:30 PM EDT
    Herndon, VA or Virtual
  • Bring this or any training to your organization

  • Full-scale program development

  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching
#901
Questions about this course?
* Required Fields
Customize Your Team Training Experience

Fill out the form below or call 888-843-8733

* Required Fields
Preferred method of contact:

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Contact Us

Business Intelligence Training FAQs

This course is aimed at experienced BI administrators, developers, analysts, and scientists and does not address fundamental business analysis best practices.

As such, you should have solid business analytics knowledge and experience to benefit from this course. As a first step, consider our foundational business analytics course, Introduction to Business Analysis Training: Defining Successful Projects.

The Business Analyst can offer significant value to the development of a BI solution. The Business Analyst should be equipped with the skills to align data, business objectives, and technology to deliver actionable information needed by the organization to inform decision-making. The Business Analyst may be responsible for some or all aspects within the BI lifecycle.

Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.

Related Courses

  • Learning Tree
    Business Analyst Soft Skills Training

    In this Business Analyst Soft Skills course you will enhance your people skills, your effectiveness in developing solutions & communication strategies.

    Foundation
    3 days
    Team Training
  • Learning Tree
    Modeling for Business Analysis Training

    This business analysis modeling course will help you fulfill your role as a BA on business & software projects through an immersive, simulated case study.

    Intermediate
    4 days
    Online or In-class
    Starts from $3,285
  • Learning Tree
    Introduction to Business Analysis Training: Defining Successful Projects

    In this Introduction to Business Analysis course, you will learn how to apply a core business analysis framework through interactive workshops.

    Foundation
    3 days
    Online or In-class
    Starts from $2,745
Chat With Us