MicroStrategy

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

Microstrategy is a business intelligence tool for reporting purpose where users can able to analyze their business easily using Microstrategy reports and in this course will teach you report creation, Dashboard/Document creation and their dependents .you will learn how to improve report performance using VLDB settings and also will teach you about project installation, DB instance creation User group creation and users creation. Each and every topic is covered with real time scenarios.

At the end of the training, participants will be able to:

Pre-requisite

All attendees must be fromTechnical Background and also having knowledge on Business Intelligence concepts.

Duarion

5 days

Course Outline

  1. Why Business Intelligence? Different Roles and Responsibilities in a business and their Reporting needs. Introduction to BI Architecture / Lifecycle Stages and also introduction to microstrategy.
  1. Architecture of Data Flow
  2. Stack description in BI
  3. Describing Reporting needs in business through a model
  4. Queries from Business Owner
  5. Understanding the requirement of BI system
  6. Difference between OLTP and OLAP
  7. Example of BI Query
  8. Delivering information through BI platform
  9. BI platform in BI technology stack
  10. Information delivery in BI
  11. BI becoming the Market Leader
  12. Introducing Dimension hierarchy
  13. Product dimension hierarchy
  14. Implementation of MD model
  15. MOPAL vs. ROLAP
  16. Analysis techniques in OLAP
  1. Microstrategy Desktop
  2. Microstrategy Architect
  3. Microstrategy report services
  4. Advanced Microstrategy desktop
  5. Microstrategy Intelligence server
  6. Microstrategy Narrowcast server
  7. Microstrategy Administration
  8. Introduction to Microstrategy webserver
  1. Introduction to Microstrategy Business Intelligence
  2. Introduction to Microstrategy Desktop & Architecture
  3. Configuration Objects
  4. Public Objects
  5. Schema Objects
  6. Creating and saving reports in desktop
  7. Report Manipulating in desktop
  1. Creating and saving basic report filters
  2. Creating, formatting and saving basic metrics
  3. Microstrategy OLAP services in desktop
  1. View filters
  2. Derived Metrics
  3. Creating and saving basic prompts & searches
  1. Introduction to Microstrategy Architect
  2. The logical data model
  3. The physical warehouse schema
  4. Advance Data modeling and schema design
  5. Many to many relationships
  6. Role attributes
  1. Creating microstrategy facts
  2. Creating microstrategy attributes
  3. Creating microstrategy hierarchies
  4. Project configuration workshop
  5. Project optimization and maintenance
  6. Maintaining your project overtime aggregate tables
  7. Partitioning & partition mappings transformation
  1. Introduction to enterprise reporting
  2. Document basics
  3. Document design concepts
  4. Useful design techniques
  5. Microstrategy office overview
  1. Introduction to advance reporting
  2. Advanced metrics
  3. Advanced filters
  4. Consolidations and custom groups
  5. Advanced prompts & OLAP services
  6. Drill maps
  7. Report data options
  8. Microstrategy Intelligence Server
  9. Introduction to Microstrategy administration
  10. Administration and query flow
  11. Connectivity
  12. Startup and administration interface
  13. Security
  14. Microstrategy intelligence server administration
  15. Caching and scheduling
  16. Datamarts
  17. Clustering
  1. Narrow server overview
  1. MSTR Installation
  2. Object manager
  3. Project duplication
  4. Groups and user creation
  5. Command manager
  1. Expsure to mstr10
  2. New concepts included in mstr10

Reviews