MicroStrategy - Creating Dashboard

A dashboard is made up of multiple visualizations. It shows many attributes grouped into separate visualizations. When we place some common attribute or metric in multiple visualization, it is easy to study the variations among them.

In the following example, we will create a dashboard showing some common attributes among the visualizations.

Step 1

Create a grid visualization using superstore.xlsx as an example data source. We drag the attributes product - Subcategory and Shipping cost - to the rows box. Then we insert the second visualization into the report as shown in the following screenshot.

Step 2

Add all the above attributes as well as an additional attribute named unit price to the newly inserted visualization as shown in the following screenshot.

Step 3

Finally, apply different visualization types to these grids. We apply pie-chart to the top visualization and heat-map chart to the bottom visualization as shown in the following screenshot. The result shows a dashboard with some common attributes used in the two visualizations.