(Livestream Replay) Deneb: Bringing the Vega Languages to Power BI Visuals! - with Daniel Marsh-Patrick

Vega and Vega-Lite are "visualization grammars" developed by the University of Washington Interactive Data Lab. They use a declarative, JSON-based format and this can also be used to build a range of bespoke visual designs with significantly less effort than coding from scratch.

Deneb is a Power BI visual that exposes these languages and lets you bind data from your model to them. We'll spend some time exploring the tool, showing you how to get started, and creating some simple examples.

If you like the visual please leave a review on AppSource as it helps support Daniel and the development of Deneb!

GUEST BIO 👤

In addition to working on Deneb, Daniel contributes a number of free and open-source custom visuals to the Power BI Marketplace.

He is extremely passionate about the Microsoft BI stack, particularly Power BI, and has been delivering Power BI solutions since 2014. He is a Microsoft Data Platform MVP, a Power BI Community Super User and regularly presents and blogs on a variety of Power BI subjects. Daniel is also a Principal Data Analyst with DiscoverEI, transforming environmental data into decisions.

RELATED CONTENT 🔗

Buy Daniel a Coffee
Deneb AppSource
Daniel's Website
Daniel's Twitter
Deneb Visual Builder

(Livestream Replay) The Evolution and Integration of Power Query - with Miguel Llopis

Join us as Miguel and I discuss a variety of topics related to Power Query. As the Lead Program Manager for Power Query, M, and Dataflows at Microsoft Miguel has invaluable insight into the current and future trends of the product. Topics will include: platforms within Microsoft where Power Query is implemented, feature parity between Power BI (Desktop vs. Service), the evolution of query folding, and more!

GUEST BIO 📄

Miguel is the Program Manager Lead for Power Query, M and Dataflows at Microsoft.

RELATED CONTENT 🔗

Website
Blog
Power Query's Twitter
Miguel's Twitter

(Livestream Replay) Implementing Proper Version Control in Power BI! - with Steve Campbell

In this session, we will explore different techniques for version control in Power BI. This is an important concept in software development, often overlooked by business users. We will explore options for different size models, thin report files and advantages of different techniques.

• What is git, DevOps and version control?

• Learn how multiple users can work on shared files

• Learn how to safely edit files, see versions and changes or roll back changes if something goes wrong

• Explore Microsoft recommendations, different options and their pros, cons and price

GUEST BIO (STEVE CAMPBELL) 📄

For my job, I lead the Power BI team for Cognizant MBG in the UK. Outside of this I love to blog on PowerBI.tips, present at conferences and webinars, and co-run the Brew City Power Platform user group. I love learning about data and sharing what I’ve learned. I also used to teach Power BI at the university in Milwaukee. I’m a Data Platform MVP and an MCT (Microsoft Certified Trainer) – it’s a fantastic community and I recommend being a part of it!

RELATED CONTENT 🔗

Steve’s LinkedIn
Steve’s Blog
User Group

(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