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.

Overview

You are a business analyst at Financial Charm Bank. The vice president of the corporate office has identified a data set that has details of the existing customers with information regarding their banking history and current term deposit holdings. The organization would like to use this data to make predictions about customers and their interest in term deposits.

The junior analysts on your team performed an initial analysis of this data. However, it turned out that the analysis was not correct because the quality of data was questionable. So, the vice president has asked for a reevaluation of the data set with manual correction. As the senior business analyst, you must ensure the quality of the data set and validate that it is ready for practical analysis.

Prompt

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.

Requirements: 2-3 PAGE