inspire 2014 – cardinal health: healthcare efficiency: doing more with less

#inspire14

Healthcare Efficiency:Doing More with Less

Roger ShiltzSenior Consultant, Business IntelligenceCardinal Health

© Copyright 2014, Cardinal Health. All rights reserved. CARDINAL HEALTH, the Cardinal Health LOGO and ESSENTIAL TO CARE are trademarks or registered trademarks of Cardinal Health.

Essential facts

33,000plus employees with direct operations in

10 countries

100,000locations

delivered to daily

2

Cardinal Health is an essential link in the healthcare supply chain, providing pharmaceuticals and medical products and services.

$101BFY13 revenue

#22on Fortune 500

list

78%of hospitals in the

U.S. use our products and

services

© Copyright 2014, Cardinal Health. All rights reserved. CARDINAL HEALTH, the Cardinal Health LOGO and ESSENTIAL TO CARE are trademarks or registered trademarks of Cardinal Health.

Essential role

Medical Segment

Medical Devices and Diagnostics

Hospital Sales and Services

Cardinal Health is bringing scale and expertise to serve healthcare providers across the care continuum with products and services that improve their cost effectiveness and ability to serve patients.

3

Ambulatory Care

Medical Segment

AssuraMed™Medical

Consumables

#inspire14#inspire14

Solutions and Analytics Team responsibilities

Product and Service AnalyticsMarket and Customer Analytics

#inspire14#inspire14

Alteryx use case

• Scale the production of customer analytical packages

– Previous capability allowed for a single FTE to produce 100 customer analytical packages per month

– Each package consist roughly of 25 PowerPoint slides and a raw Excel file for data exploration

• Make the data available on the Solutions and Analytics Portal

• Provide data in consumable formats for end users

#inspire14#inspire14

Prior state

100 analytical packages

Data processing time 1 FTE ~ 1 Month

Product Data

Sales Data

Third Part Data

Other

#inspire14#inspire14

Current state

Alteryx

Product Data

Sales Data

Third Part Data

Other

2,000+analytical packages

Data processing time 30-60 minutes

#inspire14#inspire14

Customer analytical package output

• PowerPoints formatted in Cardinal Health brand template

• Each package is 20-30 pages of graphs, charts and analytical insights

• Raw data provided in Excel Tables to allow end-users to further explore the data

• Data consumed by sales and account managers

#inspire14#inspire14

Time savings and increased production

Time reduction of 159 hours per production cycle

20 X increase in quantity produced

#inspire14#inspire14

Key challenges

• Brand template format for PowerPoint presentations

• Refreshing data for existing Excel templates and Excel tools

#inspire14#inspire14

Creating the Cardinal Health brand template

#inspire14#inspire14

Creating the Cardinal Health brand template

Total Surgical Volume by Decile

#inspire14#inspire14

Populating existing Excel templatesCreating the batch macro

Using the batch macro

Excel Data Table Batch Macro.yxzp

Click the below Icon to import the batch Macro and try it out!

#inspire14#inspire14

Conclusion

• Alteryx has saved 150 work hours per production cycle• Alteryx has increase production from 100 reporting

packages to over 2,000 customer analytical packages

Future uses• Tableau Integration• Geospatial• Automation of existing reporting

#inspire14

THANK YOU!