Masterclass Program

April 18th and 19th, 2017, 18 en 19 april 2017

Program for The Excel Data Analysis And Reporting Masterclass, April 18, 2017
Het programma van The Excel Data Analysis And Reporting Masterclass (18 april 2017)

(The program for day 2 is located here)

All presentations during this event will be in English.
Merk op dat de voertaal van de dag Engels is.


Register soon as the number of available seats is limited!
Registreer snel, het aantal beschikbare plaatsen is beperkt!


Zilveren Toren Amsterdam
Stationsplein 51-53
1012 AB Amsterdam
The Netherlands
Map and Directions

Please note this program may be subject to change!

Start End Subject
09:00 09:30


09:30 09:45

Start and introduction of speakers

Tony De Jonker & Jan Karel Pieterse

09:45 11:15

Streaming datasets in Power BI

The speed of creating an Analysis or an Overview of the KPI’s in a company is growing in significance. To make quality decisions, one needs quality data and foremost up to date data. If I don’t see data from “Right Now” or to put it differently if I don’t see data LIVE it’s very hard to steer the ship. This session is going to look at today’s methods of live data streaming and in doing that we’re going to look at the famous IoT world.

Gašper Kamenšek

11:15 11:30 Break and networking opportunities
11:30 13:00

A data-cleansing perspective on Power Query

In this session Oz shows you the ropes on how you can do your data cleansing using PowerQuery.

Oz Du Soleil

13:00 14:00 Lunch
14:00 15:30

Designing your model for charts and dashboards

People don’t think enough about what data is good for what purposes, so they take their initial data, try to format it as a table and also make a chart from it. This often ends up with unsuitable tables and unsuitable charts. We’ll have better success if we follow the process of: Data –> Analysis (pivot tables, formulas, etc.) –> Staging Areas (rearranged and reformatted, but linked to predecessor data and calculations) –> Individual Dashboard Elements (charts, tables, etc.).

Jon Peltier

15:30 15:45 Break and networking opportunities
15:45 17:15

Reverse-Engineering an Excel dashboard

So what makes a good dashboard? And how do you make one in Excel?

In this session David Hoppe will take apart a world-class dashboard and lay out the bits and pieces that make it work its magic.

From general principles of information dashboard design to crafting custom charting types using native Excel charts – this session will teach you how to enrich sparklines with bandlines, stripplots and bulletgraphs to convey a wealth of information.

Get a sense of the formula-driven clockwork that makes a good dashboard tick – no VBA involved. Pick up formatting and modeling strategies to make Excel’s static grid-layout really come to life.

David Hoppe


Wrap up

Top Excel classes, training and events