Microsoft Power BI

There are so many cool things to show in Microsoft Power BI that we debated what to show in the bonus chapter for a long time. Finally, we settled on creating a visual that uses a map as the foundation and creating visuals when our data source is a series of files.

The former is pretty self-explanatory. We'll create a map that displays our customer balances by the location of the customer itself. The latter is a great solution when data is fed to us through a series of files, such as from a point of sale system. A point of sale system would provide us with a report every day. These reports can be placed in a folder, and we can read all the files from the folder as if they were one data source. Although it may seem that this is a less common scenario, at some point in the future, you'll need it and be glad that you know about it.

Map of customer balances

As we already mentioned, our goal in this section is to walk you through creating a visual of a map that displays...