I am presenting at the first SQLSaturday event in Denmark, with my session “Create a metro style dashboard using Excel and PowerPivot”.
First of all I think the community has done a great job to bring the SQL Saturday concept to Denmark, and hope that the event can become such a success that we can do it many times. Sharing knowledge and learning from the SQL Pass community is really a great opportunity for all SQL professionals.
My session will focus on how to use Excel 2013 to build a dynamic dashboard in the Metro Style look and feel based on a Powerpivot model.
I will demonstrate
- How to build a PowerPivot model
- How to extract data and values from the PowerPivot model using the Excel CUBE functions instead of using pivottables
- How to create dynamic sets to get the latest periods
- How to create a parameterized DAX table
- How to design a metro style chart
- How to create Metro Style KPI boxes in Excel
I am really looking forward to my first speaker session and hope that the session will bring new learnings to you.
See you at SQL Saturday #196