JOINED DATA AND CREATING MAPS

Before we start learning more about the topics mentioned above, you need to download one file that connects to your Power BI for training.

Visit the link: www.superdatascience.com/powerbi

Joined Data and Creating Maps in Power BI Training - PST Analytics

Download the excel file given under section Maps and Scatterplots. You know what to do next. Just select Get Data option in Power Bi and import this file.

You will notice that there are two sheets and both contain some data. Select both the sheets.

Joined Data and Creating Maps in Power BI Training - PST Analytics

Load the sheets to Power Bi. Now, click on the Model tab to get an idea of what the sheets are wholly about. You will see that the two sheets that connect by a standard unit called Order ID. Order ID defines a relationship between the two layers, and that is how data joins in Power Bi.

JOINED DATA AND CREATING MAPS

When you double click on the line that connects the two sheets, a window will pop up. This window describes the relationship between the layers and explains what elements make this relationship valid.

Joined Data and Creating Maps in Power BI Training - PST Analytics

That was something about Data Joining in Power Bi.

CREATING MAPS

The next important feature of Power Bi that we are going to learn is Creating Maps. When I say Maps, I mean Geographical Maps. You are going to witness how cool Power Bi is in this tutorial.

First, navigate back to the report page. In the Visualizations section, find the Map Visual and click on it. An empty Map will appear on your screen.

JOINED DATA AND CREATING MAPS

Expand the ListOfOrders tab to observe the Fields section. You will notice that there are some geographical elements present there like Country, State, etc.

JOINED DATA AND CREATING MAPS

We need to create a geographical hierarchy. This hierarchy will have the Country field on the top with the State field and the City field following it. To do this, drag the state field and drop it over the country field.

A new field called Country Hierarchy will be created.

JOINED DATA AND CREATING MAPS

To add the City field to this hierarchy, just drag it and drop it over the Hierarchy field.

Joined Data and Creating Maps in Power BI Training - PST Analytics

We have the ingredients that we need to create a Map. Now click on the empty map on your screen. Drag the Country Hierarchy field and drop it over the Location tab present below the Visualizations section. When you do that, your Map will automatically come to life.

Joined Data and Creating Maps in Power BI Training - PST Analytics

Observe that Power Bi contains an inbuilt map of the globe for training, which includes every country, state, and city in the world. The data that you connected was analyzed by Power Bi to create this Map. You can navigate the Map very easily using your mouse. Zoom in and zoom out to observe the report in detail.

So, creating Maps is an important Power Bi feature and you can learn more about it by practicing.

Leave a Reply

Your email address will not be published. Required fields are marked *