WhereScape > Case Studies > Smart Meter Automation Powers Customer Service at Jersey Electricity

Smart Meter Automation Powers Customer Service at Jersey Electricity

WhereScape Logo
 Smart Meter Automation Powers Customer Service at Jersey Electricity - IoT ONE Case Study
Technology Category
  • Infrastructure as a Service (IaaS) - Cloud Databases
  • Sensors - Utility Meters
Applicable Industries
  • Utilities
Use Cases
  • Advanced Metering Infrastructure
The Customer
Jersey Electricity
About The Customer
Jersey Electricity
The Challenge

Although Jersey is not a part of the UK Smart Meter roll out, Smart Meters are a central part of a large-scale government project to upgrade the UK’s energy system, replacing around 53 million existing gas and electricity meters by 2020, allowing consumers a more accurate view of their energy consumption. Designed to provide ‘near real-time’ information on energy use, smart meters will enable consumers to manage their energy use, allow supplier switching to take place more easily and remove the need for suppliers to read meters and provide estimated bills. As the sole supplier of electricity across the island, Jersey Electricity decided to proactively rollout smart metering ahead of the rest of the UK, aiming for installation of up to 45,000 meters for domestic and commercial customers by the end of 2018. Planned as a three-year project, Jendev, its subsidiary utility software development business, examined a variety of options to deliver key components, including the smart meters themselves and the critical data warehousing technology to gather, store and analyse the data provided by every smart meter. This data collection and analysis presented an important challenge. In every property, the smart meter needs to take a daily consumption read as well as 48 half hourly reads, 365 days a year – an eventual total at the end of the project rollout approaching 1 billion reads per year. This data is passed from each property to a data concentrator in its local substation, which are all polled daily to collate data in the central data warehouse for processing and analysis.

The Solution

Gary Parsons, business manager at Jendev said. “We wanted to automate the entire data warehouse lifecycle from design and planning through to implementation and operation. Our evaluation process led us to WhereScape and its RED data warehouse application which we chose because of its proven power and flexibility. We were also impressed by the ability of the WhereScape team to build data warehouses rapidly and cost-effectively.” WhereScape RED has been designed as an Integrated Development Environment (IDE) to help build data warehouses faster in SQL Server, Teradata, DB2, Greenplum and Oracle. It supports agile as well as traditional project approaches including live prototyping for user reviews and feasibility testing. The data warehouse was built, documented and released into production in just 22 development days, delivering an automated smart metering network for Jersey Electricity that will see large-scale installation from July 2015. “We have 9,000 legacy smart meters already installed and collecting data, which helped us to design and test the WhereScape Red data warehouse automation tool,” explained Parsons. “Red is a highly versatile tool, offering very rapid development cycles and powerful reporting – it’s an excellent solution.”

Data Collected
Warehouse Capacity, Gas Meters, Electricity Meters
Operational Impact
  • [Efficiency Improvement - Customer Service]
    Able to provide customers with an informative, highly responsive and effective supply service which offers them greater value for money

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.