Design a metro style dashboard in Excel
Yesterday I presented at SQL Saturday Copenhagen #196 how to create a Metro Style Dashboard using Microsoft Excel 2013 and PowerPivot.
I made this using standard Excel functionality and with no use of VBA, and heavy use of the CUBE functions to retrieve values from the datamodel.
As promised I have uploaded a copy of the model to Skydrive – Link
My presentation can be downloaded from Link
The macro to hide the Excel look is as follows – place it in your Personal Macro Workbook
Sub TurnExcelOff(bolState As Boolean)
Application.DisplayFormulaBar = bolState
Application.DisplayStatusBar = bolState
.DisplayVerticalScrollBar = bolState
.DisplayWorkbookTabs = bolState
.DisplayGridlines = bolState
.DisplayHeadings = bolState
If you have any questions please feel free to comment on this post and I will try to answer.
PS – Thanks to all the people that arranged a great SQL Saturday event #196 in Copenhagen.