MicroStrategy training in chennai

MicroStrategy course contents

Introduction to Data warehouse concepts

  • What is Data warehouse
  • Data warehouse Terminology
  • Star Schema & Snowflake Schema Work Flow
  • Slowly Changing Dimension and Types
  • What is BI
  • OLTP vs OLAP
  • Working Methodology of ROLAP,MOLAP & HOLAP

Microstratgy 9.2.1 Concepts

  • MSTR Architecture Workflow
  • MSTR Connect methodology
  • MSTR Meta-Data
  • Creation of New Project & source of the Project
  • Introduction to MSTR Architecture & Design process
  • MSTR Object Models
  • Schema Objects
  • Application Objects
  • Attribute, Facts & Metrics Creation
  • Auto Style, Banding, Pivoting
  • Advance Metrics
  • Design View, Grid view, Graph View &Sql View
  • Report Development
  • Formatting of reports

Advance MSTR Reporting

Creation of Filters

  • Attribute Qualification
  • Set Qualification
  • Shortcut to Filter
  • Shortcut to Reports
  • Security Filter

Creation Of Prompts

  • Prompt Types
  • Dynamic Prompts
  • Static Prompts
  • VLDB Properties
  • Drill Map
  • View Filter
  • Adhoc Reporting
  • Creating Searches
  • Creating Templates
  • Initialization of Hierarchies
  • Initialization of Transformations
  • Saving, printing report
  • Reporting Advance Options

MSTR Web Interface

  • Dashboard creation and Execution
  • Score board creation and Execution
  • Document Creation and Execution
  • Creation of filter, prompts and reports in web
  • MSTR Office

MSTR Basic Administration Task

  • Create user Groups
  • Giving access to the group vise reports
  • Object Manager
  • Command manager
  • Enterprise manager
  • Migration of reports to other Environment
  • Narrowcast Server and its Functionality
  • Distribution Server and its Functionality
  • Intelligence Server