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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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