BUSINESS INTELLIGENCE

PREPARING FOR A BI INITIATIVE

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