Goal:
By June 2023 - KPI: Every residential & business address will be correct / accurate - this person lives here. Every title of each contact. Every prospect with a cap rating & influential alumni will have a live correct contactable contact detail (phone, email, address)
DQM Strategic Initiatives Roadmap:
Status 03/03/2023
Area | Comments | % | Status |
|---|---|---|---|
Business Rules Capture | Business Rules capture meetings revived as from 15/03/2023 to complete.
| 60% | ON TRACK With Revival of Weekly Meetings, also need to set up additional internal team meetings. |
Data Quality Rules and Dashboard | Data Quality rules captured, analysed, refined and next steps articulated.
| 80% | ON TRACK |
PowerBI Dashboards | Scheduled start for | 0% | NOT STARTED |
DQ Software | (a) Analysis nearly complete: Engaged 2/3 suppliers - last meeting scheduled for , (b) Then Decision and Procurement and lastly (c) Implementation | 30% | ON TRACK WITH TIMELINE RISKS |
DQ Cleaning | Dashboards and rules created, but no cleaning ownership, so that is slipping | 50% | BEHIND SCHEDULE |
Integration Fixes | Tickets raised, but not getting actioned timely by developers + marked as “Improvements”, so very low on the Dev priority list. | 50% | BEHIND SCHEDULE |
BAU Handover | BAU Model defined, Next steps defined, Needs to get buy-in from the various areas, and then roll out | 80% | ON TRACK |
DQM Strategic Initiatives 2023:
The strategic aim is to future proof the data quality of the Advancement Portfolio
1. Business Rules Capture
Jarvis Data Dictionary / Business Rules
Capture key business rules on a field by field basis. (Data Dictionary)
Roll out to other business units / training.
The Business Rules then drives the Data Quality Rules.
2. Data Quality Rules & DQ Dashboard / PowerBI Reporting Capability
2(a) Data Quality Rules & DQ Dashboard
Data Quality Rules and DQ Dashboards
Workshops to define Business Rules;
Business rules gives rise to DQ Rules;
Analysis of what causes it and how to fix it and who is responsible
Create Dashboards to make easily accessible and track.
2(b) PowerBI Reporting Capability
Ability to report over time
Drill down to individual records for DS Fixing
3. DQ Software / Capability: Aperture vs New
DQ Software Capabilities Requirements, Procurement and Implementation
Workshops to determine key outcomes to achieve
Catch up with vendors to understand their offering and do a gap analysis
Decision + Procurement
Implementation and training
4. Backlog Cleaning
DQ Cleaning
Track Backlog Cleaning Stats
5. Integration Fixes
SITS-Jarvis Integration BAU Production Defects
SWIFT-Jarvis Integration BAU Production Defects
Fix integration issues to prevent future data corruption
System | Process | Additional Info |
|---|---|---|
SWIFT https://university-comms.sydney.edu.au/survey.php?sid=27840&name=your-contact-details | ||
SITS | ||
Documentation |
6. BAU Transition
DQ BAU Operating Model (Post 30-Jun)
Create Data Quality Management Framework
Create process documents for each task that the Data Stewards needs to perform on a monthly basis, measure task estimates, define frequency.
DQ Status Reports
Date | Document | Comments | Reviewers (Please tick once reviewed) |
|---|---|---|---|
| |||
| |||
| |||
| Completed:
Planned:
| ||
Meeting Minutes / Actions:
Date | Description | Comments |
|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|