Perform data mining activities on two Excel datasets. Prepare a 4-5 page report of findings, including whether datasets accurately depict performance, the use of data sampling methods in strategic decision making, and conclusions and recommendations about improving patient service and staff performance. Include in the report the analysis of the raw data in Excel data analysis tables.
INTRODUCTION
Data mining is a statistical analysis process used to extract data to provide useful information. Beginning with raw data, a data analyst organizes the data, rearranges it, and then searches for patterns. After identifying the patterns, the analyst can turn the data into usable information. In this assessment you will perform data mining activities and apply the results to different uses in health care information settings.
DEMONSTRATION OF PROFICIENCY
By successfully completing this assessment, you will demonstrate your proficiency in the course competencies through the following assessment scoring guide criteria:
Competency 3: Use data analysis skills to support health information integrity and data quality.
Analyze data samples.
Explain how to use data sampling methods and data mining to inform strategic decision making.
Recommend quality of care improvements based on statistical analysis.
Competency 4: Apply statistical strategies to analyze health care data.
Organize raw data.
Perform data mining activities.
Competency 5: Communicate in a professional manner to support health care data analytics.
Create a clear, well-organized, professional document that is generally free of errors in grammar, spelling, and punctuation.
Follow APA style and formatting guides for citations and references.
PREPARATION
You will be working with datasets in Excel spreadsheets for this assessment. Download and review these datasets now:
Dataset 1 Clinic Performance 2017 [XLSX].
Dataset 2 Nursing Performance 2016 [XLSX].
INSTRUCTIONS
As a Vila Health data analyst, you have been asked to work on a project related to customer satisfaction and nursing staff performance. You will analyze two datasets. One concerns clinic performance, specifically, patient wait times and office visit lengths. The other dataset is on nursing performance. After analyzing these two datasets, you will compose a report for the clinic’s physicians based on your analysis.
Dataset 1: Clinic Performance
This first dataset contains raw data about clinic performance from a customer-service perspective. First, organize and analyze the raw data in Excel data analysis tables. You will include these tables in your report. Write your report about Dataset 1. Be sure to include these headings and address the bullets following each heading:
Accurate Depiction of Clinic Performance.
Explain whether the sample can accurately depict clinic performance, noting variations and patterns.
Data Sampling Methods and Strategic Decision Making.
Describe how to use data sampling methods in strategic decision making.
Conclusions and Recommendations About Clinic Physicians and Customer Service.
Draw conclusions about clinic physicians and customer service.
Make two recommendations for improving patient service based on your analysis.
Sample Solution
