• Read the Transformative Health System (THS) case study.
• Read the Datawarehouse Design for Educational Data Mining article.
• Visit the Data Warehousing https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing
• Visit the Security Risk Assessment Tool https://www.healthit.gov/topic/security-risk-assessment-tool
• Visit The Security Rule https://www.hhs.gov/hipaa/for-professionals/security/index.html
Transformative Health System (THS) currently has a functioning clinical data repository. In addition, there is an effort to increase the amount of financial data in that repository. The IT team is currently working with a group of data governance leaders to define a more specific data warehouse strategy for THS that will support their evolving Care2U company strategy. This includes developing a more thorough list of the clinical and administrative applications that must feed data into an active data warehouse. Knowing that not all data can be imported into the warehouse, the end-user group is working on the importance of specific fields from specific applications that will be needed in the data warehouse. In addition to developing the data warehouse, the committee is working on the deployment of a business intelligence application that will allow end users of the data warehouse to do queries and have direct access to visual representations of critical business data. Your challenge as the IT team leader is to put together an executive-level strategy for the evolution of the data warehouse and business intelligence visualization application.
In your paper, include the following sections:
• Section 1: THS Data Warehouse Feeder Applications
o Develop a list of the clinical applications that feed data into the THS data warehouse.
o Develop a list of the administrative applications that feed data into the THS data warehouse.
o Outline the role of the consumer portal in the THS data warehouse.
• Section 2: THS and Business Intelligence Functions
o Articulate a list of end user functional requirements to be included in the menu of the THS data warehouse business intelligence application.
o Discuss at least two end user stakeholder roles who will use the data warehouse business intelligence application most frequently.
o Compose a sample of the type of business information that the selected end user roles would extract from the THS data warehouse.
o Describe how visualization would play a role for the revenue cycle director of THS as an end user of the THS data warehouse.
• Section 3: Data Warehouse System Architecture
o Compose a system architecture diagram showing the following elements of the data warehouse and end user business intelligence applications for THS: data servers, web servers, web standards, network topography, and device connectivity.
o Develop a list of internal administrative and/or clinical end user stakeholders who will utilize the business intelligence applications that are part of the THS data warehouse.
o Explain two specific business strategies important to THS that are directly supported by the utilization of information from the data warehouse.
Sample Solution