Versions Compared

Version Old Version 47 New Version 48
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 *

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

...