June 7 and 8, 2018,
7 en 8 juni 2018
Program for The Excel Business Modeling And Reporting Masterclass, June 8, 2018
Please note this program may be subject to change!
Start and introduction of speakers
Tony De Jonker & Jan Karel Pieterse
How to build Excel Models
There are some rules you need to know when building complex Excel models. This session will show you the basic rules of building Excel models. It is loaded with tips and tricks to get more out of your Excel model. Become a real Excel Pro by mastering the structure of your model.
|10:30||11:00||Break and networking opportunities|
Effective Data Transformations
Power Query is an incredible data transformation tool but it requires a different mindset than we’re used to in native Excel. Lots of tasks are much easier in Power Query but, we can’t do the things we’ve come to love and adore over the past 30 years; e.g., create helper columns, type directly into cells, copy-paste ranges of cells. And there is no un-do!
Oz Du Soleil
The greatest Sales Report in the world
A get-your-hands-dirty demo session on how to create a great Sales Report in Power BI from raw data coming from SQL server, Excel Worksheets and other sources. All fitted perfectly into a data model and coupled with a dynamic Calendar, basic and advanced measures and visualized in Power BI. The highlights will be:
|14:30||15:00||Break and networking opportunities|
Having confidence in your forecast
They say Insight + Hindsight = Foresight, so how do you deploy this in practice? This session will consider predictive forecasting using several approaches, all relatively straightforward in Excel. Come along and improve your forecasting confidence levels accordingly.
Tips & Tricks
From Excel to Power Pivot
Power Pivot is a great tool to analyze a huge volume of data in Excel but the way to return results is totally different from the logic of Excel. This session will explain you this logic and how to create measures.
Frederic Le Guen