QPR Knowledge Base 2015.1

Heat Map Charts

Heat Map Charts

Previous topic Next topic No directory for this topic  

Heat Map Charts

Previous topic Next topic Topic directory requires JavaScript Mail us feedback on this topic!  

With heat map charts, companies can position their strategic risks in one graph. The heat map chart provides the user with good understanding of the magnitude and importance of different risks.

 

mouse_24 Exercise 135: Create a Heat Map Chart.

 

BTN_AR131. Open the Heat Map Exercise model.
BTN_AR132. On the bottom of the Model Navigator frame, click the btn_scorecard_navigator to open the Scorecard Navigator.
BTN_AR133. From the Tool Palette, drag four Measure elements under the Strategic Risks perspective:

pic_heat_map_drag_measures

BTN_AR134. Rename each of the measures by selecting it and pressing the F2 key. Give the measures the names Risk 1, Risk 2, Risk 3 and Risk 4.
BTN_AR135. Double-click the Risk 1 measure to open the Element Properties window.
BTN_AR136. On the General tab of the Element Properties window, define the measurement settings as in the picture below:

pic_risk_measurement_settings

BTN_AR137. Switch to the Series tab.
BTN_AR138. Select the Risk Value series, change the Input Type to Formula and define the formula as PROD(LIKE, IMP):

pic_heat_map_rval_formula

BTN_AR139. Switch to the Values tab.
BTN_AR1310. Input values between one and ten to the series. This will make sure that the maximum value of the risk value is 100. For example, the values can be as in the picture below:

pic_heat_map_values

BTN_AR1311. Close the Element Properties window by clicking the btn_close_element_properties button on the top right corner of the window.
BTN_AR1312. Repeat the steps 6-11 for the remaining three risk measures.
BTN_AR1313. Next, we'll define the settings for the parent measure. On the Scorecard Navigator, double-click the Strategic Risks perspective.
BTN_AR1314. The Element Properties window opens. On the General tab, define the measurement settings as in step 6.
BTN_AR1315. Switch to the Graph tab and the Edit Layout button to open the Graph Layout window.
BTN_AR1316. Right-click the chart area and select Chart Type > Heat map chart from the pop-up menu:

pic_heat_map_graph_layout1

BTN_AR1317. Right-click the chart area again and select Chart settings from the pop-up menu:

pic_heat_map_graph_layout2

BTN_AR1318. The Chart Properties window opens. We'll want to show only the Impact and Likelihood series in the heat map, so for the Alarm, Risk Value and Target, make sure Hide series is selected:

pic_heat_map_chart_prop_hide_series

BTN_AR1319. Make sure the Impact series is set to Horizontal and the Likelihood is set to Vertical.
BTN_AR1320. Next we'll add the Risk measures to the heat map. Switch to the Elements tab and click the Add... button:

pic_heat_map_chart_prop_select_elements

BTN_AR1321. The Select Elements window opens. Select the Risk measures we created earlier by clicking the Risk 1 element on the list, holding down the Shift key, clicking the Risk 4 element and clicking OK:

pic_heat_map_chart_prop_select_elements_list

BTN_AR1322. Next, we'll define the period for the heat map. In the General tab, define the period as in the picture below:

pic_heat_map_chart_prop_periods

BTN_AR1323. Switch to the Axes tab. From the Axis drop-down menu select Vertical and then Horizontal and make sure that the Visible check box is selected in both selections.
BTN_AR1324. Next, we'll select a background for the heat map. Switch to the Chart Area tab. In the Picture group, click the Load button.
BTN_AR1325. Select a background image and click Open.
BTN_AR1326. Make sure that the Place picture inside the chart check box is selected and click OK to close the Chart Properties window.
BTN_AR1327. The Heat Map chart should now look somewhat as in the picture below:

pic_heat_map_chart_ready

For more information, see the General Tab of the Chart Properties (Heat Map Chart) topic in QPR Metrics - User's Guide.