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