Kursusnavn (dansk): | T13 Business Intelligence |
Kursusnavn (engelsk): | T13 Business Intelligence |
Semester: | Efterår 2007 |
Udbydes under: | cand.it., e-business (ebuss) |
Omfang i ECTS: | 7,50 |
Kursussprog: | Engelsk |
Kursushjemmeside: | http://slesblade2.e-cbs.dk/forums/KEH/ |
Min. antal deltagere: | 20 |
Forventet antal deltagere: | 40 |
Maks. antal deltagere: | 45 |
Formelle forudsætninger: | No requirements |
Læringsmål: | (IGT)
After taking the course, students will be able to:
1. identify relevant data for an organization, which need to be
stored, create database structure and fill in data,
2. retrieve (query) data stored in a database or across databases and
analyze them 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. 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 Warehouse
Information modeling and databases
SQL
Architecture
Data Mart Design - Dimensional modeling
ETL Design and Techniques
Introduction to Microsoft - Integration Services
Introduction to Microsoft - Analysis Services
Introduction to Microsoft - Reporting
Introduction to Master Data Management
|
Læringsaktiviteter: | 12 forelæsningsgange 12 lectures and exercises with hands-on |
Eksamensform og -beskrivelse: | X. experimental examination form (7-scale; external exam), 7-trins-skala, Intern censur
|
Litteratur udover forskningsartikler: | Kimball, R., Reeves, L., Ross, M., and Thornthwaite (1998) The Data
Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing,
and Deploying Data Warehouses. New York, John Wiley & Sons, ISBN 0-471-
25547-5.
|
| |