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: ©stock.adobe.com/au/Khunatorn

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