Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    Part 3: The Art and Science of Power Bi: Crafting The Data Model

    Uploaded by

    Alex Randy
    This document discusses chapters from a book on Power BI that cover data modeling. Chapter 8 provides an introduction to data models and discusses concepts like data schemas, measures, dimensions, hierarchies and properties. Chapter 9 describes how to design and deploy data models by importing queries, defining data types and managing tables and relationships. Chapter 10 discusses optimizing data models by reducing unnecessary data and queries, managing cardinality and converting models to composite models.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Part 3: The Art and Science of Power Bi: Crafting The Data Model

    Uploaded by

    Alex Randy
    15 views1 page
    This document discusses chapters from a book on Power BI that cover data modeling. Chapter 8 provides an introduction to data models and discusses concepts like data schemas, measures, dimensions, hierarchies and properties. Chapter 9 describes how to design and deploy data models by importing queries, defining data types and managing tables and relationships. Chapter 10 discusses optimizing data models by reducing unnecessary data and queries, managing cardinality and converting models to composite models.

    Original Description:

    008

    Original Title

    008

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses chapters from a book on Power BI that cover data modeling. Chapter 8 provides an introduction to data models and discusses concepts like data schemas, measures, dimensions, hierarchies and properties. Chapter 9 describes how to design and deploy data models by importing queries, defining data types and managing tables and relationships. Chapter 10 discusses optimizing data models by reducing unnecessary data and queries, managing cardinality and converting models to composite models.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    15 views1 page

    Part 3: The Art and Science of Power Bi: Crafting The Data Model

    Uploaded by

    Alex Randy
    This document discusses chapters from a book on Power BI that cover data modeling. Chapter 8 provides an introduction to data models and discusses concepts like data schemas, measures, dimensions, hierarchies and properties. Chapter 9 describes how to design and deploy data models by importing queries, defining data types and managing tables and relationships. Chapter 10 discusses optimizing data models by reducing unnecessary data and queries, managing cardinality and converting models to composite models.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    PART 3: THE ART AND SCIENCE OF POWER BI. . . . . . . . . . . . .

    127

    CHAPTER 8: Crafting the Data Model. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129


    An Introduction to Data Models . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129
    Working with data schemas. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130
    Storing values with measures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 134
    Working with dimensions and fact tables (yet again). . . . . . . . . . .136
    Flattening hierarchies. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137
    Dealing with Table and Column Properties. . . . . . . . . . . . . . . . . . . . . . 139
    Managing Cardinality and Direction. . . . . . . . . . . . . . . . . . . . . . . . . . . . 141
    Cardinality. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 142
    Cross-filter direction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 142
    Data Granularity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144

    CHAPTER 9: Designing and Deploying Data Models . . . . . . . . . . . . . 145


    Creating a Data Model Masterpiece. . . . . . . . . . . . . . . . . . . . . . . . . . . . 145
    Working with Data view and Modeling view . . . . . . . . . . . . . . . . . . 146
    Importing queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149
    Defining data types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150
    Handling formatting and data type properties. . . . . . . . . . . . . . . . 151
    Managing tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153
    Adding and modifying data to imported, DirectQuery,
    and composite models. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158
    Managing Relationships. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159
    Creating automatic relationships . . . . . . . . . . . . . . . . . . . . . . . . . . . 159
    Creating manual relationships . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160
    Deleting relationships. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160
    Classifying and codifying data in tables. . . . . . . . . . . . . . . . . . . . . . 161
    Arranging Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162
    Sorting by and grouping by . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162
    Hiding data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162
    Working with Extended Data Models. . . . . . . . . . . . . . . . . . . . . . . . . . . 164
    Knowing the calculation types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164
    Working with column contents and joins . . . . . . . . . . . . . . . . . . . . 165
    Publishing Data Models . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166

    CHAPTER 10: Perfecting the Data Model. . . . . . . . . . . . . . . . . . . . . . . . . . . . 167


    Matching Queries with Capacity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168
    Deleting unnecessary columns and rows . . . . . . . . . . . . . . . . . . . . 168
    Swapping numeric columns with measures and variables. . . . . . 169
    Reducing cardinality . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170
    Reducing queries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172
    Converting to a composite model. . . . . . . . . . . . . . . . . . . . . . . . . . . 173
    Creating and managing aggregations . . . . . . . . . . . . . . . . . . . . . . . 174

    viii Microsoft Power BI For Dummies

    You might also like