Business Intelligence: Basics

Duration

3 days

Overview

Business Intelligence (BI) is inevitable for every organization. Without Business Intelligence, your organization doesn’t count anymore today, and you won’t be able to compete with other businesses.

With Business Intelligence, everyone within your organization has access to the right information at the right time. This information is easily accessible and gives all employees the ability to make the right decisions on the basis of reliable and current information. By using this information optimally with Business Intelligence, your organization will perform better, and you will be able to gain more profit. Insight, saving time, optimalisation, control, better decisions and information. Which organization doesn’t want that?

Course Objectives

During this training, we discuss why Business Intelligence is valuable, who you need in your team, where you need to start and which pitfalls you need to avoid. We discuss data warehousing and dimensional modelling, and why these things are important. We will use the BI tools Pentaho, ETL and Qlikview for visualization.

After this training, you will:

  • Be able to develop a dimensional model;

  • Be able to set up your ETL-process to put your data in your data warehouse;

  • Know how to make a connection with your data warehouse and how to use the data in tools like Qlikview and Tableau.

Prerequisites

  • This is a BYOD (Bring Your Own Device) training. Please bring your own laptop to the course.

  • This course is suitable for everyone who is involved in Business Intelligence projects or solutions: business analysts, business architects, functional analysts, process managers and employees, IT architects and all IT professionals who are interested in business intelligence.

Course Content

  • Introduction to Business Intelligence

  • BI-Architecture

    • Operational data sources

    • ETL

    • Analytical tools

  • Why is BI useful and valuable?

    • The knowledge pyramid

    • Data is wisdom

  • Who to involve in a BI project

    • Sponsor

    • Business analyst

    • Database architect & administrator

    • ETL architect & developer

    • BI architect

  • Where to start

    • BI lifecycle

    • Pitfalls

    • Garbage in, garbage out

    • Project sponsor MIA

    • IT only sponsor

  • Case OLTP-OLAP

  • Data warehousing

    • What is it?

    • Objectives of data warehousing

    • Components of a data warehouse

    • Pentaho of ETL and Qlikview for visualization

  • Dimensional modelling

    • Fact tables

    • Dimensional modelling methodology

    • Star diagrams

    • Snowflake diagrams

    • Slowly changing dimensions

  • Exercises

 

Enroll here


Training cost

1.917 EUR (VAT excluded) per person

This training qualifies for the SME e-wallet (KMO portefeuille)

Practical details

Classroom
From 9 AM to 5 PM

Language

Dutch
(English upon request)

Location

We organize this training course on several locations within Belgium. Select your preferred date to see the location.

This training in-company?

Upon your request we can organize this training for you.


In collaboration with

Wolters-Kluwer-logo.png