Case Study: Diabetes Hospitalizations in Minnesota in Last Five to Ten Years

  • A key part of your proposal will be to identify benchmarks and trends for the topic you have chosen for your documentation review. Benchmarks can come from national or state quality standards or trends. If your proposal is approved, you as the office manager will want to try to answer this question: How does our office data compare to national or state trends?You need to identify your benchmarks before you can collect and then compare the data. You decide what your benchmarks are. They could be based on national averages, state averages, or quality standards. For example, here is one quality standard: All patients with chronic, stable coronary artery disease are on an antiplatelet therapy or have supporting documentation as to why they cannot take an antiplatelet therapy. For instance, they may have an allergy.Another question to consider when establishing benchmarks is this: Are you comparing apples to apples or apples to oranges? In addition, if you are retrieving information from a national database or data from an HIE, how do you know your office data is comparable to the information you are retrieving? Consult your suggested resources for answers to these questions.For this second assessment, you are to:
    • Analyze statistical trends and assess quality measures relevant to your proposal.
    • Assess the compatibility of data drawn from multiple sources.
    • Determine the effects of health information quality on an HIE.

This assessment is completed in three steps:

  • Step One – Preparation: Locate data related to quality measures or trends relevant to your topic from specific websites.
  • Step Two – Data Collection: Create a data collection tracking spreadsheet and dashboard.
  • Step Three – Data Compatibility: Write a short paper on data compatibility and quality.

Step One: Preparation
Locate data related to quality measures relevant to your topic from one or more of these websites:

Step Two: Data Collection
Using the Data Collection Spreadsheet Guide [XLSX] as an example, create a spreadsheet containing three tabs: Dashboard Tracking, Data Collection, and Trending.On the first tab, Dashboard Tracking, draw from the information you gathered in Step One as part of your preparation for this assessment:

  • Identify the specific benchmark data you will compare with your office data. Remember it is up to you to establish your benchmarks.
  • Organize or create a spreadsheet to display the totals, percentages, averages, and so on of your office data and of the national or state data you will be using for comparison. Note: Your Office Data column will be blank because you are not collecting any office data. This is only a proposal to do an information review of the quality of care provided by the physician group. Data does, however, need to appear in the Benchmark (national/state) data column.
  • Include at least one comparison graph of your choice on this tab.
  • On the second tab, Data Collection, draw from the information you gathered in Step One as part of your preparation for this assessment:
    • Create a form you will use to collect specific data from the patients’ records.
    • Include a row for each patient.
    • Provide a column for each data collection point (quality measure) you will be comparing.

Note: The information on this page is totaled, averaged, et cetera, with the results linked to the first tab.To create your third tab, Trends, you will need to do some additional research. Identify national benchmarks for the condition you have chosen that could be compared to your office data. For example, if the trend in your office is that you are seeing more patients with asthma, but the national trend is decreasing, you have discovered a discrepancy that needs to be investigated.To perform your analysis:

  • Visit one or more of the following websites containing national data:
  • Locate and analyze statistical data relevant to the selected condition.
    • Examine trends:
      • What other meaningful trends exist? For example, consider the number of new cases, increases or decreases of cases within a specific age range or location, et cetera.
      • How do the national and state trends compare?
      • Is the national trend increasing or decreasing?
      • What is the percentage of cases who expire from the disease?
  • Identify the trending of one statistical result relating to the condition you selected over the last 5–10 years.
  • Create a line graph on the third tab of your spreadsheet, Trends, that illustrates the national and/or state trending of the disease you selected over the past 5–10 years.
  • Note: Remember you have not collected your office data yet for comparison purposes. You could add that data at a later time.

Step 3: Data Compatibility

Assess the compatibility of the data:

How can you ensure data from multiple sources is compatible?

How do you know the data you are using for comparison is compatible with your office data?

What challenges are associated with data standardization? We do not want to compare apples with oranges. You want to be sure data from multiple sources:

Represents the same condition.

Uses similar statistical analysis.

And so on

Effects of Health Information Quality on the HIE

Explain the difference between an HIE and a national database.

Explain what problems can develop if facilities submit incomplete or inaccurate information to an HIE.

Explain what problems can develop if facilities submit incomplete or inaccurate information to a national database.

Explain how incomplete or inaccurate data may affect your proposal.

  • Briefly reinforce your paper’s main points.