MicroStrategy for Business Intelligence
4.2 (144 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.
631 students enrolled

MicroStrategy for Business Intelligence

Comprehensive course on MicroStrategy Desktop and Web Dashboards
4.2 (144 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.
631 students enrolled
Created by Saad Qureshi
Last updated 6/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 11 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
  • 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
Expand all 42 lectures 07:06:10
+ Overview of Dimensional Modeling
4 lectures 37:01
Dimensional Modeling Overview
11:40
Star Schema,Snowflake Schema and Galaxy Schema
03:25
Dimensional Modeling Design Steps
12:34
Slowly Changing Dimension
09:22
+ Getting Started with MicroStrategy
6 lectures 58:04
MicroStrategy Introduction
01:57
Microsoft SQL Server Installation
13:22
MicroStrategy Installation
08:47
MicroStrategy Configuration and Product Activation
09:54
MicroStrategy Architecture
15:35
+ Components in MicroStrategy
5 lectures 42:51
MicroStrategy Architect Tutorial
12:16
Create an Attribute in Microstrategy
10:30
Compound Attributes
05:39
Hierarchies in Microstrategy
08:46
Create Facts
05:40
+ Metric in MicroStrategy(Levels,Conditions & Transformation)
5 lectures 01:02:52
Overview of Metrics in MicroStrategy
06:59
Use of Metric in a Report
08:08
Different Level Metrics
19:51
Conditions in MicroStrategy
18:52
Transformation in Metric
09:02
+ Filters in MicroStrategy
3 lectures 41:47
Attribute and Metric Filters in MicroStrategy
11:13
Relationship Filter in MicroStrategy
20:07
Report Filter in MicroStrategy
10:27
+ Prompts & Search Objects in MicroStartegy
4 lectures 52:14
Filter definition Prompt Part-01
14:36
Filter definition Prompt Part-02
13:06
Object,Value and Level Prompt
15:14
Search Objects
09:18
+ MicroStrategy Visualization and Dashboard Creation
10 lectures 01:35:33
MicroStrategy Web Installation
09:01
Line Chart & Pie Chart Visualization in MicroStrategy Dossier
13:46
Heat Map Visualization
12:18
Smart KPI Visualizations
11:13
Dashboard Creation
08:13
MicroStrategy Grid Visualization Part-01
08:36
MicroStrategy Grid Visualization Formatting and threshold
10:31
Grouping Attribute Elements
03:36