Power BI – ABC Automotive Ltd. (Part 3 – Sales Network Reports)

Using the “demo” database, which I described in Part 1 of this set of blog entries, I have created a number of sample reports using Power BI Desktop focusing on the Dealer network of the Financial Services Division of a fictitious company, ABC Automotive Ltd.

DEALER NETWORK MAP
Image 1: Dealer Network Map for ABC Automotive Ltd. created using Mapviewer 

The primary focus of these reports is to demonstrate how a Sales Network can be fully integrated into the reporting for any company providing business insights that are based on geographic areas.

This Sales Network that has been created for ABC Automotive Ltd. is based on the common standard for the Automotive Sector in the UK (Regions / Areas / Dealers).

In addition there are maps showing UK Postcode Districts as it is also common for the Dealer areas to be defined on a Postcode District basis.  This has been done for the sales network of ABC Automotive Ltd.

All of the map visualisations that are seen on the various reports have been created using the GIS software, Mapviewer .  This software is used to produce the “custom network maps” in the “ESRI Shapefile” format that will then be converted into “TopoJSON” formatted files using a tool like mapshaper

These “TopoJSON” files can then be imported into Power BI using the “Shape Map” visualisation and linked to information sources that contain the relevant geographic reference data. 

Click HERE to open up the interactive reports in a new tab.


ABC Automotive - Hints
Hints: Three hints on how to select the display of information within the visualisations i.e. in addition to using the filters/slicers at the top of the page.


ABC Automotive - Network Regions Report
Image 2: A Network Regions report containing a number of different visualisations including a map showing the relative number of agreements within the geographical areas of the 2 Sales regions for ABC Automotive Ltd. (North / South).

Of particular interest are the two matrix table visualisations that link Experian Mosaic data to agreements data and displays this information on the custom map.


ABC Automotive - Network Areas Report
Image 3: A Network Areas report containing a number of different visualisations including a map showing the relative number of agreements within the geographical areas of the 13 Sales areas for ABC Automotive Ltd. (“AREA01” – “AREA13”).


ABC Automotive - Network Dealers ALL ReportImage 4: A Network Dealer Areas report containing a number of different visualisations including a map showing the relative number of agreements within the geographical areas of the 32 Sales Dealer Areas for ABC Automotive Ltd. (“DLR001” – “DLR032”).

ABC Automotive - Network Dealers Report
Image 5: A Network Dealer Areas report containing a number of different visualisations including a map showing the relative number of agreements within the geographical areas of the selected Sales Dealer Areas for ABC Automotive Ltd. (“DLR001” – “DLR006”).


ABC Automotive - Network Postcode Districts Report
Image 6: A Postcode District report containing a number of different visualisations including a map showing, in this particular report, the relative number of agreements for the Royal Mail Postcode District geographical areas for the selected Postcode Area (“RG” – Reading, UK).

ABC Automotive - Network Postcode Districts Report 2
Image 7: Another Postcode District report containing a number of different visualisations including two different map visualisations showing, in this particular report, the relative number of agreements for the Royal Mail Postcode District geographical areas for the selected Postcode Area (“RG” – Reading, UK).


ABC Automotive - Network Postcode Districts DLR009 Report
Image 8: A Postcode District report containing a number of different visualisations including a map showing, in this particular report, the relative number of agreements for the Royal Mail Postcode District geographical areas for the selected Network Dealer (“DLR009”).

ABC Automotive - Network Postcode Districts AREA06 Report
Image 9: A Postcode District report containing a number of different visualisations including a map showing, in this particular report, the relative number of agreements for the Royal Mail Postcode District geographical areas for the selected Network Area (“AREA06”).


Here’s hoping that this was of interest.  If you have any questions feel free to contact me at

Leave a Reply

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