335108a Business Intelligence-Anwendungen

Zuletzt geändert:	02.09.2019 / von Carlsburg
EDV-Nr:	335108a
Studiengänge:
Dozent:
Sprache:	Englisch
Art:	V
Umfang:	3 SWS
ECTS-Punkte:	6
Workload:	5 ECTS = 150 h of work load Time in class: 1,5 h x 14 weeks = 21 h Time for preparation of class sessions: 1,5 h x 14 weeks = 21 h Time for project work, preparation of presentations, research etc.: 108 h
Inhaltliche Verbindung zu anderen Lehrveranstaltungen im Modul:	Analytical Information Systems
Prüfungsform:
Bemerkung zur Veranstaltung:	SPO 1
Beschreibung:	You will learn about different Business Intelligence Applications and how and where to use them.
English Title:	Business Intelligence Applications
English Abstract:	With a serious business game, you will learn about fundaments of Business Intelligence. After the course, students will be able to understand the following concepts: - Data-Warehouse-Architectures - Modelling a Data Mart - Dimensional Fact Modelling - Modelling a Star Schema - Modelling a Galaxy Schema - Extraction, Transformation, Loading with MSSQL Integration Services - Online Analytical Processing mit MS Excel Powerpivot - Building a Data Cube - Working with Cube Perspectives - Data Visualisation with MS Power BI - Introduction to Data Mining - Building a Close Loop Scenario with a Data Mining Service The course will have practical hands-ons in PC labs, or on student PCs.