BI Academy
Sign In
  • University Courses
  • News | Events
  • Top Experts
  • University Minors
  • FAQs
  • Forum
  • Register
Multi-Dimensional Modelling
Multi-Dimensional Modelling
Prof. Dr. Peter Lehmann
0

Description

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.

Lessons

Multi-dimensional Modelling

Table of Content

DataSheet

Unit 1: Modelling a DataMart from DataStore

Unit 2: Modelling the ETL Process

Unit 3: Modelling a Cube

Unit 4: Modelling Calculated Measures

Unit 5: Modelling User Defined Hierarchies

Unit 6: Modelling Galaxy Schema

Unit 7: Modelling Key Performance Indicators

Unit 8: Modelling Currency Conversion

Unit 9: Modelling Drill-Through

Unit 10: Modelling User Perspectives

Unit 11: Design a Dashboard

MDM FastTrack: Multidimensional Modelling

MDM FastTrack: Extraction-Transformation-Load

MDM FastTrack: Create a DataCube

Take the course to view this content

Academy Theme © 2013
  • Impressum | Imprint
  • | Lecturer Login
  • | Get a BIA User (Students)