Prior Situation / Scenario:

  • Distribution Point (DP) mapping file was manually updated and categorized each month
  • HFC polygons were incorrectly georeferenced and not aligned with local parcels
  • Manual process for files sent to BI team by email, then loaded into database for reporting

Client Challenges:

  • Long time to process a monthly report.
  • Replace time-consuming manual process, prone to error
  • Inaccurate geo-referencing of customers and network polygons
  • BI team reliant on availability of Network team for updates

Strata Solution/ Key Enablers:

  • Developed algorithm to identify parcels to correctly align network nodes with HFC polygons and map to customers
  • Script written to get billing system data and applied to final reporting, used data from GIS to classify DP layers, and data entered into database for reporting purposes
  • Technologies used: ArcGIS, Python, AWS ,Tableau for Dashboarding and Tibco SpotFire for Geo Mapping reports

Outcome:

  • Customers were geo-referenced, allowing geo-targeting sales campaigns
  • Over 90% of HFC polygons were corrected
  • 89% of DP’s were automatically classified (will increase as data quality improves)
  • Report is updated automatically on a weekly basis

Results:

Increased accuracy on network expansion plans, better ROI on network investment where there is a clear, unmet demand and substantial increase on sales effectiveness by geo-referenced marketing efforts.