Versions Compared

Version Old Version 48 New Version Current
Changes made by

albie.roets

albie.roets

Saved on

Key

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

Timeline

Roadmap Planner
maplinks
timelinetrue
source%7B%22title%22%3A%22Roadmap%20Planner%22%2C%22timeline%22%3A%7B%22startDate%22%3A%222022-12-09%2000%3A00%3A00%22%2C%22endDate%22%3A%222023-11-09%2000%3A00%3A00%22%2C%22displayOption%22%3A%22MONTH%22%7D%2C%22lanes%22%3A%5B%7B%22title%22%3A%22Analysis%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%22Workshops%20to%20Define%20Must%20Have%20Functionality%22%2C%22description%22%3A%22This%20is%20the%20first%20bar.%22%2C%22startDate%22%3A%222022-12-01%2007%3A21%3A58%22%2C%22duration%22%3A0.9702970297029703%2C%22rowIndex%22%3A0%2C%22id%22%3A%22727558c1-419c-4a2c-ad8f-643c387c1d7e%22%2C%22pageLink%22%3A%7B%7D%7D%2C%7B%22title%22%3A%22Gather%20Provider%20Capability%22%2C%22description%22%3A%22This%20is%20the%20second%20bar.%22%2C%22startDate%22%3A%222022-12-01%2007%3A21%3A58%22%2C%22duration%22%3A2.9438943960396036%2C%22rowIndex%22%3A1%2C%22id%22%3A%22eb4d2384-dde9-4b38-8101-61dda3e8af82%22%2C%22pageLink%22%3A%7B%7D%7D%5D%7D%2C%7B%22title%22%3A%22Decision%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%22Decision%22%2C%22description%22%3A%22This%20is%20the%20third%20bar.%22%2C%22startDate%22%3A%222023-02-28%2021%3A46%3A56%22%2C%22duration%22%3A0.9900990099009901%2C%22rowIndex%22%3A0%2C%22id%22%3A%229b4acef6-c00c-42df-b349-32fd2eee8294%22%2C%22pageLink%22%3A%7B%7D%7D%5D%7D%2C%7B%22title%22%3A%22Implementation%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%222023-04-01%2014%3A15%3A26%22%2C%22id%22%3A%229eefde59-7605-4457-b134-f7bf5addefdc%22%2C%22title%22%3A%22Implementation%20and%20Training%22%2C%22description%22%3A%22%22%2C%22duration%22%3A1.9636963762376238%2C%22pageLink%22%3A%7B%7D%7D%5D%7D%5D%2C%22markers%22%3A%5B%7B%22title%22%3A%22Procurement%20Complete%22%2C%22markerDate%22%3A%222023-03-31%2016%3A38%3A01%22%7D%2C%7B%22markerDate%22%3A%222023-02-28%2004%3A02%3A22%22%2C%22title%22%3A%22Analysis%20Complete%22%7D%2C%7B%22markerDate%22%3A%222023-05-31%2016%3A38%3A01%22%2C%22title%22%3A%22Complete%22%7D%5D%7D
pagelinks
titleRoadmap%20Planner
hashc933c620902f315b7c54180de8bdfab4

Key Business Outcomes:

The key business outcome is to ensure any relevant comms (mail, email, SMS) reaches the target audience (e.g. Alumni, Donor, Friend, etc.) thereby increased engagement and uplift in philanthropy donations.

Procurement Policies

No

Description

Document

1

Procurement Policy and rules for engagement

View file
namef2scamlh.hlt-26297-PDOC2011-40.pdf

Key Requirements

Date

Document

Distribution

View file
nameDQ Software Requirements_20221205.pptx

Experian Minutes : https://us02web.zoom.us/rec/share/UCR_5Z_gJDTFfmj_F9Mkt5Hd0ILE7X5-mN4jBNrvaQ4KKm6c0sNRajdrhjtxZxXn.16TeiYaPHTPUx40e?iet=751bmC-FkPd5_2HjN73gza550v1lAAm7jeOFqEbvz_E.AG.TedxnoHtTENAyntBHPTFSRThohKBftuHkG2CECeL8Wav12fjjej4ADcfU287hheIw8x00FjesM573ntMussMPcHkHRE9neTfV828_vX9v-gLLwwh8o-f9db3jkl95294NqXa6g.iIoPTNuTpirXe9qTFf6ITg.f47FW41j0OUjERJt

Passcode: &m.TT0?K

Vendor Capability Analysis

Experian

https://www.experian.com.au/insights-au/data-quality/give-your-data-quality-strategy-a-boost-with-your-own-tailored-data-quality-report/?SP_MID=37954-g&SP_RID=23911092-g&cmpid=APAC-ANZ-DQT-Experian%20Connect%20Newsletter%20Nov%2022_37954&elqTrackId=C325462474FE41A06E21DA0FD2127E61&elq=d9daf931b3af4d81b0f82913f4fde0c5&elqaid=37954&elqat=1&elqCampaignId=18065

Ataccama

Informatica

Best in class: https://www.ataccama.com/analyst-research/gartner-magic-quadrant-data-quality-solutions-2022

Note

Gartner ‘challengers’ percentile

Tip

Gartner ‘leaders’ percentile

Tip

Gartner ‘leaders’ percentile

Dashboards w Historical Progress Graphs

Note

Do provide, did not configure

Tip

Provide Historical Progress Graphs

Tip

Provide Historical Progress Graphs

Address Validation

Note

  • No International addresses - extra cost

  • Uses Google API so Unit numbers not good.

Note

  • No International addresses - extra cost

  • Uses Google API so Unit numbers not good.

Note

  • No International addresses - extra cost

  • Uses Google API so Unit numbers not good.

National Change of Address (NCOA)

Note

Australia Post integration - BUT @ extra cost

Tip

Australia Post Services included in the licensing fees

Tip

Australia Post Services included in the licensing fees

Mobile Validation

Tip

Format phone numbers

Tip

Format phone numbers

Tip

Format phone numbers

Phone Validation

Tip

Format phone numbers + validate against HLR (Home Location Register)

Tip

Format phone numbers + validate against HLR (Home Location Register)

Tip

Format phone numbers + validate against HLR (Home Location Register)

Email Validation

Tip

Various Checks

Tip

Various Checks

Tip

Various Checks

Consumer Segmentation

Tip

Mosaic customer profiling

Tip

Mosaic customer profiling

Tip

Mosaic customer profiling

Field Level Analysis (isnull, info(), etc

Tip

Yes

Tip

Yes

Tip

Yes

Data Quality Rules

Note

Set of Standard Data Quality Rules on Address, Phone and Email

Tip

Set of Standard Data Quality Rules on Address, Phone and Email + Customisable for additional rules

Tip

Set of Standard Data Quality Rules on Address, Phone and Email + Customisable for additional rules

Ease of use out of 10

5 *

8 *

10 *

Access Control Mechanism

Tip

SSO

Tip

SSO + Rule based access control

Tip

SSO + Rule based access control

Vendor and Cyber Security Assessment

Tip

Done

Aperture DS

Warning

New Provider, Needs to be done

Tip

Existing USyd supplier - Vendor and Cyber Security Assessment already done

Cost

$55,000 for 10x licenses

TBA

Current provider - will be using existing licences

Comments

-

Pro’s & Cons moving to Informatica

Pro’s

Cons

  • I think the tool is quite flexible and UI friendly:-

  • Data quality rule/data dictionary is managed separately and at the same time can be referenced for the data profiling.

  • Data Profiling pipeline looked quite intuitive. (Drag and Drop feature).

  • Data masking is easy (just simply drag that function onto the sheet and choose the field you want to mask).

  • Automatic tagging on target fields, and ability pick source fields and map onto target fields. (again quite viaual and intuitive).

  • Data enrichment capability, will definitely help us to fix lot of missing data.

  • I think Uni people are already using it (Aravind), so will be able to get timely support to resolve any query (if needed).

  • the tool is more complex, not straight forward to use comparing to Aperture DS. with Aperture DS the people who don't have training still could used it after have sometime to look at the exist work flow. example James pick up quick

  • We have to define verify rule while Aperture DS has it build in rule.

  • with aperture ds we could upload the data directly from our computer, but this tool we need to load the file to AWS of some kind before we could access. The connection to Source is not easy.

  • I agree with Manpreet that there are more features like data masking, ....

  • It will be time consuming: as the output of which I saw wasn't usable yet. I think we have to spend lots of times to define and set up to be able to output a passing data file and a failed data file.

  • Informatica also has in built rules, and we can define ours as well. It can automatically pick up data elements and create data dictionary based on the majority of data.

TAP BI Team User Details

SSO UAT Link:  https://dm-ap.informaticacloud.com/ma/sso/eMfunfYtOoUhLleAo4to6F

Name

Email

Unikey

Albie Roets

albie.roets@sydney.edu.au

aroe8216

Manpreet Sidhu

manpreet.sidhu@sydney.edu.au

msid4459

Yeng Sembrano

yeng.sembrano@sydney.edu.au

msem3353

Polina Nikulina

polina.nikulina@syndey.edu.au

pnik2390 

The-Ho Trang

theho.trang@sydney.edu.au

ttra9492

Binila Russel

binila.russel@sydney.edu.au

brus4814

Pat Dennis

pat.dennis@sydney.edu.au

pden4556

Beha Parsa

Beha.Parsa@sydney.edu.au

Bpar2671

James Allen

James.d.allen@sydney.edu.au

Jall6216

Aneev Singh

Aneev.singh@sydney.edu.au

asin2558

Miranda Adams

miranda.adams@sydney.edu.au

 

 

...

POC Outcomes:

  1. Ensure that as a minimum it can replicate the Aperture address check functionality → Run a salesforce file through Aperture and Informatica and compare.

  2. Ensure that as a minimum it can replicate the Aperture telephone formatting functionality → Run a salesforce file through Aperture and Informatica and compare.

  3. Ensure that as a minimum it can replicate the Aperture email checking functionality → Run a salesforce file through Aperture and Informatica and compare.

...

POC Area

Outcome

Comments

Address quality - comparison

Email Formatting - comparison

Telephone Formatting - comparison

TAP BI Team User Details

SSO UAT Link:  https://dm-ap.informaticacloud.com/ma/sso/eMfunfYtOoUhLleAo4to6F

Name

Email

Unikey

Albie Roets

albie.roets@sydney.edu.au

aroe8216

Manpreet Sidhu

manpreet.sidhu@sydney.edu.au

msid4459

Yeng Sembrano

yeng.sembrano@sydney.edu.au

msem3353

Polina Nikulina

polina.nikulina@syndey.edu.au

pnik2390 

The-Ho Trang

theho.trang@sydney.edu.au

ttra9492

Binila Russel

binila.russel@sydney.edu.au

brus4814

Pat Dennis

pat.dennis@sydney.edu.au

pden4556

Beha Parsa

Beha.Parsa@sydney.edu.au

Bpar2671

James Allen

James.d.allen@sydney.edu.au

Jall6216

Aneev Singh

Aneev.singh@sydney.edu.au

asin2558

Miranda Adams

miranda.adams@sydney.edu.au

 

 

Meeting Minutes / Actions:

Date

Description

Comments

 

 Cyber Security to review Workbench

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-1216

  •  Get Cyber Security to security review Workbench, albie.roets ,

 

KEY POINTS FROM ATACCAMA DEMO SESSION :-

1. Data Cataloging/Metadata Management to give enterprise-wide view of the data.

2. Ability to integrate the cleansed data into other cloud platforms eg: Snowflake, Azure etc

3. Ability to integrate with JIRA / Confluence

4. Addresses are verified using Google API / Aus Post services.

5. Ability to identify patterns in the data.

6. Supports in-built data quality rules as well as custom rules (tag/column level) based on the data asset.

7. Supports rule based access control.

8. Provides the feature of Data Quality Firewall which helps to prevent entry of poor quality data.

9. Data quality can be tracked down using score card & other metrics.

 Polina Nikulina AlainGasquet albie.roets Brad Fernandes (Unlicensed) FYI

 

Demo of Informatica: ICT → Advancement Services

https://uni-sydney.zoom.us/rec/share/Yx2yMNHeKgnrdRoAargPZ2yv2oKbQ6KvdqYZMM1aXpZ0ch1K1tfOw95yKhK8X7KX.w8OeJ6WLu_JHf7NW
Passcode: +9je@Cc5

Actions:

  •  Provide a list of users with UniKey for access to Infomatica and send the same to Arvind, albie.roets ,
  •  Check if existing Salesforce connection is available to the UAT environment., Aravind Bobba ,
  •  Do a POC in UAT environment once access is granted, albie.roets ,
  •  Support the Advancement team as needed with any implementation steps/ user guides, Aravind Bobba ,

(FYI AlainGasquet , Polina Nikulina , Manpreet Sidhu , Brad Fernandes (Unlicensed) , Yeng Sembrano , Eric Park , paras.nath , mahesh.donthireddy , Jerry Hartard , Michael Tran (ICT) , Con Bautista , md.adil , Kevin Koay)

View file
nameRE_ Infomatica demo w_ ICT.msg

View file
nameFW_ Infomatica demo w_ ICT.msg

 

 

 

 

 

 

 

 

 

...