Simplifying [DAX] with Staging Tables & Relationships in Power BI

Video by: Reid Havens

Learn how to leverage model tables/columns, and relationships to simplify your DAX code for your Power BI datasets (models), leading to simpler measures, and potentially more efficient (faster) calculations and visual queries. Tune in to learn more!

(Livestream Replay) Leveling Up Power Query - Beyond the U/I (with Chandeep Chhabra)

DESCRIPTION ๐Ÿ“„

Learning how to solve advanced problems using the M language which are beyond the scope of Power Query User Interface. Discover the beauty of the mash-up (m) language, additional functions that you can't find using just the U/I, learn about parameters and query types, and more. Tune in to find out!

GUEST BIO ๐Ÿ‘ค

Chandeep Chhabra works with clients around the world on training and consulting projects on Excel and Power BI. Prior to starting Goodly (his venture), he worked as a Financial Analyst for an Investment Bank in Mumbai, India. Follow and connect with Chandeep online:

RELATED CONTENT ๐Ÿ”—

Blog
YouTube
LinkedIn
Twitter

Posted on August 18, 2023 and filed under Livestreams, Power Query.

5 Pro Tips for Getting Started with Power Query

Video by: Reid Havens

Learn about five useful tips and techniques for upgrading your Power Query skills. These tips can be useful for those just getting started in Power Query, and even for those maybe a bit more familiar or intermediate with the tool. Tune in to learn more!

RELATED CONTENT ๐Ÿ”—

Referencing Other Queries
Data Profiling Tools
Using Parameters
Sharing Queries
Query Folding

(Livestream Replay) Monitoring Power BI and Fabric Tenant Information - with Just Blindbaek

DESCRIPTION ๐Ÿ“„

Need to get the full overview of a Power BI and/or Fabric tenant? What are the users doing? Whatโ€™s created? This session is a walkthrough of a complete monitoring solution to extract all the valuable tenant information including the activity events, the artifact metadata and the settings. You will learn how to setup and use Integration Pipelines in Azure Data Factory or Azure Synapse Analytics and get examples of querying the data with Azure Synapse Serverless SQL Pool. We will also discuss what questions you can get answered, when combining all the information. And then we will also cover alternative solutions.

GUEST BIO ๐Ÿ‘ค

Microsoft Business Intelligence architect with extensive experience in all phases of BI development on Microsoft SQL Server, Azure, Power BI and Fabric.

RELATED CONTENT ๐Ÿ”—

Just's Twitter
Just's Website
Just's GitHub
Power BI Next Step Conference

Posted on August 11, 2023 and filed under Livestreams, Fabric, Azure.