This is the Program of the 2014 Event. Dit is het programma van het evenement in 2014
All presentations during this event will be in English.
Merk op dat de voertaal van de dag Engels is.
9:00 | Registration Registratie |
9:30 | Start and introduction of speakers by Tony De Jonker & Jan Karel Pieterse Begin van de dag en presentatie van de sprekers door Tony De Jonker & Jan Karel Pieterse |
9:45 | Tips and tricks by our presenters Tips en trucs door onze experts |
10:15 | Keynote Plenaire sessie Bill Jelen And Ken Puls Power Excel: PowerPivot, Power Query, Power View and Power Map in one consolidated solution! Power Excel: PowerPivot, Power Query, Power View en Power Map in een geconsolideerde oplossing! |
11:00 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
11:15 | Round 1 Ronde 1 |
12:30 | Lunch |
13:30 | Round 2 Ronde 2 |
14:45 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
15:00 | Round 3 Ronde 3 |
16:15 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
16:30 | Excel Visualizations by Tony De Jonker & MVP support Excel Visualisaties door Tony De Jonker & MVP support |
17:15 | Wrap up by Tony De Jonker & Jan Karel Pieterse Afsluiting door Tony De Jonker & Jan Karel Pieterse |
Sessions
Round | Subject | Speaker |
1 |
VLOOKUP – from Basic to Advanced.
|
Bill Jelen |
Introduction to PowerPivot.PowerPivot is revolutionizing the way that we look at data inside Microsoft Excel. Allowing us to link multiple tables together without a single VLOOKUP statement, it enables us to pull data together from different tables and databases where we never could before. But linking data from multiple sources, while powerful, only scratches the surface of the impact that it is making in the business intelligence landscape.
If you haven’t seen PowerPivot before, YOU NEED TO ATTEND THIS CLASS! Plain and simple, PowerPivot is the future of Business Intelligence in Excel. |
Ken Puls | |
2 |
How to make Excel Calculate Your Workbooks FasterTopics:
|
Charles Williams |
Date Intelligent Measures – Building a PowerPivot Time Machine.To anyone who works in retail or finance, one of the most important things we want to be able to do is step back in time to look at results. Our dashboards are full of stats like Month to Date, Year to Date and so on. But what happens when we have huge amounts of data at our fingertips and we get asked to compare Month to Date versus the same period last year? Do you have to create another Pivot Table and/or some complicated formulas to pull it off? Depending on the approach this can be dangerous and maintenance can become a nightmare.
Please Note: This course will be covering DAX measures in PowerPivot. Attendees should either have some working experience with PowerPivot, or attend the Introduction to PowerPivot session earlier in the day. |
Ken Puls | |
3 |
Array formulas
|
Bill Jelen |
PowerView and PowerQueryPower Query is an amazing new tool for importing your data in Excel. Many users mainly use csv files to import data in Excel and unfortunately, this technique involves a lot of work (concatenate, delete, group data). With Power Query, you don’t need to do all of this because the tool saves all your data manipulation before importing the data into your Spreadsheet. PowerQuery:
Powerview:
|
Frédéric Le Guen |