MICRO STRATEGY

Length: I Class (1 Hour)

Duration – 30 days

Audience:

• Anyone who wants to start his/her career as a Micro Strategy Administrator / Developer / Consultant.
• Anyone working on technologies which are doing not so good in the market like Mainframes, SAP, Siebel, Oracle, Java, Microsoft .Net
• Business Intelligence Architecture

Student Location– To students from around the world

Delivery Method: Instructor-Led – Live online Training

Introduction to Data Warehousing

• What is a Database and why do we need a Database
• Mechanism used in RDBMS (OLTP)
• How OLTP system Works
• What is a Data Warehouse
• Who will use Data Warehouse?
• Mechanism used in Warehouse (OLAP)
• How OLAP System Works?
• Types of Systems and their Differences
  • OLTP
  • OLAP
• Data Warehousing Life Cycle

Introduction to Business Intelligence

• What is a Database and why do we need a Database
• What is Business Intelligence
• Business Intelligence Architecture

Introduction to MicroStrategy Business Intelligence

• What is a Database and why do we need a Database
• Features/Components of MicroStrategy
• MicroStrategy BI Architectures
  • 2 Tier Architecture
  • 3 Tier Architecture
  • 4 Tier Architecture
• Types of Engines in MicroStrategy
  • SQL Engine
  • Query Engine
  • Analytical Engine
• Report Execution Flow in MicroStrategy
• Roles in MicroStrategy
  • Architect
  • Designer/Developer
  • Administrator
• Objects in MicroStrategy
• Configuration Objects
• Schema Objects
• Application/Public Objects

Introduction to MicroStrategy Objects

I) Public Objects / Application Objects – Design & Development

• (a) Filters
  • Filter Qualification Types
  • Attribute to Attribute Filtering
  • Set Qualification Filters
  • Shortcut to Reports
  • Dynamic Dates
  • Joint Element List
  • Import Filter Elements
  • Set Qualifications
  • Exercises

• (b) Metrics
  • Simple Metrics
  • Smart Compound Metrics
  • Derived Metrics
  • Transformation Metrics
  • Conditional Metrics
  • Level Metrics
  • Non-aggregatable Metrics
  • Nested Metrics
  • Exercises

• (C) Prompts
  • Filter Definition Prompts
  • Objects Prompts
  • Level Prompts
  • Value Prompts
  • Exercises

• (d) Custom Groups & Consolidations
  • What is a Custom Group
  • Custom Groups and SQL Query
  • Custom Group Editor
  • What is Consolidation
  • Consolidation Elements
  • Consolidation Editor
  • Custom Groups vs. Consolidations
  • Exercises

• (f) Templates
  • What is a Template
  • How to create Templates
  • How templates useful for users
  • Exercises

• (g) Searches
  • Searches
  • What is a Search object
  • How to create Search Object
  • How search objects helps for users
  • Exercises

• (h) Reports
  • Simple Report
  • Report Data Manipulations
    • Drilling
    • Page by
    • Data Pivoting
    • Sub Totals
    • Sorting
    • Outline Mode
    • Printing and Exporting
    • Report Subscription

II) Schema Objects – Architect

• (a) Attributes
  • Creation of Attributes
  • Heterogeneous & Homogeneous Mappings
  • Simple Attribute
  • Compound Attribute
  • Implicit Attribute
  • Conditional Attribute
  • Exercises

• (b) Facts
  • Creation of Facts
  • Simple Facts
  • Derived Facts
  • Heterogeneous & Homogeneous Mappings
  • Fact Level Extensions
  • Exercises

• (C) Tables
  • Introduction to Logical Tables
  • Significance of Logical Table Size
  • Exercises

• (d) Transformations
  • Introduction Transformation
  • Types of Transformations
    • Table Based Transformations
    • Expression Based Transformations
  • Creation of Transformations
  • Exercises

• (e) Hierarchies
  • Introduction to Hierarchies
  • How Hierarchies helps in Reporting
  • Types of Hierarchies
    • System Hierarchy
    • User-Defined Hierarchy
  • Creation of Hierarchies

• (f) Documents
  • Introduction to Documents
  • Document Editor
  • Document Sections
  • Creating Documents

• (g) Dashboards
  • Introduction to Report Services Document
  • What is a Dashboard
  • Document Display Modes and Export Formats
  • Creating Dynamic Dashboards
  • Selectors
  • Widgets
  • OLAP Services in Dashboards
  • Exercises

• This Course includes both Basic and Advanced Reporting Features along with below mentioned Miscellaneous Features
  • Advanced OLAP Services – Intelligent Cubes
  • Derived Elements and Types
  • Report Data Options
  • VLDB Properties

III)Configuration Objects – System Administration

• (a) Administration Configuration & Security
  • Project Source & Project Setup Connectivity
    • Creating and configuring Project Source
    • Creating and configuring Metadata
    • Significance of Warehouse Database Instance
    • Creating WHDBI
    • Creating and Configuring Project using Project Creation Assistant Wizard

• (b) Administration Interface
  • System Administration
  • System Monitoring
  • Configuration Managers

• (C) Managing Users and Groups
  • Users and Groups Creation
  • Most Common Activities in User administration
  • Privileges and Permissions
  • Security Roles
  • Security Filters

• Administration Application Management
  • a) Object Manager
    • Duplication Wizard
    • Object Manager
    • Packages
  • b) Command Manager
    • Command Manager GUI
    • Executing Scripts and Commands in Command Manager

Fee :	400 USD
Batch Starts :	March 29th 2018
Timings :	7:00PM EST to 8:00PM EST