Merging Magic with Power Query

NOTE:
As mentioned at our October meet-up, we are moving to a new format where we will host 2 meet-ups each month. Our goal is to have one presentation focused on Power BI and one on Excel (though some presentations may overlap both tracks). We'll note the session's track(s) at the top of each event page.

SESSION TRACK:
Power BI & Excel

SESSION OUTLINE:
Joseph Yeates will start off the evening by going over some of the latest features in Power BI.

Next, Ken Puls will present on different ways to merge your Excel and Power BI data. If you've ever tried to compare two lists for equalities or inequalities in Excel, you know how hard that could be. Fortunately, Power Query makes this easy in Excel and Power BI. In this session we'll begin by looking at the 6 different join types native to Power Query. But then we'll step into a more challenging world... the hidden 7th join type, fuzzy matching, approximate matching and even making matches against different rows of your data table (in an efficient manner). After this session, you'll be armed with methods to match (or view mismatches) in virtually any way you can think of!

SPEAKER PROFILE:
Ken Puls, FCPA, FCMA, is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Ken is a blogger, author and trainer with over 20 years of corporate accounting and IT experience. He is one of the world’s leading experts in Microsoft Excel, Power Query and Power BI, and provides live and online training to clients around the world.

In recognition of his contributions, Ken has held the prestigious Microsoft MVP distinction since 2006 in both the Excel and Data Platform categories. Learn more about Ken at www.excelguru.ca and https://ca.linkedin.com/in/kenpuls, and follow him on Twitter (@kpuls) and Facebook (@xlguru).

TENTATIVE AGENDA (subject to change):
• 5:45pm Teams Meeting opens to attendees to begin joining
• 6:00pm-6:05pm Welcome and meeting overview
• 6:05pm-6:20pm "What's New in Power BI"
• 6:20pm-7:20pm Feature Presentation
• 7:20pm-7:25pm Meeting Wrap-up

REGISTRATION:
This meet-up will be hosted on Microsoft Teams, and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the Teams Meeting link.

JOINING THE EVENT:
Attendees can join the Teams Meeting starting at 5:45pm on the night of the event. The link will be visible only if you RSVP beforehand.

Once the event gets underway at 6:00pm, we ask that attendees make sure they are on MUTE, so background noise and distractions are minimized.

During the presentation, attendees can type questions and comments into the chat area, which will be monitored by the event hosts. There will be time for Q&A at the end, where attendees can un-mute their mic and even share their video to ask questions.

**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.