Analytics Practice Problems
This page contains practice report ideas. These problems may mimic actual report requests or may just be exercises in building searches, worksheets, and crosstabs.
Tips
- Consider status fields for most searches. What types of status make sense to include?
- Build searches in pieces.
- Plan each part of the report before building. How will data be displayed? How will data be sorted?
Problems
- All patients with an encounter in the past month in which some type of diabetes was diagnosed during the encounter.
- Count of patients who have a smoking problem, sorted by provider. Provide a list of names, ages, sexes, and PCPs for patients of one provider.
- All patients who received an influenza immunization in the past 6 months, the immunization company, the provider who administered it, and the date of administration.
- Diabetics with the most recent A1C test value above 10, between 8 and 10, and below 8. Show each group as a percentage of total diabetics.
- List patients who actively take aspirin more than once per day.
- Hypertensive patients whose most recent blood pressure is above 150/100.
- Vital signs for patients who have had an appointment in the past 3 months.
- All active medications prescribed as schedule 3 controlled substances in the past two years, sorted by prescribing provider. Determine the number of unique patients receiving these drugs and whether any particular patient received more than 50% from any given provider.
- All patients who have had more than two encounters in Family Medicine in the past year. Show the patient name, PCP, attending provider, and appointment location and date.