(Livestream Replay) Semantics of DAX Queries & Caveats to Composite Models - with Jeffrey Wang

The popularity of Power BI has increased dramatically in the past few years. I am seeing an increasing number of enterprise customers who built complex composite models combining import tables with DirectQuery tables. Many users have asked questions on how DAX queries and measures are translated into remote SQL/MDX/DAX queries. To the surprise of a lot of people who have a SQL background, the semantics of DAX queries is very different from that of SQL queries even though both are used to produce the right data for the same visualizations. I am going to explain why the semantics of DAX queries poses unique challenges to DAX engine and how the latter employs myriads of optimizations to deliver good query performance in common scenarios. I am also going to explain how the semantics of DAX queries complicates query generations for composite models, demonstrate some of the issues most frequently encountered by the composite model users, and describe design principles to avoid the pitfalls.

GUEST BIO 📄

Jeffrey joined Microsoft SQL Server Analysis Services team in 2004 and contributed to the revolutionary transformation of Microsoft BI from multi-dimensional model and MDX language to tabular model and DAX language. He was one of the inventors of the DAX programming language in 2009 and have been driving the evolution of the DAX language ever since. Currently he is an engineering manager focusing on the development of DAX engine, query optimizer, DirectQuery, composite models, etc. Right now his team is putting the finishing touches on the GA of DirectQuery to PowerBI datasets.

RELATED CONTENT 🔗

Website
Blog
Power Query's Twitter
Miguel's Twitter

(Livestream Replay) Let's Talk About Data Culture - with Matthew Roche

Choosing the right data and BI tools is important, but it’s just part of the picture. To get the most from Power BI or any modern self-service BI tool you need more people working with more of the right data, more often. You need a data culture! Matthew Roche from the Power BI CAT team has spent the past three years working with enterprise organizations around the world, learning what works and what doesn’t work. Matthew will introduce the Power BI Adoption Roadmap, a new set of guidance from the Power BI team, and will discuss steps that any organization can take to become more data-driven.

GUEST BIO 📄

Matthew Roche is a Principal Program Manager in Microsoft’s Cloud + AI Group, where he focuses on business intelligence, enterprise information management, metadata, and data warehousing. \

Matthew is currently a member of the Power BI CAT team, where he was saddened to learn that there were not actually any cats. Previously he has worked on Azure Data Catalog, SQL Server Integration Services, Master Data Services, and Data Quality Services. Before joining Microsoft, he worked as an architect, consultant, and trainer focusing on ETL, data warehousing, and business intelligence.

When he’s not enabling the world to get more value from its data, Matthew enjoys kittens, baking, heavy metal, and competitive longsword combat.

RELATED CONTENT 🔗

Building a Data Culture
Matthew's Website
Matthew's Twitter

(Livestream Replay) Getting to know Power BI Template Apps (AppSource) - with Teddy Bercovitz

Getting started with Power BI can be as easy as installing a template app, we will review the (AppSource) marketplace what you can find the installation experience of template apps for end users. Power BI authors will find ways to leverage template apps as a proxy model to dataset, why you should always check out the marketplace before starting from scratch and how template apps can be a way to share a protected pbix with other users.

GUEST BIO 📄

Principal Program Manager, Power BI template apps & Power Apps solutions Teddy Bercovitz has held various engineering and product management roles for the past 15 years. Teddy is part of Power BI’s developer group focused on building extensibility stories with 3rd party marketplace offerings driving success to Microsoft's partners.

RELATED CONTENT 🔗

Getting Started with Template Apps
Template Apps One Click Update
New Way of Getting Template Apps
Video Shown at End of Livestream

(Livestream Replay) Using Power BI to Monitor your Azure Data Platform - with Dave Ruijter

Hang out with us as Dave Ruijter explains and demonstrates how to develop a Power BI monitoring solution for your Azure Data Platform. You can configure your Azure resources to send tons of metrics and logs to Azure Log Analytics, but how do you get that data in Power BI and transform it into a useful report? Let’s see how!

GUEST BIO 📄

Dave Ruijter is a Data Platform MVP from the Netherlands, and he is a public speaker and consultant. His aim is to help organizations realize the full potential of the Azure cloud and the Microsoft Power Platform. He brings a decade’s worth of experience to the table and is a passionate Power BI evangelist, eager to share his knowledge and experiences from the field.

RELATED CONTENT 🔗

Dave's Website
Dave's LinkedIn
Dave's Twitter