Versions Compared

Version Old Version 80 New Version 81
Changes made by

albie.roets

albie.roets

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Roadmap Planner
maplinks239c7d8a-b166-49b8-82a2-696c8362bdba~~~~~d3b13c51-da48-4b25-b6c7-ed34ad834b0d~~~~~7c3a0391-298e-40de-89ee-c3fb61044f89~~~~~b9e4c2aa-93df-453a-b6c4-e2a958ed1a1e~~~~~eb4a2e88-498c-4e5d-b67f-747b14eb2056~~~~~1df3afc7-f1b5-4d61-ad36-a03952a1cb9e
timelinetrue
source%7B%22title%22%3A%22Roadmap%20Planner%22%2C%22timeline%22%3A%7B%22startDate%22%3A%222022-10-01%2000%3A00%3A00%22%2C%22endDate%22%3A%222023-06-30%2000%3A00%3A00%22%2C%22displayOption%22%3A%22MONTH%22%7D%2C%22lanes%22%3A%5B%7B%22title%22%3A%22Business%20Rules%22%2C%22color%22%3A%7B%22lane%22%3A%22%23f6c342%22%2C%22bar%22%3A%22%23fadb8e%22%2C%22text%22%3A%22%23594300%22%2C%22count%22%3A1%7D%2C%22bars%22%3A%5B%7B%22title%22%3A%22Business%20Rules%20Capture%22%2C%22description%22%3A%22This%20is%20the%20first%20bar.%22%2C%22startDate%22%3A%222022-10-01%2007%3A21%3A58%22%2C%22duration%22%3A5.97029702970297%2C%22rowIndex%22%3A0%2C%22id%22%3A%22239c7d8a-b166-49b8-82a2-696c8362bdba%22%2C%22pageLink%22%3A%7B%22id%22%3A%222812281033%22%2C%22spaceKey%22%3A%22PHOEN%22%2C%22title%22%3A%22Jarvis%20Data%20Dictionary%20%2F%20Business%20Rules%22%2C%22type%22%3A%22page%22%2C%22wikiLink%22%3A%22%5BJarvis%20Data%20Dictionary%20%2F%20Business%20Rules%5D%22%7D%7D%5D%7D%2C%7B%22title%22%3A%22Dashboards%22%2C%22color%22%3A%7B%22lane%22%3A%22%233b7fc4%22%2C%22bar%22%3A%22%236c9fd3%22%2C%22text%22%3A%22%23ffffff%22%2C%22count%22%3A1%7D%2C%22bars%22%3A%5B%7B%22title%22%3A%22Jarvis%20DQ%20Dashboards%22%2C%22description%22%3A%22This%20is%20the%20third%20bar.%22%2C%22startDate%22%3A%222022-10-01%2007%3A21%3A58%22%2C%22duration%22%3A1.9801980198019802%2C%22rowIndex%22%3A0%2C%22id%22%3A%22d3b13c51-da48-4b25-b6c7-ed34ad834b0d%22%2C%22pageLink%22%3A%7B%22id%22%3A%222803827105%22%2C%22spaceKey%22%3A%22PHOEN%22%2C%22title%22%3A%22DQ%20Dashboards%20and%20Rules%22%2C%22type%22%3A%22page%22%2C%22wikiLink%22%3A%22%5BDQ%20Dashboards%20and%20Rules%5D%22%7D%7D%2C%7B%22rowIndex%22%3A1%2C%22startDate%22%3A%222023-04-01%2000%3A00%3A00%22%2C%22id%22%3A%227c3a0391-298e-40de-89ee-c3fb61044f89%22%2C%22title%22%3A%22PowerBI%20Dashboards%22%2C%22description%22%3A%22%22%2C%22duration%22%3A1.9801980198019802%2C%22pageLink%22%3A%7B%22id%22%3A%222803827105%22%2C%22spaceKey%22%3A%22PHOEN%22%2C%22title%22%3A%22DQ%20Dashboards%20and%20Rules%22%2C%22type%22%3A%22page%22%2C%22wikiLink%22%3A%22%5BDQ%20Dashboards%20and%20Rules%5D%22%7D%7D%5D%7D%2C%7B%22title%22%3A%22DQ%20Software%22%2C%22color%22%3A%7B%22lane%22%3A%22%23d04437%22%2C%22bar%22%3A%22%23dc7369%22%2C%22text%22%3A%22%23ffffff%22%2C%22count%22%3A1%7D%2C%22bars%22%3A%5B%7B%22rowIndex%22%3A0%2C%22startDate%22%3A%222022-12-01%2014%3A43%3A57%22%2C%22id%22%3A%22b9e4c2aa-93df-453a-b6c4-e2a958ed1a1e%22%2C%22title%22%3A%22Analysis%22%2C%22description%22%3A%22%22%2C%22duration%22%3A2.9603960396039604%2C%22pageLink%22%3A%7B%22id%22%3A%222857042422%22%2C%22spaceKey%22%3A%22PHOEN%22%2C%22title%22%3A%22DQ%20Software%20Capabilities%20Requirements%2C%20Procurement%20and%20Implementation%22%2C%22type%22%3A%22page%22%2C%22wikiLink%22%3A%22%5BDQ%20Software%20Capabilities%20Requirements%2C%20Procurement%20and%20Implementation%5D%22%7D%7D%2C%7B%22rowIndex%22%3A1%2C%22startDate%22%3A%222023-03-01%2000%3A00%3A00%22%2C%22id%22%3A%22eb4a2e88-498c-4e5d-b67f-747b14eb2056%22%2C%22title%22%3A%22Decision%20%26%20Procurement%22%2C%22description%22%3A%22Decision%20and%20Procurement%22%2C%22duration%22%3A0.9702970297029703%2C%22pageLink%22%3A%7B%22id%22%3A%222857042422%22%2C%22spaceKey%22%3A%22PHOEN%22%2C%22title%22%3A%22DQ%20Software%20Capabilities%20Requirements%2C%20Procurement%20and%20Implementation%22%2C%22type%22%3A%22page%22%2C%22wikiLink%22%3A%22%5BDQ%20Software%20Capabilities%20Requirements%2C%20Procurement%20and%20Implementation%5D%22%7D%7D%2C%7B%22rowIndex%22%3A2%2C%22startDate%22%3A%222023-04-01%2021%3A23%3A10%22%2C%22id%22%3A%221df3afc7-f1b5-4d61-ad36-a03952a1cb9e%22%2C%22title%22%3A%22Implementation%22%2C%22description%22%3A%22%22%2C%22duration%22%3A2.9504950495049505%2C%22pageLink%22%3A%7B%22id%22%3A%222857042422%22%2C%22spaceKey%22%3A%22PHOEN%22%2C%22title%22%3A%22DQ%20Software%20Capabilities%20Requirements%2C%20Procurement%20and%20Implementation%22%2C%22type%22%3A%22page%22%2C%22wikiLink%22%3A%22%5BDQ%20Software%20Capabilities%20Requirements%2C%20Procurement%20and%20Implementation%5D%22%7D%7D%5D%7D%2C%7B%22title%22%3A%22DQ%20Cleaning%22%2C%22color%22%3A%7B%22lane%22%3A%22%238eb021%22%2C%22bar%22%3A%22%23aac459%22%2C%22text%22%3A%22%23ffffff%22%2C%22count%22%3A1%7D%2C%22bars%22%3A%5B%7B%22rowIndex%22%3A1%2C%22startDate%22%3A%222022-10-01%2007%3A21%3A58%22%2C%22id%22%3A%22ce6191a1-7709-4f64-b874-2fc825c57e7d%22%2C%22title%22%3A%22Backlog%20Cleaning%20Legacy%20(To%20identify%20issues)%22%2C%22description%22%3A%22%22%2C%22duration%22%3A3.99009900990099%2C%22pageLink%22%3A%7B%7D%7D%2C%7B%22rowIndex%22%3A0%2C%22startDate%22%3A%222023-01-01%2014%3A43%3A57%22%2C%22id%22%3A%22bc883364-b1ec-43df-8f18-0ed5eefca4e0%22%2C%22title%22%3A%22Integration%20Fixes%20%2F%20Enhancement%22%2C%22description%22%3A%22%22%2C%22duration%22%3A2.9702970297029703%2C%22pageLink%22%3A%7B%7D%7D%2C%7B%22rowIndex%22%3A1%2C%22startDate%22%3A%222023-02-02%2004%3A10%3A23%22%2C%22id%22%3A%22af6545ae-bda7-40f6-826c-de7e5aa144bf%22%2C%22title%22%3A%22Data%20Cleaning%20Post%20Integration%20fixes%22%2C%22description%22%3A%22%22%2C%22duration%22%3A3.9603960396039604%2C%22pageLink%22%3A%7B%7D%7D%5D%7D%2C%7B%22title%22%3A%22BAU%20Transition%22%2C%22color%22%3A%7B%22lane%22%3A%22%23ea632b%22%2C%22bar%22%3A%22%23ef8a60%22%2C%22text%22%3A%22%23ffffff%22%2C%22count%22%3A1%7D%2C%22bars%22%3A%5B%7B%22rowIndex%22%3A0%2C%22startDate%22%3A%222022-10-01%2007%3A21%3A58%22%2C%22id%22%3A%22df3c3d81-4e36-4867-aadc-b1cea209810e%22%2C%22title%22%3A%22Define%20DQ%20Operating%20Model%22%2C%22description%22%3A%22%22%2C%22duration%22%3A1.9702970297029703%2C%22pageLink%22%3A%7B%7D%7D%2C%7B%22rowIndex%22%3A1%2C%22startDate%22%3A%222023-04-01%2007%3A07%3A43%22%2C%22id%22%3A%22ed39b900-d9a2-4976-b494-0b6848f3fa03%22%2C%22title%22%3A%22BAU%20Transition%22%2C%22description%22%3A%22%22%2C%22duration%22%3A3.00990099009901%2C%22pageLink%22%3A%7B%7D%7D%5D%7D%5D%2C%22markers%22%3A%5B%7B%22markerDate%22%3A%222022-11-30%2016%3A52%3A16%22%2C%22title%22%3A%22Define%20Operating%20Model%20%26%20Dashboards%22%7D%2C%7B%22markerDate%22%3A%222023-03-31%2016%3A38%3A01%22%2C%22title%22%3A%22Integration%20Fixes%20Complete%22%7D%2C%7B%22markerDate%22%3A%222023-06-01%2014%3A12%3A06%22%2C%22title%22%3A%22DQ%20Fixes%20Complete%22%7D%5D%7D
pagelinksJarvis Data Dictionary / Business Rules~~~~~Data Rules~~~~~2. Data Quality Rules and DQ Dashboards~~~~~Data Dashboards~~~~~2. Data Quality Rules and DQ Dashboards~~~~~3. DQ Dashboards~~~~~DQ Software Capabilities : Requirements, Procurement and Implementation~~~~~DQ Implementation~~~~~3. DQ Software Capabilities : Requirements, Procurement and Implementation~~~~~DQ Implementation~~~~~3. DQ Software Capabilities : Requirements, Procurement and Implementation
titleRoadmap%20Planner
hashdf3e27b079562640c6b678469663a507

Status

...

17/03/2023

Address Management, Email & Phone Rules of Engagement

Area

Comments

%

Status

Business Rules Capture

Business Rules capture meetings revived as from 15/03/2023 to complete.

  • Needs sign off on Contacts and Accounts,

  • Needs deeper analysis around education, Opportunities, Chart of Account, Gift Adin Key fields and Processes, etc

80%

Status
colourGreen
titleON 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.

  • Needs a second round with business to flesh out any new rules

80%

Status
colourGreen
titleON TRACK

PowerBI Dashboards

Scheduled start for

0%

Status
titleNOT STARTED

DQ Software

(a) Informatica POC underway , (b) Then Decision and Procurement and lastly (c) Implementation

70%

Status
colourGreen
titleON TRACK

DQ Cleaning

Dashboards and rules created, but no cleaning ownership, so that is slipping

50%

Status
colourRed
titleBEHIND SCHEDULE

Integration Fixes

Tickets raised, but not getting actioned timely by developers + marked as “Improvements”, so very low on the Dev priority list.

50%

Status
colourRed
titleBEHIND SCHEDULE

BAU Handover

BAU Model defined, Next steps defined, Needs to get buy-in from the various areas, and then roll out

80%

Status
colourGreen
titleON TRACK

...

2(a) Data Quality Rules & DQ Dashboard

Data Quality Rules and DQ Dashboards

  1. Workshops to define Business Rules;

  2. Business rules gives rise to DQ Rules;

  3. Analysis of what causes it and how to fix it and who is responsible

  4. Create Dashboards to make easily accessible and track.

...

3. DQ Software / Capability: Aperture vs New

DQ Software Capabilities Requirements, Procurement and Implementation

  1. Workshops to determine key outcomes to achieve

  2. Catch up with vendors to understand their offering and do a gap analysis

  3. Decision + Procurement

  4. Implementation and training

4. Backlog Cleaning

DQ Backlog Cleaning

  1. DQ Cleaning

  2. 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

View file
nameSwift to Jarvis Integration Process 2021_revised_30112021.pdf

View file
nameSWIFT_Update_Your_Details - Mapping.csv

SITS

View file
nameSITS-AQ-interface-business-req.docx

View file
nameSITS validation rules - test data.xlsx

Documentation

/wiki/spaces/IP/pages/1352368226

6. BAU Transition

DQ BAU Operating Model (Post 30-Jun)

  1. Create Data Quality Management Framework

  2. Create process documents for each task that the Data Stewards needs to perform on a monthly basis, measure task estimates, define frequency.

...

No

Date

Description

Responsible

When

Status

Comments

DQ-0026

  •  Weekly Data Cleaning Status Report Spreadsheet, albie.roets . (To be provided to AlainGasquet Polina Nikulina on a Monday morning with results as at COB on the previous Friday,)

albie.roets

Status
titleDONE

Actioned and placed here on a weekly basis:

https://sydneyuni.atlassian.net/wiki/spaces/PHOEN/pages/2863432172/DQ+Backlog+Cleaning#Weekly-Status-Reports

DQ-0027

  •  BAU Operating Model: Full List of DQ Reports with: what is causing the issue, how to fix, responsible, next steps, etc, albie.roets with Manpreet Sidhu ,

albie.roets

Status
colourGreen
titleIN PROGRESS

Rules, causes, fixing, RACI, freq + next steps captured: Data Quality Rules and DQ Dashboards plus the summary in DQ BAU Operating Model (Post 30-Jun)

 

 

 

DQ Task Report:

Task report
pages2805006380
isMissingRequiredParameterstrue

...