[UDEMY]Introduction to MicroStrategy Report Development

Introduction to MicroStrategy Report Development

Instructed by Adastra Academy Business / Data & Analytics

Course Description

What is MicroStrategy?

MicroStrategy is a powerful Business Intelligence and Visualization software. Compared to other Business Intelligence tools, MicroStrategy is capable of providing a complete enterprise-level reporting solution that is flexible, scalable, robust, and user-friendly. Microstrategy is rapidly increasing in popularity and is being leveraged across organizations in various industry verticals. It is currently being used by esteemed companies such as Netflix, eBay, Adobe, Adidas, BNP Paribas, Carrefour, Danone, Deloitte, ING Direct, Pfizer, Shell, and McDonald's to name a few.

The software can connect to a wide variety of traditional and cutting-edge data platforms, including Big Data tools such as Hadoop.

Course Outcomes

After taking this course, students will be able to:

Describe the core MicroStrategy concepts and MicroStrategy Project Lifecycle phases
Define components and different types of MicroStrategy Architecture
Create Scheme Objects, Public Objects and MicroStrategy reports
Understand the Report Execution Lifecycle, apply data manipulation techniques, and analyze different report views of the MicroStrategy reports.
Work with the Warehouse Catalogue

Recommended Experience

This is a beginner to intermediate level course.

No previous experience with MicroStrategy is required. However, some knowledge of the Business Intelligence and Information Management concepts will be helpful.

Why Adastra Academy?

Adastra Academy is a leading source of training and development for Information Management professionals and individuals interested in Data Management and Analytics technology. Our dedication to identifying and mastering emerging technologies guarantees our students are the first to have access to these quality courses. For an exceptional learning experience, our programs include hands-on labs and real world examples allowing students to easily apply their new knowledge.

What are the requirements?

A computer with administrator privileges
A working version of Microstrategy Enterprise Platform (a lab document with instructions on how to download the software will also be provided)
What am I going to get from this course?

Over 63 lectures and 10 hours of content!
Describe the core MicroStrategy concepts and MicroStrategy Project Lifecycle phases
Define components and different types of MicroStrategy Architecture
Create Scheme Objects, Public Objects, and MicroStrategy reports
Understand the Report Execution Lifecycle, apply data manipulation techniques, and analyze different report views of the MicroStrategy reports
Work with the Warehouse Catalogue
What is the target audience?

Business Intelligence Professionals
Data Analysts
ETL Developers
Big Data Professionals
Curriculum

Section 1: Introduction
Lecture 1
Introduction to the Course
Preview
04:20
Lecture 2
What is Microstrategy?
02:22
Lecture 3
MicroStrategy Installation Guide
24 pages
Section 2: MicroStrategy Project Lifecycle
Lecture 4
MicroStrategy Project Lifecycle
05:08
Section 3: Microstrategy Architecture
Lecture 5
Different Tiers in MicroStrategy architecture
03:26
Lecture 6
MicroStrategy Metadata
01:49
Lecture 7
Different Engines in MicroStrategy
05:19
Section 4: Report Execution Life Cycle
Lecture 8
Report execution life cycle
02:14
Lecture 9
Different types of objects in MicroStrategy
03:10
Lecture 10
MicroStrategy Developer and Web
04:55
Lecture 11
Hands-on Demo: Developer and Web Environment
47:46
Section 5: Warehouse Catalog
Lecture 12
Overview of the Warehouse Catalog
04:55
Lecture 13
Hands-on Demo: Warehouse catalog
06:01
Section 6: Basic Reporting Components
Lecture 14
Attributes
03:31
Lecture 15
Hands-on Demo: Attributes- part I
14:40
Lecture 16
Hands-on Demo: Attributes- part II
06:40
Lecture 17
Hands-on Demo: Attributes- part III
18:14
Lecture 18
Facts
01:48
Lecture 19
Hands-On Demo: Facts
17:53
Lecture 20
Metrics
03:45
Lecture 21
Hands-on Demo: Metrics- part I
15:20
Lecture 22
Hands-on Demo: Metrics- part II
13:46
Lecture 23
Hands-on Demo: Metrics- part III
17:55
Lecture 24
Filters
02:12
Lecture 25
Hands-on Demo: Filters- part I
05:32
Lecture 26
Hands-on Demo: Filters- part II
14:33
Lecture 27
Hands-on Demo: Filters- part III
11:28
Lecture 28
Prompts
02:15
Lecture 29
Hands-on Demo: Prompts- part I
19:55
Lecture 30
Hands-on Demo: Prompts- part II
14:31
Lecture 31
Hands-on Demo: Prompts- part III
11:53
Lecture 32
Hands-on Demo: Prompts- part IV
12:14
Lecture 33
Hands-on Demo: Prompts- part V
10:45
Lecture 34
Hierarchies
02:20
Lecture 35
Creating Reports with Report Editor
03:15
Lecture 36
Hands-on Demo: Report Editor- part I
13:53
Lecture 37
Hands-on Demo: Report Editor- part II
06:53
Lecture 38
Hands-on Demo: Report Editor- part III
19:56
Lecture 39
Report Views
05:55
Section 7: Report Data Manipulation
Lecture 40
Report Data Manipulations-Page By
02:49
Lecture 41
Report Data Manipulations-Pivoting and Subtotaling
03:16
Lecture 42
Report Data Manipulations-Sorting
01:59
Lecture 43
Report Data Manipulations-Report Limits
02:04
Lecture 44
Report Data Manipulations-Aliasing and Null Values
02:39
Lecture 45
Report Data Manipulations-Drilling
02:44
Lecture 46
Report Data Manipulations-Metric Join Types
01:57
Lecture 47
Hands-on Demo: Data Manipulation- page by, Pivoting
08:48
Lecture 48
Hands-on Demo: Data Manipulation- Report Subtotals
18:21
Lecture 49
Hands-on Demo: Data Manipulation- Sorting Data, Report Limits, Aliasing
18:21
Lecture 50
Hands-on Demo: Data Manipulation- Handling Null Values
16:20
Lecture 51
Hands-on Demo: Data Manipulation- Report Drilling Part I
15:17
Lecture 52
Hands-on Demo: Data Manipulation- Report Drilling Part II
10:48
Lecture 53
Hands-on Demo: Data Manipulation- Report Drilling Part III
13:35
Lecture 54
Hands-on Demo: Data Manipulation- Metric Join Types
11:42
Lecture 55
Report Data Manipulations-Formatting and Auto Styles
03:00
Lecture 56
Report Data Manipulations-Thresholds
02:33
Lecture 57
Report Data Manipulations-Banding and Locking
03:12
Lecture 58
Report Data Manipulations-Dependants, Components and Object Searches
03:33
Lecture 59
Hands-on Demo: Data Formatting in Reports
16:59
Lecture 60
Hands-on Demo: Applying Thresholds
13:44
Lecture 61
Hands-on Demo: Autostyles, Banding, Locking column/row headers
15:33
Lecture 62
Hands-on Demo: Mergin row/column headers, Displaying Attribute forms
11:53
Lecture 63
Hands-on Demo: Searches, Shortcuts
11:20
Quiz 1
MicroStrategy final Quiz
32 questions
Instructor Biography


Adastra Academy , Emerging Data Management and Analytics Technology Educators
We're focused on the tools and technologies that matter most for today and tomorrow.

Adastra Academy is a leading source of training and development for Information Management professionals and individuals interested in Data Management and Analytics technology. Our dedication to identifying and mastering emerging technologies guarantees our students are the first to gain access to critical skills. Our programs consist of hands-on labs and real world examples allowing students to easily apply their new knowledge.

As a division of Adastra Corporation, we leverage twenty years of world-class Information Management knowledge, experience, services and solutions to fuel the Academy and to advance Information Management professionals everywhere.