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 were in English.
Merk op dat de voertaal van de dag Engels is.

Registration
Registratie

Registration has closed.

Location
Locatie

Room Mate Aitana Hotel
IJdok 6
1013 MM Amsterdam
map

Registration

Start and introduction of speakers

Tony De Jonker & Jan Karel Pieterse

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

Using Power Query for your ultimate data preparation

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

• Connect to an external folder
• Merge
• Append
• Conditional Columns
• Unpivot

Oz Du Soleil

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 will touch on these subjects:

• Preserve incoming data
• Use staging areas to plan and manage dashboards
• Facilitate alternate views of your data
• Streamline dashboard creation
• Facilitate dashboard maintenance and updates

Jon Peltier

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

The Best Tips & Tricks on Data Analysis & Reporting

Tony de Jonker

And we’ll wrap up after this great session too!