Courses
Browse

MicroStrategy Developer and Administrator Training (Free Data Warehousing and ERwin Course)

Our MicroStrategy certification master’s program lets you gain proficiency in MicroStrategy Developer and Administrator. You will work on real-world projects in MicroStrategy Desktop, Server administration, architecture, designing schema objects, data modeling, BI Reports, Dashboards, ODBC, Cubes, Cache, security, and filter.

Free Data Warehousing and ERwin course

Key Features

24 Hrs Self-paced Videos
48 Hrs Project work & Exercises
Certification and Job Assistance
Flexible Schedule
Lifetime Free Upgrade
24 x 7 Lifetime Support & Access

About MicroStrategy Developer and Administrator Course

In this combo course, you will master the concepts of the most powerful and agile Business Intelligence and Analysis software tool, MicroStrategy. This course provides you in-depth learning in MicroStrategy Developer and Administrator roles. Some of the topics included in this course are multidimensional data modeling with levels, measures and hierarchies, along with admin topics like ODBC data source administration, Cubes, Caches and so on. You will also learn MicroStrategy services, security, filters, etc. in this combo course.

What will you learn in this training course?

  1. Business Intelligence overview
  2. Difference between OLAP and OLTP
  3. Application, configuration and schema of objects
  4. MicroStrategy Filter Reports and Prompts
  5. MicroStrategy Admin Architecture
  6. iServer and ways to start and restart it
  7. Intelligent Cubes creation and monitoring
  8. Security Model and warehouse authentication
  9. MicroStrategy Object Manager
  • Software Architects, ETL Developers and Data Analysts
  • Business Intelligence Professionals
  • Those looking for a career in BI and Administration

A basic idea of data analytics is beneficial while taking up this course.

MicroStrategy is a powerful Business Intelligence tool that is placed in the ‘Leaders’ quadrant in the Gartner Magic Quadrant for Business Intelligence and Analytics Platform. This combo training course will equip you with skills to take up jobs either as a Developer or as an Administrator in this Business Intelligence platform. This can help you get high-paying jobs in some of the best companies.

View More

Talk to us

Course Fees

Self Paced Training

  • 24 Hrs e-learning videos
  • Lifetime Free Upgrade
  • 24 x 7 Lifetime Support & Access
$320
$0

Corporate Training

  • Customized Learning
  • Enterprise grade learning management system (LMS)
  • 24x7 support
  • Strong Reporting

Course Content

MicroStrategy Course Content

MicroStrategy Introduction & Installation preview videos

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

Self Paced

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

MicroStrategy Admin Course Content

What is MicroStrategy?, Microstrategy Architecture, Two-tier architecture, Three-tier architecture, Four-tier architecture, Report Execution Flow, Element browsing, Object browsing, Clustering, ODBC connection creation, ODBC drivers for MSTR, ODBC data source administration, Server definition windows, Project source, Web and I server Connectivity

Database Instance, Commands to create dl,dc and dL, Health center, Master health agent, Admin Interface, Components of MSTR, How to restart Server?, Administration menu, History list messages, History list setting, Caching, Report Cache flow, Reporting caching example, Intelligent cubes, Difference bw cubes and caches, Intelligent cubes example, Monitor intelligent cube, Intelligent cube status

Incremental refresh of intelligent cubes, Intelligent cube refresh settings, Dynamic Sourcing, How to create intelligent cube?, Clustering, Clustering in microstrategy, Cluster Node Monitor, Caching in clustering, Local Caching, Pros and cons of Local Caching, Centralized Caching, Scheduling, Time based Schedule, Command manager Script to trigger events, History list subscriptions, Microstrategy distribution Services, Transmitters, Generic email device, File Device, Email delivery notification, Security

Controlling access to the data, Scenario: Normal, connection mapping scenario, Creating and assigning configuration mapping, Warehouse authentication, Security filters, Apply filter on an attribute, Controlling access to application, How to directly assigning privileges to users/groups?, Command manager commands, Access control list permissions, ACL(Access control list), Microstrategy web:Administration, Web Preferences,diagnostics,License manager

DATA Mart report creation, Edit the subscription

Narrowcast server, Narrowcast server components, Narrowcast Administrator, Delivery Engine, Subscription portal, Narrowcast server Configure, Service components, Registering the target system, Update Intelligence server Reference, Upgrading the copied narrowcast server, How to Update Repository?

Object Manager

View More

Free Career Counselling

MicroStrategy Developer and Administrator Projects

What projects I will be working on this MicroStrategy training?

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.

Project : MicroStrategy Cube Administration, Maintenance and Security

Industry : General

Problem Statement : How to deploy Intelligent Cubes for various applications

Topics : In this project you will be working on MicroStrategy intelligent cubes which are multi-dimensional cubes that are shared as a single in-memory copy. Learn to create email and file subscriptions using Intelligent Cubes, perform reporting and data analysis, work with Server and automate administrative tasks with MicroStrategy Command Manager, secure and configure user groups. Upon completion of the project you will be well-versed in administrating, maintaining and securing MicroStrategy.

Highlight :

  • Use OLAP service features on Reports
  • Microstrategy administration task automation
  • Deploying Microstrategy Command Manager.
View More

MicroStrategy Developer and Administrator Certification

This course is designed for clearing two certifications:

  • MicroStrategy Certified Application Administrator Exam
  • MicroStrategy Certified Developer Exam

The entire course content is in line with the certification program and helps you clear it with ease and get the best jobs in top MNCs. As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly.

At the end of this training program, there will be quizzes that perfectly reflect the type of questions asked in the respective certification exams and help you score better.

Intellipaat Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 60% marks in the quiz. Intellipaat certification is well recognized in top MNCs like Ericsson, Cisco, Cognizant, Sony, Wipro, Standard Chartered, TCS, Genpact, Tata Communication, etc.

Our Alumni works at top 3000+ companies

client-desktop client-mobile

MicroStrategy Developer and Administrator Review

 course-reviews

Mr Yoga

 course-reviews

John Chioles

 course-reviews

Ritesh

 course-reviews

Dileep & Ajay

Ashwani Kumar

System Engineer at Cisco Systems

Intellipaat has an excellent methodology; the entire session was planned in a way to meet every need of the industry and was really helpful to expertise on every minute concept of the tool. Kudos to the team Intellipaat and cheers to the trainer!

Nitin singh

BI Analyst at Intel Security

The course was great and informative. Every lecture was detailed and industry-oriented, and the entire session covered topics from the very basics to the advanced concepts.

Frequently Asked Questions on MicroStrategy Developer and Administrator

Why Should I Learn This Combo Course from Intellipaat?

Intellipaat is a leader in providing Business Intelligence training. This is an industry-designed MicroStrategy training that includes both the Developer and Administrator components. You will be trained in database connections, ODBC data source administration, and working with interactive dashboards, scorecards, and reports in order to derive valuable business insights. The entire training is in line with clearing two exams: MicroStrategy Certified Developer and MicroStrategy Certified Application Administrator.

You will be working on real-time projects and step-by-step assignments that have high relevance in the corporate world, and the course curriculum is designed by industry experts. Upon the completion of the training course, you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 support and course material upgrading to the latest version at no extra fee. Hence, it is clearly a one-time investment.

At Intellipaat you can enroll either for the instructor-led online training or self-paced training. Apart from this Intellipaat also offers corporate training for organizations to upskill their workforce. All trainers at Intellipaat have 12+ years of relevant industry experience and they have been actively working as consultants in the same domain making them subject matter experts. Go through the sample videos to check the quality of the trainers.
Intellipaat is offering the 24/7 query resolution and you can raise a ticket with the dedicated support team anytime. You can avail the email support for all your queries. In the event of your query not getting resolved through email we can also arrange one-to-one sessions with the trainers. You would be glad to know that you can contact Intellipaat support even after completion of the training. We also do not put a limit on the number of tickets you can raise when it comes to query resolution and doubt clearance.
Intellipaat offers the self-paced training to those who want to learn at their own pace. This training also affords you the benefit of query resolution through email, one-on-one sessions with trainers, round the clock support and access to the learning modules or LMS for lifetime. Also you get the latest version of the course material at no added cost. The Intellipaat self-paced training is 75% lesser priced compared to the online instructor-led training. If you face any problems while learning we can always arrange a virtual live class with the trainers as well.
Intellipaat is offering you the most updated, relevant and high value real-world projects as part of the training program. This way you can implement the learning that you have acquired in a real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning and practical knowledge thus making you completely industry-ready. You will work on highly exciting projects in the domains of high technology, ecommerce, marketing, sales, networking, banking, insurance, etc. Upon successful completion of the projects your skills will be considered equal to six months of rigorous industry experience.
Intellipaat actively provides placement assistance to all learners who have successfully completed the training. For this we are exclusively tied-up with over 80 top MNCs from around the world. This way you can be placed in outstanding organizations like Sony, Ericsson, TCS, Mu Sigma, Standard Chartered, Cognizant, Cisco, among other equally great enterprises. We also help you with the job interview and résumé preparation part as well.
You can definitely make the switch from self-paced to online instructor-led training by simply paying the extra amount and joining the next batch of the training which shall be notified to you specifically.
Once you complete the Intellipaat training program along with all the real-world projects, quizzes and assignments and upon scoring at least 60% marks in the qualifying exam; you will be awarded the Intellipaat verified certification. This certificate is very well recognized in Intellipaat affiliate organizations which include over 80 top MNCs from around the world which are also part of the Fortune 500 list of companies.
Apparently, No. Our Job Assistance program is aimed at helping you land in your dream job. It offers a potential opportunity for you to explore various competitive openings in the corporate world and assists you in finding a well-paid job, matching your profile. The final decision on your hiring will always be based on your performance in the interview and the requirements of the recruiter.
View More

Talk to us

Select Currency