Habanero Data Solutions

Microstrategy Fundamentals

Approved by Habanero Data
next available COURSE:
Duration :
5 Day/s
5 Day/s
$ 650
₦ 300,000

Course Information

Everything you need to know

  • Course Syllabus
  • Your trainer
  • Key Information

About this 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

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

I – Laptops will be provided for all candidates with pre-installed Microstrategy

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).

For more information on our training, please enquire using the form above or call +2348103382376

Microstrategy Fundamentals

Contact Our Team Today!

    What's Included

    Find out what’s included in the training programme.

    Delivery Options

    Everything you need to know


    Course Schedule

    Find out the next available dates

    Microstrategy Fundamentals

    Available Dates

    Available Places

    Book or Enquire

    July 19, 2021

    Abuja, Accra, Addis Ababa, Freetown, Kigali, Lagos, Nairobi

    We are happy to help

    Call our team today on +234 8103382376 or email training@habanerodata.net

    We’re here to discuss your needs with a free consultation and to offer guidance on the best route forward for you or your team. We’re proud of our expert data courses and consultancy services, and we’re always happy to talk about them.