Order Number |
6875321344 |
Type of Project |
ESSAY |
Writer Level |
PHD VERIFIED |
Format |
APA |
Academic Sources |
10 |
Page Count |
3-12 PAGES |
Subject: Business
Topic: Data Cleaning and Data Cleaning Tools
Paper details:
By successfully completing this assignment, you will demonstrate your proficiency in the following course competencies and assessment criteria: Competency 2: Apply data quality and cleansing tools to prepare data appropriate for a specific data mining project in gathering business intelligence. Define criteria to use when selecting data cleaning tool. Design an evaluation matrix. Evaluate data cleaning tools. Justify the selection of a data cleaning tool.
Competency 5: Communicate ideas effectively. Communicate effectively. Assignment Instructions Note: Please complete the first discussion in this unit before starting this assignment. In this assignment, you will develop a strategy that deals with data cleansing as a process that may continuously be applied to the pre-processing of data for elimination of missing values, noise, and inconsistencies. To begin, take time to investigate the following commercial data cleaning tools: D&B;: Offers data management transition and data quality programs. Equifax: Offers database management, data integration, and analytics solutions.
Experian: QAS Clean Service provides coding accuracy support system (CASS) certification for address verification services. IBM: Infosphere Information Server is a tool that provides data cleansing and data monitoring services. Lavastorm Analytics: Provides self-service data cleansing, data normalization, and analytics using the Business Rules Editor. Oracle: Data quality solutions work with both customer and product data. SAS: Integration with DataFlux suite of data integration, cleansing, data governance, and data quality services. Identify a business intelligence case scenario, its analytics model, and data requirements. Use the scenario you explained in the first discussion in this unit. Assume that there exists a data quality problem, and you need to select a tool for data. Then complete the following: Define general criteria that should be used for tool selection. Criteria may include user friendliness, integration, purchase cost, maintenance cost, and so forth.
Discuss why you selected these criteria and elaborate on the specifics associated with them. Design an evaluation matrix, in the form of a table, which includes both important attributes of all tools as well as the criteria you defined. Use the elements of this table and evaluate the tools listed above according to those criteria. To evaluate the tools, you will compare and rank them. Include in your comparison how each tool fits with the business intelligence case scenario you identified. Recommend the tool, based on your comparison and ranking you would use in your business intelligence case and justify your selection. Submission Requirements Your assignment should meet the following requirements: Written communication: Written communication should be free of errors that detract from the overall message. APA format: Your paper should be formatted according to current APA style and formatting. Font and font size: Times New Roman, 12 points.