Student will learn about following Product as part of Microstrategy Developer Track Workshop
MicroStrategy Desktop & Architect ( Project Design)• Project design process from designing the logical data model and physical schema for the data warehouse to creating a project in MicroStrategy Architect.
• Project creation process, including how to work with tables, facts, attributes, and user hierarchies to create a fully functioning MicroStrategy project.
• Hands-on practice in designing and creating MicroStrategy projects through a series of exercises.
• Extend the architecture of a MicroStrategy project by creating aggregate fact tables, using multiple data sources, and defining advanced schema objects.
Microstrategy Desktop ( Reporting and Advanced Reporting )• Learn the foundations of the MicroStrategy analytical architecture.
• Develop reports, filters, metrics, and prompts using MicroStrategy Developer interface for core reporting needs.
• Drill, sort, subtotal, and modify in-memory data for optimized report views and analytical comprehension.
• Build complex reports by creating advanced metrics and filters, defining Intelligent Cubes, and modifying report data options.
• Understand how the MicroStrategy Engine develops Structured Query Language (SQL) to gather data in a variety of reporting scenarios.
• Learn methods for tuning and optimizing report performance using Very Large Database (VLDB) properties
• Learn how to create a dashboard in Visual Insight to explore your data and discover trends or anomalies.
• Create reports in MicroStrategy Developer by composing your own queries using Free-Form SQL
MicroStrategy Report Services: Documents and Dashboards• Features and functionality of MicroStrategy Web™, focusing using MicroStrategy Report Services™ to create dashboards and documents.
• Learn how to create documents, add datasets, various objects such as grids, graphs, text boxes, images, as well as implementation of OLAP services features within your document Students will also design and use dashboard features, such as panel stacks, selectors, and dashboard templates.
• Flash-specific features, such as widgets, and Flash-specific formatting options. Finally, the course illustrates useful document designing techniques.
Microstrategy Web ( Reporting )• Understand MicroStrategy Web features and determine how to interact with reports, dashboards, and mobile apps at a high level.
• Develop reports, filters, prompts, and metrics in MicroStrategy Web to analyze data and publish reports to other users.
• Determine how to manipulate existing reports, define custom formatting, and linking between multiple reports using Microstrategy Web.
Microstrategy Features (new in Version 10 ) and Other Tools• Enhanced reporting and visualizations capabilities in Web, Desktop, Mobile, and Transaction Services.
• Administrators will discover expanded feature sets to help tackle big data, improve performance, and have comprehensive monitoring through the new Operations Manager.
• MicroStrategy Integrity Manager , MicroStrategy Command Manager and Object Migration
Who should go for this Course?• BI Developers and Analyst
• Business Intelligence experts.
Pre-requisites for this Course?• Knowledge of SQL
• DW Concept
Project WorkThe entire course , you will learning with case study and you will be implementing concepts of Microstrategy of each Module required for the case study.
Introduction to MicroStrategy Architect
• Overview of MicroStrategy Architect • Roles of MicroStrategy Architect • Overview of the Project Design Process
Designing the Logical Data Model• Introduction to Logical Data Modeling • Logical Data Model Components • Creating a Logical Data Model
Designing the Data Warehouse Schema• Introduction to Physical Schemas • Physical Schema Components • Schema Types • Creating a Data Warehouse Schema
Creating a Project in MicroStrategy Architect• Overview of Project Creation • Project Creation Interfaces
Working with Tables• What Is a Project Table? • Using the Warehouse Catalog • Using the Logical Table Editor
Working with Facts• What Is a Fact? • Types of Facts • Using the Fact Creation Wizard • Using the Fact Editor
Working with Attributes• What Is an Attribute? • What Is an Attribute Form? • Types of Attributes • Using the Attribute Creation Wizard • Using the Attribute Editor • What Is the System Hierarchy?
Working with User Hierarchies• What Is a User Hierarchy? • Using the Hierarchy Editor
Introduction to the Architect Graphical Interface• Introduction to Architect • Overview of Architect Components • Saving Project Work in Architect • Undo and Redo Actions in Architect • Overview of Architect Settings • Demonstration of Architect
Reporting Essential Basic and AdvancedIntroduction to MicroStrategy Business Intelligence
• Introduction to MicroStrategy Desktop
Reports in Desktop• Report Manipulations in Desktop • Data Manipulations • Style Manipulations • Filters • Metrics • MicroStrategy OLAP Services • Report Objects • View Filters • Derived Metrics • Prompts and Searches
Advanced Metrics• Level Metrics • Non-aggregatable Metrics • Transformation Metrics • Base Formulas • Conditional Metrics • Nested Metrics • Advanced Subtotals
Advanced Filters• Attribute-to-attribute Filtering • Joint Element List • Dynamic Dates • Pass Through Functions • Qualify on Metrics • Relationship Filters
Consolidations and Custom Groups Advanced OLAP Services• Intelligent Cubes • View Filters
Derived Elements Report Data Options Drill Maps Report Developer Tools• Find and Replace • Project Documentation
Reporting Essential Basic and AdvancedIntroduction to Report Services
• Beyond Basic Grids and Graphs • Overview of MicroStrategy Web Interface • Reporting Capabilities • What is a RS Dashboard • Interacting with an RS Dashboard • Document Display Modes and Export Formats • Document Subscriptions
Creating Documents• Introduction to the Document Editor • Creating Documents • Creating Multiple Layout Documents • Useful Design Techniques and Document Specific Objects
Creating Report Services Dashboards• Dashboard Templates • Dashboard Layering • Document Objects and Formatting • Document Objects • Arranging and Formatting Objects on a Document • Drilling on Grid/Graphs • OLAP Services Features • Graph Formatting
Selectors• Selectors • Using Panel Stack as an Information Window
Flash Mode and Widgets• DHTML vs. Flash • Advanced Visualizations • Widget Rendering in PDF and Excel • Widgets in Interactive Mode • Flash Selectors and Formatting • Flash-only Selector Widgets • Widgets as Selectors • Flash-Specific Formatting
Dashboard Design Considerations• Designing and Creating Dashboards • Best Practices in Dashboard Design • Linking from Documents • Document Linking
Microstrategy Web for Professionals and Analyst Using the MicroStrategy Web interface• Introduction to the MicroStrategy Web interface • Executing reports and documents • Report and document manipulations in MicroStrategy Web
Manipulating and distributing grids and documents• Drilling • Document linking • Subtotals • Sorting • Thresholds • Basic subscriptions with Distribution Services • Printing documents • Exporting reports and documents • Exporting to multiple Excel worksheets
Subscribing, printing, and exporting reports and documents Distribution Services in MicroStrategy Web• Basic subscriptions with Distribution Services • Alert-based subscriptions
MicroStrategy Architectecture and Admin tools: MicroStrategy Intelligence Server and Components Architecture and query flowo Metadata repository overview o Business intelligence architecture o Three-tier query flow
Connectivity• Introduction to MicroStrategy connectivity • ODBC connectivity • Server definition • Project source • Establishing web connectivity • Database instance • Big data
MicroStrategy Integrity Manager• Integrity Manager overview
MicroStrategy Command Manager• Command Manager overview
Object Migration• Application lifecycle management overview • What is Object Manager? • Duplicating projects and objects • Managing objects with Object Manager
At the end of your course, you will work on a real time Project. You will receive a Problem Statement along with a dataset to work. Once you are successfully through with the project (reviewed by an expert), you will be awarded a certificate with a performance based grading. If your project is not approved in 1st attempt, you can take additional assistance to understand the concepts better and reattempt the Project free of cost.
At the end of your course, you will work on a real time Project. You will receive a Problem Statement along with a dataset to work. Once you are successfully through with the project (reviewed by an expert), you will be awarded a certificate with a performance based grading. If your project is not approved in 1st attempt, you can take additional assistance to understand the concepts better and reattempt the Project free of cost.