Microstrategy Online Training

Microstrategy Online Training By IT Experts

Vision Online Training facility offers Microstrategy Online Training. Our Microstrategy trainers come with vast work experience and teaching skills. Our Microstrategy training online is regarded as the one of the Best online training in India. All our students were happy and able to find Jobs quickly in USA, UK, Singapore, Japan, Europe. Microstrategy training online is your one stop solution to learn Microstrategy at the comfort of your home with flexible schedules.

Vision Online Training offers the Microstrategy Online Course in a true global setting.

Microstrategy Online Training Concepts :

Ø Introduction to Data Warehousing

  1. What is a Database and why do we need a Database
  2. Mechanism used in RDBMS (OLTP)
  3. How OLTP system Works
  4. What is a Data Warehouse
  5. Who will use Data Warehouse?
  6. Mechanism used in Warehouse (OLAP)
  7. How OLAP System Works?
  8. Types of Systems and their Differences
    1. OLTP
    2. OLAP
  9. Data Warehousing Life Cycle
  10. Data Warehousing Testing Life Cycle
  11. Phases of Data Warehouse

Ø Introduction to Business Intelligence

  1. What is Business Intelligence
  2. Business Intelligence Architecture
  3. 5 Styles of Business Intelligence

Ø Introduction to MicroStrategy Business Intelligence

  1. Introduction to MicroStrategy Business Intelligence
  2. Features/Components of MicroStrategy
  3. MicroStrategy BI Architectures
    1. 2 Tier Architecture
    2. 3 Tier Architecture
    3. 4 Tier Architecture
  4. Types of Engines in MicroStrategy
    1. SQL Engine
    2. Query Engine
    3. Analytical Engine
  5. Report Execution Flow in MicroStrategy
  6. Roles in MicroStrategy
    1. Architect
    2. Designer/Developer
    3. Administrator
  7. Objects in MicroStrategy
    1. Configuration Objects
    2. Schema Objects
    3. Application/Public Objects

Ø Introduction to MicroStrategy Objects

i) Schema Objects – Architect

(a) Attributes

  1. Creation of Attributes
  2. Heterogeneous & Homogeneous Mappings
  3. Simple Attribute
  4. Compound Attribute
  5. Implicit Attribute
  6. Explicit Attribute
  7. Conditional Attribute
  8. Exercises

(b) Facts

  1. Creation of Facts
  2. Simple Facts
  3. Derived Facts
  4. Heterogeneous & Homogeneous Mappings
  5. Fact Level Extensions
  6. Exercises

(c) Tables

  1. Introduction to Logical Tables
  2. Significance of Logical Table Size
  3. Exercises

(d) Transformations

  1. Introduction Transformation
  2. Types of Transformations
    1. Table Based Transformations
    2. Expression Based Transformations
  3. Creation of Transformations
  4. Exercises

(e) Hierarchies

  1. Introduction to Hierarchies
  2. How Hierarchies helps in Reporting
  3. Types of Hierarchies
    1. System Hierarchy
    2. User-Defined Hierarchy
  4. Creation of Hierarchies

ii) Public Objects / Application Objects – Design & Development

(a) Filters

  1. Filter Qualification Types
  2. Attribute to Attribute Filtering
  3. Set Qualification Filters
  4. Shortcut to Reports
  5. Dynamic Dates
  6. Joint Element List
  7. Import Filter Elements
  8. Set Qualifications
  9. Exercises

(b) Metrics

  1. Simple Metrics
  2. Smart Compound Metrics
  3. Derived Metrics
  4. Transformation Metrics
  5. Conditional Metrics
  6. Level Metrics
  7. Non-aggregatable Metrics
  8. Nested Metrics
  9. Base Formulas
  10. Exercises

(c) Prompts

  1. Filter Definition Prompts
  2. Objects Prompts
  3. Level Prompts
  4. Value Prompts
  5. Exercises

(d) Custom Groups & Consolidations

  1. What is a Custom Group
  2. Custom Groups and SQL Query
  3. Custom Group Editor
  4. Custom Group Banding
  5. What is Consolidation
  6. Consolidation Elements
  7. Consolidation Editor
  8. Custom Groups vs. Consolidations
  9. Exercises

(f) Templates

  1. What is a Template
  2. How to create Templates
  3. How templates useful for users
  4. Exercises

(g) Searches

  1. What is a Search object
  2. How to create Search Object
  3. How search objects helps for users
  4. Exercises

(h) Reports

  1. Simple Report
  2. Report Data Manipulations
    1. Drilling
    2. Page by
    3. Data Pivoting
    4. Sub Totals
    5. Sorting
    6. Outline Mode
    7. Printing and Exporting
    8. Report Subscription
  3. Report Style Manipulations
    1. Formatting
    2. Threshold
    3. Banding
    4. Locking and Resizing Columns
    5. Graph Properties
  4. Exercises

(i) Documents

  1. Introduction to Documents
  2. Document Editor
  3. Document Sections
  4. Grouping Section and Properties (Custom Section)
  5. Creating Documents

(j) Dashboards

  1. Introduction to Report Services Document
  2. What is a Dashboard
  3. Document Display Modes and Export Formats
  4. Document Subscriptions
  5. Creating Dynamic Dashboards
  6. Selectors
  7. Widgets
  8. OLAP Services in Dashboards
  9. Exercises

This Course includes both Basic and Advanced Reporting Features along with below mentioned Miscellaneous Features

a. Advanced OLAP Services – Intelligent Cubes

b. Derived Elements and Types

c. Data Mart Reports

e. Report Data Options

f. VLDB Properties

iii) Configuration Objects – System Administration

(1) Administration Configuration & Security

  1. Project Source & Project Setup Connectivity
  1. Creating and configuring Project Source
  2. Creating and configuring Metadata
  3. Significance of Warehouse Database Instance
  4. Creating WHDBI
  5. Creating and Configuring Project using Project Creation Assistant Wizard

(b) Administration Interface

  1. System Administration
  2. System Monitoring
  3. Configuration Managers
  4. Delivery Managers

(c) Managing Users and Groups

  1. Users and Groups Creation
  2. Most Common Activities in User administration
  3. Privileges and Permissions
  4. Security Roles
  5. Security Filters

(d) Authentication

  1. Modes available in Authentication
  2. Authentication Modes Significance

(k) Schedules and Subscriptions Administration

(i) Scheduling Types

  1. Time Based Schedules
  2. Event Based Schedules

(l) MicroStrategy Report Distribution services Administration

Configuration Considerations

Configuring Distribution Services

1. Transmitters

2. Devices

3. Schedules

4. Users and Contacts

(2) Administration Application Management

a)      Object Manager

  1. Duplication Wizard
  2. Object Manager
  3. Packages

b)      Command Manager

  1. Command Manager GUI
  2. Executing Scripts and Commands in Command Manager
  3. Most Commonly performing Administration Activities and Tasks

c)       Integrity Manager

  1. Integrity Manager Overview
  2. Integrity Manager Tests

Our Microstrategy Online Training batches start every week and we accommodate your flexible timings.

Vision Trainings provides online training for various courses like Datastage Online Training,Taradata Online Training,Pentaho Online Training,BOXI Online Training

Home    About Us    Contact Us    Sitemap