Microstrategy
Overview
This MicroStrategy training makes participants expert in the MicroStrategy tool for creating reports and dashboards. This training covers MicroStrategy architecture and schema objects through its Web and Desktop. In this training, participants will learn-
- Installation and mstr configuration
- The concepts of Data warehousing and also about MicroStrategy architecture
- Master MicroStrategy analytics, the desktop objects and schemas
- MicroStrategy’s analytics and reporting
- MicroStrategy’s hierarchy and grouping
- Creation facts, schema objects, attributes
- “data wrangling” : Integrating social media and analytics data through
- MicroStrategy security filter and performance tuning
4 Days
Pre-Requisites
Not Applicable
Course Outline
- Database Concepts
- DW Definition
- Type of Tables
- Star Schema
- Snow Flake Schema
- 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
- 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
- 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
- Creating Intelligent Cube
- Publishing Intelligent Cube
- Creating Intelligent Cube Reports
- Derived Elements (List, Calculation, Filters)
- Dynamic Aggregation
- Dynamic Sourcing
- Report Data Options
- Aliasing
- Report Limit
- Attribute Join Type
- Metric Join Type
- VLDB Properties
- Introduction to MicroStrategy Architect
- The logical data model
- The physical warehouse schema
- Advance Data modelling and schema design
- Many to many relationships
- Introduction: Creating project in MicroStrategy architect
- Creating MicroStrategy facts
- Creating MicroStrategy attributes
- Role attributes
- Automatic and Manual Mapping
- Creating MicroStrategy hierarchies
- Project configuration workshop
- Introduction to enterprise reporting
- Document basics
- Document design concepts
- Useful design techniques
- Introduction to MicroStrategy administration
- Administration and query flow
- Connectivity
- Start-up and administration interface
- Security
- MicroStrategy intelligence server administration
- Caching and Scheduling
- DataMart’s
- Clustering
- Creating Subscription
- Scheduling Subscription
- Subscribing User and User Groups
- MSTR Installation
- Object manager
- Project duplication
- Groups and user creation
- Command manager
- 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
- Creating Documents and Dashboard.
- Different View and Execution Modes.
- Documents Creation, dashboard usage slice and Dice Concepts.
- Insert Panel Stacks, Layouts, Selectors and widget in Documents and Dashboard
- Addition of External data from various sources to create a dashboard.
- Importing Dashboards
- Exporting Dashboards.
- Data blending.
- Linking Different attributes