(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.

RELATED CONTENT 🔗

Alex's LinkedIn

Adding Grand Totals to Small Multiples in Power BI

Learn how to configure your model to enable a Grand Total (multiple) when adding small multiples to native visuals in Power BI. There's a mix of modeling and Power Query (M)agic involved. So tune in to learn more!

Video by: Reid Havens

(Livestream Replay) Top Secrets of Power BI Report Design! - with Mara Pereira

ABSTRACT 📝

A lot of the focus on Power BI report development goes to the backend (transforming and cleaning data, data modelling, DAX…). However, most people that will use your reports will not be able to see that backend, they will be interacting with the frontend. So, a question came up: why are most Power BI Developers not putting a lot of effort into the frontend of their reports? The answer was surprising: developers didn’t feel they were very creative, they struggled to understand what good/bad looks like. During this session, we will be discussing how to approach frontend development in Power BI, and we will be learning about some of the tricks that you can use to make sure your designs always look great! You will learn how you can get ideas for creativity, how to apply those ideas, and no, you don’t need to be a Picasso!

GUEST BIO 👤

Mara is the Founder of Data Pears. You might know her from her blog and YouTube channel, where she regularly posts blogs and videos about Power BI, Data Visualization and Data Analytics. Mara loves everything around data visualization and report design and her main goal is to change the world of reporting, one report at a time. She believes that effective reporting solutions are more than just data and charts, they are a beautiful combination of data, insights, and user experience. After working with Power BI for 6+ years, she decided to embark on an entrepreneurship journey, with the focus on guiding enterprise customers and individuals on their Power BI journeys. Before that, she was a Cloud Solutions Architect for Data & AI at Microsoft.

RELATED CONTENT 🔗

YouTube
Blog
LinkedIn
Twitter