Approved by Habanero Data
Microstrategy
next available:
January 11, 2021
Duration :
5 Day/s
DURATION
5 Day/s
USD $
550
USD
$ 550
NGN ₦
250,000
NGN
₦ 250,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

Contact Our Team Today!








    What's Included

    Find out what’s included in the training programme.
    COURSE MANUALS
    REFRESHMENTS
    INSTRUCTOR

    Delivery Options

    Everything you need to know

    CLASS ROOM TRAINING
    ONLINE TRAINING
    ONSITE TRAINING

    Course Schedule

    Find out the next available dates

    Microstrategy

    Available Dates

    Available Places

    Book or Enquire

    April 19, 2021

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

    We are happy to help

    Call our team today on +2348103382376 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.