Business Intelligence Training Course

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 Prioritisation

• 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

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: Optimised

Driving the BI Initiative Forwards

• 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 Standardised 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

• Denormalisation
• OLTP vs. OLAP
• OLAP Terminology
• Value of OLAP

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 Organisation
• 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
• Organising the BICC

Overview of BI Tools

• Organisational Issues
• Reporting on BI Data

KPIs and BI Tools

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

Capstone Activity: Using BI to Solve Problems