Data Validation to Ensure Internal Data Integrity
Big Four professional services firm, global operations
1The Background
Ernst & Young is one of the big four professional services networks in the world, providing financial audit, tax, consulting, and advisory services. Each large practice depends on data teams to collect and manage internal financial performance data that is validated and useful for final internal reporting. Internal governance and compliance depend on a robust data quality process.
2The Challenge
With current data workflows in place, a further layer of protection was needed to check both the logic and completeness of data being fed into the system. Multiple small projects with disparate data required validation to ensure the SQL database in Azure was normalized and correct for both structure and logic. Internal clients depend on this process to ensure both the financial reporting and the data supporting it are correct.
Technical Environment
- Azure SQL Database
- PowerBI for reporting
- Multiple disparate data projects
- Normalized SQL database structure
3The Solution
DataTrust was deployed to automatically validate the large volume mix of disparate data, projects, and department reporting across the enterprise. Functional Data Reconciliation (FDR) tested data based on application functionality, comparing datasets on a field-by-field level. Technical Data Reconciliation (TDR) compared bulk datasets for sanity checks including table counts, record counts, and metadata comparison.
The RightData Edge
Data validation unifies data understanding for ingested data, warehouse data, and data fed into reporting. The edge that RightData provided was its know-how on each specific internal department use case or project – each had its own nature, and with DataTrust, the EY internal data team could provide a consistent approach for its enterprise.
4The Results
"RightData understood the importance of our data validation operation and was there with both advice and software knowledge when it counted."
EY Manager
Internal Data Team
Quick Facts
Company
Ernst & Young
Industry
Professional Services
Company Size
Big Four professional services firm, global operations
Published
August 28, 2023
Categories
