EncartaLabs

MicroStrategy Designing Metrics for the Intelligent Enterprise

( Duration: 1 Day )

In MicroStrategy Designing Metrics for the Intelligent Enterprise training course, attendees will learn to develop enterprise metrics such as level and transformation metrics for use on analytical reports. Work with filters to create conditional metrics. Implement data governance by creating base metrics. The majority of this course is hands-on using MicroStrategy Web in a cloud environment.

By attending MicroStrategy Designing Metrics for the Intelligent Enterprise workshop, attendees will learn to:

  • Create time-based comparisons with transformation metrics
  • Create level metrics to compare contributions
  • Present inventory data with non-aggregatable metrics
  • Create conditional metrics to filter your calculations
  • Select the function used for dynamic aggregation, when attributes are removed on the fly from a report

  • Attend MicroStrategy - Enterprise Analytics Overview training or equivalent knowledge
  • Attend MicroStrategy - Analytics Reporting training or equivalent knowledge

  • Metric Designer

COURSE AGENDA

1

Introduction to enterprise metrics

  • Calculating business data: Metrics
  • Reusing metric formulas for consistency and data governance: Base metrics
2

Transformation metrics

  • Time-based comparisons
3

Level metrics

  • Changing a metric's calculation level
  • Defining a level
  • Defining whether the level metric aggregates (groups) by the target attribute
  • Defining the level metric's relationship with the report filter
  • Combining aggregation and filtering options to create a level metric
  • Interacting with the context of reports: Report level
  • Creating metrics with the Formula Editor
  • Nested metrics: Multiple formulas with different levels in a single metric
4

Non-aggregatable metrics

  • Inventory metrics
5

Conditional metrics

  • Applying filters to metrics
  • How conditional metrics and report filters interact
  • Ignoring related report filter elements
  • Merging metric and report filters
6

Dynamic aggregation

  • Calculating metrics at different levels on a report
  • Changing the dynamic aggregation function of metrics

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top