Data Science: Data analysis and data modeling with Power BI.

Credit

What is power BI?

Power BI is a set of software services, apps, and connectors that work together to transform disparate data sources into logical, visually immersive, and interactive insights. Your data could be in the form of an Excel spreadsheet or a collection of hybrid data warehouses that are both cloud-based and on-premises. Power BI makes it simple to connect to your data sources, visualise and uncover what matters, and share your findings with whomever you choose.

The following are the most typical uses for Power BI Desktop:

• Connect to information
• To construct a data model, transform and clean the data.
• Create graphics that provide visual representations of the data, such as charts or graphs.
• On one or more report pages, create reports that are collections of graphics.
• Use the Power BI service to share reports with others.

Home Screen In Power BI

Home Screen

In the illustration above, the left panel has three options:

• Report: In this view, you produce reports and visuals, and this is where you spend the majority of your creative time.
• Data: In this view, you may see the tables, measures, and other data used in the report’s data model, as well as transform the data for the best use in the report’s model.
• Model: You can see and control the relationships between tables in your data model in this view.

Creating the following relationship between fields In Power BI

Model Structure

Loading Data In Power BI

From Navigator, select the.xlsx file that contains the data.

DS_B2_PR-7(1).xlsx loaded

Dataset loading

Toggle to the fields tab. For exploration, use the right side panel.

Fields loaded

To open the required field for exploration, click on a particular field.

Let’s look at how to manage the relationships between the fields now.Open the Manage Relationships tab from the taskbar to see the following output:

Relationships present in the dataset

Auto Detect relationship

Let’s generate the model now that the relationships have been maintained.It will generate a model if you open the model generate option on the pages tab.

Generated Model

Conclusion

We learned how to use the Power BI data visualisation tool in this blog.