Fundamentals of Data Quality

Amazon, as of now, uses plain Excel sheets to maintain information about their Customers, Orders and Products.

They've hired you as a Data Analyst to help them do basic reporting for the customers. However, even after knowing the best of the Excel, you are not able to accurately report the business metrics. Time and again, the management comes back with complaints saying the numbers are wrong, inconsistent or inaccurate.

Without the right quality checks, any data initiative is bound to fail in an organization.

How will you go about investigating and identifying quality issues in your data?