Modelling Data in Power BI

-

 Introduction of Data Modelling

The Power BI Data Modelling is a feature used to connect multiple data sources in the BI tool using a relationship. In data modeling, the data sources are connected to each other and you can create interesting data visualization on multiple data resources.

If none of the tables selected for the relationship has a unique value you will see the error and fix this error by adding an intermediary table made of the distinct key values to the model.




In the above image, you can see the relation between the two tables. The tables are joined by a column named "ID".

Similarly, in Power BI, you set the relationship between two objects. To set the relationship, you have to drag a line between the common columns. You can also view the “Relationship” in a data model in Power BI.

To create a data model in Power BI, you need to add all data sources in Power BI's new report option. To add a data source, go to the Get data option.



When you add multiple data sources to Power BI visualization, the tool automatically tries to detect the relationship between the column. You can manually create relation using the manage relationship option.




There are different categories of relations to connecting elements in the table:

  • One to One relation
  • One to Many relations
  • Many to One relation
  • Many to Many relations


Create Calculated Columns

When the data you are analyzing doesn't contain the field that you need. So to fix the problem answer might be a Calculated Column. The calculated column is created in power BI by combining two or more elements of the existing data.

You can even create a calculated column to establish a relationship between the tables and it can also be used to set up a relationship between two tables.

To create a new calculated column, navigate to the Data View tab on the left side of the screen and then click Modeling.


When you click on the new column tab, you will see a new column name in the formula bar where you can write DAX [ Data Analysis Expression] formula to perform the calculation. DAX is a powerful language used to perform calculations like excel. You can rename the column name in the formula bar.


Optimize Data Model

When we import data for reports and data visualization,it often contains field that no need for tasks. Therefore, Power BI tool optimize the data and make it more usable by hiding columns.




Create Measures

In Power BI Measures defined as calculations on your data  that  are performed at the time of query. Measures are calculated as you react with reports and are not stored in database.You can use measure in other table just drag and drop it.






Summary 

From the above information it clear that in Power BI  modelling helps to create relationship between two or more elements in table.In Model View we can check relation diagram  between table and easy to edit it.The calculated column create field that stored in model.

Comments

Post a Comment

Popular posts from this blog

Power BI Desktop

-
Image
  Power BI Desktop is an open-source application for  Computers that  Gather, Transform, and Visualizes  your data. The Power BI Desktop creates reports and dashboards and publishes them in the Power BI Service. With Power BI Desktop, you can connect multiple sources of data and combine them ( Data Modelling) . Most of the users use the Power BI desktop to solve Business Intelligence problems to create reports, visual and share it on Power BI Service. Power BI Desktop Uses: Connect to different data sources. Transform and Clean data (Data Modelling) Create visuals (such as charts, graphs) Create reports (collection of visuals) Share reports on Power BI Service In Power BI Desktop windows there are 3 types of views: Report: In this view, we spent more time creating reports and visuals. Data: In this view, you see the tables, measures, and other data used in the data model. Model:  In the model view, we make the relationships among the tables. Power BI Desktop W...
Read more

Visuals in Power BI

-
Image
  Visualization is a building block of Power BI  and is used to present your data visually. It is the process of taking raw data and transforming it into graphical visualization. In Power BI a wide variety of features such as Bar Chart, Column Chart, Pie Chart, Waterfalls, Funnels & Map, etc. Data visualization is a quick and easy way to convey concepts to the end-user. There are more than 30+ features of visualization in Power BI. Let's see one by one; 1] Bar Chart & Column Chart: This is one of the most familiar &  standard types of charts used to display specific values across different categories. A bar & column chart is used to represent categorical data in rectangular bars by the length of the rectangle denoted by a specific measure value. Bar Chart Stacked Bar Chart & Clustered Bar Chart A stacked bar chart is a visual representation of parts of a whole & is often used to compare. In a stacked bar chart each bar represents a whole and segmen...
Read more