MedAssets Inc. provides technology-enabled products and services for hospitals and health systems. The Company’s technology-enabled solutions are delivered primarily through company-hosted, or ASP-based, software supported by enterprise-wide sales, account management, implementation services and consulting. MedAssets’ customers include more than 4,500 hospitals and about 123,000 non-acute health care providers mainly in the US, but also in Canada.
MedAssets needed to efficiently handle disparate data sources and efficiently query data to provide management with a single version of the truth.
iOLAP’s team developed an implementation strategy and coordinated execution of a custom Salesforce module, including quality assurance. Next they created customized SQL queries to produce appropriate data and metrics for specific client billing agreements, operation analysis, and client account reviews. iOLAP then analyzed trends and used statistical analysis of historical data to forecast incoming requests, projected output, and expected efficiency. They collaborated with the database administration team to set up automated processes, and modify database tables, for reporting purposes.
MedAssets now has dashboards to report productivity and workloads to streamline process flow, which reduced turnaround times by an average of twenty-five percent (25%). Story boards and presentations were created for management team to discuss performance trends and projections. iOLAP provided ad-hoc research and quantitative analysis using visual analytics for executive team to have the ability to formulate actionable strategies.