Rebuilding trust in their member data

Case Study Feature Image

At a glance

The Ontario Association of Social Workers (OASW) has migrated to IMIS Cloud EMS in 2022 and they were looking to expand their usage of IMIS by introducing self-serve member capabilities and automation.

The association knew they had data quality issues but was unsure of its extent. They were also lacking a common understanding of their data model which was preventing them from making progress in a structured way towards a trusted member database.

Services

Shift from storing data to using it Data Analytics

What we did

Analyzed core tables for completeness and data discrepancies

Took inventory of all lookup tables and list of values

Provided recommendations to address data quality and integrity issues (in concert with their IMIS provider)

Mapped core forms, staff and member views to database fields

Created an easy-to-use data model (in Miro format)

← Back to Cases