Using the Case Study below, determine the following:
. What criteria you would need to extract the data from
. What the report would look like (data field titles) to best represent this case study?
. How should the user be able to sort the data (sort options) for further analysis?
Case Study: Dr. Bartlett is enrolled in a quality improvement initiative and has been collecting data for submission on the quality measures pertaining to
diabetes. He has asked you for a report that contains his patients who are over the age of 20 with a diagnosis of diabetes or gestational diabetes.
Using your knowledge of data storage and retrieval, and data mining techniques, design a report that will capture all pertinent information that Dr. Bartlett may
The design should include the following elements and can be turned in using Word or Excel:
. Define the criteria used to filter the information from the EHR (e.g. specific diagnoses)
. What data that would be displayed when the report is printed/displayed (e.g. patient name)
. Any sorting criteria that may be helpful (e.g. sort alphabetically by patient name