MicroStrategy

MicroStrategy Training 

Course Description 

Introduction

  • Business Intelligence
  • OLAP
  • Architecture of OLAP
  • What are Different Types of OLAP’s
  • Introduction of BI tools
  • Database Overview

Introduction of MicroStrategy

  • MicroStrategy Desktop
  • MicroStrategy Architecture
  • MicroStrategy Web
  • MicroStrategy Servers
  • Administration
  • Folder Structure
  • My Personal Objects
  • Public Object
  • Schema Object
  • Metadata
  • Report View
  • Data – Export
  • Auto Styles
  • Custom Groups
  • Facts
  • Tables
  • Update Schema

Lab Setup

  • MicroStrategy: Installation

MicroStrategy Desktop: Reporting Essentials

  • Introduction to MicroStrategy Business Intelligence
  • Introduction to MicroStrategy Desktop
  • Creating and Saving Reports in Desktop
  • Report Manipulations in Desktop
  • Data Manipulations
  • Style Manipulations
  • Creating and Saving Basic Report Filters
  • Creating, Formatting and Saving Basic Metrics
  • MicroStrategy OLAP Services in Desktop
  • Report Objects
  • View Filters
  • Derived Metrics
  • Creating and Saving Basic Prompts and Searches

MicroStrategy Desktop: Advanced Reporting

  • Introduction to Advanced Reporting
  • Advanced Metrics
  • Advanced Filters
  • Consolidations and Custom Groups
  • Advanced Prompts
  • Advanced OLAP services
  • Drill Maps
  • Report Data Options
  • Report Developer Tools

MicroStrategy Architect: Project Design

  • Introduction to MicroStrategy Architect
  • The Logical Data Model
  • The physical Warehouse Schema
  • Advanced Data Modelling and Schema Design
  • Introduction to Project Creation in MicroStrategy Architect
  • Creating MicroStrategy Facts
  • Creating MicroStrategy Attributes
  • Creating MicroStrategy Hierarchies
  • Project configuration Workshop

MicroStrategy Web

  • Connect to MSTR Web
  • Configure I-Server and Create Reports
  • Create Objects (Filter, Prompts) using Web

MicroStrategy Report Services Documents

  • Creating a Document using existing report
  • Create Dashboards – Workshop

MicroStrategy Administrator

  • Basic Administration tasks
  • User Management
  • Roles and Security Management, Project Access
  • MicroStrategy Security Filters

Comments are closed