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
Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.
- Rick Kirk, CTO, Alliant Energy / Ernst & Young
“Our Informatica Data Quality training class was very good. The trainer knew the tool and the Informatica platform very well. We recommed ExistBI for Informatica training.”
- Darren Jackson, CIO, US Bank
“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
