Capella University Data Quality Case Study Discussion

Capella University Data Quality Case Study Discussion

Capella University Data Quality Case Study Discussion

Please answer all parts fully and completely all parts need to be on separate Documents.


Impact of Data Quality in Data Mining and Analysis

By successfully completing this assignment, you will demonstrate your proficiency in the following course competencies and assessment criteria:

  • Competency 1: Evaluate how data management domains impact the outcome of data mining and analysis for business intelligence.
    • Describe the role and importance of data extraction, transformation, and loading.
    • Describe an application of data extract, transfer, and loading.
    • Analyze the role of data quality and its impact on the outcome of data mining and analysis.
  • Competency 5: Communicate ideas effectively.
    • Communicate effectively.



Write a paper analyzing a business intelligence case study where data quality may have impacted the conclusion and the recommended course of action. You may develop a prototype database using Excel for demonstration purposes.

In your paper, identify a business intelligence case study, highlighting its data requirements. Then address the following in regard to the case you identified:

  • An examination of the importance of data extraction, transformation, and data loading.
  • An analysis of the role that data quality plays on the outcome of data mining and analysis.
  • The impact, positive and negative, of data quality on outcomes in your business intelligence case.
  • Recommendations for a course of action to avoid negative impact for the business intelligence case in question, as well as for process changes for future data mining projects.


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.
  • Length: 2–4 typed, double-spaced pages.
  • Font and font size: Times New Roman, 12 point.
  • PART 2:

Data Extraction and Transformation

To complete this discussion:

  • Consider a business intelligence project of your choice. It can be a quality control project, inventory management project, customer service analysis, or introduction of a new product to the market.
  • Assume that in addition to business intelligence, you would conduct a data analysis for an inferential evidence-based recommendation for future direction.
  • Develop a strategy for identification, extraction, and transformation of the necessary data for your business intelligence project.


Internal and External Data Extraction and Integration for Business Intelligence

Use the first discussion in this unit, Data Extraction and Transformation, as a basis for this discussion and assume that the data required are identified in external and internal repositories. To complete this discussion:

    • Identify a business intelligence case study and highlight its data requirements.
      • Develop a strategy for integration and aggregation of data from different sources as well as the measures needed to be taken to assure high-quality data.
        • How do you confirm that the database contains all necessary data needed for the analytic project? For example, in detail, review what is needed to analyze the efficiency of advertising channels.
    • Develop a strategy for development of the data model.