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

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

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

  • 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-Overview of Data Warehousing
5
1.1-Overview of OLTP
1.2-Data warehousing Concepts
1.3-Benefits and Limitation of Data Warehouse
1.4-ETL in Data Warehousing
1.5-ETL vs ELT
2-Overview of Dimensional Modeling
4
2.1-Dimensional Modeling Overview
2.2-Star Schema,Snowflake Schema and Galaxy Schema
2.3-Dimensional Modeling Design Steps
2.4-Slowly Changing Dimension
3-Getting Started with MicroStrategy
6
3.1-MicroStrategy Introduction
3.2-Microsoft SQL Server Installation
3.3-MicroStrategy Installation
3.4-MicroStrategy Configuration and Product Activation
3.5-MicroStrategy Architecture
3.6-Project Source and Project Creation
4-Components in MicroStrategy
5
4.1-MicroStrategy Architect Tutorial
4.2-Create an Attribute in Microstrategy
4.3-Compound Attributes
4.4-Hierarchies in Microstrategy
4.5-Create Facts
5-Metric in MicroStrategy(Levels,Conditions & Transformation)
5
5.1-Overview of Metrics in MicroStrategy
5.2-Use of Metric in a Report
5.3-Different Level Metrics
5.4-Conditions in MicroStrategy
5.5-Transformation in Metric
6-Filters in MicroStrategy
3
6.1-Attribute and Metric Filters in MicroStrategy
6.2-Relationship Filter in MicroStrategy
6.3-Report Filter in MicroStrategy
7-Prompts & Search Objects in MicroStartegy
4
7.1-Filter definition Prompt Part-01
7.2-Filter definition Prompt Part-02
7.3-Object,Value and Level Prompt
7.4-Search Objects
8-Consolidation and Custom Group in MicroStrategy
4
8.1-Consolidation
8.2-Custom Group
8.3-Consolidation and Custom Group Differences
8.4-Overview of Intelligent Cubes
9-MicroStrategy Visualization and Dashboard Creation
10
9.1-MicroStrategy Web Installation
9.2-Data Loading and Data Wrangling
9.3-Bar Chart Visualizations in MicroStrategy Dossier
9.4-Line Chart & Pie Chart Visualization in MicroStrategy Dossier
9.5-Heat Map Visualization
9.6-Smart KPI Visualizations
9.7-Dashboard Creation
9.8-MicroStrategy Grid Visualization Part-01
9.9-MicroStrategy Grid Visualization Formatting and threshold
9.10-Grouping Attribute Elements