Developing High-Impact Dashboards in Microsoft Office

Encode Data Matrix ECC200 in Microsoft Office Developing High-Impact Dashboards

the graph) Now, the Average is actually $600,000,00000 but in your InfoCube you are storing the difference or in the query you are calculating the difference so the Average is actually $100,000,00000 Using the average number of $100,000,00000 and using the Stack option for the bar chart type you get the $600,000,00000 You do the same for the Highest Level, and when it is presented on the chart, you get your correct sections for the ranges To configure this dashboard, I again started with a table in the WAD I then added the required Web items Column and Bar Chart types Just remember that if you need to adjust the size of the table, you should use the option to reduce the size This will help eliminate any spaces between the chart types I ve used 80% in this case to help structure the Web items as well Now the rest of the configuration for the stacked columns comes into play with the series formatting Within the wizard, I assigned the chart type stacked columns and then switched to the Refine approach to get to each of the series to configure at that level, as shown next Using the different shades of color helps emphasize the sections of the stack

For Series4, I changed the look and feel via the Refine view to the line chart type and also adjusted the format of the Area Property In this configuration, I adjusted several items, as shown in the next illustration: I changed the Chart Type to Lines In the Area Properties, I adjusted the two colors Color and Secondary Color In the Area Properties, I adjusted the Marker Shape to Triangle

In the case of the waterfall chart type, I had to do a couple of additional configuration changes, but I used the same stacked column to start, and then just worked with the colors within the series to make them invisible, creating a floating center section I created that type of chart in about five minutes With a little touch-up, I achieved the finished product The next illustration shows the configuration for the top section of the waterfall chart I didn t really make the section invisible but rather made it blend with the background so that the color is the same as the background color That s the trick

7:

To complete this, we can now look at Series4, which is the line chart type In this case, I adjusted the look and feel of the line and marker itself As shown in the following illustration, I enlarged the size of the marker so that the complete value can be seen within the object I adjusted this to a size of 30, and chose Circle for the Marker Shape Finally, I turned on the (visible parameter) Show Labels option The important item here is to leave the Format field blank This will allow the values to show up as absolutes rather than fighting with currency or unit of measure (UOM) signs

The additional configuration is very similar to that of the previous dashboard All in all, this is a consistent dashboard and will accommodate many different requirements by your customers Yes, you could get really fancy and add all the bells and whistles, even going as far as creating your own HTML that you type directly into the XHTML tab within the WAD If you want items that consist of links to other formatting options that are not available within the WAD or links to other systems, you will have to use this functionality All in all the WAD component of BI to help with the display of our KPIs within a dashboard format If we take this configuration and go just one step further using the Visual Composer (VC) toolset, we can see the finished results of a dashboard Now this example has more dynamic visual appeal, but the basic information that you see is very similar to what we just developed from the WAD The next illustration shows the finished product of a WAD-developed report in VC You can see that this type of data is very similar to what we ve reviewed, but now the wow factor comes into play

7: