# Using Power BI to Visualize Customer Saturation

- URL: https://dynamicaccounting.net/using-power-bi-to-visualize-customer-saturation/
- Date: 2013-08-08
- Topics: Reporting & BI, Payables & Receivables
- Type: original article

Our resident AX MVP, Murray Fife was presented with a challenge recently. A customer needed to know how many independent salespeople they have in a zip code and compare that to the number of people in that area. They want to limit the number of salespeople per capital to 1 per 10,000.

Murray’s data was in AX (and other places) but his solution used various Excel tools from Microsoft so It’s completely applicable to GP.

Check out how he solved it at Using Power BI to Visualize Customer Saturation.

This week I was challenged to find a way for one of our customers to view how many customers they have by zip code, and compare it to the population within the area so that they can determine if they should accept new customer requests. Their customers are actually sales people, and they did not want to have more than one customer per 10000 people within the local zip code or surrounding area.  In this worked example I will show how I used the new suite of Power BI tools (Power Query, Power Pivot, Power View & Power Map) to allow them to analyze this information in a simple, and also very cool way.  Below are the postings and links to the downloads on SlideShare just in case you want to take a peek: