Create a report certifying the correctness of the data set. You must evaluate the existing data set and perform error detection, gap analysis, and anomaly detection. Include any screenshots necessary to support the analysis.
In the report to the vice president, include the following criteria:
Determine errors, gaps, and anomalies in the data set:
Identify the data set for errors, gaps, and anomalies.
Inconsistencies of names
Inconsistencies of numerical data and how many adjustments may be needed
Inconsistencies of blank fields
Identify if there are gaps in the data that may need additional analysis.
Identify any anomalies in the data leading to any data quality issues.
Analyze data quality issues in the data set and describe their impact.
Identify missing values and gaps in the data set.
What missing values did you identify?
What other data quality issues did you identify?
Interpret the impact of the data quality issues, stating what will happen if this unclean data set is used for organizational prediction.
Correct the errors and issues in the given data set.
Apply manual correction techniques on the data set to remove inconsistencies and improve data quality.
Describe the steps you used for the corrections and how they helped improve data quality.
Summarize your findings from the data set analysis and correction process.
Explain why you are confident that the data set is now correct and usable.
Describe how these improvements in the data set will help in further analysis and planning for the benefit of customers.
What to Submit
Submit a 2- to 3-page report using double spacing, 12-point Times New Roman font, and one-inch margins. Submit the corrected data set along with the report, which may be a .CSV, .XLS, or .XLSX file. This report should include references cited in APA format. Consult the Shapiro Library APA Style Guide for more information on citations.
