Versions Compared

Version Old Version 44 New Version 45
Changes made by

albie.roets

albie.roets

Saved on

Key

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

...

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 *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

-

...

  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.

View file
nameContacts.xlsx

(Desensitised - No PII info in the file)

POC Area

Outcome

Comments

Address quality - comparison

Email Formatting - comparison

Telephone Formatting - comparison

...

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

 

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

 

Aneev Singh

Aneev.singh@sydney.edu.au

asin2558

Miranda Adams 

miranda.adams@sydney.edu.au

 

 

Meeting Minutes / Actions:

...