MICRO STRATEGY COURSE DETAILS – 9.X
1. Introduction to Data Warehousing -------------------------1.0 Hrs
OLAP
OLTP
Data Warehousing Architecture
Star Schema
Snowflake Schema
Hybrid Schema
- Purpose of Data Warehousing ------------------------------ 0.5Hrs
- Micro Strategy Architecture ---------------------------------0.5 Hrs
- Micro Strategy Products ------------------------------------0.5 Hrs
- Micro Strategy Desktop
Installing Mstr in to desktop ----------------------------- ---0.5 Hrs
Schema Objects
Attributes------------------------------------------------3.0 Hrs
Creation of Attribute
Simple Attribute
Compound Attribute
Pass-through Functions
Facts ----------------------------------------------------2 Hrs
Creation of Fact
Column Alias
Fact entry Level
Hierarchies --------------------------------------------- 0.5 Hrs
System Hierarchy
User Hierarchy
Entry Points
Tables ---------------------------------------------------1 Hr
Logical Table
Table Alias
Logical View
Transformations ----------------------------------------1.0 Hrs
Expression Based
Table Based
Public Objects
Auto styles -------------------------------------------0.25Hrs
Consolidations --------------------------------------- 1.0 Hr
Creation of Consolidations
How to use
Virtual Attribute
Custom Groups ----------------------------------------1.0 Hr
Creation of Custom Groups
Difference with Consolidation and Custom Groups
Drill Maps --------------------------------------------- 1.0 Hr
Creation of Drill Maps
Purpose of Drill Maps
Filters ------------------------------------------------- 3.0 Hrs
Report Filter
View Filter
Advanced Filter
Pass-through Functions
Metrics ------------------------------------------------ 3.0 Hrs
Simple Metric
Compound Metric
Nested Metric
Prompts ----------------------------------------------- 4.0 Hrs
Prompted Filters
Object Prompt
Level Prompt
Value Prompt
Reports and searches---------------------------------- 1.0 Hr
Report Manipulations
Templates ---------------------------------------------- 1.0 Hr
- Micro Strategy Web --------------------------------------1.0 Hrs
- Documents and Static, Dynamic Dashboards ------------ 2.0 Hrs
- Introduction to Administration
Command Manager and Object Manager---------------- 1.0 Hr
P S: Each and Very topic in course content will be shown with live examples.
