Course : MicroStrategy Architect, creating BI projects

Practical course - 2d - 14h00 - Ref. MSP
Price : 1430 € E.T.

MicroStrategy Architect, creating BI projects



New course

This training course will enable you to confidently approach the functionalities of MicroStrategy Architect, as well as the efficiency and flexibility of its interface. Starting with logical and physical data models, you will learn how to conceptualize BI projects, right through to the creation of the semantic layer.


INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class
Disponible en anglais, à la demande

Ref. MSP
  2d - 14h00
1430 € E.T.




This training course will enable you to confidently approach the functionalities of MicroStrategy Architect, as well as the efficiency and flexibility of its interface. Starting with logical and physical data models, you will learn how to conceptualize BI projects, right through to the creation of the semantic layer.


Teaching objectives
At the end of the training, the participant will be able to:
Understanding how MicroStrategy Architect works
Understanding the MicroStrategy project creation process
Create a MicroStrategy project from the physical model
Understand how security principles work in MicroStrategy

Intended audience
Business intelligence project architects.

Prerequisites
No

Practical details
Teaching methods
Active

Course schedule

1
Introduction to MicroStrategy Business Intelligence

  • MicroStrategy BI architecture
  • The three components of MicroStrategy BI architecture: data sources, metadata and MicroStrategy applications
  • Introduction to reporting principles

2
Introduction to MicroStrategy Architect

  • Role of MicroStrategy Architect
  • Using MicroStrategy Architect: initializing data, creating schema objects
  • The project creation cycle: setting up metadata, configuring project connectivity, creating schema objects, updating project schema
Hands-on work
Get started with MicroStrategy Architect and create your first project.

3
Data models and project creation in MicroStrategy Architect

  • The logical data model: attributes, facts, hierarchies
  • The physical data model: tables, columns
  • Project creation interfaces
Hands-on work
Manipulate project data.

4
Project semantic layer on MicroStrategy Architect

  • Definitions
  • Creation of the semantic layer: facts, hierarchy attributes, measures
Hands-on work
Continue data manipulation. Create a semantic project layer.

5
Project administration on MicroStrategy Architect

  • Project documentation
  • Security: user management, user maintenance
Hands-on work
Create project documentation and manage user accounts.