MicroStrategy Certification Training - Pune, India

1. Architecture of MicroStrategy
2. MicroStrategy installation and configuration
3. Working on the desktop objects and schemas
4. Analytics and reporting with MicroStrategy
5. Creating Facts, Attributes and Metrics

Enterprise Business Intelligence Professionals, Software Architects, ETL Developers, Analytics Managers and Data Specialists

You don’t need any specific skills to take up this MicroStrategy certification course.

Pune is a top Indian city when it comes to job opportunities for skilled technology professionals. Among the Business Intelligence tools, MicroStrategy is widely being deployed by organizations for extracting valuable business insights. Taking industry-designed training like Intellipaat MicroStrategy training can help you grab the best jobs in top companies.

The market in Pune for MicroStrategy is growing at a rapid pace, thanks to huge business development activities along with the high impetus given to enterprises for basing their businesses in this city. This positive market trend in MicroStrategy can be utilized by getting the right training like Intellipaat MicroStrategy training and certification in Pune.

• Worldwide Business Intelligence and Analytics market to grow to $22.8 billion in revenue in the next two years – Gartner
• MicroStrategy occupies the Leaders quadrant for the eighth year in a row for Business Intelligence and Analytics Platforms – Gartner
• A Senior MicroStrategy Developer in the United States can earn $112,000 – Indeed

Professionals can take up Intellipaat MicroStrategy training and certification and upgrade their skills to achieve highly lucrative job opportunities in best enterprises. MicroStrategy is today being deployed in a huge number of organizations making it highly desirable to take up the MicroStrategy training and excel at one’s career.

Introduction to MicroStrategy Business Intelligence tool, the various capabilities of MicroStrategy in data discovery, advanced analytics, enterprise reporting and dashboard functionality, detailed knowledge of installation of MicroStrategy.

Understand in detail about the Data Warehousing and Business Intelligence architecture, data sources, ETL process, loading data in EDW and data marts.

Learning how BI capability various at different levels, operational, adhoc and dashboard needs and solutions offered like grids and graphs.

Progression in analytical methods, various types models like summarization, trends, benchmarking, comparative analysis, optimization and predictions.

A detailed architecture of MicroStrategy including tools and services, data assets, schemas, metadata, public objects and information delivered via web, desktop and mobile.

MicroStrategy data flow architecture, the various types of setup like on-premise, cloud and mobile, understanding the need for data containers, customization using SDK, security for backend data containers and other offerings.

Learning about the various backend data support that MicroStrategy offers, seamless integration with relational databases and unstructured data storage.

Learning about the basic components and elements of schema, facts and dimensions, analyzing data and quantifying business elements.

Understanding about measures and metrics in a data warehouse schema.

Hands-on Exercise – Use measures and metrics in a data warehouse schema

The MicroStrategy foundation of logical data model and schema, its role in data warehouse and business intelligence, clear understanding of Star Schema, working with Facts and Dimensions Tables.

Hands-on Exercise – Create a Star Schema, Work with Facts and Dimensions Tables

Creation of Project Source in MicroStrategy, connecting with metadata database, detailed learning of MicroStrategy project, the first step to creating public and schema objects.

Hands-on Exercise – Create a Project Source in MicroStrategy, Connect with metadata database, Create public and schema objects

The significance of architect for the projects, a detailed demo of working with Architect for project, and creation of schema objects like Facts and Attributes.

Hands-on Exercise – creation of schema objects like Facts and Attributes.

Understanding how to create schema objects, data warehouse catalog, schema tables, creation and editing of Attributes and Facts, Schema update and its need.

Hands-on Exercise – Create schema objects, Use data warehouse catalog, Create schema tables, Create and edit of Attributes and Facts, Update a Schema

Learning about the need for creating folders, Attributes organization, getting a structured view of Facts and Attributes, mapping of Attributes depending on the folder in which they are located, defining navigation path using hierarchies and steps to creating hierarchies.

Hands-on Exercise – Creating folders, Organize Attributes, Get a structured view of Facts and Attributes, Map attributes depending on the folder in which they are located, Create hierarchies, Navigate to different places using hierarchies

Creation of basic metrics and level metrics, defining metrics using filters, studying the metrics generated by SQL when working with level dimensionality, detailed step by step process to create metrics.

Hands-on Exercise – Create basic metrics and level metrics, define metrics using filters

Learning about the step by step process for creating filters and the different options in creating filters.

Hands-on Exercise – Create filters and use different available options to change the filters

Understanding the different ways of creation of Prompts and its various uses.

Hands-on Exercise – Create different types of Prompts and use them

Learning how to create Search Objects, the usage of Search Objects in Prompts and

Hands-on Exercise – Create Search Objects, Use search objects in Prompts

The method to creating Consolidation Objects, the significance of them, learning through detailed demonstration, understanding the difference between Consolidation and Custom Groups (Doesn’t belong here. This line is present in Custom Groups also)

Hands-on Exercise – Create Consolidation Objects

Learning how to create Custom Groups and their distinction from Consolidation Objects, Custom Groups are a consequence of SQL queries and Consolidation Objects are functions of analytical engine, a detailed demonstration of steps needed for SQL query generation in Custom Groups.

Hands-on Exercise – Create Custom Groups, Generate SQL query in Custom Groups

Understanding Drill Maps creations, its significance, role of hierarchies in drill navigation, detailed demonstration of Drill Maps and Navigation.

Hands-on Exercise – Create a Drill Map, Use a map for analysis

Understanding partitioning, various type of data partitioning like homogenous and heterogeneous mapping, metadata and warehouse partitioning, a detailed demonstration of creating partition mapping in MicroStrategy.

Hands-on Exercise – Create a partition mapping in MicroStrategy

Clear understanding of how to create Reports using MicroStrategy Developer/Desktop, executing the Report, the various View types like Design, SQL and Grid, deploying View Filters and Report Editor, learning to work with Reports like creating and using Filters, Prompts, Sorts, Drill-down and Format.

Hands-on Exercise – Create and executing a Report command, Create a design view, Use a Grid view, Deploy View Filters and Report Editor, Create Reports by using using Filters, Prompts, Sorts, Drill-down and Format

Understanding the MicroStrategy Web Interface, learning about folder structure, Report deployment and other features.

Hands-on Exercise – Practice on MicroStrategy Web Interface, Deploy a Report generation

Learning about the MicroStrategy Dashboard created using Web Interface, importance of Visual Insight for Self-service Business Intelligence, creating dashboards on web in production environment.

Hands-on Exercise – Create a Dashboard using Web Interface

Understanding the MicroStrategy Intelligence Server, the various components like OLAP and Reporting, Distribution and Transaction Services, Clustering and Multisourcing, learning about the two tier and three tier architecture.

Hands-on Exercise – Use MicroStrategy Intelligence Server, Use Reporting, Distribution and Transaction Services, Make Cluster

Project– MicroStrategy Report

Data – Revenue Dataset

In this project you will be creating a complex MicroStrategy report based on the revenue dataset of a business organization. You will gain hands-on experience in working with schema objects, public objects, creation of dashboard and web interface. Learn to dice and slice the data using flexible reporting capabilities based on OLAP functionalities. The goal of the project is to predict the revenue using MicroStrategy Reports for particular country, call center, and category of product.