MicroStrategy Training: Advanced Data Warehousing

Summary

This course covers advanced issues in data warehousing design and explains how to work with these complexities when implementing a MicroStrategy project.

Students learn how to model complex attribute relationships and hierarchies, implement role attributes and slowly changing dimensions, design the schema for optimal performance, use logical views to resolve data modeling and schema design issues, and optimize query performance using both database and MicroStrategy functionality.

Students get hands-on practice during the course through exercises.

Prerequisites

There are no prerequisites for this course.

Duration

2 Days/Lecture & Lab

Audience

This course is for those wanting to learn advanced issues in data warehousing design and explains how to work with these complexities when implementing a MicroStrategy project.

Topics

• Introduction to advanced data warehousing

• Advanced schema design

• Logical views

• Many-to-many relationships

• Attribute roles

• Hierarchies