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

Power BI – Mapping when “Disconnected”

Having recently read an article on the subject (Aaron Bator MSFT, Click here for his blog entry) I decided to share my own similar approach to providing “geographical” visualisations in a report.

I am a member of a team working on the creation of a Neighbourhood Plan for the Parish, Tilehurst, in which I live.  As part of my input to the plan I have been investigating how to visualise all manner of demographic data (from the Office for National Statistics) on standard and custom maps.

I, like Aaron, looked at the current options in Power BI Desktop and found none of them to be what I was looking for.  The need to be connected to the Internet was one issue as was the lack of any serious capability to use my own “custom regions”.  

Being a big fan of the “Synoptic Panel” Power BI Desktop visualisation and it’s sister the “Synoptic Designer” website (both by OKViz) I decided to create the custom maps that I needed as follows:

1. GIS software (Mapviewer 8)
2. Export the created map as a “.png” file
3. Upload the “.png”
to the “Synoptic Designer website
4. Define the areas and then export the results as a “.svg” file
5. Add the “.svg” file(s) to a Report using the “Synoptic Panel” visualisation 
6. Link the visualisation(s) to the data table


Office for National Statistics (ONS) Population Report for Tilehurst Parish

Image 01Image 1: Tilehurst Parish population by ONS Lower Layer Super Output Area (LSOA), Middle Layer Super Output Area (MSOA) and Output Area (OA).

Click HERE to open up the interactive report in a new tab!


Image 02
Image 2: Map showing the population of Tilehurst Parish by Ward and Output Area (OA)


Image 03
Image 3: Zooming in to map showing the population of Tilehurst Parish by Ward and Output Area (OA).  Note the use of the “States” settings to colour the Output Areas by population.


Image 04
Image 4: Map showing the population of Tilehurst Parish by Middle Layer Super Output Area (MSOA)


Image 05
Image 5:  Map showing the population of Tilehurst Parish by Lower Layer Super Output Area (LSOA)


Image 06
Image 6: Source ONS Census 2011 data consolidated by Geolytix


Image 07
Image 7: Data model showing Geolytix and Postcode tables


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

I will describe how I create the maps using the GIS software (Mapviewer 8) and the  Synoptic Designer website” soon.