Excel and Power BI Unplugged
Gašper Kamenšek is a Microsoft MVP for Excel and MCSA for BI Reporting. Gašper is a lead author @ Excel Unplugged, where he tries to generously share his knowledge and enthusiasm about Excel. He is a regular speaker at many international conferences in Europe and all around the World. When he is not lecturing Excel, Gašper is busy with various BI projects consisting either of Power Query and PowerPivot, VBA for Excel and increasingly Power BI, which seems to be endless in its variations of applicability. The thing we find most fascinating about Excel is that although we use it every day, it still finds ways to surprise and amaze us.
Gašper lives in Ljubljana, Slovenia where he leads his consulting firm called Excel Olympics.
The first Excel & Power BI session will be the tribute to the diversity of importing Excel files into Power BI Desktop. We will be touching base on simple Excel imports and just go through the Do’s and Dont’s and dig deep into more complex scenarios for importing Excel files.
This session will go beyond a simple Power BI Desktop “Power Query” experience of importing Excel Files and show multiple other ways to get data or in some cases parts of the file and in some cases the entire Excel file to the Power BI. This session will include tools like:
Office 365 offers quite a few extensions to Excel that are not available in the regular standalone version of Microsoft Office. This first session will look at how the user experience varies between the two versions and why Office 365’s version of Excel is actually Excel vNext. There have been a number of little changes added but now they do add up to a quite different experience and quite a different product. Since many companies are already using Office 365 or will start to use it in the near future, this session will provide a walkthrough of the differences. All will include short demos and some a more in-depth look and a vision of the future. The session will among other differences focus on:
Whereas session one of Office 365 & Excel focused on differentiating between Excel 365 and a standalone version of Excel, this session is meant to place Excel within the whole Office 365 package. And this includes so much more than just other products from the Office suite. We will look at the collaboration story between Excel and:
This session should really give you a broader picture where Excel is just one piece (the most important one of course) of the Office 365 puzzle and how the whole picture gives you even more options and tools to enhance Excel.
Gašper Kamenšek started Excel Unplugged with one reason only. To help people through the maze of Excel commands and functions and make them better at their everyday tasks in Excel. It was going to start off as a depository for keyboard and mouse Shortcuts, various Tools in Excel with some useful functions and a little bit of VBA. That plan seriously sidetracked with the release of Power Pivot. It sidetracked even more with the release of Power Query. Then along came Power BI. Gašper admits that Power BI is its own product and technology, however, he does not consider it as anything else but an Excel extension. The whole complex of new technologies and tools became the topic of his writing. Hence, the original idea of Excel Unplugged has transformed a bit since the early beginnings.
Currently, it covers a very broad array of topics varying from Excel to Power BI. Gašper has been recently fiddling around with Power Apps, Microsoft Forms and Microsoft Flow. These are all powerful tools in the Office 365 suite; in combination with Excel, they can make our work much much easier. Gašper believes that these tools will definitely influence the future of the current manner of work.
We all keep searching for ways to improve our data models from performance and usability standpoint. This session will include techniques that I’ve learned to improve my data models. Whereas I will use Power BI for all the demos, this is also 100% applicable in Excel. Some of the presented solutions also improve data models […]