Introduction To Microstrategy Report Development I

Introduction to MicroStrategy Report Development

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

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)

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 OutcomesAfter taking this course, students will be able to:Describe the core MicroStrategy concepts and MicroStrategy Project Lifecycle phasesDefine components and different types of MicroStrategy ArchitectureCreate Scheme Objects, Public Objects and MicroStrategy reportsUnderstand the Report Execution Lifecycle, apply data manipulation techniques, and analyze different report views of the MicroStrategy reports.Work with the Warehouse CatalogueRecommended ExperienceThis 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.

Overview

Section 1: Introduction

Lecture 1 Introduction to the Course

Lecture 2 What is Microstrategy?

Lecture 3 MicroStrategy Installation Guide

Section 2: MicroStrategy Project Lifecycle

Lecture 4 MicroStrategy Project Lifecycle

Section 3: Microstrategy Architecture

Lecture 5 Different Tiers in MicroStrategy architecture

Lecture 6 MicroStrategy Metadata

Lecture 7 Different Engines in MicroStrategy

Section 4: Report Execution Life Cycle

Lecture 8 Report execution life cycle

Lecture 9 Different types of objects in MicroStrategy

Lecture 10 MicroStrategy Developer and Web

Lecture 11 Hands-on Demo: Developer and Web Environment

Section 5: Warehouse Catalog

Lecture 12 Overview of the Warehouse Catalog

Lecture 13 Hands-on Demo: Warehouse catalog

Section 6: Basic Reporting Components

Lecture 14 Attributes

Lecture 15 Hands-on Demo: Attributes- part I

Lecture 16 Hands-on Demo: Attributes- part II

Lecture 17 Hands-on Demo: Attributes- part III

Lecture 18 Facts

Lecture 19 Hands-On Demo: Facts

Lecture 20 Metrics

Lecture 21 Hands-on Demo: Metrics- part I

Lecture 22 Hands-on Demo: Metrics- part II

Lecture 23 Hands-on Demo: Metrics- part III

Lecture 24 Filters

Lecture 25 Hands-on Demo: Filters- part I

Lecture 26 Hands-on Demo: Filters- part II

Lecture 27 Hands-on Demo: Filters- part III

Lecture 28 Prompts

Lecture 29 Hands-on Demo: Prompts- part I

Lecture 30 Hands-on Demo: Prompts- part II

Lecture 31 Hands-on Demo: Prompts- part III

Lecture 32 Hands-on Demo: Prompts- part IV

Lecture 33 Hands-on Demo: Prompts- part V

Lecture 34 Hierarchies

Lecture 35 Creating Reports with Report Editor

Lecture 36 Hands-on Demo: Report Editor- part I

Lecture 37 Hands-on Demo: Report Editor- part II

Lecture 38 Hands-on Demo: Report Editor- part III

Lecture 39 Report Views

Section 7: Report Data Manipulation

Lecture 40 Report Data Manipulations-Page By

Lecture 41 Report Data Manipulations-Pivoting and Subtotaling

Lecture 42 Report Data Manipulations-Sorting

Lecture 43 Report Data Manipulations-Report Limits

Lecture 44 Report Data Manipulations-Aliasing and Null Values

Lecture 45 Report Data Manipulations-Drilling

Lecture 46 Report Data Manipulations-Metric Join Types

Lecture 47 Hands-on Demo: Data Manipulation- page by, Pivoting

Lecture 48 Hands-on Demo: Data Manipulation- Report Subtotals

Lecture 49 Hands-on Demo: Data Manipulation- Sorting Data, Report Limits, Aliasing

Lecture 50 Hands-on Demo: Data Manipulation- Handling Null Values

Lecture 51 Hands-on Demo: Data Manipulation- Report Drilling Part I

Lecture 52 Hands-on Demo: Data Manipulation- Report Drilling Part II

Lecture 53 Hands-on Demo: Data Manipulation- Report Drilling Part III

Lecture 54 Hands-on Demo: Data Manipulation- Metric Join Types

Lecture 55 Report Data Manipulations-Formatting and Auto Styles

Lecture 56 Report Data Manipulations-Thresholds

Lecture 57 Report Data Manipulations-Banding and Locking

Lecture 58 Report Data Manipulations-Dependants, Components and Object Searches

Lecture 59 Hands-on Demo: Data Formatting in Reports

Lecture 60 Hands-on Demo: Applying Thresholds

Lecture 61 Hands-on Demo: Autostyles, Banding, Locking column/row headers

Lecture 62 Hands-on Demo: Mergin row/column headers, Displaying Attribute forms

Lecture 63 Hands-on Demo: Searches, Shortcuts

Business Intelligence Professionals,Data Analysts,ETL Developers,Big Data Professionals