Since 1996, Surgical Information Systems (“SIS”) has been dedicated to providing surgical care providers with the solutions and services they need to deliver improved operational, financial, and clinical outcomes. Focused exclusively on perioperative IT, SIS serves over 2900 facilities across the United States and Canada.
SIS brought in J2 to help build a business intelligence solution to consolidate data from three of its applications—AdvantX, SurgiSource, and Vision—into a single data store capable of supporting pre-built reports, ad-hoc queries, and advanced analytics. Using Health Connect and DeepSee, we designed and built a solution that included a robust Caché data warehouse, ETL processes for loading and updating the data model from external Caché and SQLServer databases, and a process for data purging and archiving. Subsequent project phases introduced role-based security and authentication, transaction auditing capabilities, and the development of DeepSee data cubes, dashboards, and reports.