Master the concepts of most powerful and agile business intelligence and analysis software, MicroStrategy
About Microstrategy Developer and Administration Combo Course
This is a Combo Training Course that provides you in-depth learning in Microstrategy Developer and Administration roles. Some of the topics included are multidimensional data modeling with levels, measures and hierarchies along with admin topics like ODBC data source administration, Cubes, Caches and so on. Learn about Microstrategy services, security, filters, etc.
A basic idea of data analytics is beneficial.
Microstrategy is a powerful Business Intelligence Tool that is placed in the ‘Leaders’ Quadrant in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms. This Combo Training Course will equip you 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.
Topics: 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.
Topics: Understand in detail about the Data Warehousing and Business Intelligence architecture, data sources, ETL process, loading data in EDW and data marts.
Topics: Learning how BI capability various at different levels, operational, adhoc and dashboard needs and solutions offered like grids and graphs.
Topics: Progression in analytical methods, various types models like summarization, trends, benchmarking, comparative analysis, optimization and predictions.
Topics: A detailed architecture of MicroStrategy including tools and services, data assets, schemas, metadata, public objects and information delivered via web, desktop and mobile.
Topics: 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.
Topics: Learning about the various backend data support that MicroStrategy offers, seamless integration with relational databases and unstructured data storage.
Topics: Learning about the basic components and elements of schema, facts and dimensions, analyzing data and quantifying business elements.
Topics: Understanding about measures and metrics in a data warehouse schema.
Topics: 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.
Topics: Creation of Project Source in MicroStrategy, connecting with metadata database, detailed learning of MicroStrategy project, the first step to creating public and schema objects.
Topics: 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.
Topics: Understanding how to create schema objects, data warehouse catalog, schema tables, creation and editing of Attributes and Facts, Schema update and its need.
Topics: 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.
Topics: 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.
Topics: Learning about the step by step process for creating filters and the different options in creating filters.
Topics: Understanding the different ways of creation of Prompts and its various uses.
Topics: Learning how to create Search Objects, the usage of Search Objects in Prompts and
Topics: The method to creating Consolidation Objects, the significance of them, learning through detailed demonstration, understanding the difference between Consolidation and Custom Groups.
Topics: 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.
Topics: Understanding Drill Maps creations, its significance, role of hierarchies in drill navigation, detailed demonstration of Drill Maps and Navigation.
Topics: 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.
Topics: 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.
Topics: Understanding the MicroStrategy Web Interface, learning about folder structure, Report deployment and other features.
Topics: 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.
Topics: 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.
Project Work: An end to end project in MicroStrategy starting from creation of Project, Schema Objects, Public Objects, Web interface & Dashboard Creation
Data – Revenue Dataset
Problem Statement – Create complex Report using MicroStrategy
Topics: It includes creation of Region and Call Center wise Revenue Report and Region and category wise Revenue.
Topics: 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
Topics: 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
Topics: 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
Topics: 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), Microstrategyweb:Administration, Web Preferences,diagnostics,License manager
Topics: DATA Mart report creation, Edit the subscription
Topics: 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?
Topics: Object Manager
Project – Cube
Topics: After finishing this training course, we will help you prepare a real-time project using MicroStrategy skills learned. In this project, you will create an intelligent cube and publish it., You will further create report caches, email subscriptions , file subscription and receive valid outputs of each operation., The project also focuses on restarting the I-server, creating user groups from Command Manager and configuring them and generating new security rules.
In Intellipaat self-paced training program you will receive recorded sessions, course material, Quiz,related software’s and assignments.The courses are designed such that you will get real world exposure and focused on clearing relevant certification exam. After completion of training you can take quiz which enable you to check your knowledge and enables you to clear relevant certification at higher marks/grade also you will be able to work on the technology independently.
In Self-paced courses trainer is not available whereas in Online training trainer will be available for answering queries at the same time. In self-paced course we provide email support for doubt clearance or any query related to training also if you face some unexpected challenges we will arrange live class with trainer.
All Courses are highly interactive to provide good exposure. You can learn at your own place and at your leisure time. Prices of self-paced is training is 75% cheaper than online training. You will have lifetime access hence you can refer it anytime during your project work or job.
Yes, at the top of the page of course details you can see sample videos.
As soon as you enroll to the course, your LMS (The Learning Management System) Access will be Functional. You will immediately get access to our course content in the form of a complete set of previous class recordings, PPTs, PDFs, assignments and access to our 24×7 support team. You can start learning right away.
24/7 access to video tutorials and Email Support along with online interactive session support with trainer for issue resolving.
Yes, You can pay difference amount between Online training and Self-paced course and you can be enrolled in next online training batch.
Yes, we will provide you the link from where you can download the required software’s.
Please send an email . You can also chat with us to get an instant solution.
Intellipaat verified certificates will be awarded based on successful completion of course projects. There are set of quizzes after each couse module that you need to go through . After successful submission, official Intellipaat verified certificate will be given to you.
Towards the end of the Course, you will have to work on a Training project. This will help you understand how the different components of course are related to each other.
Classes are conducted via LIVE Video Streaming, where you get a chance to meet the instructor by speaking, chatting and sharing your screen. You will always have the access to videos and PPT. This would give you a clear insight about how the classes are conducted, quality of instructors and the level of Interaction in the Class.
Yes, We do keep launching multiple offers, please see offer page.
We will help you with the issue and doubts regarding the course. You can attempt the quiz again.
At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate. Become in demand with Intellipaat certifications
You will get Lifetime access to high quality interactive tutorials along with life time access to complete Course Material .There will be 24/7 access to video tutorials with email support. If you stuck in any unexpected problem we will provide online interactive sessions with trainer for issue resolving.
We provide 24X7 support by email for issues or doubts clearance for Self-paced training.
In online Instructor led training, trainer will be available to help you out with your queries regarding the course. If required, the support team can also provide you live support by accessing your machine remotely. This ensures that all your doubts and problems faced during labs and project work are clarified round the clock.
At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate.
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org