Call us on 07035368449 or Request a call back Today !

MicroStrategy (Reporting Essential & Advanced Reporting)

5 Day Microstrategy Course – Accelerate your return on your data

What is MicroStrategy?

MicroStrategy is an enterprise business intelligence (BI) application software vendor. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. Interfaces include web, desktop (for developers) and Microsoft Office integration. MicroStrategy Mobile also supports mobile BI.

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

Course Syllabus:

Day 1

Introduction to MicroStrategy Business

  • Introduction to Business Intelligence
  • Business Intelligence Architecture
  • MicroStrategy Objects
  • Introduction to MicroStrategy
  • Developer
  • Reports
  • Data Manipulations

Day 2

Style Manipulations

  • Filters
  • Metrics
  • MicroStrategy OLAP Services
  • Report Objects
  • View Filters
  • Derived Metrics
  • Prompts and Searches

Day 3

Introduction to Advanced Reporting

  • Advanced Metrics
  • Level Metrics
  • Non-aggregatable Metrics
  • Transformation Metrics
  • Base Formulas
  • Conditional Metrics
  • Nested Metrics
  • Advanced Subtotals

Day 4

Advanced Filters

  • 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

Day 5

Derived Elements

  • Report Data Options
  • Drill Maps
  • Report Developer Tools
  • Find and Replace
  • Project Documentatio

Your Trainer

Our international certified trainers are highly experienced Microstrategy practitioners who have real-world expertise.

Key Information

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

Your Name (required)

Company Name

Phone Number

Your Email (required)

Courses

Your Message

MicroStrategy Course

₦ 230,000per course