ANNOUNCEMENT: Octopai has reached Microsoft's Co-Sell Partner Status for Microsoft Azure Customers: Read More

How The Smith Family Cut Two-Day Impact Analysis Processes to One Hour

Company The Smith Family
Industry Educational Non-Profit
Needs Expressed Impact analysis in an agile environment with new releases every two weeks
Benefits Realized The ability to do impact analysis for new business processes in a simple one-hour routine

The Smith Family is a national, independent Australian non-profit tackling the issue of children’s poverty. With one in six Australian children and young people living in poverty, this is a heart-breaking social issue. By providing support through programs in literacy, numeracy, technology, and mentoring – among others – the organization is helping create a lasting impact for future generations of families.

When you lack the agility to be agile...

The Smith Family’s educational efforts are supported by a complex BI environment. Their team of data architects work in an agile environment with a new release every two weeks. With such a rapid development pace, it becomes more important than ever to keep track of process changes such column additions, table updates or report modifications, and to predict their impact on the system overall. At the same time, investing significant time in impact analysis would slow down the development to an unacceptable pace. 


It is a catch-22 that had The Smith Family’s data team feeling stuck for years. They were constantly on the lookout for a tool that could provide impact analysis for new business processes at the pace they needed… and then they found Octopai.

Working magic on impact analysis

With Octopai’s end-to-end data lineage, The Smith Family’s data team was able to cut their typical one to two day impact analysis for new short processes down to a simple ONE HOUR routine. 


The Smith Family finally had the adaptability and agility they needed to move forward at their ideal pace, with the security of knowing that doing so would not result in unpleasant surprises.

Supporting migrations, compliance and more

Furthermore, when The Smith Family’s BI environment of SSIS, SQL, and Power BI underwent a massive migration process from on-premises to MS Azure, Octopai was a critical part of making the migration go smoothly. With Octopai’s support of Azure Data Factory (the first platform to do so in a complex environment) and full visibility to SSIS, it was heavily used in planning the data processes and data migration, and specifically in identifying loopholes while delivering such a complex migration. 


In addition, The Smith Family’s developers have found other areas where Octopai’s platform measurably enhances their development process:

  • troubleshooting when they need to track back a source in SSIS. With the click of a button, they can get the source of a data query. 
  • properly tracking data flows for compliance with privacy regulations