MicroStrategy

Reading Time: 3 minutes

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