mp31

1. Introduction
Business decision makers need the right information, in right form at right time. Business intelligence supports these needs and continues to play an important role in business IT: The market for BI tools has defied the recession to show revenue growth of almost 22%. New figures from **Gartner (analysis firm) ** show that the business intelligence (BI) sector is thriving despite flagging IT budgets.The worldwide appetite for BI platforms, analytic applications and performance management software in 2008 increased 21.7% on the previous year, from $7.2 billion to $8.8 billion.

Source: http://www.information-age.com/channels/information-management/news/1052367/business-intelligence-market-grows-22-says-gartner.thtml

2. Course structure

 * Introduction
 * The Information Supply Chain (ISC)
 * Analytical Applications with the ISC
 * Data Warehousing (MOLAP, ROLAP, HOLAP)
 * Extraction Transforming Loading (ETL)
 * OLAP
 * Data Mining
 * Reporting
 * Planning
 * Legal Consolidation
 * Case Examples

3. Case studies
The course includes various small case studies.

4. Parameters
ECTS: 6 Hours of study in total:180 Weekly hours per semester: 4 Course characteristics: compulsory optional Course frequency: every year - winter semester Maximal capacity: 10 students Course admittance prerequisites: Modules of the first 2 semesters - the exams of 2 modules out of 10 can be open Skills trained in this course: professional, methodological, and personal skills
 * Contact hours: 60
 * Self study hours: 120

Assessment of the course: The ratio between these two components should be adjusted to the local examination regulations. Teaching staff: Prof. Dr. Christoph Engels
 * 75% the quality of project results including a final presentation
 * 25% written examination at the end of the course

5. Learning outcomes

 * 5.1 Knowledge**

The students can


 * explain the core concepts of the Information Supply Chain


 * 5.2 Skills**

The students are able to


 * use Data Warehouse and OLAP techniques
 * apply Data Mining, Reporting, ETL methods

in a given context in the course


 * 5.3 Competence - attitude**

They are able to


 * apply Data Mining, Reporting, ETL methods
 * implement core modules with SQL Server BI-Services

in a new context / project.


 * 5.4 On scaling outcomes**


 * Analysis - assessed according to complexity and completeness
 * Models – assessed according to correctness, complexity and completeness
 * Tools - appropriate application, correctness, complexity and completeness of results

=6. Teaching and training methods:=

An initial lecture block is combined with integrated exercises and tutorials followed by hands-on training. Practical work includes a simulation of a real data Business Intelligence project where student teams build an Information Supply Chain with focus on a Reporting and/or OLAP Analysis task. Usage of professional Analytical Software: MS SQL Analysis, Reporting and Integration Services

=7. Course mapping=

All courses of the first 2 semesters contribute to this course especially MP16: Information and Knowledge Management

=8. References:=

Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker: The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence, John Wiley & Sons 2010, ISBN 9780470563106.

optional (in English): Scott Cameron: Microsoft® SQL Server® 2008 Analysis Services Step by Step, Microsoft Press 2000.

optional (in German): Christoph Engels: Basiswissen Business Intelligence, W3l, 2008.