- Overview of OLTP
- Data warehousing Concepts
- Benefits and Limitation of Data Warehouse
- ETL in Data Warehousing
- ETL vs ELT
Online
₹ 449 3,499
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 449 ₹3,499
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Overview of Data Warehousing
Overview of Dimensional Modeling
- Dimensional Modeling Overview
- Star Schema,Snowflake Schema and Galaxy Schema
- Dimensional Modeling Design Steps
- Slowly Changing Dimension
Getting Started with MicroStrategy
- MicroStrategy Introduction
- Microsoft SQL Server Installation
- MicroStrategy Installation
- MicroStrategy Configuration and Product Activation
- MicroStrategy Architecture
- Project Source and Project Creation
Components in MicroStrategy
- MicroStrategy Architect Tutorial
- Create an Attribute in Microstrategy
- Compound Attributes
- Hierarchies in Microstrategy
- Create Facts
Metric in MicroStrategy(Levels,Conditions & Transformation)
- Overview of Metrics in MicroStrategy
- Use of Metric in a Report
- Different Level Metrics
- Conditions in MicroStrategy
- Transformation in Metric
Filters in MicroStrategy
- Attribute and Metric Filters in MicroStrategy
- Relationship Filter in MicroStrategy
- Report Filter in MicroStrategy
Prompts & Search Objects in MicroStartegy
- Filter definition Prompt Part-01
- Filter definition Prompt Part-02
- Object,Value and Level Prompt
- Search Objects
Consolidation and Custom Group in MicroStrategy
- Consolidation
- Custom Group
- Consolidation and Custom Group Differences
- Overview of Intelligent Cubes
MicroStrategy Visualization and Dashboard Creation
- MicroStrategy Web Installation
- Data Loading and Data Wrangling
- Bar Chart Visualizations in MicroStrategy Dossier
- Line Chart & Pie Chart Visualization in MicroStrategy Dossier
- Heat Map Visualization
- Smart KPI Visualizations
- Dashboard Creation
- MicroStrategy Grid Visualization Part-01
- MicroStrategy Grid Visualization Formatting and threshold
- Grouping Attribute Elements