Better data and insights for NSW DCJ

Taysols Pty Ltd

Monday, 09 September, 2019

Better data and insights for NSW DCJ

NSW DCJ has partnered with Taysols to upgrade its corporate data warehouse and improve outcomes for its clients.

Consulting, cloud and support services company Taysols is working with the Department of Communities and Justice (DCJ) to deliver greater insights into the services DCJ provides children by improving the technology that delivers these insights to caseworkers and other carers.

DCJ works with children, adults, families and communities, and has a statutory responsibility to protect children and young people from risk of significant harm.

For the implementation of the new IT system, ChildStory, DCJ required data warehouse improvements, reports and dashboards that would help report on and manage the families and children that DCJ assists. It was therefore necessary to upgrade the Corporate Information Warehouse (CIW) to work seamlessly with ChildStory.

Taysols is working closely with the DCJ team to create a solution that includes building reports and dashboards built in OBIEE, extract, transform, load (ETL) capabilities using Informatica, and a data warehouse based on Oracle. The source data comes from Salesforce.

“Access to better data and insights is an essential component of the ChildStory program, making the CIW mission-critical for DCJ. The strong working relationship between Taysols and DCJ is a crucial element of this project’s success,” said Mark Taylor, founder and director of Taysols.

“With Taysols’ focus on delivering high-quality outcomes, we’ve been able to help DCJ evolve their team on the ground with ongoing support along with system analysis, development, testing and deployment.”

The implementation was challenging, in part because the CIW project was run in parallel with DCJ’s implementation of the new source system. This created challenges because data warehouses normally rely on stable underlying data structures. However, because the source system was being implemented at the same time, it meant the data structure was constantly evolving, which had a flow-on effect to the ETL and data model development for the CIW.

Despite this challenge, and after significant effort over several months, Taysols delivered the original CIW piece of work on time, just four short weeks after ChildStory went live. Taysols and DCJ continue to deliver new information, enhancements, and updates every eight weeks.

“DCJ enjoys a strong working relationship with Taysols, which has seen the successful delivery of this project,” said Owen Griffiths, DCJ director of information management.

“It was important to work with an organisation highly experienced in OBIEE and data warehouse projects, and Taysols delivered a high-quality outcome. DCJ continues to rely on Taysols for expertise focused on the delivery of the CIW.”

Image credit: ©

Please follow us and share on Twitter and Facebook. You can also subscribe for FREE to our weekly newsletter and quarterly magazine.

Related Articles

Interview: Ray Greenwood, SAS Australia & New Zealand

In our annual Leaders in Technology series, we ask the experts what the year ahead holds. Today...

Interview: Ray Bradbery, NCB Group

In our annual Leaders in Technology series, we ask the experts what the year ahead holds. Today...

Best of 2019: Demystifying government procurement for start-ups

Across the festive season we'll be reprising some of our best articles from 2019. Today we...

  • All content Copyright © 2020 Westwick-Farrow Pty Ltd