Introduction

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.