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 | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
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
“Tomi was great. He was very detailed and made sure I fully understood the section before moving on. There are so many functions, so the Informatica materials and lab books are super helpful.”
- Leroy Smith, ETL Developer, US Army
“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
“The Informatica B2B session was awesome, the materials were accurate and Jean was a really good instructor”
- James Martin, Manager, Business Intelligence, Large US Company
