(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) ChatGPT...Fad or Future? - Practical use-cases for Power BI - with Mathias Halkjær

ABSTRACT 📄

As chatbots become more prevalent in the business world, many companies are wondering if ChatGPT is just a passing fad or if it has real staying power.

A new tool that has the potential to help us streamline our workflows by providing automated assistance with tasks such as data modeling, coding, design and troubleshooting, or end up sending us down the wrong alley or implement buggy code.

It is truly a double-edged sword.

In this session, we will explore practical use-cases and cautions to be taken for ChatGPT in Power BI, covering everything from data modeling, coding, project planning, troubleshooting errors, proposing best practices and all the way to the major troubles it will cause us if we trust it blindly.

GUEST BIO 👤

Mathias is self-proclaimed data platform fanatic on a mission to help leaders leverage their data to transform the way they do business.

With a background in Product Development and Innovation, Mathias offers a unique perspective to analytics and will often babble on about data as products, data prototypes, and the importance of user research. He often finds himself taking several steps back to focus on the bigger picture, and with his slightly rebellious attitude, he will much rather try to break the rules, norms, and industry standards than follow them blindly.

Several years of experience working with data in high-tech, high-growth companies have taught him a thing or two about working with and designing data platforms and data models for fast-paced analytics with quick turn-around from problems or user needs to insights.

RELATED CONTENT 🔗

Mathias' Blog
Mathias' LinkedIn
Mathias' Twitter

(Livestream Replay) [DAX] Window Functions & Tabular Editor 3 - with Daniel Otykier

ABSTRACT 📄

The Power BI December 2022 update included some exciting new DAX functions, that are all the buzz recently. Let’s explore these new functions using Tabular Editor 3’s DAX debugger to see what we can learn from them.

GUEST BIO 👤

Daniel is a Microsoft Data Platform MVP and CTO of Tabular Editor ApS – the company behind the tool. Tabular Editor is a popular tool for managing and editing Microsoft Power BI, Analysis Services, and Azure Analysis Services models. With a background in data analysis and business intelligence, Daniel has a strong understanding of the challenges and needs of BI professionals. He developed the Tabular Editor as a solution to streamline the process of managing and editing tabular models, and it has since become a go-to tool for many in the industry.

RELATED CONTENT 🔗

Tabular Editor Site
Daniel's Twitter
New DAX Functions (Dec ‘22 Power BI Release)

(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