IT-Universitetet i København
 
  Tilbage Kursusoversigt
Kursusbeskrivelse
Kursusnavn (dansk):T13 Business Intelligence 
Kursusnavn (engelsk):T13 Business Intelligence 
Semester:Efterår 2010 
Udbydes under:cand.it., e-business (ebuss) 
Omfang i ECTS:7,50 
Kursussprog:Engelsk 
Kursushjemmeside:https://blog.itu.dk/ET13-E2010/ 
Min. antal deltagere:20 
Forventet antal deltagere:40 
Maks. antal deltagere:45 
Formelle forudsætninger:


Basic understanding of database systems, entity-relationship modeling and SQL; in case of doubt please contact the teacher.  
Læringsmål:After taking the course, students will be able to:
1. do dimensional modeling (denormalized tables),
2. analyze data using BI tools and methods discussed at the course,
3. identify master data in a context of a specific organization and
create a data mart,
4. manage ETL (extract-transform-load) process,
5. initiate and manage a BI project in an organization.
 
Fagligt indhold:The course is a general introduction to Business Intelligence as topic and as tool, and covers important contributor's views on and methods for building a data warehouse. These are combined with practical examples and methods from the real world.

The following topics will be covered:

Introduction to Business Intelligence and Data Warehousing
Launching and managing DW/BI project/program
Requirements collection
Architecture
Dimensional modeling
Designing physical database and planning for performance
ETL design and techniques
Business Intelligence applications
Deploying and supporting DW/BI system
Expanding DW/BI system
Master data management, unstructured data and other trends in DW/BI
 
Læringsaktiviteter:12 forelæsningsgange

12 lectures and 10 exercises with hands-on  

Eksamensform og -beskrivelse:X. experimental examination form (7-scale; external exam), 7-trins-skala, Ekstern censur

 

Litteratur udover forskningsartikler:Kimball, R., Ross, M., Thornthwaite, W., Mundy, J., and Becker, B. (2008) The Data Warehouse Lifecycle Toolkit, 2nd edition. New York, Wiley, ISBN 978-0-470-14977-5.
Slaughter, S.J., and Delwiche, L.D. (2006) The Little SAS Book for Enterprise Guide 4.1. Cary, SAS Institute, ISBN 978-1-59994-089-2.

Optional:
Buchecker, M., Calhoun, S., and Stewart, L. (2004) SAS Programming I: Essentials. Cary, SAS Institute, ISBN 978-1-59047-432-7.
Cheema, J., and Thielbar, M. (2006) SAS Programming II: Manipulating Data with the DATA Step. Cary, SAS Institute, ISBN 1-59994-169-4
Lafler, K.P. (2004) PROC SQL: Beyond the Basics Using SAS. Cary, SAS Institute, ISBN 978-1-59047-534-8
 
 
Afholdelse (tid og sted)
Kurset afholdes på følgende tid og sted:
UgedagTidspunktForelæsning/ØvelserStedLokale
Fredag 09.00-12.00 Forelæsning ITU 2A14
Fredag 13.00-16.00 Øvelser ITU 2A14, 2A52, 4A54

Eksamen afholdes på følgende tid og sted:
EksamensdatoTidspunktEksamenstypeStedLokale
2011-01-21 Tidspunkt oplyses senere Mundtlig eksamen ITU 2A20
2011-01-24 Tidspunkt oplyses senere Mundtlig eksamen ITU 2A20
2011-01-25 Tidspunkt oplyses senere Mundtlig eksamen ITU 2A20