Table of Contents:
1) Introduction to DW and Microstrategy Reporting
1.1) Types of tables in Data Warehouse
1.2) Keys in tables and relationship between tables
1.3) Types of Schemas (Star Schema and Snowflake Schema)
1.4) Types of Joins that Microstrategy Supports
1.5) Slowly Changing Dimensions in Datawarehouse
1.6) Data Modeling(Logical and Physical Data Modeling)
2) Microstrategy Architecture
1.1) What is Meant by metadata
1.2) Types of Architectures in Microstrategy
1.3) Different types of Engines and their Functionality
1.4) Projects and Project Sources and interaction of Microstrategy with metadata and data warehouse
3) Objects in Microstrategy
1.1) Schema Objects
1.2) Public Objects
1.3) Configuration Objects
4) Schema Objects
1.1) Tables and their Types
1.2) Attributes, Types and Parent Child relationship between attributes
1.3) Facts and their Types
1.4) Hierarchies and Types
1.5) Transformations and Types
1.6) Partition Mapping
1.7) Issues faced with Schema Objects and solutions (Role Attributes, Facts Extension,Heterogenous mapping)
5) Public Objects
1.1) Filters and their Functionality
1.2) Prompts and their Usages
1.3) Metrics and Types of Metrics
1.4) Level Metrics with examples
1.5) Custom Groups and Consolidations
1.6) Drill Maps and how Drilling works in Microstrategy
1.7)Templates and Autostyles
1.7) Documents
6) Freeform SQL reports in Microstrategy
7) Dashboards and Concepts of dashboards
1.1) Panels and Panel Stacks
1.2) Selectors and types
1.3) Types Of Widgets with examples
8) Intelligent Cubes
9) Configuration Objects
1.1) Basic Introduction about Database Instances,Users and User Groups
1.2) Subscriptions and Schedules
10) Microstrategy Web Introduction
11) Challenges Faced in Real Time