A web based Data Mart system for patient care

Abstract

The unprecedented volumes of data today existing in a variety of places and different formats makes it imperative to have some techniques for data integration. Health Care organizations claim that data are complicated animals that hinders executives from decision making. The accentriatics of this data include differences in the data types and the data sources where data is stored. Data existed any where and in different formats. Executive Managers need access to a free flow of Information so that decision makers can react in real time to changing needs. Information is one of the most valuable assets of an organization that Executive Managers or physicians would need to base their decisions on, during decision-making which would improve the value of any organization. A common challenge faced by today’s information workers is ”analysis paralysis”- too much data, sets of reports that do not tie together and no usable data warehousing techniques. A reservoir for Information in form of a data mart is necessary to enhance quick and easy access to patient Information that requires the integration of the different source systems of data into one repository source. A Web Based Data Mart System is therefore necessary to integrate the different data sources into a central data repository that would pave way for Executive Managers to make accurate and reliable decisions. Interviews, questionnaires, facilitated sessions and observations portrayed the kind of information Executive Managers needed. The researcher analyzed the current system and then designed a new system for the organization. This was done using ASP.NET and Microsoft SQL SERVER 2005. The data mart system and the adhoc reporting OLAP tool provides high level reports for Executive Managers to make real time decisions. These high level reports integrate information from the Data Mart in a summarized format, the kind that is converted into Excel or PDF report depending on the needs of the Executives.