100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 11 out of 31 pages.
ANGELES UNIVERSITY FOUNDATIONCollege of Computer StudiesModel Data in Power BI
IntroductionLearning ObjectivesCourse 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 dataWhat is in this module?
Introduction ToModeling Your Data
Introduction to modeling your dataIn Power BI, you can create a relationshipto 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.
How To Manage Your Data Relationships
How to manage your data relationshipsIn the Model view, notice that a block represents each table and its columns and that lines between them represent relationships.
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.
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.
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.
How to manage your data relationshipsYour options for Cardinality are explained in the following table.