April 18th and 19th, 2017, 18 en 19 april 2017
Program for The Amsterdam Excel Summit, April 19, 2017
Please note this program may be subject to change!
|Start||End||BI track||Deep Into Excel track|
Start and introduction of speakers
Tony De Jonker & Jan Karel Pieterse
Guy Hunkin (Microsoft Excel Senior Program Manager)
|09:55||11:10||Side sessions 1||
Automatically convert currencies depending on the date.
In this PowerQeury session, Frédéric will demonstrate a couple of things, including:
Frédéric Le Guen
Make Your Life Easier with Excel Tables
Excel Tables (not “tables”) have been helping users since their introduction as “Lists” in Excel 2003. Four major versions later, Excel’s Tables have matured into a powerful and dynamic data structures. Their filtering and sorting capabilities as well as their dynamic nature make them an indispensable sidekick to Pivot Tables and Charts. We’ll look at just a few ways that Tables can make Excel more fun.
|11:10||11:30||Break and networking opportunities|
|11:30||12:45||Side sessions 2||
The goofy things to watch out for in PQ
PowerQuery is great, but there are things that are still much easier to do in native Excel. Join Oz for a great session that helps you determine your data import strategy.
Oz Du Soleil
A comparison of Excel Extensibility Technologies
VBA, VB6, VSTO,
The objective for this session is to answer questions like:
|13:45||15:00||Side sessions 3||
Excel Power Pivot – Hierarchy and Control tables.
In this session we’ll deep-dive into some unknown DAX functions and Power pivot functionality. We will build a P&L statement, using a Dutch ledger schedule. To accomplish this we use the DAX PATH functions and the new possibilities of VAR definitions within Excel 2016. Next we will build a control table to combine slicers with (predefined) measures. The prime DAX function we use in this case is the is DAX SWITCH. Basically what we’ll do is create different measures and use a slicer to present the selected measure in the desired dashboard. By combining the hierarchy with the control table the output dashboard stays very compact.
Bing maps & Excel
What’s the distance between two cities (addresses) if you go by car, walk or take public transportation? Where in Excel can we get that information? Short answer is nowhere.
|15:00||15:20||Break and networking opportunities|
|15:20||16:35||Side sessions 4||
Moving beyond Excel with Power BI
If you haven’t come across Power BI yet, you’re missing a huge change in the business intelligence landscape. A free tool that lets you rapidly collect, clean and transform your data, it also allows you to build great insights quickly using the Excel skills you already know. Even better, however, it also removes several sharing barriers that existed with Excel… have you even wanted to deploy an interactive report to your phone? Well now you can!
Join Ken as he shows how you can take your Excel knowledge into the new and exciting world of Power BI.
The Checks In The Post
People build models all the time. People build errors all the time. People seldom build checks. Correlation?? Would you like us to keep you posted about why checks will pay you back with interest? You can cash in with this session.
Experienced financial modeller and auditor Liam Bastick will highlight
Microsoft Principal Designer Jakob Nielsen and Microsoft Program Manager Sudhi Ramamurthi will be presenting this session. More details will be disclosed soon.