International Institute for Learning, Inc Business Intelligence International Institute for Learning, Inc

Business Intelligence (BI) refers to a set of technology-based techniques, applications, and practices used to aggregate, analyze, and present business data. BI practices provide historical and current views of vast amounts of data and generate predictions for business operations. The purpose of Business Intelligence is the support of better business decision making. This course provides an overview of the technology and application of BI and how it can be used to improve corporate performance.

Who is the Course for?

  • Business analysts
  • Project managers
  • Business managers
  • Data analysts
  • IT architects

Course Overview:

Getting Started

  • Introductions
  • Agenda
  • Expectations

Module 1: Foundation Concepts

  • The challenge of decision making
  • What is Business Intelligence?
  • The Business Intelligence value proposition
  • Business Intelligence taxonomy
  • Business Intelligence management issues

Module 2: Sources of Business Intelligence
Data warehousing

  • Data and information
  • Information architecture

Defining the data warehouse and its relationships

  • Facts and dimensions
  • Modeling, meta-modeling, and schemas
  • Alternate architectures

Building the data warehouse

  • Extracting
  • Transforming
  • Loading

Setting up the data and relationships

  • Dimensions and the Fact Table
  • Implementing many-to-many relationships in data warehouse
  • Data marts

Module 3: Online Analytical Processing (OLAP)
What is OLAP?

  • OLAP and OLTP
  • OLAP functionality

Multi-dimensions

  • Thinking in more than two dimensions
  • What are the possibilities?

OLAP architecture

  • Cubism
  • Tools
  • OLAP variations - MOLAP, ROLAP, HOLAP
  • BI using SOA
  • Applications of Business Intelligence
  • Applying BI through OLAP
  • Enterprise Resource Planning and CRM
  • Business Intelligence and financial information
  • Module 4: Business Intelligence User Interfaces and Presentations

Data access

  • Push-pull data access
  • Types of decision support systems
  • Designing the front end
  • Presentation formats

Dashboards

  • Types of dashboards
  • Common dashboard features
  • Briefing books and scorecards

Querying and Reporting

  • Reporting emphasis
  • Retrofitting
  • Talking back
  • Key Performance Indicators

Report Definition and Visualization

  • Typical reporting environment
  • Forms of visualization
  • Unconstrained views

Data mining

  • What is in the mine?
  • Applications for data mining
  • Data mining architecture
  • Cross Industry Standard Process for Data Mining (CISP-DM)
  • Data mining techniques
  • Validation

Module 5: The Business Intelligence User Experience
The business analyst role

  • Business analysis and data analysis
  • Five-step approach
  • Cultural impact
  • Identifying questions
  • Gathering information

Understand the goals

  • The strategic Business Intelligence cycle
  • Focus of Business Intelligence
  • Design for the user

Iterate the access

  • Iterative solution development process
  • Review and validation questions

Basic approaches

  • Building ad-hoc queries
  • Building on-demand self-service reports
  • Closed loop Business Intelligence
  • Coming attractions - future of Business Intelligence
  • Best practices in Business Intelligence

 Eligibility:

Participants should have a basic understanding of information systems technology and database fundamentals.

About International Institute for Learning, Inc. (IIL)

With a wholly-owned network of operating companies all over the world and clients in more than 150 countries, IIL is a global leader in training and certification, coaching and mentoring, consulting and customized course development. Our core competencies include: Project, Program and Portfolio Management; Business Analysis; Lean Six Sigma and Process Excellence; Agile; ITIL ; Leadership and Interpersonal Skills.

Using our proprietary Many Methods of Learning™, IIL delivers innovative, effective and consistent training solutions through a variety of learning approaches: Virtual, Traditional Classroom, On-Demand, Mobile, Video and Simulation. As a PMI  Global Registered Education Provider (R.E.P.); a member of PMI's Global Executive Council; an APMG Accredited Training Organization (ATO) for PRINCE2 , ITIL , and others; a Microsoft Partner (with a Microsoft Gold Project and Portfolio Management competency); and an IIBA  Endorsed Education Provider (EEP™), IIL is the training solution partner of choice for many top global companies.

See all International Institute for Learning, Inc courses

Enquire about this course

You may add more courses here,
your list will be saved.

Rate our content