MicroStrategy Architect

Name: MicroStrategy Architect
Rating: 4.5 (1103 reviews)

A comprehensive course that covers the basics and advanced concepts required to be a MicroStrategy Architect.

Created byJames Oliver

Last updated 6/2020

English

English [Auto],Spanish [Auto],

What you'll learn

Build and maintain MicroStrategy projects in the real world
Data warehousing concepts

Course content

8 sections • 28 lectures • 2h 32m total length

Introduction0:36
What it means to be a MicroStrategy Architect.
Course Agenda2:09
Review the course agenda and what you will learn in each section.

What are attributes?1:44
Understanding attributes.
Creating Attributes11:11
Mapping attributes in MicroStrategy.
Quiz: Attributes
What are facts?0:57
Understanding facts.
Creating Facts7:11
Mapping facts in MicroStrategy.
Quiz: Facts
Metrics - Putting it all together4:38
Bringing everything together with metrics.
Logical Tables4:44
Understand the benefits of logical tables.
Quiz: Metrics and Logical Tables
Understanding Mapping and Logical Sizes7:41
Transformations9:03
Define transformations to compare current year data to prior year across day, week, month, quarter, and year using date lookup tables and 1-to-1 mappings, then create metrics and build reports.

One-to-One6:36
Learn how to implement a 1 to 1 relationship in microstrategy architect, using customer and social security number as examples, avoiding cross joins and enabling correct inner joins.
One-to-Many11:14
Master one-to-many relationships in MicroStrategy Architect by building a time hierarchy from day to year, creating attributes, and defining relationship tables to avoid cross joins and produce accurate SQL.
Many-to-Many10:03
Explore many-to-many relationships between items and colors, map an item-color relationship table in MicroStrategy Architect, and resolve color reporting accuracy by adding color to the fact table.
Joint Child Relationships7:13
User Hierarchies4:54
Logical Models3:03
Meet with the business to design a logical model for district and store hierarchies, then define one-to-many relationships so MicroStrategy can generate the required SQL for district reports.
Quiz: Relationships

Compound Keys5:05
Ragged Hierarchy6:04
Split Hierarchy5:06
Recursive Hierarchy4:35
Define a recursive hierarchy of employees and managers, including the CEO. Flatten the structure into separate employee and manager lookup tables and establish a many-to-one relationship for analysis.
Slowly Changing Dimensions13:07
Master slowly changing dimensions, including type one and type two designs with start and end dates and current flags, to ensure accurate manager and store history in reports.
Attribute Roles and Table Aliases7:51
Quiz: Advanced Concepts

Requirements

Basic understanding of MicroStrategy
Basic knowledge of SQL

Description

MicroStrategy Architects can be hard to find and play a critical role in any organization. In addition to being experts on MicroStrategy, Architects understand data warehousing concepts as well as business concepts. As a result, they are usually highly compensated for their unique combination of skills.

Whether you are a Report Developer or BI Analyst aspiring to be an Architect or have some experience as an Architect but want to take things to the next level, this course has something for you.

Who this course is for:

BI developers looking to start a career as a MicroStrategy Architect
MicroStrategy developers interested in Architect certifications
Analysts looking to advance their career

MicroStrategy Architect

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 3min

The Basics2 lectures • 6min

Schema Objects8 lectures • 47min

Data Warehousing Concepts2 lectures • 9min

Relationships6 lectures • 43min

Advanced Concepts6 lectures • 42min

Misc1 lecture • 3min

Learn more1 lecture • 1min

Requirements

Description

Who this course is for: