When David Higginson arrived at Phoenix Childrens Hospital to serve as CIO in 2011, the organization analyzed much of its data in silos. Clinicians and staff developed reports using information in the facilitys transactional systems, but the data was not widely available between its disparate departments.Concerned with the lack of information flow, Higginson developed a plan to bring the disparate data together, building the foundation for what would become the hospitals data lake. He and his team stood up a Microsoft SQL server and its extraction, transformation and load packages, and they also launched Microsofts reporting services application.We pulled data from 40 systems everything from the surgery system to the scanned medical records to the general ledger and payroll, says Higginson, who is now also the hospitals executive vice president and chief administrative officer. Anyplace we could tap data, we did.

Source: Click here