Multidimensional Analysis

Be able to design multidimensional models using appropriate design principles.



Multidimensional

Analysis





Organization

  • Length of course: 2 weeks
  • Credit points: 1
  • Estimated workload: 30h
  • Type of course: self-paced, on demand

Topic

Business Intelligence refers to the procedures and processes for the systematic analysis of data in electronic form to enable better operational or strategic decisions. It helps companies to have more comprehensive knowledge of the factors affecting their business. Business intelligence is based on a broad variety of technologies. The ability to understand and master these technologies is a basis to become a data-driven company.

Focus of this Course

This course is based on the course Introduction to Business Intelligence. It deepens the knowledge on the design and modeling of multidimensional systems and introduces design principles for facts and dimensions.

Contents

  1. Design principles for facts
  2. Beyond the Star Scheme: Snowflake and Galaxy Scheme
  3. Design principles for changing dimensions
  4. Design principles for dimensions

Learning outcome

  • Be able to design multidimensional models
  • Be able to chose correct scheme for analyzing data

Teaching method

  • Online lecture with exercises

Assessment

  • Continuous assessment: Exercises

Recommended reading

  • Adamson (2010): Star Schema. McGraw-Hill.
  • Corr, Stagnito (2011): Agile Data Warehouse Design. Decision One Press.

Prof. Dr. Thomas Schmidt

is professor at Flensburg University of Applied Sciences for business computing, focusing on management information systems, business analytics, enterprise architecture and information logistics. He has 30 years of experience in IT and logistics and advised a large number of companies on strategy and implementation projects. He is an ACM member, member of the “Bundesvereinigung Logistik” and of the German-African Business Association.

Prior to his appointment as a professor, he started his career as a research associate at Fraunhofer Institute for Manufacturing Engineering and Automation, and later as Senior Management Consultant at CSC Ploenzke, responsible for the area of logistics. During this time, he did his PhD at the University of Bamberg.

Thomas Schmidt has 15 years of experience in Africa with projects in university partnerships with technology transfer in logistics and information technology. As Director of the Centre for Business and Technology in Africa, he founded the Namibian-German Centre for Logistics and operates partnerships in Cameroon, Kenya, Namibia and Ghana with successful cooperative Bachelor and Master programs. In addition to his African expertise, he taught and researched as a guest professor in the USA, Sweden, Finland, France and China.