Please enable JavaScript.
Coggle requires JavaScript to display documents.
Healthcare Case Study: Transforming OLTP system to BI Solution (BI…
Healthcare Case Study: Transforming OLTP system to BI Solution
¿What is Business Intelligence?
Strategic initiative by which organizations measure and drive the effectiveness of their competitive strategy
Integration
BI infrastructure, Development tools,
Metadata management, Collaboration
Information Delivery
Reporting, Ad-hoc query, Dashboards, Data integration, Search-based BI, Mobile BI.
Analysis
Online analytical processing (OLAP),Interactive visualization, Data mining and Predictive modelling, Scorecards
BI Architecture
Multidimensional Data Warehouse
Big database containing all the data needed for performance management, decision making, and prediction
The Source Systems
Feed the BI Solution
XML
ERP
Excel Sheets
ETL (Extract, Transform & Load)
Pulling required data from different data sources and populates the multidimensional data warehouse
ODS (Operational Data Store)
Offline copy of one or more production source systems
OLAP (Online Analytical Processing)
Analysis for aggregation, summarization, and the ability to view information from different angles
Semantic Layer
Layer between the database and the reporting which made data access easier for end users
Database fields can be translated into Objects, each object has a business definition.
BI Portal
Single point of access to data that contains reports
Data Mining
Automated process of discovering previously unknown useful patterns within structured data
OLTP (Online Transacional Processing)
Category of data processing that is focused on transaction-oriented tasks
Applications for Healthcare using BI
Technology Solutions
DSS (Decision Suppor Systems)
Support managerial decision making
Executive Information Systems
Support decision making at the senior management level
OLAP
Support analysts with the capability of perform multi-dimensional analysis of data
Query and Reporting Services
Provide quick and easy access to the data
Data Mining (Reporting Model)
Examines data to discover hidden facts
Operational Data Services
Collect data from end users, organizing data
Integration Services
Design and implement of process flow of data
Business Solutions
Patient Analysis
Focuses on analysis of patients’ demographic and satisfaction
Electronic Health Record Analysis
Focuses on analysis of the quality of clinical data
Performance Analysis
Streamline and optimize the way that a business uses its resources
Fund Channel Analysis
Devise, implement, and evaluate fund strategies
Productivity Analysis
Focuses on building business metrics for activities
Behavioural Analysis
Understanding and predicting trends and patterns
Supply Chain Analysis
Monitor, benchmark, and improve supply chain activities
Wait Time Analysis
Focuses on the factors that are associated with longer waiting times
The Study
Solution
Outcomes
Data Management and Reporting
Hand Hygiene System
Data Warehouse Building
Dashboard for Infection prevention and Control
Technology
SQL Server 2008
Visual Studio
BI Development Studio
SSRS
Excel
The Goal
Transforming an OLTP system towards building an OLAP solution by improving infection rates of antibiotic resistant organisms at the LHSC through an analysis of a Data Warehouse