Microstrategy Developer and Administration Training
Intellipaat
Course Summary
Our MicroStrategy certification master program lets you gain proficiency in MicroStrategy developer and administration. 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, filter.
-
+
Course Description
About Microstrategy Developer and Administration Course
What you will learn in this Training Course?
- Learn about Business Intelligence overview
- Difference between OLAP and OLTP
- Get to know application, configuration and schema objects
- Microstrategy Filter Reports and Prompts
- Learn about Microstrategy Admin Architecture
- Learn about iServer and ways to start and restart it
- Intelligent Cubes creation and monitoring
- Understand the Security Model, and warehouse authentication
- Study about Microstrategy Object Manager
Who should take this Training Course?
- Software Architects, ETL Developers and Data Analysts
- Business Intelligence professionals
- Those looking for a career in BI and administration
What are the prerequisites for taking this Training Course?
A basic idea of data analytics is beneficial.Why should you take this Training 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 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.
-
+
Course Syllabus
MicroStrategy Course Content
MicroStrategy Introduction & InstallationIntroduction 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.DW & BI ArchitectureUnderstand in detail about the Data Warehousing and Business Intelligence architecture, data sources, ETL process, loading data in EDW and data marts.Business Intelligence capabilityLearning how BI capability various at different levels, operational, adhoc and dashboard needs and solutions offered like grids and graphs.Analytical ModelsProgression in analytical methods, various types models like summarization, trends, benchmarking, comparative analysis, optimization and predictions.MicroStrategy Platform ArchitectureA detailed architecture of MicroStrategy including tools and services, data assets, schemas, metadata, public objects and information delivered via web, desktop and mobile.MicroStrategy Architecture FlowMicroStrategy 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.Connectivity and the Data ecosystemsLearning about the various backend data support that MicroStrategy offers, seamless integration with relational databases and unstructured data storage.Analyzing dataLearning about the basic components and elements of schema, facts and dimensions, analyzing data and quantifying business elements.Measures & MetricsUnderstanding about measures and metrics in a data warehouse schema.Hands-on Exercise – Use measures and metrics in a data warehouse schemaLogical & Physical Warehouse SchemaThe 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 TablesProject Source and CreationCreation 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 objectsSchema ArchitectThe 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.Organizing Schema ObjectsUnderstanding 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 SchemaCreation of HierarchiesLearning 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 hierarchiesCreating MetricsCreation 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 filtersCreating FiltersLearning 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 filtersCreating PromptsUnderstanding the different ways of creation of Prompts and its various uses.Hands-on Exercise – Create different types of Prompts and use themSearch ObjectsLearning how to create Search Objects, the usage of Search Objects in Prompts andHands-on Exercise – Create Search Objects, Use search objects in PromptsConsolidationThe 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 ObjectsCustom GroupsLearning 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 GroupsDrill MapsUnderstanding 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 analysisPartition mappingUnderstanding 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 MicroStrategyDifferent type of Reports CreationClear 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 FormatMicroStrategy WebUnderstanding the MicroStrategy Web Interface, learning about folder structure, Report deployment and other features.Hands-on Exercise – Practice on MicroStrategy Web Interface, Deploy a Report generationWeb DashboardLearning 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 InterfaceMicroStrategy Intelligence ServerUnderstanding 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 ClusterMicroStrategy Admin Course Content
Getting started with MicroStrategy Administration, its Architecture and Server definitions and ConnectivityWhat 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 ConnectivityWorking with Database Connections, Admin Interface , Caches and CubesDatabase 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 statusCreating Intelligent Cubes and understanding Clustering, Caching and Scheduling in MicroStrategyIncremental 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, SecurityUnderstanding MicroStrategy Security Model, Security Filters, Web Administration and Web PreferencesControlling 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 managerCreating Data Mart Reports and understanding PersonalizationDATA Mart report creation, Edit the subscriptionIntroduction to Narrowcast Administration, Narrowcast Server Configuration and Updating Intelligence ServerNarrowcast 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?Introduction to MicroStrategy Object ManagerObject ManagerMicroStrategy ProjectProject– MicroStrategy ReportData – Revenue DatasetIn 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.MicroStrategy Admin ProjectProject – MicroStrategy Cube Administration, Maintenance and SecurityIn this project you will be working on MicroStrategy intelligent cubes which are multi-dimensional cubes that is 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.
This course is listed under
Development & Implementations
, Data & Information Management
and Networks & IT Infrastructure
Community
Related Posts: