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