Logo der HdM
Veranstaltungsbeschreibung

335107b Analytische Informationssysteme Übungen

Zuletzt geändert:25.09.2017 / Huber
EDV-Nr:335107b
Studiengänge: Wirtschaftsinformatik und digitale Medien (Bachelor, 7 Semester) , Prüfungsleistung im Modul Analytische Informationssysteme (ab SS 16) in Semester 4
Häufigkeit: unregelmäßig
Dozent: Prof. Dr. Peter Lehmann
Sprache: Englisch
Art: V
Umfang: 2 SWS
ECTS-Punkte: 3
Workload:
  • Lecture: 15 weeks, 1,5 hours = 22 hours
  • Preparation: 15 weeks, 3 hours = 45 hours
Prüfungsform:
Beschreibung: OLAP

Online Analytical Processing, or OLAP, is an approach for business users to answering multi-dimensional analytical queries. OLAP is part of the broader category of Business Intelligence. Typical applications of OLAP include business reporting, for example for sales, marketing, management reporting, budgeting and forecasting, financial reporting and similar areas. OLAP tools enable business users to analyze multidimensional data interactively from multiple perspectives. OLAP consists of three basic analytical operations: consolidation (roll-up), drill-down, and slicing and dicing. 1.Consolidation involves the aggregation of data that can be accumulated and computed in one or more dimensions. 2.Drill-down is a technique that allows users to navigate through the details. 3.Slicing and dicing is a feature whereby users can take out (slicing) a specific set of data of the OLAP cube and view (dicing) the slices from different viewpoints.

Multi-dimensional Modelling

Data Warehouses are databases used by decision makers to analyze the status and the development of an organization. Data Warehouses are based on large amounts of data integrated from heterogeneous sources into multi-dimensional, and they are optimized for accessing data in a way that comes natural to human analysts (e.g., OLAP applications). Data in a Data Warehouse are organized according to the multi-dimensional model, that hinges on the concepts of fact (a focus of interest for the decision-making process, such as sales and orders) and dimension (a coordinate for analyzing a fact, such as time, customer, and product). Each fact is quantified through a set of numerical measures, such as the quantity of product sold, the price of products, etc. DW design and development require ad hoc methodologies and an appropriate life-cycle.

Data Mining

Microsoft SQL Server is a complete set of enterprise-ready technologies and tools that help people derive the most value from information. We will demonstrate important data mining issues with easy to understand yet powerful business scenarios.
English Title: Hand's On's to Analytical Information Systems
English Abstract: In the Exercises, the students will lean: •How to create a Data Cube •How to create an OLAP Query •How to create an ETl Process •How to do Data Analytics •How to do Data Mining
Internet: www.bi-academy.eu

Heute ist

Deutscher Lebertag

Termine

Weitere Termine im HdM-Kalender

Studieninfotag 2017 in Outlook eintragen 22.11.2017 Studieninfotag 2017 mehr

Ringvorlesung zu aktuellen Themen aus der Welt der Medien in Outlook eintragen 22.11.2017 Ringvorlesung zu aktuellen Themen aus der Welt der Medien mehr

Games Day - 20 Jahre Games an der HdM in Outlook eintragen 23.11.2017  - 24.11.2017 Games Day - 20 Jahre Games an der HdM mehr

Kontaktstudium Design Thinking in Outlook eintragen 24.11.2017  - 25.11.2017 Kontaktstudium Design Thinking mehr

International Week in Outlook eintragen 27.11.2017  - 01.12.2017 International Week mehr

Innovation Day in Outlook eintragen 28.11.2017 Innovation Day mehr

34. EXIST-Workshop in Outlook eintragen 28.11.2017  - 29.11.2017 34. EXIST-Workshop mehr

TONI ERDMANN meets ProducersDAY@HdM  in Outlook eintragen 29.11.2017 TONI ERDMANN meets ProducersDAY@HdM mehr

Weitere Termine im HdM-Kalender

© Hochschule der Medien 2017 | Impressum | Hinweise zum Datenschutz Login