(Livestream Replay) Improving Models & Calculations in Power BI - with Jeroen ter Heerdt

Join Jeroen ter Heerdt (Program Manager - MSFT) as we discuss various topics under the umbrella of improving models and calculations in Power BI! We'll be diving into discussions around tables, relationships, model configurations / enhancements, DAX, design, and more! Tune in to find out!

GUEST BIO 👤

Jeroen ter Heerdt is a Program Manager with Microsoft. He works on Power BI and is passionate about "all things data"; whether it is about databases, data warehousing, BI, big data, data visualizations, self-service BI, advanced analytics, real-time BI or anything even remotely related to data or insight. He strives to apply these concepts in his life as much as possible. Jeroen combines enthusiasm, vision, and hands-on experience into his talks.

RELATED CONTENT 🔗

Jeroen's Blog
Jeroen's Twitter
Jeroen's LinkedIn

5 Reasons to Hide Fields from Report View in Power BI

Let's discuss five reasons why you'd want to consider hiding columns from the report view in Power BI. All of these suggestions are centered around curating the Fields list during report development for both yourself, and any other potential business users or analysts who might want leverage your model for reports in the Power BI service. Tune in to learn more!

Video by: Reid Havens

Transforming Beast Tables into Beauty Models in Power BI

Learn how to use Power Query to transform wide single tables into relational models that leverage fact and dimension table design with relationships. This process optimizes the tables for the tabular model in Power BI resulting in smaller file/model size, and faster performance! While aiming towards a star schema design, which works best in Power BI. Tune in to learn more!

Video by: Reid Havens

RELATED CONTENT 🔗

Understand Star Schema Importance in Power BI
Building Your First Calendar Table

(Livestream Replay) Co-Creation: Defining Reporting Requirements with Users - with Kurt Buhler

Many reporting requests have a common starting point - existing reports.

These might be Excel workbooks, large PowerPoint slide decks, or bundles of reports scattered across other technologies. For one reason or another, these reports need to be re-made, re-designed or migrated over to Power BI. “They need to be in Power BI, and they need to be there now.” The business has urgent needs, and there’s pressure from management to see the result. But where do we start? What do we make? Defining the right requirements is essential if we want to make an effective report that is used and delivers value. Otherwise, it will just be collecting digital dust & cobwebs in an abandoned app…

Kurt will discuss three common approaches to collecting reporting requirements, arguing in favor of the third approach - working iteratively & collaboratively with business users.

GUEST BIO 👤

Kurt Buhler is a Power BI data goblin, speaker, and consultant. Kurt discovered his passion for working with & analyzing data during his doctoral research in Biomedical Sciences. Since then, he has worked as a consultant and bridge-builder between IT & Business in organizations to derive value from their data using actionable visuals and solutions. He advocates a design-thinking, user-centric approach to data projects to ensure solutions meet business needs and improve effectiveness. He's a lover of cats, tabletop roleplaying games, and all things Power BI & data related.

RELATED CONTENT 🔗

Kurt’s website/Blog
Kurt’s Twitter
Kurt’s LinkedIn