In this hands-on business intelligence (BI) course, you will learn to implement a BI solution that will help you source, integrate and transform data into valuable business insights. 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
Business Intelligence Training Course Delivery Methods
Business Intelligence Training Benefits
Apply the BI Meta Model (BIMM) to turn desired outcomes into actions
Choose between a strategic and a tactical application of BIMap operational data to a data warehouseDesign a BI solution for a business problem
Test your skills in the included end-of-course exam
Leverage continued support with after-course one-on-one instructor coaching and computing sandbox
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