Powering Up – Building a Data Warehouse

By: Sysware  05-Apr-2012
Keywords: Data Warehouse

The opening of the New Zealand electricity industry to competition bought its own challenges to this large state-owned enterprise. To be able to participate in this sharing of the electricity market, this power utility had to build an ultra-reliable data warehouse that collected real-time power pricing data 24 by 7. Millions of dollars of trades are done daily so both system reliability and timely delivery of trading data are critical.

Sysware consultants were instrumental in developing and supporting these applications that helped drive the business. Working with an ETL (extract, transform and load) tool, our consultants built many ETL and monitoring programs to provide the energy traders with the appropriate data. The project included providing OLAP data structures for end users to exploit, the development of web-based reporting for end users; and the establishment and optimisation of the reporting architecture.

Keywords: Data Warehouse

Other products and services from Sysware

05-Apr-2012

Business Intelligence Solutions

We’ve worked with many leading organisations, helping them to increase their profits, optimise business and technical performance, analyse and report on their data, develop and implement powerful customer retention strategies and reduce their operating costs. By combining data mining with traditional audit techniques, you create effective and efficient tests for making cost recoveries, discovering revenue opportunities and identifying fraud.


05-Apr-2012

Using Predictive Modelling to Reduce Churn

The marketing team decided to focus on high value customers who were most likely to leave and asked Sysware to help carry out a predictive modelling exercise to identify these customers. The data was fed into a SAS predictive modelling tool that uses neural networking techniques to build a model to predict churn behaviour and factors with little or no influence were removed.


05-Apr-2012

Data Consolidation delivers value and efficiency

Sysware successfully tendered for the job and promptly delivered a cost-effective solution on time, to budget, meeting all expectations for cost, performance and quality. It is also a distributed application split into five regional instances, with a structurally identical database existing for each region. Using SAS Data Integration Studio, Sysware quickly delivered the project, enabling the required improvements, including.


05-Apr-2012

Predictive Analytics Increase Sales, Reduce Campaign Costs

Sysware was proud to be involved in such a successful collaborative exercise, which provides compelling evidence on the success of targeting on increasing sales and reducing costs. By utilising Sysware’s data mining expertise and Mapnet’s mapping capability, the client achieved a vastly improved response rate, and a huge return on their investment.