(Livestream Replay) 5 Ways to Get Power BI Data into Excel! None are Copy Paste! - with Wyn Hopkins

ABSTRACT 📄

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.

GUEST BIO 👤

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.

RELATED CONTENT 🔗

Wyn's Book & Website
Wyn's Company Website
Wyn's Social Media Links

(Livestream Replay) Next Gen Visualizations in Power BI - with Gopal

ABSTRACT 📄

1. Deliver Advanced Visualizations with Data Stories in no-code user experience in just few clicks.

2. How Inforiver Charts is helping Tableau, Qlik and Tibco Spotfire customers to migrate to Power BI by offering change management with coverage to missing features and functionalities.

3. We will focus on demonstrating unique features on why Inforiver Charts over Deneb or Native Power BI Visuals.

4. Buying Direct with Microsoft - Inforiver Charts and/or other Transactable Custom Visuals 5. Inforiver Charts Pricing Model.

5. What’s the roadmap for Inforiver Charts.

RELATED CONTENT 🔗

InfoRiver Charts
Inforiver Charts AppSource
Lumel

(Livestream Replay) [DAX] Best Practices 101 for Optimization & Performance - with Alberto Ferrari

ABSTRACT 📄

Despite being usually very fast, DAX can be optimized, like any other computer system. Optimizing DAX requires a deeper understanding of the internals of the engine, because most optimizations are not intuitive. We will talk about the basics of optimizations, looking at some examples of code and discussing together ideas and options to make the code faster.

GUEST BIO 👤

Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.

Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.

Today, Alberto's main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.

Alberto is a well-known speaker at many international conferences, like PASS Summit, Sqlbits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses.

Outside of SQLBI, most of Alberto's personal time is spent practicing video games, in the vain hope of eventually beating his son.

RELATED CONTENT 🔗

SQLBI Website

(Livestream Replay) Making The Most Out of The Power Platform - with Nicky van Vroenhoven

ABSTRACT 📄

Have you always wanted to edit your data in Power BI, like in Excel?
Do you want (some of) your users to be able to refresh the Power BI dataset behind a report?
Do you want to refresh your Power BI dataset as soon as the connected dataflow is refreshed?
Now you can! With a combination of Power BI, Power Apps and Power Automate.
In this live demo session I will demonstrate the Microsoft Power Platform products working together to create easy, usable, and interactive data solutions.

GUEST BIO 👤

Nicky van Vroenhoven is a BI professional focused at the Microsoft stack and a Data Platform MVP. He mainly works with Power BI, Power Platform and T-SQL. Nicky started working with SQL Server and SSIS 2005 in the DWH space, and later moved from Power Pivot to Power BI. After working 10 years in BI-consultancy jobs in several industries and companies, he worked for 5 years as a Power BI Administrator at a wealth management bank, and he is currently working as Unit Lead Power BI at Powerdobs in The Netherlands.

Nicky has spoken at several User Groups, SQL Saturday Events, the Power BI World Tour and SQLBits. In addition he enjoys tweeting and blogging about topics like Power BI and Power Platform at his website below.

In his spare time Nicky like's to go running, play chess or try to improve his Rubik's cube record. He is also a husband, father of 3 and a (former) ballroom dancer!

RELATED CONTENT 🔗

Nicky's Blog
Nicky's Twitter
Nicky's LinkedIn