This dashboard uses a combination of XLCubed Reporting Techniques, in-cell Charting and Excel Charts to provide an effective visualization of the key aspects of the business performance for a fictitious bicycle sales company.

The two prerequisites to use the example workbook are:

• A licensed or evaluation version of XLCubed Excel Edition.
• The workbook connects to a sample local cube file installed with XLCubed Excel Edition. It assumes that XLCubed was installed to the default location.

Note that this workbook is also available through Start – All Programs – XLCubed – Management Book.xls.

The information displayed can be varied by Time and Point of Sale, using the drop down selectors. A detail product level view for each KPI is available by clicking on one of the linkthrough cells in E7:E14.

Feel free to contact us to discuss the approach or techniques used, and how they can be applied to your environment.

Click here to download the excel file,