Mastering Power BI Strategies for Effective Data Modeling at Dynamic Communities 2022

Unlock the secrets of Power BI data modeling with expert insights from Nick Talsma at the largest independent gathering of Microsoft users. Explore topics such as storage options, relationships, cardinality, and more to enhance maintenance, performance, and cost efficiency. Discover the significance of good modeling practices and delve into tools like Power BI Desktop and DAX Studio for exceptional results in your data projects.

• Power BI
• Data Modeling
• Dynamic Communities 2022
• User Ecosystem
• Microsoft Users

hael210 Follow

Uploaded on Sep 16, 2024 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

1. The Largest IndependentGathering of the Microsoft User Ecosystem For Users, By Users Data Model Strategies in Power BI Nick Talsma Decrease Complexities, Deliver Results. Sr. Power Platform Technical Solution Architect Ludia Consulting @ 2022 Dynamic Communities

2. Agenda For Users, By Users Why Good Modeling Matters Storage Options Relationships Cardinality Dates Tools File/Workspace Structure The Largest Independent Gathering of the Microsoft User Ecosystem @ 2022 Dynamic Communities

3. Why Good Modeling Matters For Users, By Users Maintenance Performance Cost The Largest Independent Gathering of the Microsoft User Ecosystem @ 2022 Dynamic Communities

4. Storage Options For Users, By Users Import Direct Query The Largest Independent Gathering of the Microsoft User Ecosystem @ 2022 Dynamic Communities

5. Relationships For Users, By Users Star Schema Model Snowflake Model N:N, 1:N, and 1:1 The Largest Independent Gathering of the Microsoft User Ecosystem @ 2022 Dynamic Communities

6. Cardinality For Users, By Users Definition Common Offenders Column Selection Column Transformation The Largest Independent Gathering of the Microsoft User Ecosystem @ 2022 Dynamic Communities

7. Dates For Users, By Users Formatting Date Tables Auto-Date The Largest Independent Gathering of the Microsoft User Ecosystem @ 2022 Dynamic Communities

8. Tools For Users, By Users Power BI Desktop/Service Dax Studio Tabular Editor 2 -> BPA Synapse The Largest Independent Gathering of the Microsoft User Ecosystem @ 2022 Dynamic Communities

9. File/Workspace Structure For Users, By Users Hub and Spoke Security Advantages The Largest Independent Gathering of the Microsoft User Ecosystem @ 2022 Dynamic Communities

10. Recap For Users, By Users Why Good Modeling Matters Storage Options Relationships Cardinality Dates Tools File/Workspace Structure The Largest Independent Gathering of the Microsoft User Ecosystem @ 2022 Dynamic Communities

11. For Users, By Users Thank you for attending! Submit Feedback: The Largest Independent Gathering of the Microsoft User Ecosystem Decrease Complexities, Deliver Results. @ 2022 Dynamic Communities