Sep. 2122, 2006

1
v
Sep. 21-22, 2006
FME Worldwide User Conference - Vancouver
Network Visualisation / Market Maker Jon Lenihan,
ACECOMM, UK
2
NetVis/Market Maker
Network Visualization (NetVis) now rebranded as
Market Maker
3
NetVis/Market Maker

• UK cable company
• 8 million subscribers
• Largest broadband provider in the UK

• Public Software Company (NASDAQ ACEC)
• Over 20 years serving the telecommunications
  industry
• US-based, HQ in Metropolitan Washington DC area
• offices in London, Edinburgh, Montreal,
  Australia, Shanghai
• Over 4000 installations at 300 customers in 70
  countries

4
Situation
NetVis/Market Maker

• Multiple disparate GIS systems with limited
  availability
• Multiple disparate customer systems with limited
  availability
• Multiple disparate network systems with limited
  availability
• Demographic data not widely available

5
Proposal
NetVis/Market Maker

• To provide a consolidated view, containing all
  the elements, presented in a an accessible format
  on the intranet.

6
The non-spatial system
NetVis/Market Maker

• Oracle database, entire system refreshed monthly
• Over 80m customer and premise records processed
  regularly
• Over 26m reference addresses updated quarterly

7
The spatial system
NetVis/Market Maker

• Oracle, ESRI ArcSDE and ArcIMS
• FME chosen to do spatial transformation and
  loading for the following reasons
• Ease of use
• Speed
• Flexibility
• Wide range of functionality
• Transformers used were of many kinds
• non-spatial filtering and regular expressions
  (regex)
• spatial area calculation, point on area, area on
  area, polygon validation

8
The spatial system
NetVis/Market Maker

• GIS systems processed include
• ESRI
• Smallworld
• Microstation
• Intergraph
• Over 17 million records process regularly
• Data cleansing was also performed as a part of
  the transformation activity
• Over 140 FME workbench scripts

9
The final system
NetVis/Market Maker

• Several pre-canned reports covering
• Address management, including premises unknown to
  ntl
• Address and GIS discrepancy comparison
• GIS quality audit
• Integrated single address, customer and GIS view
• A spatial intranet viewer

10
NetVis/Market Maker
Targeting sales

• NetVis enables precise targeting of prospects
  and existing customers with relevant service
  offers based on parameters such as
• Demographics
• Credit rating
• Service history
• Payment record
• Churn/propensity to churn

The example here shows existing customer premises
color coded according to the services they receive
11
NetVis/Market Maker
Capacity Management
NetVis allows you to combine capacity
information with physical network, premise and
prospect data so that sales campaigns are only
focused on areas where there is available
capacity. The example here shows an area with
only 9 capacity available so sales focus should
be on most profitable sale.
12
NetVis/Market Maker
Network Planning
Network planners use NetVis in their day-to-day
job. It provides an instant view of the network
in a geographical context. NetVis allows
planners to see which customers are affected by
engineering works The example here shows a L3
boundary with all the customers in the boundary
highlighted, these can then be downloaded and
mailed.
13
NetVis/Market Maker
The next generation
14
NetVis/Market Maker

• Questions?

15
Thank you.
NetVis/Market Maker
Gary Osborne GIS Technical Analyst telephone 44
28 9020 6459 email Gary.Osborne_at_ntl.com
Jon Lenihan Program manager Mobile 44 7949
633488Email jon.lenihan_at_acecomm.com