Timeline
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 |
Key Requirements
Date | Document | Distribution |
|---|---|---|
| Passcode: &m.TT0?K | |
Vendor Capability Analysis
Experian | Ataccama | Informatica | |
|---|---|---|---|
Best in class: https://www.ataccama.com/analyst-research/gartner-magic-quadrant-data-quality-solutions-2022 | Gartner ‘challengers’ percentile | Gartner ‘leaders’ percentile | Gartner ‘leaders’ percentile |
Dashboards w Historical Progress Graphs | Do provide, did not configure | Provide Historical Progress Graphs | Provide Historical Progress Graphs |
Address Validation |
|
|
|
National Change of Address (NCOA) | Australia Post integration - BUT @ extra cost | Australia Post Services included in the licensing fees | Australia Post Services included in the licensing fees |
Mobile Validation | Format phone numbers | Format phone numbers | Format phone numbers |
Phone Validation | Format phone numbers + validate against HLR (Home Location Register) | Format phone numbers + validate against HLR (Home Location Register) | Format phone numbers + validate against HLR (Home Location Register) |
Email Validation | Various Checks | Various Checks | Various Checks |
Consumer Segmentation | Mosaic customer profiling | Mosaic customer profiling | Mosaic customer profiling |
Field Level Analysis (isnull, info(), etc | Yes | Yes | Yes |
Data Quality Rules | Set of Standard Data Quality Rules on Address, Phone and Email | Set of Standard Data Quality Rules on Address, Phone and Email + Customisable for additional rules | Set of Standard Data Quality Rules on Address, Phone and Email + Customisable for additional rules |
Ease of use out of 10 | 5 * | 8 * | 8 * |
Access Control Mechanism | SSO | SSO + Rule based access control | SSO + Rule based access control |
Vendor and Cyber Security Assessment | Done | New Provider, Needs to be done | Existing USyd supplier - Vendor and Cyber Security Assessment already done |
Cost | $55,000 for 10x licenses | ?? | Current provider - will be using existing licences |
Comments | - |
POC Outcomes:
Ensure that as a minimum it can replicate the Aperture address check functionality → Run a salesforce file through Aperture and Informatica and compare.
Ensure that as a minimum it can replicate the Aperture telephone formatting functionality → Run a salesforce file through Aperture and Informatica and compare.
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 | Unikey | |
Albie Roets | aroe8216 | |
Manpreet Sidhu | msid4459 | |
Yeng Sembrano | msem3353 | |
Polina Nikulina | pnik2390 | |
The-Ho Trang |
|
|
Binila Russel | ||
Pat Dennis | pden4556 | |
Beha Parsa | Bpar2671 | |
James Allen |
|
|
Aneev Singh | asin2558 | |
Miranda Adams |
|
|
Meeting Minutes / Actions:
Date | Description | Comments |
|---|---|---|
| Cyber Security to review Workbench TAP-1216 - Getting issue details... STATUS |
|
| 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 Actions:
(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) | |
|
|
|
|
|
|
|
|
|