Microstrategy Course

Comprehensive course on MicroStrategy Desktop and Web Dashboards

Last updated 2022-01-10 | 4.5

- Overview of Data warehousing and Dimensional Modeling
- Attributes
- facts
- hierarchies and transformations
- Metrics
- Prompts
- Search objects in MicroStrategy

What you'll learn

Overview of Data warehousing and Dimensional Modeling
Attributes
facts
hierarchies and transformations
Metrics
Prompts
Search objects in MicroStrategy
Consolidations & Custom Group in MicroStrategy
Intelligent Cubes in MicroStrategy
FreeformSQL Reports in MicroStrategy
MicroStrategy Dossier Visualization
MicroStrategy Dashboard Creation
Filters and Report creation

* Requirements

* Basic SQL knowledge
* Very basic understanding of DWH & BI
* Windows
* Mac
* and Linux users are all welcome
* Tools:Microsoft SQL Server 2017
* MicroStrategy

Description

MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. MicroStrategy has some great features such as:

  • Data Discovery

  • Data Wrangling

  • Data Mining and Predictive Analysis

  • Mobile Platform

  • Real time Dashboards


What are we learning in this course?

This course consists of three different sections.In the first section of the course,we will be discussing data warehousing and dimensional modeling concepts.Second section is on MicroStrategy Desktop and the last part will be on MicroStrategy Web.

Section:1

  • Overview of Data warehousing

  • Dimensional Modeling concepts

Section:2

  • Attributes,Facts and Metrics

  • Reports and Filters

  • Prompts and Search Objects

  • Consolidation and Custom Group

  • Intelligent Cubes and FreeformSQL report

    and much more

Section:3

Visualizations and Dashboard creation

Career Perspective:

If you want to have a career as a Data analyst or Business Intelligence,this course will help you big time.Many big companies like Netflix, Adobe, Adidas,Shell, and McDonald's etc are using MicroStrategy for data analysis so this course will add a tremendous value in your resume. The important aspect is that after this course,learning other BI tools will not be very difficult.

After this course:

Once your are done with the course,you can apply these concepts making reports,making visualizations and creating attractive dashboards.

Have a Great Learning..!!!

Who this course is for:

  • Business Analyst Professionals
  • ETL Developers
  • Students who want to have a career in the field of Business Analyst/Business Intelligence

Course content

9 sections • 46 lectures

Overview of OLTP Preview 03:16

Data warehousing Concepts Preview 10:10

Benefits and Limitation of Data Warehouse Preview 03:35

ETL in Data Warehousing Preview 12:34

ETL vs ELT Preview 06:13

Dimensional Modeling Overview Preview 11:40

Star Schema,Snowflake Schema and Galaxy Schema Preview 03:25

Dimensional Modeling Design Steps Preview 12:34

Slowly Changing Dimension Preview 09:22

MicroStrategy Introduction Preview 01:57

Microsoft SQL Server Installation Preview 13:22

MicroStrategy Installation Preview 08:47

MicroStrategy Configuration and Product Activation Preview 09:54

MicroStrategy Architecture Preview 15:35

Project Source and Project Creation Preview 08:29

MicroStrategy Architect Tutorial Preview 12:16

Create an Attribute in Microstrategy Preview 10:30

Compound Attributes Preview 05:39

Hierarchies in Microstrategy Preview 08:46

Create Facts Preview 05:40

Overview of Metrics in MicroStrategy Preview 06:59

Use of Metric in a Report Preview 08:08

Different Level Metrics Preview 19:51

Conditions in MicroStrategy Preview 18:52

Transformation in Metric Preview 09:02

Attribute and Metric Filters in MicroStrategy Preview 11:13

Relationship Filter in MicroStrategy Preview 20:07

Report Filter in MicroStrategy Preview 10:27

Filter definition Prompt Part-01 Preview 14:36

Filter definition Prompt Part-02 Preview 13:06

Object,Value and Level Prompt Preview 15:14

Search Objects Preview 09:18

Consolidation Preview 06:49

Custom Group Preview 14:03

Consolidation and Custom Group Differences Preview 08:54

Overview of Intelligent Cubes Preview 09:58

MicroStrategy Web Installation Preview 09:01

Data Loading and Data Wrangling Preview 08:27

Bar Chart Visualizations in MicroStrategy Dossier Preview 09:52

Line Chart & Pie Chart Visualization in MicroStrategy Dossier Preview 13:46

Heat Map Visualization Preview 12:18

Smart KPI Visualizations Preview 11:13

Dashboard Creation Preview 08:13

MicroStrategy Grid Visualization Part-01 Preview 08:36

MicroStrategy Grid Visualization Formatting and threshold Preview 10:31

Grouping Attribute Elements Preview 03:36