Kursusoversigt
Kursusbeskrivelse
Kursusnavn (dansk):
T13 Business Intelligence
Kursusnavn (engelsk):
T13 Business Intelligence
Semester:
Efterår 2009
Udbydes under:
cand.it., e-business (ebuss)
Omfang i ECTS:
7,50
Kursussprog:
Engelsk
Kursushjemmeside:
https://blog.itu.dk/ET13-E2009/
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 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:
Golfarelli, M., and Rizzi, S. (2009) Data Warehouse Design: Modern Principles and Methodologies. McGraw-Hill; 1st edition, ISBN 978-0071610391.
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:
Ugedag
Tidspunkt
Forelæsning/Øvelser
Sted
Lokale
Tirsdag
09.00-12.00
Forelæsning
ITU
4A22
Tirsdag
13.00-16.00
Øvelser
ITU
3A52
Eksamen afholdes på følgende tid og sted:
Eksamensdato
Tidspunkt
Eksamenstype
Sted
Lokale
2009-11-18
inden kl. 15:00
Skriftlige arbejder
ITU
Lokale oplyses senere
2010-01-14
9:00-16:00
Mundtlig eksamen
ITU
Lokale oplyses senere
2010-01-15
9:00-16:00
Mundtlig eksamen
ITU
Lokale oplyses senere