April Power BI User Group - 3 topics from out of town speakers

We will be having 3 out of town speaker presenting on different topics for us. Please see below for details. Meet at 5:30pm for some light refreshments and the presentations will start at 6pm. This meeting may run a bit longer than usual.

Gašper Kamenšek
• Microsoft MVP for Excel since 2016
• BI Consultant and Trainer @ Excel Olympics
• Lead Author @ ExcelUnplugged.com
• Trainer with 900+ courses
• Trainer with 5000+ attendees

Ultimate Sales Dashboard
This will be a short and sweet journey from raw sales data from a SQL server, Forecasts and Pricing tables that live in Excel Workbooks all the way to the "I can't believe I'm seeing this" reports in Power BI. And all that in just 25 minutes!!

Liam Bastick
• Seven Excel MVP awards
• Organiser of Unlock Excel events in Australia and New Zealand
• 30 years’ experience in Excel
• Author of over 2,000 articles around the world
• Trainer with 2,000+ courses / 14,000+ attendees

Surprisingly Complicated
How can I link to data on a website where it is on more than one page of a table, all with the same URL? It only took six MVPs, two program managers and one piece of third party software to crack this…

Ken Puls
• President of Excelguru Consulting Inc.
• Blogger, author and trainer with over 20 years of business and financial modelling experience
• Held the Microsoft MVP distinction since 2006
• One of the “Top 20 under 40” business & community leaders on Vancouver Island (I love that he uses this – he’s not under 40 😊)

Merging Magic: Surprising Ways to Solve Data Problems
Every problem I solve in this session will leverage the merge function to do it, from conditional logic to VLOOKUP approximate match and others.