Posts filed under Data Modeling

(Livestream Replay) Configuring Incremental Refresh PBI-Tools - with Mathias Thierbach

ABSTRACT πŸ“

You've heard about Power BI Incremental Refresh for datasets but you're missing powerful tooling? pbi-tools is here to help! Learn how pbi-tools supports you manage, configure, monitor and optimize incremental refresh for your largest datasets. Ask questions and see demos how to automate deploying and refreshing incremental refresh datasets. You'll hear about refresh policies, auto-managed partitions, effective date and many more technical details.

GUEST BIO πŸ‘€

In 2015, after having spent over ten years as a Software Developer and Architect with Microsoft technologies, Mathias Thierbach moved into the Microsoft BI space. He soon landed on Power BI, but also realized quickly that the development and engineering tools and practices were nothing like the ones well established in software development. This is how pbi-tools started as a project, filling this gap in tooling. Today, leading a growing data management team at YouGov, he experiences the benefits of those efforts every day. Having open sourced the project in fall of 2021, Mathias spends a lot of his free time bringing those practices to the wider Power BI community now.

RELATED CONTENT πŸ”—

PBI Tools
Mathias Notes/Articles
Mathias's Twitter
Mathias's LinkedIn
Mathias's GitHub

(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