Introduction
Jersey Electricity (JE) is the island of Jersey’s sole electricity provider, supplying more than 48,000 homes and businesses. Determined to lead its sector, JE committed to deploying Smart Meters ahead of UK and EU legislation. To support this initiative, the organisation required a scalable, automated data warehouse capable of handling billions of readings while improving customer engagement.
Pre-WhereScape Challenges
- Lack of mandated infrastructure: With no legislation driving Smart Metering, JE needed a future-proof data strategy to support early adoption.
- Heavy data volumes: Nearly a billion half-hour readings each year demanded high-performance ingestion and processing.
- Manual data validation: Identifying meter errors during quarterly cycles delayed detection and resolution.
- Fragmented reporting: Usage analytics were difficult to consolidate, limiting customer insight and internal decision making.
- Scaling complexity: Frequent requirement changes and increasing data volume required a responsive, automated architecture.
Why WhereScape?
JE selected WhereScape RED after evaluating its ability to rapidly build, automate, and document enterprise-scale data warehouses. The platform offered end-to-end lifecycle automation, from design to deployment, while leveraging JE’s existing internal skills. With daily refresh requirements, customer portal publishing, and escalating data volume, WhereScape provided the reliability and flexibility JE needed.
“ We have found that RED is as flexible as we had hoped it would be and that WhereScape have been an excellent partner in the project to date.”
– Gary Parsons, Manager, Jendev
The Solution
Automated Smart Meter Data Ingestion
WhereScape RED enabled JE to ingest nearly one billion annual half-hour readings, automating daily refresh cycles and providing timely access to validated consumption data.
Flexible, Scalable Data Warehouse Design
The solution supported rapid changes in requirements, allowing JE to adapt modelling and processing rules without lengthy development cycles or manual rework.
Rich Reporting and Analytics Enablement
Data was stored in both a warehouse and OLAP database, enabling JE to deliver self-service analytics via Excel and SSRS, as well as high-quality information through the customer portal.
Full Documentation and Internal Knowledge Growth
WhereScape automated the documentation process: data lineage, logic, and transformations; supporting compliance and enabling JE teams to build long-term capability.
Results
🚀 Single Source of Truth
- Consolidated data from multiple meter and concentrator sources.
- Enabled consistent analytics across JE departments and customers.
- Improved accuracy of energy usage reporting.
🚀 Daily Data Validation
- Automatic validation detects faulty readings early rather than quarterly.
- Faster resolution of meter issues improves operational efficiency.
- Reduces customer billing concerns and errors.
🚀 Enhanced Customer Engagement
- Customers receive accurate, timely usage information.
- Off-peak tariffs are easier to understand and adopt.
- Improved transparency strengthens JE’s competitive advantage.
🚀 Operational Intelligence for the Grid
- Smart Metering supports network performance monitoring.
- Combined usage and meteorological data enhances demand forecasting.
- Helps JE optimise equipment utilisation across the island.
🚀 Rapid Delivery and Full Documentation
- Full smart metering warehouse built in just 22 development days.
- Included 68 stage tables, 17 ODS tables, 4 facts, 15 dimensions, 3 OLAP cubes.
- Delivered 106 procedures with 30,000 lines of code and three scheduled workflows.
Smart Metering Leadership
While many utilities waited for legislative direction, JE proactively invested in Smart Metering to give customers deeper insight into their energy usage. This move positioned JE as a leader in customer engagement and data-driven energy management.
Scalable Architecture for Future Demand
With growing data volumes and increasingly complex tariff models, JE needed a platform capable of scaling without disrupting service. WhereScape’s automation ensures that as smart infrastructure expands, the data platform expands with it.
Improved Forecasting and Planning
Combining Smart Meter data with weather information enables JE to make more accurate predictions of demand across the island. This optimises plant operations and improves resilience; critical for a sole electricity provider.
Cross-Functional Skills Development
The implementation also served as a capability-building exercise. JE established a cross-functional team that now shares knowledge, develops new skills, and has the autonomy to extend and refine the data warehouse over time.
