Data Modeling
kodegems.com
What is Data Modeling
Is one of the features used to connect multiple data sources in BI tool using a relationship. A relationship defines how data sources are connected with each other and you can create interesting data visualizations on multiple data sources.
kodegems.com
With the modeling feature, you can build custom calculations on the existing tables and these columns can be directly presented into Power BI visualizations. This allows businesses to define new metrics and to perform custom calculations for those metrics.
What is Data Modeling
kodegems.com
Learning Objectives
- Create relationships between your data sources.
- Create a new field with calculated columns.
- Optimize data by hiding fields and sorting visualization data.
- Create a measure to perform calculations on your data.
- Use a calculated table to create a relationship between two tables.
- Format time-based data so that you can drill down for more details.
kodegems.com
Ameen Khan
Power BI Developer
Project Manager Web
Youtube Instructor
kodegems.com
Strength of Power BI
- No need to put your data into a single table.
- You can use multiple tables from multiple sources and define the relationship between them.
kodegems.com
Also,
Create your own custom calculations and assign new metrics to view specific segments of your data.
kodegems.com
Practical Approach
kodegems.com
How to manage your data relationships?
kodegems.com
kodegems.com
kodegems.com
Adding and Removing Relationships
kodegems.com
Hiding Table
What is the Cardinality of the relationship?
kodegems.com
Cardinality Options Example
kodegems.com
Many to One
The most common default relationship. The column in one table can have more than one instance of a value. The related table (or lookup table) has only one instance of a value.
kodegems.com
One to One
The column in one table has only one instance of a particular value, and the other related table has only one instance of a particular value.
kodegems.com
Cross Filter Direction
kodegems.com
kodegems.com
Calculated Columns
kodegems.com
kodegems.com
kodegems.com
kodegems.com
DAX - Data Analysis Expression
kodegems.com
Data Analysis Expressions is a programming language that is used throughout Microsoft Power BI for creating calculated columns, measures, and custom tables. It is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values.
Optimize data models
kodegems.com
kodegems.com
Hide Fields
kodegems.com
Sort visualization data by another field
kodegems.com
kodegems.com
kodegems.com
kodegems.com
kodegems.com
Setting Data Type
Measures in Power BI
kodegems.com
Let’s look at an example
kodegems.com
kodegems.com
Create calculated tables
kodegems.com
kodegems.com
Explore time-based data
kodegems.com
kodegems.com
kodegems.com
What You Learned So Far...
kodegems.com
kodegems.com
- Create calculated tables
- How to manage your data relationship
- Introduction to Modeling data
- Create calculated columns
- Optimize data models
- Create Measures
- Explore time-based data
- Quiz to check your knowledge
kodegems.com
https://kodegems.com/data-modeling-quiz/
kodegems.com
In this module, you learned how to create relationships between your data sources and optimize data. These skills will help you pull clean data from several different sources.