Automating processes for the online connections project

Electricity North West Ltd. (ENWL) needed to undertake various ETL tasks on their network data before submitting it for use in an online mapping application. They wanted a solution that would automate the monthly processing of updates, saving them time.

Time saved with automation

Future innovations enabled

The Challenge

The Data Team at ENWL needed to combine and transform huge volumes of network data into multiple spatial data formats. The output then needed to be sent to the supplier managing ENWL’s online mapping tool.
The process, repeated every month, was conducted manually using GIS software and SFTP connections. Between 3 and 5 days per month were required to complete the job.

The Solution

Miso worked closely with ENWL to build a custom FME workspace. The workspace combines the network asset data, before translating it into the required formats (e.g. .tab, .shp). It then loads the outputs into a central location and transfers them across to the supplier, via an SFTP. Run on FME Server, the process is now fully automated, requiring little to no manual intervention.
During the project, Miso also delivered training and one-to-one mentoring sessions to enable ENWL to get more value from their data and ROI on their FME software.
The solution has dramatically reduced the time needed to complete the process, freeing-up employees to work on other tasks. Customer experience has also been enhanced as customers are now able to self-serve to receive a quotation and pay online. This is both saving costs and benefitting the business’ customer satisfaction score.

ENWL save time and improve customer satisfaction with an FME-based solution.

FME® automates data manipulation and transformation

Data rarely arrives in your environment in a state that’s ready to use. The repetitive tasks required to get it into a usable form are laborious and costly. FME® automates these data manipulation and transformation tasks, leaving you to work much more efficiently with your newly optimised data set.

Here’s the problem; you have lots of data from lots of different internal and external sources, but managing it all can be difficult. You’re faced with a unique set of challenges that have a large impact on the way you work:

Driving value for your organisation by making the most of your business intelligence.
Managing the complex combination of data sources, formats and destinations.
Dealing with evolving data, resources and requirements.