MicroStrategy - Course Content

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
- AutoStyles
- Custom Groups
- Facts
- Tables
- Update Schema
 
 
Lab Setup:
- MicroStrategy: Installation
 
 
 
MicroStrategy Desktop: Reporting Essentials
 
- Introduction t- MicroStrategy Business Intelligence
- Introduction t- 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 t- 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 t- MicroStrategy Architect
- The Logical Data Model
- The physical Warehouse Schema
- Advanced Data Modeling and Schema Design
- Introduction t- Project Creation in MicroStrategy Architect
- Creating MicroStrategy Facts
- Creating MicroStrategy Attributes
- Creating MicroStrategy Hierarchies
- Project configuration Workshop        
 
 
MicroStrategy Web
 
- Connect t- 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