The next wave in BI
Healthcare
Hospital |
A mid-sized general hospital had various problems regarding their business intelligence environment. During the first phase of the project a quick scan has been conducted, identifying problems in technology, architecture, processes and communication. After solving the most critical technical issues, it was decided that the best way to address the remaining problems was to redesign the existing datawarehouse and ETL process. The final stage of the project consisted of the migration to Cognos 8 which enables the organization to better tailor the information delivery to the different user groups within the hospital
Roles/responsibilities
Project lead, analysis, (re-)design & development of data warehouse & ETL process, deployment new BI solution
Platform
BI frontend
Cognos8
Datawarehouse
ETL: Cognos Data Manager
RDBMS: Oracle 10g2 Standard Edition One
Source systems
* X/Care, X/Care Invoicing, Chipsoft OK
* External CTG files
* Excel files & Access tables