5 Day Microstrategy Course – Accelerate your return on your data
MicroStrategy (Reporting Essential & Advanced Reporting)
What is MicroStrategy?
About the course
This five day course provides students with an overview of the extensive reporting capabilities of Developer. It will also enable students to gain a thorough understanding of the most powerful capabilities of Microstrategy Developer. Participants will leave with an understanding of report creation and the numerous data and style report manipulations in Developer, including auto-style creation, drilling, data pivoting, page-by, outline mode, grid and graph, formatting, and thresholds. Additionally, participants will be versed in the creation of basic components that are essential in the creation of reports, including reporting filters, metrics, OLAP Services features, prompts, and searches. Participants will understand report design principles that leverage the capabilities of Developer. Participants will learn how to create numerous types of advanced metrics, including level metrics, non-aggregatable metrics, and transformation metrics, non-aggregatable metics.
Participants will also learn how to create different types of advanced filters, including attribute-to-attribute filters, joint element lists, and dynamic date filters. Participants will then learn about consolidations, custom groups, and advanced MicroStrategy OLAP Services features, such as Intelligent Cubes and derived elements. The course concludes with report data options, drill maps, and other report developer tools, such as Find and Replace and the Project Documentation.
This course will be reinforced with hands-on exercises.
Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects
Recommended Prerequisites: None
Course Schedule: 5 Days, 40 Academic Hours
Introduction to MicroStrategy Business
- Introduction to Business Intelligence
- Business Intelligence Architecture
- MicroStrategy Objects
- Introduction to MicroStrategy
- Data Manipulations
- MicroStrategy OLAP Services
- Report Objects
- View Filters
- Derived Metrics
- Prompts and Searches
Introduction to Advanced Reporting
- Advanced Metrics
- Level Metrics
- Non-aggregatable Metrics
- Transformation Metrics
- Base Formulas
- Conditional Metrics
- Nested Metrics
- Advanced Subtotals
- Attribute-to-attribute Filtering
- Joint Element List
- Dynamic Dates
- Pass Through Functions
- Qualify on Metrics
- Relationship Filters
- Consolidations and Custom Groups
- Advanced OLAP Services
- Intelligent Cubes
- View Filters
- Report Data Options
- Drill Maps
- Report Developer Tools
- Find and Replace
- Project Documentatio
Our international certified trainers are highly experienced Microstrategy practitioners who have real-world expertise.
I – All course material including a copy of Business Intelligence with Microstrategy Cookbook will be provided to all candidates.
II – Laptops will be provided for all candidates with pre-installed Microstrategy.
III – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course).
For more information on our training, please enquire using the form above or call 07035368449