Case Study – Medicare Database

Summary

The Medicare database case study uses data from the Survey of Patient’s Hospital Experience available at https://data.medicare.gov/dataset/Survey-of-Patients-Hospital-Experiences-HCAHPS-/rj76-22dk . The case study is used in class first to allow students to demonstrate their ability to export data from the internet and import it into SQL Server. The example demonstrates the use of views and stored procedures to create a single satisfaction score and allow queries on that score. The equation for the score is

Score = (% Sometimes or Never Answers * 0 + % Usually Answers * 5 + % Always Answers * 10) / Total Percent

The score will always normalize to 10 (10 is perfect score).

Associated Lectures

Getting Started with Database Tools in Visual Studio

Spring 2012 Assignment 3 – Instructor Solution

Medicare Database Visual Studio Code Example

Associated Assignments

Spring 2012 Assignment 3 – Data Visualization with solution Spring 2012 Assignment 3 – Instructor Solution