Manukau City Council Lays NCR Teradata Foundation
*** Resource and building consents will be first to benefit from data warehouse ***
The local government responsible for one of New Zealand's largest and fastest growing urban centres - Manukau City - has
selected the Teradata division of NCR to provide a data warehouse that will consolidate more than 100 individual
information systems and serve as a technology platform for future e-business initiatives.
Denis Price, Manukau City Council's (MCC) information and technology manager, says the decision to adopt a Teradata®
data warehouse was driven by the need to construct a single, consistent view of the information held within the various
council business units, so that it could operate more efficiently and deliver improved services to customers.
"We were faced with dozens of disparate and duplicate database systems, making it very difficult to source and combine
the different bits of information we would need to service a customer request," says Mr Price.
"We also recognised that we could not move forward with other e-business initiatives, such as financial applications and
customer relationship management solutions, until we had consolidated, cleansed and restructured our current IT
Following an extensive evaluation of several possible technology providers, MCC chose Teradata to build and implement a
data warehouse that would not only combine existing council data sources, but would also generate powerful, real-time
analytical reports to help managers improve decision-making and expedite customer response times.
"We were looking for a technology partner, not just a technology provider," says Mr Price. "Not only does Teradata
demonstrate the necessary expertise and experience, but equally as important is their continued display of commitment
and enthusiasm to work with us and our organisational culture. Finding the right people was a significant criteria
because we wanted to establish a long-term partnership."
The first phase of the data warehouse project, which was awarded in February, involved creating a blueprint that mapped
MCC's business operations, data sources and technical architecture, a process that involved all of the council's senior
Now that the blueprint has been developed, the next phase involves bringing all of the business critical information
from the various council departments into the data warehouse, eliminating duplicated and irrelevant information. This
was recently achieved in the council's building and resource consents unit, a process that took less than two months to
"We've helped build the foundation and put up the walls," says Julian Beavis, Teradata's vice president for Australia
and New Zealand. "Now it's time to install all the doors and windows. Resource consents will be the first window to what
will be a robust, scalable and secure building."
For example, building and resource consents staff will find it much easier to access and retrieve the information they
need to manage the consents application process.
"Staff will be able to access everything from one single source," says Mr Price, "and this will inevitably translate
into quicker turnaround times for customers."
The data warehouse will also power applications that give the council an improved view of all consent-related operations
and make it easier for staff to complete mandatory reports, such as the annual consents audit that every council must
provide to central government every year. The data warehouse will now generate this report in a matter of seconds,
saving the council the several weeks of staff time and resources that was once required to compile and input all the
necessary fields of information.
A pioneer in data warehousing, NCR Teradata is the first to integrate data mining capability, analytical modelling and
scoring into a single, powerful database engine. This integration helps businesses drive growth by more quickly and
efficiently analysing customer behaviour information, then delivering this business intelligence to frontline employees
to better serve customers.
Other Teradata customers in New Zealand include The Warehouse and Guardian Trust.
*** About Teradata Division Teradata, a division of NCR Corporation, offers powerful analytical solutions that help
businesses drive growth. Teradata solutions include the Teradata database, and analytical applications for customer
relationship management, operations and financial management, business performance management and e-business. To learn
more about Teradata Division and its solutions, go to http://www.Teradata.com.
*** About NCR Corporation NCR Corporation (NYSE: NCR) is a leader in providing Relationship Technology solutions to
customers worldwide. NCR's Relationship Technology solutions include the Teradata database and analytical applications
such as customer relationship management (CRM) and demand chain management, store automation systems and automated
teller machines (ATMs). The company's business solutions are built on the foundation of its long-established industry
knowledge and consulting expertise, value-adding software, global customer support services, a complete line of
consumable and media products, and leading edge hardware technology. NCR employs 33,300 in more than 100 countries, and
is a component stock of the Standard & Poor's 500 Index. More information about NCR and its solutions may be found at www.ncr.com.
# # #