Course Description

This two-day Advanced Analytics Reporting MicroStrategy training teaches you how to build advanced objects (metrics, filters, derived elements, custom groups) to develop complex analytical reports. Bring your reports to the next level with more detailed information using advanced analytics, to glean valuable insights by manipulating your raw data.

Products covered: MicroStrategy Developer and Web.

Course Outcomes

At the end of the course, learners will be able to:

  • Create level metrics to compare contributions
  • Create transformation metrics to offset time values
  • Filter data with dynamic dates, by combining elements from different attributes, and using pass-through functions
  • Create attributes and metrics on the fly in reports
  • Create virtual attributes to define how data is grouped and displayed on reports
  • Optimize performance with Intelligent Cubes
  • Determine the order of calculation
  • Determine how data source tables are joined to produce specific results

Course Summary

Next Public Course Dates

UK & Europe:

  • 6 - 7 October 2026
  • 20 - 21 October 2026
  • 3 - 4 November 2026

US & Canada:

  • 13 - 14 October 2026
  • 27 - 28 October 2026
  • 24 - 25 November 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 analytics
  • Creating metrics in reports
  • Advanced attributes
  • Advanced filters: Filtering data on reports
  • Improving Performance: Intelligent Cubes
  • Advanced reporting options
  • Base formulas and advanced subtotals
  • Advanced metrics

Testimonials

“The PowerCenter training last week went very well. There were many practical exercises included which I really appreciated because they helped me understand the topics much better, I learned a lot and found the sessions very useful. I’m continuing to review and practice the content this week to consolidate what I’ve learned.

.”

★★★★★

- Taha Elmaadani, Data Integration Consultant, PTA IT Consulting

“Mahesh was an EXCELLENT trainer. Very gifted instructor. Able to clearly communicate and teach objectives. Very engaging made you want to keep learning, and was so patient and kind to all students. Would love to be taught by him anytime.

★★★★★

- Jackie Calvo, Quality Improvement Manager, Horizon Health Center

Absolutely loved the enthusiasm and appreciate the knowledge he brought to class!!!

★★★★★

- Shelly Fruits, KPERS

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.