home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral courses » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » Linux - UNIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Data Science, Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
Data warehouse concepts

This one-day course offers a conceptual overview of the data warehouse.

All the characteristics and possibilities of data warehousing are treated: definitions, myth and reality, key concepts, implementation and exploitation strategies.

What does datamining mean and what are the possibilities now? Several types of products can be of use (cleaning, loading, extraction, ...). An architecture is essential, so some time will be spent on that.

Schedule

datedur.lang.  location  price
21 Sep1?Leuven  (BE)500 EUR  (excl. VAT) 
13 Oct1NWoerden  (NL)500 EUR  (exempt from VAT) 
SESSION INFO AND ENROLMENT

Intended for

IT personnel, those persons in charge of the set-up of a warehouse, managers ...

Background

Some background on (relational) database management systems is a plus (see course SQL and relational databases fundamentals).

Main topics

explanation of the key concepts (datamart, DSS, OLAP, MDBMS, ...)

Back end ETT/ETL), Data Store, Front end Tools, Meta Data

the complete strategy: source data • transformation • loading • extraction • cleaning • maintenance metadata • datamining • ...

no data warehouse without a well-considered datamodel: ER, Multi Dimensional Modeling, Snowflakes, Stars

Training method

Theory alternated with practical examples.

Duration

1 day.

Course leader

Kris Van Thillo.

Global score

   
3.9/5 (based on 40 evaluations)

Reviews

     
uitstekend (, )
     
Zeer leerrijk en verhelderend (, )
     
Goed overzicht van concepten (, )
     
goed vr algemeen beeld; iets minder indien het om meer experimentele zaken gaat (eg. row-wise/column wise databases). (, )
     
very good overvieuw. a tot of concepts in 1 day (good thing (, )
     
Enthousiast gebracht! (, )
     
Goed gebracht, informatief, veel bijgeleerd. (, )
     
Goed gegeven; duidelijk (, )
     
Proficiat! (, )
     
Goed; stof tot nadenken, groter werk dan gedacht. (, )

SESSION INFO AND ENROLMENT