A map of dots gets looked at. A number for the spot somebody pointed at gets argued with
Leadership had only ever seen its customer base as rows in an export. The tool I built turned those rows into a story they had never been able to see: point at an area, and see what it actually earns.
Why hovering shows the math. A color gives you the answer without the work. Hovering a location shows loan income minus deposit cost, so a disagreement lands on a specific number that can be checked.
Read the Case StudyExhibit 2 What sits inside the circle, and what it earns
Click or drag the map to place the circle; size it with the slider.
View the data
| Location | Area | Miles east | Miles north | Loan income | Deposit expense | Net | Age | Age band |
|---|---|---|---|---|---|---|---|---|
| L01 | Area A | 5.5 | 9.4 | 58,000 | 2,900 | 55,100 | 44 | 35–49 |
| L02 | Area A | 5.3 | 12.2 | 29,000 | 28,700 | 300 | 65 | 65–79 |
| L03 | Area A | 6.4 | 10.3 | 41,000 | 38,200 | 2,800 | 26 | 18–34 |
| L04 | Area A | 2.6 | 9.5 | 38,000 | 27,300 | 10,700 | 25 | 18–34 |
| L05 | Area A | 4.1 | 11.9 | 0 | 40,000 | −40,000 | 33 | 18–34 |
| L06 | Area A | 5.3 | 11.6 | 0 | 24,600 | −24,600 | 18 | 18–34 |
| L07 | Area A | 4.5 | 9.9 | 0 | 21,500 | −21,500 | 66 | 65–79 |
| L08 | Area A | 7.6 | 10.9 | 7,000 | 41,000 | −34,000 | 31 | 18–34 |
| L09 | Area A | 3.9 | 10.9 | 11,000 | 23,900 | −12,900 | 66 | 65–79 |
| L10 | Area A | 6.3 | 11.5 | 50,000 | 8,300 | 41,700 | 59 | 50–64 |
| L11 | Area A | 4.7 | 11.2 | 0 | 2,400 | −2,400 | 89 | 80+ |
| L12 | Area A | 6.3 | 10.4 | 0 | 19,700 | −19,700 | 51 | 50–64 |
| L13 | Area A | 7.8 | 11.2 | 63,000 | 17,800 | 45,200 | 19 | 18–34 |
| L14 | Area A | 4.2 | 10.5 | 0 | 25,300 | −25,300 | 87 | 80+ |
| L15 | Area A | 4.3 | 11.2 | 69,000 | 20,300 | 48,700 | 53 | 50–64 |
| L16 | Area A | 6.2 | 8.0 | 79,000 | 25,900 | 53,100 | 31 | 18–34 |
| L17 | Area B | 14.5 | 7.5 | 25,000 | 25,900 | −900 | 51 | 50–64 |
| L18 | Area B | 13.2 | 4.6 | 51,000 | 8,900 | 42,100 | 67 | 65–79 |
| L19 | Area B | 15.5 | 6.0 | 52,000 | 20,400 | 31,600 | 77 | 65–79 |
| L20 | Area B | 12.2 | 3.9 | 12,000 | 34,800 | −22,800 | 88 | 80+ |
| L21 | Area B | 11.8 | 5.0 | 0 | 24,500 | −24,500 | 18 | 18–34 |
| L22 | Area B | 15.2 | 5.0 | 70,000 | 15,400 | 54,600 | 59 | 50–64 |
| L23 | Area B | 12.4 | 6.1 | 64,000 | 18,500 | 45,500 | 80 | 80+ |
| L24 | Area B | 12.6 | 9.7 | 0 | 4,700 | −4,700 | 45 | 35–49 |
| L25 | Area B | 15.4 | 6.7 | 21,000 | 35,200 | −14,200 | 34 | 18–34 |
| L26 | Area B | 14.1 | 3.8 | 0 | 22,500 | −22,500 | 60 | 50–64 |
| L27 | Area B | 13.5 | 6.9 | 84,200 | 31,600 | 52,600 | 58 | 50–64 |
| L28 | Area B | 10.7 | 5.1 | 31,000 | 10,400 | 20,600 | 32 | 18–34 |
| L29 | Area B | 12.9 | 3.6 | 0 | 30,200 | −30,200 | 43 | 35–49 |
| L30 | Area B | 14.2 | 7.6 | 0 | 15,400 | −15,400 | 54 | 50–64 |
| L31 | Area C | 5.7 | 4.9 | 0 | 10,300 | −10,300 | 35 | 35–49 |
| L32 | Area C | 6.8 | 2.6 | 87,000 | 40,900 | 46,100 | 83 | 80+ |
| L33 | Area C | 3.1 | 4.2 | 82,000 | 22,700 | 59,300 | 64 | 50–64 |
| L34 | Area C | 6.3 | 4.6 | 56,000 | 27,100 | 28,900 | 51 | 50–64 |
| L35 | Area C | 4.8 | 3.8 | 0 | 24,800 | −24,800 | 18 | 18–34 |
| L36 | Area C | 4.7 | 4.5 | 0 | 16,400 | −16,400 | 72 | 65–79 |
| L37 | Area C | 6.3 | 5.7 | 75,000 | 4,000 | 71,000 | 46 | 35–49 |
| L38 | Area C | 6.6 | 3.7 | 29,000 | 3,400 | 25,600 | 67 | 65–79 |
| L39 | Area C | 5.9 | 5.1 | 51,000 | 17,800 | 33,200 | 66 | 65–79 |
| L40 | Area C | 5.3 | 3.3 | 0 | 17,000 | −17,000 | 56 | 50–64 |
| L41 | Area D | 15.0 | 11.1 | 83,000 | 39,500 | 43,500 | 59 | 50–64 |
| L42 | Area D | 16.2 | 11.1 | 0 | 8,600 | −8,600 | 24 | 18–34 |
| L43 | Area D | 15.6 | 11.4 | 82,000 | 24,300 | 57,700 | 64 | 50–64 |
| L44 | Area D | 18.2 | 9.9 | 11,000 | 1,600 | 9,400 | 46 | 35–49 |
| L45 | Area D | 15.7 | 13.5 | 83,000 | 9,600 | 73,400 | 22 | 18–34 |
| L46 | Area D | 16.1 | 11.7 | 65,000 | 36,000 | 29,000 | 74 | 65–79 |
| L47 | Area D | 15.9 | 9.8 | 0 | 29,300 | −29,300 | 55 | 50–64 |
| L48 | Area D | 19.4 | 15.3 | 0 | 14,900 | −14,900 | 60 | 50–64 |