Programming

Wilmington Week 6 Data Warehouse Improve Patient Experience Case Study | savvyessaywriters.us

Question 1. Week 6 – Data Warehouse Assignment

Access your case study (http://www.healthcatalyst.com/wp-content/uploads/2…)

The three business goals for the data warehouse in the case study are:

  • Improving the patient experience of care (including quality and satisfaction)
  • Improving the health of populations
  • Reducing the per person cost of healthcare

The case study concentrates on the advantages and disadvantages of different architectures for data warehouses. In addition to architecture, the data analyst must also determine what data to capture in the data warehouse to achieve the business goals. For example, one way to improve the patient experience (the first business goal) could be to reduce waits times for appointments. In order to understand what causes wait times, data about the scheduled start time, actual start time, scheduled end time, actual end time, availability of the doctor, and reason for the appointment would have to be analyzed in the data warehouse. Other ways to improve the patient experience could include: getting the diagnosis right the first time, knowing the cost upfront, avoiding second appointments with specialists, providing supplemental information for patients to read at home, etc. Each of those improvements would require different types of data in the data warehouse.

Your assignment is to specify at least one improvement for each of the three business goals above. For the improvement you identify, indicate what specific data would have to be stored in the data warehouse to analyze ways to achieve that improvement. Also specify how that data would be obtained.

Your paper should be 1 – 3 pages in APA format. Include at least one paragraph for each of the three business goals above.

Video: Module 13 – Introduction to Data Warehousing (5:27 min.) Youtube

Question 2. Week 6 – Data Management Project: Rough Draft

All project requirements identified below must be submitted in this “final rough draft.” This will give students the capability to get feedback and identify any issues before submitting final project. This course project is to develop an individual project plan that focuses on the database aspects of the project development lifecycle. All design, research, and work by each student will be original work in the design and creation of a new database. Students will become familiar with data management, database modeling and design, and skills to develop a final project plan. These requirements include the following:

1. Background of database – why you chose to design this particular database
2. Purpose of database
3. Business goals and rules for database
4. User requirements for database
5. Data requirements for database
6. Reporting requirements for database
7. Estimated project schedule and project costs for creating the database and populating it with data
8. Logical data model
9. Data dictionary for all tables in data model
10. SQL statements:
– CREATE TABLE statements (for entities defined in model)
– Minimum of two SELECT statements
– INSERT, UPDATE, or DELETE statements for at least one table
11. Identify the database management system (DBMS) software that will be used for the database
12. Specify the hardware for storing your database
13. Create a basic database back-up and recovery plan that is consistent with the business goals

Video: Module 16 – Database Administration (2:36 min.)

ORDER NOW

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational