Havens Consulting
Video by: Reid Havens
Learn how to query the XMLA end-point in a Premium (Per User or Capacity) workspace to extract all the Power Query M Code, and parse out your SQL Database names, table, names, and parameters from your queries. Tune in to learn more.
The reality is folks need / want their data in Excel at some point. While Power BI reduces that need, it still exists. Wyn’s demos will show how to connect using various approaches including a trick to create a connected table with the help of “create formatted table” feature of Power BI, and the largely unknown Featured Table option.
Wyn Hopkins is a Microsoft MVP, trainer, consultant and author of the book “Power BI for the Excel Analyst”
Based in Perth, Western Australia, Wyn is the director of the Power BI and Excel consulting firm “Access Analytic”. Their YouTube channel has 40,000+ subscribers and he co-runs the Perth Power BI and Modern Excel meetup group. Once upon a time Wyn was a chartered Accountant with PriceWaterhouseCoopers but Wyn and team now spend their time delivering Power BI and Excel training along with reporting solutions for clients of all industries and sizes. Wyn’s claim to fame is that he suggested and campaigned for the creation of the XLOOKUP function.
Wyn's Book & Website
Wyn's Company Website
Wyn's Social Media Links
Once you have built a Power BI dataset there are several options for displaying the data in it: classic Power BI reports, paginated reports and Excel. This session is all about the third option, Excel. You’ll learn how to connect Excel to a Power BI dataset and use PivotTables, Excel cube functions and the new Excel data types to build reports. You’ll also get a sneak preview of upcoming functionality which allows your Power BI-connected Excel reports to work in the browser and not just in Excel on the desktop.
Chris Webb works on the Power BI CAT team at Microsoft. He has been using Microsoft BI tools for over 20 years, speaks regularly at user groups and conferences and has written several books on Analysis Services and Power Query.
Come hang out as Ken Puls (Excel Guru) showcases his fantastic pro user Excel plug-in [Monkey Tools]! This tool is fantastic for helping users build better BI models for use in both Excel AND Power BI. Just SOME of the features include many "sleuthing" features to investigate and optimize parts of your model or report. One of my favorites honestly is the Dynamic Calendar Creator! Watch the stream to learn about all this and more.
Ken Puls is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. A blogger, software developer, author and trainer with over 20 years of accounting and IT experience, Ken's passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Learn more about Ken at the links below!
Ken's Twitter
Ken's LinkedIn
Company Website
Company Blog
MonkeyTools
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
