MicroStrategy Architect
4.4 (21 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
75 students enrolled

MicroStrategy Architect

A comprehensive course that covers the basics and advanced concepts required to be a MicroStrategy Architect.
Bestseller
4.4 (21 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
75 students enrolled
Created by James Oliver
Last updated 6/2020
English
English [Auto]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Build and maintain MicroStrategy projects in the real world
  • Data warehousing 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
Course content
Expand all 28 lectures 02:32:29
+ Introduction
2 lectures 02:45

What it means to be a MicroStrategy Architect.

Preview 00:36

Review the course agenda and what you will learn in each section.

Preview 02:09
+ The Basics
2 lectures 05:31

What happens when a user submits a report request?

MicroStrategy Architecture Overview
02:19
Quiz: MicroStrategy Architecture
3 questions

Learn about the various types of tables found in a data warehouse and their purpose.

Tables: Fact, Lookup and Relationship
03:12
Quiz: Tables
3 questions
+ Schema Objects
8 lectures 47:09

Understanding attributes.

Preview 01:44

Mapping attributes in MicroStrategy.

Preview 11:11
Quiz: Attributes
5 questions

Understanding facts.

Preview 00:57

Mapping facts in MicroStrategy.

Creating Facts
07:11
Quiz: Facts
5 questions

Bringing everything together with metrics.

Metrics - Putting it all together
04:38

Understand the benefits of logical tables.

Logical Tables
04:44
Quiz: Metrics and Logical Tables
5 questions
Understanding Mapping and Logical Sizes
07:41
Transformations
09:03
+ Data Warehousing Concepts
2 lectures 08:35

Understand the two most common types of data warehouse schema designs.

Star and Snowflake Schema
04:17

Understand why MicroStrategy prefers the Snowflake schema.

Which schema does MicroStrategy prefer?
04:18
Quiz: Data Warehousing Concepts
5 questions
+ Relationships
6 lectures 43:03
One-to-One
06:36
One-to-Many
11:14
Many-to-Many
10:03
Joint Child Relationships
07:13
User Hierarchies
04:54
Logical Models
03:03
Quiz: Relationships
6 questions
+ Advanced Concepts
6 lectures 41:48
Compound Keys
05:05
Ragged Hierarchy
06:04
Split Hierarchy
05:06
Recursive Hierarchy
04:35
Slowly Changing Dimensions
13:07
Attribute Roles and Table Aliases
07:51
Quiz: Advanced Concepts
7 questions
+ Misc
1 lecture 03:11

This video will cover creating ODBC connections using a Windows I-Server and database instances in MicroStrategy.

Creating Connections
03:11
+ Learn more
1 lecture 00:27
Additional Content
00:27