Objectives of Microstrategy Training
- To create schema, desktops, and reports using Microstrategy
- Understand the design of schema objects like Facts, Attributes, and Hierarchies
- Learn about the creation of complex filters and to apply them to reports
- To Manage the operational and analytical reports with dashboards
- To Learn about creating filters and prompts using web
Course Features
- Duration60 hours
- Skill levelAll level
- Batch Strength15
- AssessmentsYes
- Mock InterviewsYes
- Resume BuildingYes
- PlacementsYes
- Flexible TimingYes
- Fee InstallmentsYes
- LanguageTamil/English
Section 1: Datawarehousing Concepts
- What is DWH?
- Characteristics of Datawarehouse
- Difference between OLTP and DWH
- Architecture of DWH
- Various BI tools
- Types of DWH
- Types of Dimensional Data Modeling
- Surrogate key
- Types of Dimension
Section 2: Data Modeling
- How are data models used in practice?
- What about conceptual models?
- Common data modeling notations
- How to model data
- Identify entity types
- Identify attributes
- Apply naming conventions
- Identify relationships
- Apply data model patterns
- Assign keys
- Normalize to reduce data redundancy
- De-normalize to improve performance
- Evolutionary/agile data modeling
- How to become better at modeling data
Section 3: Architecture of OLAP
- What is OLAP
- What are Different Types of OLAP’s
Section 4: Microstrategy: Installation
- Microstrategy: Installation
Section 5: Microstrategy Desktop - Reporting Essentials
- Introduction to Microstrategy Business Intelligence
- Introduction to Microstrategy Desktop
- Creating and Saving Reports in Desktop
- Report Manipulations in Desktop
- Data Manipulations
- Style Manipulations
- Creating and Saving Basic Report Filters
- Creating, Formatting and Saving Basic Metrics
- Microstrategy OLAP Services in Desktop
- Report Objects
- View Filters
- Derived Metrics
- Creating and Saving Basic Prompts and Searches
Section 6: Microstrategy Desktop - Advanced Reporting
- Introduction to Advanced Reporting
- Advanced Metrics
- Advanced Filters
- Consolidations and Custom Groups
- Advanced Prompts
- Advanced OLAP services
- Drill Maps
- Report Data Options
- Report Developer Tools
Section 7: Microstrategy Architect: Project Design
- Introduction to Microstrategy Architect
- The Logical Data Model
- The physical Warehouse Schema
- Advanced Data Modeling and Schema Design
- Introduction to Project Creation in Microstrategy Architect
- Creating Microstrategy Facts
- Creating Microstrategy Attributes
- Creating Microstrategy Hierarchies
- Project configuration Workshop
Section 8: Microstrategy Web
- Connect to MSTR Web
- Configure I-Server and Create Reports
- Create Objects (Filter, Prompts) using Web
Section 9: Microstrategy Report Services Documents
- Creating a Document using existing report
- Create Dashboards – Workshop
Section 10: Microstrategy Administrator
- Basic Administration tasks
- User Management
- Roles and Security Management, Project Access
- Microstrategy Security Filters
You will be going through detailed 2 to 3 months of Microstrategy Hands-on training
- Detailed instructor led sessions to help you become a proficient Expert in Microstrategy.
- Build a Microstrategy professional portfolio by working on hands on assignments and projects.
- Personalised mentorship from professionals working in leading companies.
- Lifetime access to downloadable Microstrategy course materials, interview questions and project resources.
Credo Systemz - Velachery, Chennai
Call Us +91 9884412301
Credo Systemz - OMR, Chennai
Call Us +91 9600112302
Wonderful Micro strategy training at CREDO SYSTEMZ..Im working in leading MNC as consultant. I felt that i have been provided with prompt response from the trainer Feroz..Really worth and i will recommend to my friends
CREDO SYSTEMZ is a great institute to learn Microstrategy with practical and labs .
It is a perfect way to learn .
I loved it.
Thanks CREDO SYSTEMZ!!
