Porto.Data #55 From Power BI to Excel: the best of the two Worlds

Next Porto.Data meetup will be dedicated to Microsoft Power BI, and we are happy to have an expert to talk about it.

Pedro Reis is a Business Intelligence and Supply Chain Management professional, and above all a Power BI, Excel, and full Microsoft BI Stack enthusiast. MCSA in BI Reporting, Founder, Co-Leader of the PowerBIPortugal meetup group and the Porto PUG, currently working @ Altran as Solutions Architect.

Session summary:
Power BI is "the" tool of the moment. But did you know that once you have Power BI Data in the cloud, you can also Analyze it in Excel? I'll show how to do it and why.

This session will help:

• A business user who wants to have flexibility in analyzing Power BI Datasets in Excel, and learn more how to leverage both together
• An IT professional who wants to provide the best options in his model and governance for the user from the datasets he manages

In a glance, I'll show you:

• How to connect from Excel to the Data Model stored in a Power BI cloud dataset
• Which are the reasons for doing so
• Things you can do in Excel which you cannot do in Power BI
• How to do some amazing things with formulas connected to the cube by using MDX, named ranges and much more!
• How to publish charts and other elements from Excel to Power BI in the Cloud

Agenda
• Welcome
• Talk: From Power BI to Excel: the best of the two Worlds - Pedro Reis.
• Coffee break\networking
• Closing