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
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
