Model_Data_In_Power_BI.pptx - Model Data in Power BI ANGELES UNIVERSITY FOUNDATION College of Computer Studies What is in this module Introduction

Model_Data_In_Power_BI.pptx - Model Data in Power BI...

This preview shows page 1 - 11 out of 31 pages.

ANGELES UNIVERSITY FOUNDATION College of Computer Studies Model Data in Power BI
Image of page 1
Introduction Learning Objectives Course Description HERE Introduction to modeling your data How to manage your data relationships Create calculated columns Optimize data models Create calculated measures Create calculated tables Explore time-based data What is in this module?
Image of page 2
Introduction To Modeling Your Data
Image of page 3
Introduction to modeling your data In Power BI, you can create a relationship to create a logical connection between different data sources. A relationship enables Power BI to con- nect tables to one another so that you can create visuals and reports. This module describes data-centric relationships and how to create rela- tionships when none exists. You'll also create your own custom calculations and assign new metrics to view specific segments of your data.
Image of page 4
How To Manage Your Data Relationships
Image of page 5
How to manage your data relationships In the Model view, notice that a block represents each table and its columns and that lines between them represent relationships.
Image of page 6
How to manage your data relationshipsAdding and removing relationships is straightforward. To remove arelationship, right-click the relationship and select Delete. To create a relationship, drag and drop the fields that you want to link between tables.
Image of page 7
How to manage your data relationshipsTo hide a table or individual column from your report, right-click the table or column in the Model view and select Hide in report view .
Image of page 8
How to manage your data relationshipsFor a more detailed view of your data relationships, on the Hometab, select Manage Relationships. The Manage Relationshipsdialog box displays your relationships as a list instead of as a visual diagram. From the dialog box, you can select Autodetectto find relationships in new or updated data. Select Editto manually edit your relationships. You'll find advanced options in the Edit section to set the Cardinalityand Cross-filterdirection of your relationships.
Image of page 9
How to manage your data relationships Your options for Cardinality are explained in the following table .
Image of page 10
Image of page 11

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture