Case Study

Automation of Self-Service Analytics to Leverage the Power of Healthcare Data

Automation of Self-Service Analytics to Leverage the Power of Healthcare Data 

How Systech streamlined visibility into enterprise operations through the delivery of an end-to-end data management system. 

Who we worked with:

A privately held healthcare company headquartered in San Marcos, CA, managing skilled nursing and assisted living facilities in California, Nevada, Arizona, and Utah. 

What the customer needed: 

To migrate and centralize all existing systems into one centralized repository of data so that it could be made actionable. 

What Systech delivered: 

A clear view into the ongoing business activities through improved analytics and automation. 

Visibility into enterprise operations by end-to-end data management
  • IT professional expertise surrounding the creation of facility comparison analytics and insights, reputation integration, and travelers integration. 
  • Support for current Tidal jobs (deployed as part of Datahub integration project) and its application data integration. 
  • A detailed implementation strategy, including an architecture framework, testing strategy and all key elements related to the solution. 
  • Identification of the conform dimension fit into the current model to help the analyst perform cross functional analysis. 
  • Development of source to target mapping documentation highlighting transformations and qualifiers. 
  • Execution of a formal schedule to sync the data from external source to datahub and ensure on-time delivery of insights to business users. 
  • Automation of various processes, supporting seamless access to data in a faster and more efficient way than ever before. 

Elimination of manual and labor-intensive activities responsible for increased performance 

 The client was in dire need of a centralized data management system that could support its customer, employee, nurse, and partner data. They were limited by their existing technological infrastructure and lack of documentation. Specifically, there was no reporting or data layer to compare how each facility was performing on a day-to-day basis. This made it impossible for the management to compare performance across different facilities. Moreover, almost all ongoing activities were manual and labor intensive. This was due to the fact that data was pulled from many systems, that all worked independently of one another. To make data actionable, the enterprise would need to aggregate and centralize its various systems so that they could establish self-service analysis automation. Additionally, the organization worked with highly classified financial and health information. It was extremely important that the new data environment was secure and compliant, in adherence with all financial and HIPAA stipulations.  

 While the client already had data for MATRIX and KRONOS, they were missing data elements from WORKDAY and ONSHIFT. They required an Data Integration process that could capture the missing data from the platforms and generate key metrics utilizing that information. To realize this lofty goal, they would require the expertise of a partner with skills and competencies in informatica power centre/cloud/cloud real-time; SQL server; Workday, Windows, MicroStrategy, Tidal, and PowerShell. 

 Systech was hired to consult and address the enterprise’s unmet needs and inefficiencies within their infrastructure. The disparate legacy system made the consolidation of payroll, management, insurance, and customer data impossible. They would need a new system and framework that could relay sensitive information – compliantly – to partners, generate operational dashboards, and unify KPIs. The creation of a mobile application that could support these functions was also highly desirable.  

 Systech’s expertise in data management and warehousing was instrumental in keeping IT infrastructure running smoothly while also enabling the creation of a consistent budgetary expense. The customer required a solution that supported dashboard generation, real-time data insights, built-in mobile application functionality, and self-service analysis automation. Thus, the customer required Systech’s counsel to begin their data transformation journey. 


Self-service analysis and automation made possible through MicroStrategy, SQL, and Informatica 

Systech first assessed the current data environment to formulate a migration strategy. Informatica Cloud was selected as the data integration engine. It was able to bring in the information from all the existing systems and reintegrate it into one data hub. Microsoft SQL Server and MicroStrategy was utilized for the purpose of operational dashboard creation. Once built, it was able to capture and generate insights from the missing data from Workday and Onshift. With that information, key metrics were calculated and loaded into MicroStrategy cube. This not only helped business professionals gain better visibility, but also enabled the access and automation of data insights. From there, mobile applications were built to support these dashboards so that data could be accessed and evaluated from any location and device. This supported the creation of insights surrounding number of admissions, number of readmissions, patient bed occupancy, patient gender, and more.  

The implementation of an end-to-end management system included streamlining timesheet, punch event, patient, ancillary, workers, payroll, financial, nursing, HCP, insurance, and miscellaneous information. This visibility was invaluable to their performance. Thanks to Systech’s team of experts, data management and analysis was no longer manual, tedious, or labor intensive. Insights could now be securely and compliantly shared with enterprise partners, in real-time. 

All implementation related activities helped streamline data federation, automated data processes, and generated dashboards for executives and financially vested partners. This migration resulted in dramatic monetary gains. It also increased productivity and impact. In a matter of months, the client was prepared to take ownership over their data environment in a way that was never before possible. 


At the completion of the initiative, the client benefited from the following: 

  • Migration from a common control Tidal architecture scheduler to that of an independent one, enabling individual access to different applications. 
  • Automated data repository and domain backup, executed on a biweekly basis. 
  • Elimination of time-intensive, manual processing. 
  • Automated deployment of insights and analytics, triggering a PDF facilitated comparison after the completion of the nightly batch. The nightly batch loaded data from the following applications into Datahub: 
  • Matrix, Onsift, Workday, Kronos. 
  • Systech maintenance of Kronos and Matrix (ongoing), expediently resolving failures due to source structure, connection changes, and reruns/enhancements. 
  • Delivered unified KPI’s across the following: 
  • Bed occupancy, skilled mix, medicare, registry %, nursing PPD, nursing overtime %, nursing wage PPD, non-nursing PPD, non-nursing overtime %, non-nursing wage PPD, collection of prior month revenue, and labor as a percent of revenue. 

Unified KPIs and a centralized MDM solution help solidify a financially prosperous future 

 Systech met all service requirements and delivered self-service analysis automation and dashboard generation, on time and on budget. A modernized data framework – as well as unified KPIs – enabled business users to make data-driven decisions. This business value empowered the client to take ownership of their data landscape for years to come and set them in motion toward the path of data and management excellence.  

 Systech has remained an advocate and partner of the client since 2017. Without a doubt, they will continue to support all the client’s future ambitions and initiatives. 

 Explore Systech’s case studies to stay informed and up to date on the latest innovations within the data and analytics space by clicking here