Implementing Data Warehouse for Healthcare Organization

ImplementingData Warehouse for Healthcare Organization

ImplementingData Warehouse for Healthcare Organization

Stepsneeded to implement a data warehouse for tracking Hepatitis-B or FoodPoisoning Outbreaks

Aproper implementation of a data warehouse is required to ensure thatthe hospitals are in a better position to pursue Hepatitis B or evenfood poisoning outbreaks that emerge. Execution of the data storageis a process that requires proper decision-making, collaboration, andthe combination of available resources to ensure the success of theprocedure. Therefore, careful and appropriate follow-up of possiblesteps will ensure that an organization, a healthcare institution,implements useful data warehouses that can be used for purposes oftracking Hepatitis B or food poisoning outbursts (Krishnan, 2013).The reason for the keen following of the steps is that building adata warehouse is not an easy task and should not be left to oneperson.

Step#1 – Analysis and Definition of the Project

Amajority of organizations that engage in the construction of datawarehouses usually fear to fail. The analysis and definition stageinvolves the team asking various questions about the data storagesuch as the what, who, when, how, and why queries. While asking theseissues, the management will be involved in the recording of theanswers that they generate and integrating the solutions in thedeveloping of a data warehouse that will help in tracking hepatitis Bor food poisoning outbreaks.

Step#2 – The Design Step

Thedesign phase is an important consideration in developing a datawarehouse. Consultation and stakeholder involvement are important ingenerating a design phase of a data storage. At this stage, it isvital to engage in the explanation of the data, which will beimported and taken to the depository (Biehl, 2016). Moreover,identification of all data sources regarding food poisoning outbreaksand Hepatitis B are made at this stage.

Step#3 – Identification of Core Business Processes

Thethird phase to follow while implementing the formation of a datawarehouse for tracking hepatitis B includes identifying businessprocesses that are vital for the creation of the data warehouse. Inthis phase, there is the determination of factors that will aid inachieving the performance indicator in the organization. For example,training of the employees on the way they can identify food poisoningor Hepatitis B among individuals.

Step#4 – Construction of a conceptual data Model

Thefourth step involves the development of a conceptual data model wherethere is a modeling of the reality. While developing theconceptualized data model, identification of the primary performanceindicators for the activities such as Hepatitis B and food poisoningwill be stated clearly for understanding. The conceptual model willhelp in identifying areas that have loopholes and improvement done toseal the gaps and facilitate proper implementation of a datawarehouse.

Step#5 – Location of data sources and planning data transformations

Inthe application process, this phase will involve the determinationand identification of critical information sources and plan on how tomove the data to the warehouse. Processes that are vital in thissection include the scrubbing of data and moving the information intoa consolidated structure. Consequently, a determination on when thedata should be transferred is necessary to avoid the interferencewith the systems.

Step#6 – Monitoring and evaluation

Monitoringand assessment step is the last step in the implementation of a datawarehouse for tracking hepatitis B or food poisoning outbreaks(Todman, 2011). Monitoring and evaluation provide the organizationwith feedback regarding the data storage and suggests areas thatrequire improvement for success in the tracking Hepatitis B and foodpoisoning outbreaks.


Biehl,R. E. (2016). Datawarehousing for biomedical informatics.Boca Raton, FL: CRC Press LLC.

Krishnan,K. (2013). Datawarehousing in the age of big data.Amsterdam: Elsevier,

Todman,C. (2011). Designinga data warehouse: Supporting customer relationship management.Upper Saddle River, N.J: Prentice Hall PTR.