MICRO STRATEGY COURSE DESCRIPTION AND DETAILS


 

DATA WAREHOUSE(DWH) CONCEPTS

  • Introduction to DWH
  • Need for DWH in Real time
  • DWH Life Cycle
  • OLTP & OLAP Databases
  • Dimension types
  • Fact Types
  • Data Marts
  • Granularity

MICROSTRATEGY INTRODUCTION

  • Introduction to MicroStrategy
  • Business Intelligence
  • MicroStrategy Architecture
  • Introduction to MicroStrategy Desktop, MicroStrategy Iserver and Metadata
  • Report Execution flow

MICROSTRATEGY BASIC ADMIN & ARCHITECT

  • MSTR Installation
  • Metadata ODBC Connection
  • Populating Metadata Tables
  • Creation of Project Source
  • Creation of DBI
  • Creation of Project
  • Introduction to MSTR Architect
  • Loading Tables into Project Creation of simple Attributes
  • Creation of simple Attributes
  • Creation of simple Facts
  • Creation of Hierarchies
  • Creation of Attributes
  • Attribute Types
  • Creation of Hierarchies
  • Creation of Transformations

CONFIGURATION OBJECTS

  • User and User Group Creation
  • Types of Caches
  • Subscriptions
  • Jobs Monitoring
  • Object Manager
  • Introduction to Project Merge
  • Command Manager
  • Enterprise Manager
  • Integrity Manager
  • Introduction to NCS

ADD ONS

  • 100% Placement Assistance
  • Real Time Overview
  • Interview Tips
  • FAQs
  • Resume Preparation
  • SDLC Overview
  • Agile Project Methodology
  • SQL Tuning Techniques
  • Performance Tuning

PUBLIC OBJECTS(DEVELOPER)

  • Report sections
  • Different Views of Report
  • Creating and Saving Reports in Desktop
  • Types of Filteres
  • Types of Metrics
  • Consolidation
  • Custom Groups
  • Prompts
  • Drill Maps
  • Templates
  • Autostyles
  • Searches
  • Formatting Grids

    • Report Data Options
    • Grid Options
    • Thresholds
    • Page By
    • Sorting

  • I Cubes & Reporting on I Cube
  • OLAP Services
  • Introduction to Documents
  • Sections in Documents
  • Introduction to Dashboards
  • Visulization in Dashboards
  • Building interactive Dashboards
  • Advanced Dashboards
  • Visual Insight Dashboards
  • Mobile Dashboards

SCHEMA OBJECTS (ARCHITECT)

  • Introduction to Architect
  • Project tables & Hierarchical View
  • Loading Tables into MSTR
  • Logical Data Modelling
  • Creation of Facts
  • Fact Types