Lesson 1:An Introduction to MicroStrategy 10
In this module, you will get a complete overview of MicroStrategy 10 BI Suite, Benefits, Development Process, Architecture, Components and MicroStrategy 10 New Features.
o Introduction to MicroStrategy
o MicroStrategy Architecture
o MicroStrategy Components
o MicroStrategy Developer
o MicroStrategy Desktop
o MicroStrategy Web,
o Installation & Administration, Configuration & Connectivity With Database
o Understanding to Intelligence Server
o Understanding to Intelligence Cube
o MicroStrategy 10 New Feature.
Lesson 2: Working with the Developer
In this module, you will learn MicroStrategy 10 Developer, MicroStrategy Report - Basics, Formatting Data, Analyzing Data, Developing Objects, Report & Dashboard Development.
o Micro strategy Developer
o Folder Structure
o Folder Management
o My Personal Objects
o Public Object & Schema Object
o Creating and saving Reports in Desktop
o Report Manipulations in Desktop
o Data Manipulations & Style Manipulations
o Creating and saving basic report filters
o Creating, formatting and saving basic metrics
o Microstrategy OLAP services in Desktop,Report objects
o View Filters
o Derived Metrics
o Creating and saving Basic prompts and searches
o Creating a Dashboard Document
o Designing a Dashboard
o Publishing a Dashboard.
Lesson 3: Schema Development with Architect
In this module, you will learn the MicroStrategy 10 Architect, Basics, Schema Objects, Building, MicroStrategy Architect – Maintenance.
o Introduction to MicroStrategy Architect, The logical data model, The physical warehouse schema, Advanced Data modeling and schema design
o Many to Many relationships
o Creating MicroStrategy Attributes
o Facts and Hierarchies.
Lesson 4: Reporting Services & Dashboard Development
In this module, you will learn about MicroStrategy 10 Reporting & Dashboard, Basics, Template, Structure, Building.
o Introduction to Reporting Services
o Document basics
o Document design concepts
o Useful design techniques
o Derived summary and stacked metrics
o Calculated expressions
o Conditional formatting
o Advanced Metrics & Filter
o Creating a Dashboard and Setting up the default dashboard prompt.
Lesson 5: Working With Desktop
In this module, you will get Started with Analytics Desktop, learn Importing Data into Analytics Desktop, Creating and Modifying Dashboards, Analyzing Data in Dashboards, Organizing and Searching for Objects.
o MicroStrategy Desktop, Getting Started with Analytics Desktop
o Importing Data into Analytics Desktop
o Creating and Modifying Dashboards
o Analyzing Data in Dashboards
o Organizing and Searching for Objects.
Lesson 6: MicroStrategy 10 BI Project
This is a MicroStratregy 10 Business Intelligence Project which starts from User Source System and Business Requirement Gathering till end of Project Development with production support strategies developments.
o Developing a MicroStratregy 10 Project
o Source System Understanding
o Business Requirement Gathering
o Preparation of BRD:Source-Data Mart or Relational Data Model Detailed Description / ER Diagram
o Report KPI Calculations, List of Dimension-Attributes, List of Facts-Measures & Metrics, List of Report, List of Dashboard
o Project Management With Desktop
o Project Folder Creation
o Database Connection
o User Management
o Group Management
o Roles & Privileges, Object Creations
o MicroStrategy Architect, As per the BRList of Attributes
o List of Facts, List of Metrics
o List of Hierarchies
o MicroStrategy Dashboard
o List of Dashboard, List of Charts
o List of Users & Groups
o List of Roles for Dashboard
o Setting up the Main Dashboard Report for Applying Default Page Filter.
Lesson 7: MicroStrategy Admin
In this Module we will teach you how to configure I server. Create a Metadata, Project, Project Configuration with DW, Creating DSN, Creating Metadata Tables.
o I SERVER Configuration and other configuration set ups - Creating metadata and metadata tables
o creating schema
o creating history lead tables, configuring projects with DWH, creating project sources, setting up authentication modes, security roles and filters, configuring I Server with metadata and License Manager.
Lesson 8: MicroStrategy Migration
In this Module we will learn to migrate the developed objects from one environment to other through Object Manager. We will learn Migration, Project Merge, User Merge, Package Creation.
o Object Migration with Object Manager - migrating objects from one environment to other
o project merge
o project duplication
o package creation
o user merge.
Lesson 9: MicroStrategy Object Integrity TestLearning
We will learn how to test the Project Object automatically through Integrity Manager.
o Object Test Through Integrity Manager - Single Project Test
o project v/s worker's project
o baseline v/s project
o baseline v/s baseline.
Lesson 10: Command Manager
We will learn how to execute commands through Command Manager.
o Firing Commands Through Command Line - Creating bulk users
o creating bulk user subscription
o starting / stopping I Server
o Creating / Purging cache, etc.