ITS531 – B03 Business Intelligence
January 23, 2023
week 4 project
January 23, 2023

Data Warehouse Assignment

Access yourcase study.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 populationsReducing the per person cost of healthcareThe 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.Include at least one paragraph for each of the three business goals above.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.