11.412

Advanced Analytics Reporting

Develop advanced report objects (metrics, filters, derived attributes, custom groups, and consolidations) to create complex analytical reports. The majority of this course is hands on using MicroStrategy Developer and Web in a Cloud environment.

Skills you gain

  • Creating non-aggregatable metrics
  • Creating level metrics to compare contributions
  • Creating transformation metrics to offset values
  • Using advanced mathematical functions in metric calculations
  • Combining elements from different attributes to filter data
  • Using dynamic dates to filter data
  • Using pass-through functions to filter data
  • Creating attributes and metrics on the fly
  • Optimizing performance with Intelligent Cubes
  • Determining the order of calculation
  • Determining how data source tables are joined to produce specific results

MicroStrategy products covered

  • MicroStrategy Developer and Web

Topics

  • Introduction to advanced analytics
  • Base formulas and advanced subtotals
  • Advanced metrics
  • Level and inventory metrics
  • Advanced filters
  • Advanced attributes
  • Intelligent Cubes
  • Advanced reporting options

Self-Paced Training

E-Learning

English Register

Course Recordings

English Register
Portuguese Register
Spanish Register

Instructor-Led Training

Online Mar 30 - Apr 1, 2020
9:30 PM - 5:30 AM CET
English Greg Butler Register
Online Mar 30 - Apr 1, 2020
9:30 PM - 5:30 AM CET
Italian Stefano Sartorio Stefano Sartorio Register
Online Apr 6 - 8, 2020
9:00 PM - 5:00 AM ART
Spanish Juan Martin Castro Juan Martin Castro Register
Online Apr 7 - 9, 2020
9:30 PM - 5:30 AM CET
English Chantal Moss Register
Online Apr 13 - 15, 2020
9:30 PM - 5:30 AM EST
English Stephen Goodson Stephen Goodson Register
Online Apr 14 - 16, 2020
9:30 PM - 5:30 AM CET
English Lukasz Pniewski Register
Online Apr 20 - 22, 2020
9:30 PM - 5:30 AM CET
Italian Stefano Sartorio Stefano Sartorio Register
Online Apr 20 - 22, 2020
9:30 PM - 5:30 AM CET
Spanish Igor Freitas Igor Freitas Register
Online Apr 20 - 22, 2020
9:30 PM - 5:30 AM CST
English Douglas TerBush Douglas TerBush Register
Online Apr 20 - 22, 2020
9:30 PM - 5:30 AM CET
German Hans-Joachim Diedrich Hans-Joachim Diedrich Register
Online May 4 - 6, 2020
9:30 PM - 5:30 AM AET
English Gina Sidhu Gurvant Singh Register
Online May 5 - 7, 2020
9:30 PM - 5:30 AM CST
English Marianne Messeh Register
Online May 11 - 13, 2020
9:30 PM - 5:30 AM CET
English Lukasz Pniewski Register
Online May 11 - 13, 2020
9:30 PM - 5:30 AM CET
English Peter Brown Peter Brown Register
Online May 18 - 20, 2020
9:30 PM - 5:30 AM CET
English Chantal Moss Register
Online May 18 - 20, 2020
9:30 PM - 5:30 AM CET
French Sophie Da Silva Sophie Da Silva Register
Online May 28 - 30, 2020
8:00 PM - 4:00 AM PST
English Anahi Serrano Anahi Serrano Register
Online Jun 7 - 9, 2020
9:00 PM - 5:00 AM GST
English Aatif Rahim Register
Online Jun 8 - 10, 2020
9:30 PM - 5:30 AM CET
English Greg Butler Register
Online Jun 15 - 17, 2020
9:30 PM - 5:30 AM MYT
English Daniel Koh Register
Classroom/Webex Class Locations > North America > NA - On Site > Tysons Corner, Virginia, USA Jun 29 - Jul 1, 2020
9:00 PM - 5:00 AM EST
English Jason Hudson Jason Hudson Register
Online Jul 6 - 8, 2020
9:30 PM - 5:30 AM CET
Italian Stefano Sartorio Stefano Sartorio Register
Classroom/Webex Class Locations > Europe-Middle East-Africa > EMEA - On Site > Cologne, Germany Jul 6 - 8, 2020
9:30 PM - 5:30 AM CET
German Hans-Joachim Diedrich Hans-Joachim Diedrich Register
Online Jul 9 - 11, 2020
9:30 PM - 5:30 AM CET
French Myriam Rielau Myriam Rielau Register
Online Jul 13 - 15, 2020
9:30 PM - 5:30 AM CET
Spanish Pedro Marco Ortega Pedro Marco Ortega Register
Classroom/Webex Class Locations > North America > NA - On Site > Los Angeles REGUS, Classroom/Webex Class Locations > North America > NA - On Site > Los Angeles REGUS Jul 20 - 22, 2020
9:00 PM - 5:00 AM PST
English Reza Supandi Register
Classroom/Webex Class Locations > North America > NA - On Site > New York, New York, USA Jul 20 - 22, 2020
9:00 PM - 5:00 AM EST
English Stephen Goodson Stephen Goodson Register
Classroom/Webex Class Locations > Latin America > LATAM - On Site > Buenos Aires, Argentina Jul 20 - 22, 2020
9:00 PM - 5:00 AM ART
Spanish Juan Martin Castro Juan Martin Castro Register
Online Jul 20 - 22, 2020
9:30 PM - 5:30 AM CST
English Anahi Serrano Anahi Serrano Register
Online Aug 10 - 12, 2020
9:30 PM - 5:30 AM CET
English Peter Brown Peter Brown Register
Classroom/Webex Class Locations > North America > NA - On Site > Tysons Corner, Virginia, USA Aug 24 - 26, 2020
9:00 PM - 5:00 AM EST
English Marianne Messeh Register
Online Aug 24 - 26, 2020
9:30 PM - 5:30 AM AET
English Gina Sidhu Gurvant Singh Register
Online Aug 24 - 26, 2020
9:30 PM - 5:30 AM CET
English Chantal Moss Register
Online Aug 31 - Sep 2, 2020
9:00 PM - 5:00 AM IST
English Aatif Rahim Register
Classroom/Webex Class Locations > Europe-Middle East-Africa > EMEA - On Site > London, United Kingdom Sep 14 - 16, 2020
9:30 PM - 5:30 AM GMT
English Greg Butler Register
Classroom/Webex Class Locations > North America > NA - On Site > San Francisco REGUS, Classroom/Webex Class Locations > North America > NA - On Site > San Francisco REGUS Sep 21 - 23, 2020
9:00 PM - 5:00 AM PST
English Reza Supandi Register
Online Sep 21 - 23, 2020
9:30 PM - 5:30 AM PST
English Anahi Serrano Anahi Serrano Register
Classroom/Webex Class Locations > Latin America > LATAM - On Site > Buenos Aires, Argentina Sep 28 - 30, 2020
9:00 PM - 5:00 AM ART
Spanish Juan Martin Castro Juan Martin Castro Register
Classroom/Webex Class Locations > North America > NA - On Site > New York, New York, USA Sep 28 - 30, 2020
9:00 PM - 5:00 AM EST
English Stephen Goodson Stephen Goodson Register
Online Sep 28 - 30, 2020
9:00 PM - 5:00 AM BRT-BRST
Spanish TBA Register
Online Sep 28 - 30, 2020
9:00 PM - 5:00 AM ART
Spanish TBA Register
Classroom/Webex Class Locations > North America > NA - On Site > Atlanta, Georgia, USA Sep 28 - 30, 2020
9:00 PM - 5:00 AM EST
English TBA Register
Classroom/Webex Class Locations > North America > NA - On Site > Toronto, Ontario, Canada Sep 28 - 30, 2020
9:00 PM - 5:00 AM CST
English TBA Register
Online Sep 28 - 30, 2020
9:30 PM - 5:30 AM CST
English Jason Hudson Jason Hudson Register
Classroom/Webex Class Locations > Europe-Middle East-Africa > EMEA - On Site > Cologne, Germany Sep 28 - 30, 2020
9:30 PM - 5:30 AM CET
German Hans-Joachim Diedrich Hans-Joachim Diedrich Register
Classroom/Webex Class Locations > Europe-Middle East-Africa > EMEA - On Site > Milan, Italy Oct 5 - 7, 2020
9:30 PM - 5:30 AM CET
Italian Stefano Sartorio Stefano Sartorio Register
Online Oct 9 - 14, 2020
9:30 PM - 5:30 AM CET
Spanish Igor Freitas Igor Freitas Register
Classroom/Webex Class Locations > North America > NA - On Site > Tysons Corner, Virginia, USA Oct 19 - 21, 2020
9:00 PM - 5:00 AM EST
English Marianne Messeh Register
Online Oct 19 - 21, 2020
9:30 PM - 5:30 AM CET
French Myriam Rielau Myriam Rielau Register
Online Nov 9 - 11, 2020
10:30 PM - 6:30 AM CET
English Chantal Moss Register
Online Nov 23 - 25, 2020
10:30 PM - 6:30 AM MYT
English Daniel Koh Register
Online Dec 7 - 9, 2020
10:00 PM - 6:00 AM IST
English Aatif Rahim Register

No sessions were found matching your criteria.