Microstrategy Training in Chennai

We are providing best Microstrategy training in Chennai with experienced professionals. Our Microstrategy training syllabus very depth and carrier oriented. Using this course you can learn Data Warehouse Concept and QlokView tool strength from MNC professionals.

Microstrategy is a leading Business Intelligence tool, it providing very powerful features to Data Mining and Predictive Analysis and Real time Dashboards. Using Microstrategy tool features, we can create more interactive Analytics Dashboard.

Orange TechnoMind provides real-time and placement focused Microstrategy training in Chennai, This course syllabus covers basic to advanced level and it helps to get the placement in any MNC companies. We designed Microstrategy training syllabus based on industry standard. Our trainers are experts and working professionals with hands on real time knowledges.

Using this course, you learns fundamental of Data Warehouse Concept and Design, basic concept on Microstrategy, Installation and Configuration, Microstrategy Reporting and Data Manipulation, OLAP Services and Scorecards and Dashboard. And also you learn best practice to follow while developing solution, Interview and Certification Tips.

Audience

Microstrategy course is designed for Data Warehouse Developers, Data Analytics Designer, Job Seekers and IT professionals who want to learn Data Analytics application using advanced technologies.

Microstrategy Course Syllabus

Introduction Data Warehouse

What is Data Warehouse?
Data Warehouse Definition
Features and Benefit of DWH
Understanding Data Warehouse Concept
Data Warehouse Design and Architecture
Explain on different types of Schema
OLTP vs OLAP
Dimensional and Fact Table design
Explain on Star Schema
Explain on Snow Flake Schema

Getting Start with MicroStrategy

Overview of Business Intelligence
Feature for organization
Trends of Business Intelligence
Introduction to MicroStrategy
Overview of MicroStrategy Product
Understanding on MicroStrategy Intelligence server
MicroStrategy Desktop
Explain on MicroStrategy Web Universal
Architecture of MicroStrategy
Data Layer
MicroStrategy report servers
MicroStrategy Distribution Services
Object Manager
Integrity Manager

Installation and Configuration

Discussion with Hardware and Software Requirements
System setting for operating system
ODBC drivers for MicroStrategy Server
Explain Graphical, Command line Installation
Types of licenses
Verify Installation
Configure Intelligence Server

MicroStrategy Basics

Create meta database
Create project in MicroStrategy
Create and Configure Data Source
Understanding on Schema Objects
Understanding on Public Objects
Explain on MicroStrategy Business Intelligence
Explain on MicroStrategy Developer and Architecture
Types of Objects
Configuration Objects

Working with MicroStrategy Reporting

Introduction to Reporting
Component of Report
Explain on Report Types
How to display Multiple Reports in Single Presentation
Format Grid and Graph Reports
Basic Report Creation
Understanding Analyzing Data
Apply sorting Data
Pivoting Data
Understanding Hierarchies
Metric Join
Control drilling behavior
Refreshing displayed data
Report Caches

Advanced Reporting and Data Manipulations

Create report using template and filter
How to create and save objects
Creating and saving Advanced Report Prompts
How to Calculate data on Reports
Formatting a Metric
Totals and Subtotals
Create / edit filter using Filter Editor
Filter data by Business Attributes
Joining Filter
Advanced Gris Reports
Create HTML Document for Reports
Exporting Report
Query Builder and Freeform SQL
Linking Reports and documents
VLDB Properties

MicroStrategy OLAP Services

Overview of OLAP Service
Benefits of using OLAP Service
Create Intelligent Cube
Sharing Intelligent Cubes
Enable ROLAP
Enable Dynamic Source
How to do Incremental Refresh
Create Intelligent Cube Reports
Explain different types of derived elements
Creating derived elements
Group and Filter derived elements
Using Dynamic Aggregation
Create / Delete view Filter
Dynamic Sourcing
Configure Dynamic Souring

Working Scorecards and Dashboards

Overview of Scorecards and Dashboards
Scorecards vs Dashboards
Design Dashboards
MicroStrategy Panels, Layouts and Visualization
Advanced Configuration on Dashboard
Building Scorecard
Dashboard building process
How to Share or publish BI Reports to Dashboards
Public Reports to Social Media like Facebook and Twitter
Build potable Dashboard
Stop / unshare the reports

Report Performance Tuning

Overview of Performance Tuning
Explain on Report Data Options
Aliasing
Set Limit on Report
Attribute Join Type
Metric Join Type
VLDB Properties

Security

Overview of Security on MicroStrategy
Understanding on Users and Groups
Roles and access permission on MicroStrategy
Object Permission
Deployment on Security Model
Best Practices on Security

Basic Administration on MicroStrategy

Overview of Administration
Manage Platform
Monitoring MicroStrategy
Deploying Enterprise Manager
System Manager Overview
Activating change Journal

MicroStrategy Troubleshooting

Explain experienced issues and solving methods
MicroStrategy Community
How to setup Health Center
Understanding Diagnostics on MicroStrategy
Troubleshooting the MicroStrategy Web / Desktop / Office Evaluation
Support from product