Course Content

1. An Introduction to MicroStrategy 10
o Introduction to MicroStrategy
o MicroStrategy Architecture
o MicroStrategy Developer,
o Folder components
o MicroStrategy Web
2. Working with the MicroStrategy Admin
o MicroStrategy Installation
o MicroStrategy Configuration & Connectivity With Database
o Understanding to Intelligence Server
o Configuration of Server & metadata
o Configuring project source
o Creating projects
o Start/stop/re-start of server
o Role of metadata
o Configuring database instance & connection
3. Working with the MicroStrategy Architect
o Introduction to MicroStrategy Architect
o The Logical Data Model
o The Physical Model / Data Warehouse Schema
o Browsing warehouse catalog
o Importing Tables & their components
o Creating Facts
o Creating Attributes
o Creating Hierarchies
o Creating Transformations
o Attribute Relationships
o Schema Update
o Dashboard Creation
o Custom Groups
o Metric Creation
o Prompt Creation
4. Working with the MicroStrategy Developer
o Introduction To Micro strategy Developer,
o Folder Structure,
o Folder Management,
o My Personal Objects,
o Report components
o Creating Metrics (all types)
o Creating filters (all types)
o Creating prompts (all types)
o Report style manipulations
o Report Data manipulations
o Report view modes
o Graph & properties
o Templates
o Sorting
o Auto Styles
o Outline Mode
o Formatting Changes
o Threshold
o Custom Total
o Exporting Report
o View filters
o Derived Metrics
o Smart Metrics
o Level Metric
o Transformation Metric
o Conditional metric
o Creating and saving prompts & searches
o Consolidations and Custom Group
5. Working with the MicroStrategy Report Performance Tuning
o Report Data Options
o Report Limit
o Attribute Join Type
o Metric Join Type
o VLDB Properties
6. Working with the MicroStrategy Web
o Introduction to enterprise reporting
o Document basics
o Document design concepts
o Useful design techniques
o Document Creation
o Different View and Execution Modes
o Inserting Panel Stacks ,Layouts ,Selectors and widget in Documents
7. Working with the MicroStrategy OLAP Services
o Creating Intelligent Cube
o Publishing Intelligent Cube
o Creating Intelligent Cube Reports
o Derived Elements(List, Calculation, Filters)
o Dynamic Aggregation
o Dynamic Sourcing
8. Working with the MicroStrategy OLAP Services
o Creating Subscription
o Scheduling Subscription
o Subscribing User and User Groups
9. Working with MicroStrategy Visual Insights
o Adding External data from various sources to create dashboard.
o Importing Dashboards
o Exporting Dashboards.
o Data blending.
o Linking Different attributes
10. Working with MicroStrategy Object manager
o Introduction to Object Manager
o Object Package Creation
o Object Package Deployment
o Undo Package