image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

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.
Who this course is for:
Business Intelligence Professionals
Data Analysts
ETL Developers
Big Data Professionals

What you'll learn

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

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
3
1.1-Introduction to the Course
1.2-What is Microstrategy?
1.3-MicroStrategy Installation Guide
2-MicroStrategy Project Lifecycle
1
2.1-MicroStrategy Project Lifecycle
3-Microstrategy Architecture
3
3.1-Different Tiers in MicroStrategy architecture
3.2-MicroStrategy Metadata
3.3-Different Engines in MicroStrategy
4-Report Execution Life Cycle
4
4.1-Report execution life cycle
4.2-Different types of objects in MicroStrategy
4.3-MicroStrategy Developer and Web
4.4-Hands-on Demo: Developer and Web Environment
5-Warehouse Catalog
2
5.1-Overview of the Warehouse Catalog
5.2-Hands-on Demo: Warehouse catalog
6-Basic Reporting Components
26
6.1-Attributes
6.2-Hands-on Demo: Attributes- part I
6.3-Hands-on Demo: Attributes- part II
6.4-Hands-on Demo: Attributes- part III
6.5-Facts
6.6-Hands-On Demo: Facts
6.7-Metrics
6.8-Hands-on Demo: Metrics- part I
6.9-Hands-on Demo: Metrics- part II
6.10-Hands-on Demo: Metrics- part III
6.11-Filters
6.12-Hands-on Demo: Filters- part I
6.13-Hands-on Demo: Filters- part II
6.14-Hands-on Demo: Filters- part III
6.15-Prompts
6.16-Hands-on Demo: Prompts- part I
6.17-Hands-on Demo: Prompts- part II
6.18-Hands-on Demo: Prompts- part III
6.19-Hands-on Demo: Prompts- part IV
6.20-Hands-on Demo: Prompts- part V
6.21-Hierarchies
6.22-Creating Reports with Report Editor
6.23-Hands-on Demo: Report Editor- part I
6.24-Hands-on Demo: Report Editor- part II
6.25-Hands-on Demo: Report Editor- part III
6.26-Report Views
7-Report Data Manipulation
25
7.1-Report Data Manipulations-Page By
7.2-Report Data Manipulations-Pivoting and Subtotaling
7.3-Report Data Manipulations-Sorting
7.4-Report Data Manipulations-Report Limits
7.5-Report Data Manipulations-Aliasing and Null Values
7.6-Report Data Manipulations-Drilling
7.7-Report Data Manipulations-Metric Join Types
7.8-Hands-on Demo: Data Manipulation- page by, Pivoting
7.9-Hands-on Demo: Data Manipulation- Report Subtotals
7.10-Hands-on Demo: Data Manipulation- Sorting Data, Report Limits, Aliasing
7.11-Hands-on Demo: Data Manipulation- Handling Null Values
7.12-Hands-on Demo: Data Manipulation- Report Drilling Part I
7.13-Hands-on Demo: Data Manipulation- Report Drilling Part II
7.14-Hands-on Demo: Data Manipulation- Report Drilling Part III
7.15-Hands-on Demo: Data Manipulation- Metric Join Types
7.16-Report Data Manipulations-Formatting and Auto Styles
7.17-Report Data Manipulations-Thresholds
7.18-Report Data Manipulations-Banding and Locking
7.19-Report Data Manipulations-Dependants, Components and Object Searches
7.20-Hands-on Demo: Data Formatting in Reports
7.21-Hands-on Demo: Applying Thresholds
7.22-Hands-on Demo: Autostyles, Banding, Locking column/row headers
7.23-Hands-on Demo: Mergin row/column headers, Displaying Attribute forms
7.24-Hands-on Demo: Searches, Shortcuts
7.25-MicroStrategy final Quiz