Course Description

This two-day MicroStrategy Advanced Data Warehousing training 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.

Course Summary

Next Public Course Dates

UK & Europe:

  • 11 - 12 August 2026
  • 25 - 26 August 2026
  • 8 - 9 September 2026

US & Canada:

  • 4 - 5 August 2026
  • 18 - 19 August 2026
  • 1 - 2 September 2026

More dates

Prerequisites
  • None
Duration
  • 2 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite

Course Modules

Introduction to advanced data warehousing

  • Data warehouse design and reporting
  • Overview of advanced data warehousing

Testimonials

“Mike was great. He was very detailed and made sure I fully understood the section before moving on. There are so many functions to remember, so just have to practice with the materials and labs to get acquainted with all of them.”

★★★★★

- Ariel, Analyst, US Military

“ExistBI, Thank you again for the great Microsoft Power BI, PowerApps and Power Automate courses, our team was very happy”

★★★★★

- Kerry Urofsky, Systems Manager, Service, Avantik

The trainers clear and obvious enthusiasm for number crunching, analytics, and teaching others is infectious. He doesn’t waste time, shows exactly what you need to know and is genuinely hilarious.

Every one of my employees had tons of positive stuff to say.

★★★★★

- Benjamin G, MXSG Analysis and Integration Chief, US Air Force

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your training requirements or book a class, drop us a line

      To book this course, please fill in your details and submit the form.

        To book this course, please fill in your details and submit the form.