
June 7 and 8, 2018,
7 en 8 juni 2018
Program for The Excel Business Modeling And Reporting Masterclass, June 8, 2018
|
Registration
|
Please note this program may be subject to change!
Start | End | Subject |
08:30 | 09:00 |
Registration |
09:00 | 9:15 |
Start and introduction of speakersTony De Jonker & Jan Karel Pieterse |
09:15 | 10:30 |
Having confidence in your forecastThey 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.
Liam Bastick |
10:30 | 11:00 | Break and networking opportunities |
11:00 | 12:15 |
From Excel to Power PivotPower 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 |
12:15 | 13:15 | Lunch |
13:15 | 14:30 |
Effective Data TransformationsPower 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 |
14:30 | 15:00 | Break and networking opportunities |
15:00 | 16:15 |
The greatest Sales Report in the worldA 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:
Gašper Kamenšek |
16:15 | 16:45 |
Tips & TricksBob Umlas |
16:45 | 17:30 |
How to build Excel ModelsThere 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.
Henk Vlootman |