Microstrategy
Module 1: Introduction Data Warehouse
- What is Data Warehouse?
- Data Warehouse Definition
- Features and Benefit of DWH
- Understanding Data Warehouse Concept
- Data Warehouse Design and Architecture
- Explain on different types of Schema
- OLTP vs OLAP
- Dimensional and Fact Table design
- Explain on Star Schema
- Explain on Snow Flake Schema
Module 2: Getting Start with MicroStrategy
- Overview of Business Intelligence
- Feature for organization
- Trends of Business Intelligence
- Introduction to MicroStrategy
- Overview of MicroStrategy Product
- Understanding on MicroStrategy Intelligence server
- MicroStrategy Desktop
- Explain on MicroStrategy Web Universal
- Architecture of MicroStrategy
- Data Layer
- MicroStrategy report servers
- MicroStrategy Distribution Services
- Object Manager
- Integrity Manager
Module 3: Installation and Configuration
- Discussion with Hardware and Software Requirements
- System setting for operating system
- ODBC drivers for MicroStrategy Server
- Explain Graphical, Command line Installation
- Types of licenses
- Verify Installation
- Configure Intelligence Server
Module 4: MicroStrategy Basics
- Create meta database
- Create project in MicroStrategy
- Create and Configure Data Source
- Understanding on Schema Objects
- Understanding on Public Objects
- Explain on MicroStrategy Business Intelligence
- Explain on MicroStrategy Developer and Architecture
- Types of Objects
- Configuration Objects
Module 5: Working with MicroStrategy Reporting
- Introduction to Reporting
- Component of Report
- Explain on Report Types
- How to display Multiple Reports in Single Presentation
- Format Grid and Graph Reports
- Basic Report Creation
- Understanding Analyzing Data
- Apply sorting Data
- Pivoting Data
- Understanding Hierarchies
- Metric Join
- Control drilling behavior
- Refreshing displayed data
- Report Caches
Module 6: Advanced Reporting and Data Manipulations
- Create report using template and filter
- How to create and save objects
- Creating and saving Advanced Report Prompts
- How to Calculate data on Reports
- Formatting a Metric
- Totals and Subtotals
- Create / edit filter using Filter Editor
- Filter data by Business Attributes
- Joining Filter
- Advanced Gris Reports
- Create HTML Document for Reports
- Exporting Report
- Query Builder and Freeform SQL
- Linking Reports and documents
- VLDB Properties
Module 7: MicroStrategy OLAP Services
- Overview of OLAP Service
- Benefits of using OLAP Service
- Create Intelligent Cube
- Sharing Intelligent Cubes
- Enable ROLAP
- Enable Dynamic Source
- How to do Incremental Refresh
- Create Intelligent Cube Reports
- Explain different types of derived elements
- Creating derived elements
- Group and Filter derived elements
- Using Dynamic Aggregation
- Create / Delete view Filter
- Dynamic Sourcing
- Configure Dynamic Souring
Module 8: Working Scorecards and Dashboards
- Overview of Scorecards and Dashboards
- Scorecards vs Dashboards
- Design Dashboards
- MicroStrategy Panels, Layouts and Visualization
- Advanced Configuration on Dashboard
- Building Scorecard
- Dashboard building process
- How to Share or publish BI Reports to Dashboards
- Public Reports to Social Media like Facebook and Twitter
- Build potable Dashboard
- Stop / unshare the reports
Module 9: Report Performance Tuning
- Overview of Performance Tuning
- Explain on Report Data Options
- Aliasing
- Set Limit on Report
- Attribute Join Type
- Metric Join Type
- VLDB Properties
Module 10: Security
- Overview of Security on MicroStrategy
- Understanding on Users and Groups
- Roles and access permission on MicroStrategy
- Object Permission
- Deployment on Security Model
- Best Practices on Security
Module 11: Basic Administration on MicroStrategy
- Overview of Administration
- Manage Platform
- Monitoring MicroStrategy
- Deploying Enterprise Manager
- System Manager Overview
- Activating change Journal
Module 12: MicroStrategy Troubleshooting
- Explain experienced issues and solving methods
- MicroStrategy Community
- How to setup Health Center
- Understanding Diagnostics on MicroStrategy
- Troubleshooting the MicroStrategy Web / Desktop / Office Evaluation
- Support from product
Module 13: Case Studies on Cloud version of MicroStrategy
Module 14: Practices on MicroStrategy Best