MicroStrategy ONE

Key Driver Analysis

Single factor key driver analysis is part of the MicroStrategy AI add-on bundle and is available for MicroStrategy Cloud Environment (MCE) customers starting in MicroStrategy ONE Update 11 (September 2023). Only users and user groups with the Use Auto Assistant and ML Visualizations privilege are able to access key driver analysis.

Key driver analysis is available in the following ways:

  • Through the visualization gallery in a dashboard using a drag and drop interface to create a Key Driver visualization.

  • Auto can utilize natural language queries to perform key driver analysis

Create a Single Factor Key Driver Visualization

  1. Open a dashboard for editing.

  2. In the top toolbar, click Insert Visualization .

  3. Choose Insight+ > Key Driver.

  4. Drag a metric from the Datasets panel to Target in the Editor panel.

  5. Drag attributes from the Datasets panel to Potential Drivers in the Editor panel.

Use Attributes as Additional Explanatory Factors

Add attributes to More Data Levels field:

For attributes that might not be your primary focus, MicroStrategy recommends adding them to More Data Levels. The target metric is analyzed at the visualization level, meaning the possible factors are determined from the pool of Potential Drivers objects. However, this reduces the granularity for the underlying algorithm and increases the precision of the result. This feature is specific to Key Driver Analysis visualization.

Customize the Appearance of a Key Driver Visualization

Make your key drivers visually engaging by customizing the appearance of your Key Driver visualization. Adjust colors, fonts, and labels to match your preferences and create a chart that's not only insightful, but looks great!

By default, factors that cause a metric to increase use the first color from the chosen color palette and factors that decrease the metric use the second color from the chosen color palette. However, you can customize the color, factor labels, and text using the Format panel.

  1. In the Format panel, click Text and Form .

  2. Under Title, select a font, size, and color.

  3. Under Factor Labels, select a font, size, and color.

  4. Under Shape, select colors for increasing and decreasing the value of the analyzed object.

Optimize Key Driver Analysis Visualization Interpretation

Get the most out of your key driver line chart visualization.

Hover for Insights Hover your cursor over a data point in the Key Driver Analysis visualization to reveal a tooltip. It contains detailed information about key driver analysis values.

FAQs

What key driver analysis method is used?

MicroStrategy produces the key factors by calculating the impact value on the average value. The formula of impact value is:

Copy 
Impact = (Overall Average Value - Average Value Excluding the Element) / ABS(Overall Average Value)

The impact value can reflect how the key driver influences the overall average. For example, you have a Data Scientist Salary dataset and the Employee Location is US has a 50% impact. This means the job location of a data scientist in the United States increases the overall average salary worldwide by 54%.

Can hyper-parameters be adjusted for key driver analysis?

Currently, MicroStrategy does not expose the hyper-parameter.