Deloitte has been engaged to help a company aggregate data across business units for a key reporting process on a monthly basis.
Business situation
Each business unit uses different data sets and tables for their reporting; therefore Deloitte will need to join the tables for further analysis. The client has many data quality issues including, but not limited to, duplicates, null, and blank values. In complex projects such as this, an important focus on the front end of an engagement is assessing and reacting to data quality discrepancies across the various data sources.
Problem statement
As a new team member, your role on the team is developing the process to check the quality of the data and implement a process to aggregate the information of each business unit smoothly and successfully.
for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. Certain services may not be available to attest clients under the rules and regulations of public accounting.