Using Power BI to collect and connect data
There are a number of steps that we need to follow to create a dashboard. The first step is to collect and connect the data we have to the data model so that we can then move on to the next step.
We will use our sales data from different stores based in the UK. The reality is that these files could be online, on a SQL server, or on a website, but you could also have downloaded the files locally, as with this example. The only difference in the steps would be when you get the data. This example shows connecting to a folder, but if your data is somewhere else, you can refer to Chapter 4, Connecting to Various Data Sources Using Get & Transform, to see how to get data from various sources into Power BI Desktop. The files for this example can be found in the GitHub repository.
In the following screenshot, we have the ZIP code of the store, the product that was sold, and how the person paid for the goods, and the last column (column H...