From Power BI to Excel - The best of two worlds

 
English Intermediate Other

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 you 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

Speaker

Pedro Reis

IT Team Leader

Pedro is passionate about Leading Teams and turning data, technology, and people together into value. During the last 15 years, Pedro has managed multiple teams in Banking, Supply Chain, and Operations, and also planned and coordinated the construction and migration of thousands of Reports to Power BI, SSRS, and other BI tools. He is the Co-Founder of the Power BI Portugal Meetup group and the Porto Power BI User Group, Invited University Lecturer, and active speaker at events like Power Platform World Tour, SQL Saturday, Porto Data, and local meetups.

Code of Conduct

We seek to provide a respectful, friendly, professional experience for everyone, regardless of gender, sexual orientation, physical appearance, disability, age, race or religion. We do not tolerate any behavior that is harassing or degrading to any individual, in any form. The Code of Conduct will be enforced.

Who does this Code of Conduct apply to?

All live stream organizers using the Global Azure brand and Global Azure speakers are responsible for knowing and abiding by these standards. Each speaker who wishes to submit through our Call for Presentations needs to read and accept the Code of Conduct. We encourage every organizer and attendee to assist in creating a welcoming and safe environment. Live stream organizers are required to inform and enforce the Code of Conduct if they accept community content to their stream.

Where can I get help?

If you are being harassed, notice that someone else is being harassed, or have any other concerns, report it. Please report any concerns, suspicious or disruptive activity or behavior directly to any of the live stream organizers, or directly to the Global Azure admins at team@globalazure.net. All reports to the Global admin team will remain confidential.

Code of Conduct for local live streams

We expect local organizers to set up and enforce a Code of Conduct for all Global Azure live stream.

A good template can be found at https://confcodeofconduct.com/, including internationalized versions at https://github.com/confcodeofconduct/confcodeofconduct.com. An excellent version of a Code of Conduct, not a template, is built by the DDD Europe conference at https://dddeurope.com/2020/coc/.