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 desgin 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
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?
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.
Intellipaat is a leader in providing Business Intelligence training. This is an industry-designed Microstrategy training that includes both the developer and administration components. You will be trained in database connections, ODBC data source administration, working with interactive dashboards, scorecards, reports in order to derive valuable business insights. The entire training is in line with clearing the two exams: MicroStrategy Certified Developer and Microstrategy Certified Administrator.
You will be working on real time projects that have high relevance in the corporate world, step by step assignments and curriculum designed by industry experts. Upon 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 latest version at no extra fees. Hence it is clearly a one-time investment.
Intellipaat basically offers the self-paced training and online instructor-led training. Apart from that we also provide corporate training for enterprises. All our trainers come with over 12 years of industry experience in relevant technologies and also they are subject matter experts working as consultants. You can check about the quality of our trainers in the sample videos provided.
If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers. The best part is that you can contact Intellipaat even after completion of training to get support and assistance. There is also no limit on the number of queries you can raise when it comes to doubt clearance and query resolution.
The Intellipaat self-paced training is for people who want to learn at their own leisurely pace. As part of this program we provide you with one-on-one sessions, doubt clearance over email, 24/7 Live Support, lifetime LMS and upgrade to the latest version at no extra cost. The prices of self-paced training can be 75% lesser than online training. While studying should you face any unexpected challenges then we shall arrange a Virtual LIVE session with the trainer.
We provide you with the opportunity to work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready. These projects could be in exciting and challenging fields like banking, insurance, retail, social networking, ecommerce, marketing, sales, high technology and so on. The Intellipaat projects are equivalent to six months of relevant experience in the corporate world.
Yes, Intellipaat does provide you with placement assistance. We have tie-ups with 80+ organizations including Ericsson, Cisco, Cognizant, TCS, among others that are looking for skilled & quality professionals and we would be happy to assist you with the process of preparing yourself for the interview and the job.
Yes, if you would want to upgrade from the self-paced training to instructor-led training then you can easily do so by paying the difference of the fees amount and joining the next batch of classes which shall be separately notified to you.
Upon successful completion of training you have to take a set of quizzes, complete the projects and upon review and on scoring over 60% marks in the qualifying quiz the official Intellipaat verified certificate is awarded.The Intellipaat Certification is a seal of approval and is highly recognized in 80+ corporations around the world including many in the Fortune 500 list of companies.
This course is designed for clearing the two certifications:
The entire training course content is in line with this certification programs and helps you clear it with ease and get the best jobs in the 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 scenario 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 helps you score better marks in certification exam.
Intellipaat Course Completion Certification will be awarded on the completion of Project work (on expert review) and upon scoring of at least 60% marks in the quiz. Intellipaat certification is well recognized in top 80+ MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.
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.
"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