BUSIT 205 Multidimensional Analysis • 5 Cr.

Description

Concepts and techniques used in BUSIT 105 are expanded upon to create advanced, business-oriented solutions with multi-dimensional databases. Students learn the MDX language for querying multi-dimensional databases. Prerequisite: BUSIT 105 with a C- or better and PROG 140 with a C- or better.

Outcomes

After completing this class, students should be able to:

  • Develop MDX queries to extract data from multi-dimensional databases
  • Develop MDX expressions to create calculated measures
  • Develop MDX expressions to create Key Performance Indicators
  • Create multi-dimensional databases with advanced features
  • Describe how aggregations are stored in multi-dimensional databases
  • Describe the physical storage options for multi-dimensional databases