Overview of Microstrategy
Microstrategy training makes you expert in Microstrategy tool for creating reports and dashboards. Training covers Microstrategy architecture, Microstrategy schema objects through Microstrategy Web and Desktop.
In this training, you will learn
- Microstrategy Installation and mstr configuration
- The concepts of Data warehousing and Microstrategy architecture
- Master Microstrategy analytics desktop objects and schemas
- Microstrategy analytics and reporting
- Microstrategy hierarchy and grouping
- Creation of facts, attributes and schema objects
- Integrating social media and analytics data through “data wrangling”
- MicroStrategy security filter and performance tuning
Duration
4 Days
Prerequisite for Microstrategy
No specific skills are required to take up this Microstrategy certification course.
Course Outline for Microstrategy
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
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.
- Documents Creation and dashboard usage slice n Dice Concepts.
- Insert Panel Stacks, Layouts, Selectors and widget in Documents and Dashboard.
Microstrategy Web Visual Insights
- Addition of External data from various sources to create a dashboard.
- Importing Dashboards
- Exporting Dashboards.
- Data blending.
- Linking Different attributes.