Business Intelligence with I.B.M. Data Warehouse Enterprise Edition

Abstract

To carry out a training period in a foreign country with the Erasmus project was my desire. Discovering new culture, working with foreign persons and improving my English speaking was the advantages of doing a project out of Belgium. My Erasmus training period has been done in Thessaloniki in Greece. This document presents the theoretical notions of Business Intelligence within I.B.M. Data Warehouse Enterprise Edition. These notions will be explained and showed with an end to end example. First, We will present the DB2 Data Warehouse Enterprise Edition by describing most components like the Intelligent Miner and the Websphere application server. Next to the presentation, we create a sample database which will be used for the tutorials. This database is the one of JK Superstore, a fictive company. The created database will be then used in Design Studio and loaded into a Data Model Project ( OLAP ). After Working on the Data Model Project, we will build a data warehousing application that will be deployed on the Websphere Application server. This application will be designed into a Data warehouse project in Design Studio. The data warehouse project contains data flows, control flows and mining flows. Finally, we will do data mining on the JK Superstore to try to improve the sales of the company. We will also try data mining on the Titanic data set and try to regroup the population in clusters and check if the rule “Children and women before” is respected. In the end of the document, I will speak about the presentation I have done at the University of Thessaloniki.