MicroStrategy Online Training

MicroStrategy Online Training

Data warehouse Basics

  • Database Concepts
  • DW Definition
  • Type of Tables
  • Star Schema
  • Snow Flake Schema

Microstrategy Product Overview

  • Microstrategy Developer
  • Microstrategy Architect
  • Microstrategy report services
  • Microstrategy Intelligence server
  • Microstrategy Distribution Services
  • Microstrategy Administration
  • Microstrategy Object Manager
  • Microstrategy Integrity Manager
  • Microstrategy Command Manager
  • Microstrategy Web
  • Microstrategy Data Blending
  • Microstrategy Visual Insights

Microstrategy Developer:

Microstrategy Basics

  • Introduction to Microstrategy Business Intelligence
  • Introduction to Microstrategy Developer & Architecture
  • Types of Microstrategy Objects
  • Introduction to Public Objects
  • Introduction to Schema Objects
  • Introduction to Configuration Objects

Microstrategy Basic Reporting

  • Introduction to Attributes and Metrics.
  • Basic Report Creation
  • Different types of Report Mode
  • Pivoting
  • Templates
  • Sorting
  • Auto Styles
  • Outline Mode
  • Formatting Changes
  • Conditional Formatting(Templates)

Advanced Reporting and Data Manipulations

  • Creating and saving Advanced report filters
  • Creating and saving Advanced report Prompts
  • Creating, formatting and saving metrics
  • Microstrategy OLAP services in desktop
  • Report Objects
  • View filters
  • Derived Metrics
  • Smart Metrics
  • Level Metric
  • Transformation Metric
  • Conditional metric
  • Creating and saving prompts & searches
  • Consolidations and Custom Group
  • Exporting Report

OLAP Services

  • Creating Intelligent Cube
  • Publishing Intelligent Cube
  • Creating Intelligent Cube Reports
  • Derived Elements(List,Calculation,Filters)
  • Dynamic Aggregation
  • Dynamic Sourcing

Report Performance Tuning

  • Report Data Options
  • Aliasing
  • Report Limit
  • Attribute Join Type
  • Metric Join Type
  • VLDB Properties

Microstrategy Architect

  • Introduction to Microstrategy Architect
  • The logical data model
  • The physical warehouse schema
  • Advance Data modeling and schema design
  • Many to many relationships
  • Introduction to project creation in Microstrategy architect
  • Creating Microstrategy facts
  • Creating Microstrategy attributes
  • Role attributes
  • Automatic and Manual Mapping
  • Creating Microstrategy hierarchies
  • Project configuration workshop

Microstrategy report services

  • Introduction to enterprise reporting
  • Document basics
  • Document design concepts
  • Useful design techniques

Microstrategy Intelligence server

  • Introduction to Microstrategy administration
  • Administration and query flow
  • Connectivity
  • Startup and administration interface
  • Security
  • Microstrategy intelligence server administration
  • Caching and scheduling
  • Datamarts
  • Clustering

Microstrategy Distribution Services

  • Creating Subscription
  • Scheduling Subscription
  • Subscribing User and User Groups

Microstrategy Administration

  • MSTR Installation
  • Object manager
  • Project duplication
  • Groups and user creation
  • Command manager

Microstrategy web Basics

  • Exposure to mstr10
  • New concepts included in mstr10
  • Document Creation in Web
  • Dashboard Creation in Web.
  • Custom Groups in Web
  • Metric Creation in Web
  • Prompt Creation in Web.

Microstrategy Web Advanced

  • Creating Documents and Dashboard.
  • Different View and Execution Modes.
  • Creating Documents and dashboard using slice n Dice Concepts.
  • Inserting Panel Stacks, Layouts, Selectors and widget in Documents and Dashboard.

Microstrategy Web Visual Insights

  • Adding External data from various sources to create dashboard.
  • Importing Dashboards
  • Exporting Dashboards.
  • Data blending.
  • Linking Different attributes.

Microstrategy Interview Questions and Queries.