Presenting at SQLSaturday #196 Copenhagen

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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s