Define big data analysis dataset to include in datawarehouse

Assignment Help Database Management System
Reference no: EM131808330

Assignment

Managing the quality and cost of co-morbid populations is one of the most challenging aspects of health leadership. In this Discussion, you are challenged with selecting those data which will be most helpful in the management of Medicare populations. As health information exchanges (HIEs) progress at the state, federal, and nation level, health leaders are tasked to participate in the development of analytics tools that can be used to pull data and inform policy practice.

Scenario:

Examine the CMS Chronic Conditions Triads: Prevalence and Medicare Spending spreadsheet located in your Learning Resources. Familiarize yourself with CMS data regarding chronic conditions and Medicare spending (CMS.gov), beginning with the first tab in the spreadsheet, titled Overview, that summarizes the data sources, study population chronic conditions, and socio-demographic variables involved in the data. Note that the remainder of this data set presents five years of data on various triads of chronic conditions that represent material co-morbidities studied by CMS. With the CMS development of ACO's (accountable care organizations) there is an emphasis on managing certain chronic conditions to minimize hospital readmissions. The pro-active medical management of heart failure, specifically CHF (congestive heart failure), is a focus in trying to prevent unnecessary hospital admissions. In the medical management of this condition and associated comorbidities such as diabetes chronic kidney disease and hyperlipidemia, patients must manage both their fluid intake and maintain a rigorous regime of medication such as beta-blockers. A lack of medication compliance and or fluid management in these patients often results in repeated emergency room visits and or hospital readmissions to stabilize physiologic parameters. In this scenario assume you are an administrator of an integrated delivery network who is working with CMS on developing an ACO. Using these historical, five year data on CMS patients with comorbidities related to Heart Failure and per capita spending, you are asked to work with an IT analyst to lead the design of the functional requirements for the data warehouse. This business intelligence application will upload information from your organization to CMS as a part of the ACO. Senior leaders want to understand which HIT systems and which data within those HIT systems will be required to contribute relevant information to CMS regarding comorbidities on heart failure patients. They also want to understand the availability of those data and the level of quality of those data in the organization, as they will be key to the financial parameters set within the ACO agreement.

Review the high volume Medicare Data Scenario. In this scenario you are asked to work with a complex dataset of co-morbidity data of patients that have three concurrent co-morbid conditions (Chronic Condition Triads: Prevalence and Medicare Spending). How can data from HIT systems be used to formulate useful information to facilitate in the management of this population?

To prepare:

• Using the health care information systems standards for clinical and financial data discussed in Week 6 (Chapter 11 of Health Care Information Systems: A Practical Approach for Health Care Management), identify specific types of data (data sets, standards, examples of those data) that can be redeveloped into Big Data tools and used to address the management of population health initiatives.

• Define a "Big Data" analysis dataset to include in a data warehouse by identifying two specific types of clinical and financial data from the Chronic Condition Triads: Prevalence and Medicare Spending dataset in your Learning Resources that you feel could be used to drive behavior change in the patient and provider populations. This Big Data dataset will become the focus of your Discussion.

Post:

Explain why the two specific types of clinical and financial data you selected as your Big Data dataset would best affect behavior change in the type of co-morbid Medicare populations served in the scenario. Explain and assess how this Big Data dataset can change the behaviors of health care providers in the scenario. Assuming that your Big Data dataset is going to be shared in a regional health information exchange, explain how the Centers for Medicare and Medicaid Services and private payers might use these regional data sets to increase value in delivering services to co-morbid Medicare patient populations in the region.

Attachment:- Chronic-Condition-Triads.rar

Reference no: EM131808330

Questions Cloud

Confidence interval for the population mean sales increase : During a 1-week experiment, motion was added to in store sales displays at a random sample of your firm's stores nationwide.
Create more effective performance management systems : Explain the methods to create more effective performance management systems.
Compute the standard error of the average : Table shows the 2015 performance of stocks recommended by Gene Marcia, whose list was published in Forbes in December 2014.
Prepare a ppt report on MR industry : Prepare a ppt report on MR industry in selected country - Write a brief-like document on the topic that you are going to do the research on during this course
Define big data analysis dataset to include in datawarehouse : Define a Big Data analysis dataset to include in a data warehouse by identifying two specific type of clinical and financial data from Chronic Condition Triads.
Describing the activities to enhance your career prospective : Explain your career goals by describing the activities to enhance your career prospective.
How parenting impacts happiness-satisfaction : How parenting impacts happiness/satisfaction. How single parenting differs from a 2-parent household. Adoption, foster care situations, blended families.
What is the external environment and competitive environment : Consider these questions: What is the external environment? What is the competitive environment? Why are you analyzing the external environment
What are benefits or consequences that you have witnessed : What are the benefits or consequences that you have witnessed when it comes to employee rights? What steps do you believe managers use to solve problems.

Reviews

Write a Review

Database Management System Questions & Answers

  Create erd for each of the given descriptions

Each of the MegaCo Corporation's divisions is composed of many departments. Each department has many employees assigned to it, but each employee works.

  Find all super keys of r

Let R(A, B,C, D) be a relation and suppose it contains the following dependencies: A → B, BC → D, and D → A. - Find all super keys of R.

  Researchers wanted to explore self-esteem in adolescent

researchers wanted to explore self-esteem in adolescent boys and adolescent girls. each respondent completed a 10-item

  Explain your rationale behind the design of your e-r diagram

Explain your rationale behind the design of your E-R Diagram. Create at least two sample queries that will support the organizational reporting needs.

  Create an e-r diagram relating table of your database schema

Create an Entity-Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia.

  Prepare a systems proposal

Prepare a Systems Proposal that includes an executive summary and a problem statement. Refer to the guidelines and recommended format for the systems proposal.

  Create a report detailing the basics of databases

Henningson has asked you to create a report detailing the basics of databases. She would also like you to provide a detailed explanation of relational databases along with their associated business advantages.

  Create a class report with headings

IT 210:Create a class report with headings and columns of proper width for STUDENT NAME, TEST 1, TEST 2, TEST 3, and AVERAGE.

  Create an erd that represents the entities and attributes

Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule.

  Find database management system selection

Identify and describe three criteria that should be used to evaluate the selection of a database management system.

  Explain the reasons for probability and impact assessments

The rationale should explain the reasons for your probability and impact assessments and There should be one risk information sheet for each risk identified

  Use three-sphere model for systems management

Use the three-sphere model for systems management and brainstorm issues related to the change based on the business, technology, and organization spheres.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd