Update from the HDWA conference
There were a handful of interesting presentations from Northwestern Medical Faculty Foundation (NMFF), Ottawa Hospital, Duke, and MD Anderson on the first day of the HDWA conference.
NMFF presented an open source SQL server integration services extension for regular expression extractions from free text, a de-identification utility, and TaskMaster, a system for processing ad-hoc data requests. One of the clever features in their workflow management approach was an integration that pulls data from the eIRB into the data warehouse to display the details of the eIRB process. It also had the capability to link out from the tool to execute tasks such as creating a report from a SQL query. Another interesting component of their model was the use of distributed analysts to query the database. The analysts operated within their own groups, but this required segmented hospital data to prevent inappropriate queries.
The Ottawa Hospital presented a dashboard view of their hospital-acquired infections graphically overlaid onto the hospital floor plan to identify infection hotspots.
Duke presented a poster on an open source framework that supports patient recruitment for clinical trials using Mirth.
MD Anderson created a new group called the Office of Performance Improvement. The organization utilized Minitab, QI Analyst, and ultimately Statit to effectively generate control charts in order to rectify challenges found among common BI tools such as Cognos and Business Objects. One of the challenges was an inflated length of stay measurement from last year. This was due to Hurricane Ike, as it was inappropriate to discharge patients in the midst of 110 MPH winds.
One of the common trends among the HDWA presentations was an initial model for data warehouses and delivery systems that provided free access in order to drive adoption, but eventually transitioned to a fee-for-service model for sustainability. Only a few of the organizations were successful thus far in making that transition.
Dan Housman
Managing Director, Analytical Applications
NMFF presented an open source SQL server integration services extension for regular expression extractions from free text, a de-identification utility, and TaskMaster, a system for processing ad-hoc data requests. One of the clever features in their workflow management approach was an integration that pulls data from the eIRB into the data warehouse to display the details of the eIRB process. It also had the capability to link out from the tool to execute tasks such as creating a report from a SQL query. Another interesting component of their model was the use of distributed analysts to query the database. The analysts operated within their own groups, but this required segmented hospital data to prevent inappropriate queries.
The Ottawa Hospital presented a dashboard view of their hospital-acquired infections graphically overlaid onto the hospital floor plan to identify infection hotspots.
Duke presented a poster on an open source framework that supports patient recruitment for clinical trials using Mirth.
MD Anderson created a new group called the Office of Performance Improvement. The organization utilized Minitab, QI Analyst, and ultimately Statit to effectively generate control charts in order to rectify challenges found among common BI tools such as Cognos and Business Objects. One of the challenges was an inflated length of stay measurement from last year. This was due to Hurricane Ike, as it was inappropriate to discharge patients in the midst of 110 MPH winds.
One of the common trends among the HDWA presentations was an initial model for data warehouses and delivery systems that provided free access in order to drive adoption, but eventually transitioned to a fee-for-service model for sustainability. Only a few of the organizations were successful thus far in making that transition.
Dan Housman
Managing Director, Analytical Applications
Labels: Data Warehousing
0 Comments:
Post a Comment