Video by: Reid Havens
Let's review the NEW relationship Pane (in preview as of February 2023) that can be found in the Model View for Power BI Desktop! We'll compare it to the traditional relationship pop up window as well! Tune in to learn more.
Posts filed under Data Modeling
(Livestream Replay) Inside Bravo for Power BI - with Marco Russo
ABSTRACT 📄
Explore the features available in Bravo for Power BI: Analyze Model, Format DAX, Manage Dates, and Export Data. In particular, we will see how it is possible to customize and deploy a date table for an entire organization!
GUEST BIO 👤
Marco Russo wrote several books about DAX and data modeling for Power BI and Analysis Service with Alberto Ferrari. Marco regularly publishes new content on sqlbi.com and teaches DAX around the world.
RELATED CONTENT 🔗
Bravo for Power BI
SQLBI Website
Marco's Twitter
Marco's LinkedIn
(Livestream Replay) No More Data Quality Surprises! - with Dave Ruijter
ABSTRACT 📄
Do you know your data? Do you have confidence in the data of your Power BI solutions, no matter what? And do you already actively monitor for deviations from those expectations? Being in control of your data (quality) is essential for any solution, and it can be quite difficult to achieve in Power BI. In this demo-rich session you will learn how you can implement a framework for data validation and monitoring! We'll leverage an open source library called Great Expectations to quickly get up-and-running. Become in control of the data quality of your solutions!
GUEST BIO 👤
Dave is a hands-on solution and platform architect, and implements solutions using Power BI and the Azure Data Platform. He brings a vast amount of consultancy experience to the table and is always eager to take things to the next level. Dave has received the Microsoft MVP Award twice for his deep knowledge of Microsoft products and services and community leadership.
RELATED CONTENT 🔗
Great Expectations
Dave’s Blog
Dave’s LinkedIn
Dave’s Twitter
Dave’s GitHub
(Livestream Replay) Lessons learned After Two Years With a Large Model - with Alex Dupler
ABSTRACT 📄
For the past two years, my team has been working on a premium Power BI model that has grown significantly in size, from 50 GB to over 100 GB. During this time, we have gained valuable insights and lessons that we would like to share with you. These include the importance of conducting systematic testing, determining which features and columns will have the most impact on performance, and managing the ongoing refresh of a model of this size. We hope that these tips will be helpful for those looking to optimize and improve their Power BI models.
GUEST BIO 👤
Alex Dupler is a Power BI developer and architect at Microsoft, where he currently serves as the lead Program Manager for a data warehouse platform supporting the company's advertising business. In this role, Alex is responsible for a Power BI import dataset with 90 GB of data. He is also one half of "Two Alex's," a YouTube channel that features live discussions on Power BI topics without one correct answer. Prior to joining Microsoft, Alex worked as a chemist. He is a member of the PBICAT team and has been inactive for a while.
