Business Intelligence: Basics

Business Intelligence: Basics
Image from eventbrite.com
From Tue 9 June 2020 to Tue 23 June 2020
From Tuesday 9 June 2020 to Tuesday 23 June 2020
9:00 AM - 5:00 PM
Ended

The Business Intelligence: Basics training will take place on June 9, 16 and 23, 2020.

Check out all details on our website thecampus.be.

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

7323 Views - 24/06/2020 Last update
culture business
Elewijt Center
564 Tervuursesteenweg, Elewijt-Zemst, 1982, Vlaanderen, Belgium
Event from
eventbrite.com

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event

Nearby hotels and apartments

564 Tervuursesteenweg, Elewijt-Zemst, 1982, Vlaanderen, Belgium

Browse other venues in Mechelen
Discover now


Discover more events in Mechelen
Discover now



Elewijt Center
564 Tervuursesteenweg, Elewijt-Zemst, 1982, Vlaanderen, Belgium
Event from
eventbrite.com


Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event
  1. Mechelen
  2. Elewijt Center
  3. Business Intelligence: Basics
 
 
 
 
Your changes have been saved.