Power BI Database Design

Data modeling is one of the techniques used in BI tools to integrate many data sources via a connection. A connection explains how data sources are linked to one another, allowing you to construct fascinating data visualizations based on numerous data sources. 

You may use the modeling capability to create new calculations on existing tables, and these columns can then be immediately shown in Power BI visualizations. Businesses may use this to establish new metrics and do custom computations on those metrics.

Similarly, you may define the relationship between two items in Power BI. To establish the association, draw a line between the common columns. In Power BI, you can also see the “relationship” in a data model.

• To establish a data model in Power BI, add all data sources to the Power BI new report option. Go to the Get data option to add a data source. Then, choose the data source to which you wish to connect and press the Connect button.
• When you add a data source, it appears on the right sidebar. We imported data using two Xls files: Customer and Product.
• On the left side of the screen in Power BI, there are three tabs:

1. Report
2. Data
3. Relationships

• When you go to the Report tab, you’ll notice a dashboard and a chart that has been selected for data visualization. You may choose from a variety of chart kinds based on your requirements. In this example, we choose a Table type from the various Visualizations.
• When you navigate to the Data tab, you can see all of the data from the data sources based on the specified Relationship.
• The relationship between data sources may be seen in the Relationship tab. When you add numerous data sources to a Power BI display, the tool attempts to discover the link between the columns automatically. You may view the relationship by going to the Relationship tab. You may also use the Construct Relationships option to create a relationship between the columns.
• In data visualization, you may also create and remove associations. To delete a relationship, right-click it and pick the “Delete” option. To build a new “Relationship,” just drag and drop the fields you wish to connect between the data sources.
• The Relationship view may also be used to conceal a specific column in the report. To hide a column, right-click on its name and select “Hide in report view.”

Create a data model in Power BI.

The process of designing a complex data model with Power BI is simple. If your data is coming in from more than one transactional system, you may find yourself with dozens of tables to work with before you realize it. Creating a powerful data model is all about simplifying the chaos. Here it’s  about the vocabulary and implementation of star schemas, which are one technique to simplify a data model. You will also discover why selecting the appropriate data granularity is critical for the performance and usability of your Power BI reports. Finally, you’ll discover how to improve the performance of your Power BI data models.