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
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.
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.
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.
That was something about Data Joining in Power Bi.
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.
Expand the ListOfOrders tab to observe the Fields section. You will notice that there are some geographical elements present there like Country, State, etc.
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.
To add the City field to this hierarchy, just drag it and drop it over the Hierarchy field.
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.
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.