Kaleida Health has millions of patient records and needed a business intelligence tool that couple handle it all, quickly and painlessly. They chose Tableau to get the power of data analysis into the user's hands. They are able to quickly analyze among other things, resources, patients with high emergency room visits and the healthcare market in general to stay competitive. "It's endless, the types of things we can look at," said Jennifer Kuebler, Corporate Analyst at Kaleida. "I could go on forever about this product. It's made my life a whole lot easier."
Kaleida Health is the largest health care provider in Western New York. With 10,000 employees, five hospitals, a number or clinics and nursing homes, and a visiting nurse association – not to mention millions of patient records. Kaleida needed a BI tool that could handle large data sets quickly and painlessly.
Kaleida found traditional reporting tools inadequate to handle its requirements. Driven by the need for a deeper analytic capability, Kaleida created a corporate analysis department around Tableau. Instead of simply pushing out mass reports, Kaleida's BI department wanted a team that could give users what they wanted: reports they could understand.
"A huge time saver when dealing with millions of records."
Jennifer Keubler, Corporate Analyst with Kaleida, said although their data warehouse is robust, Oracle Reporting proved to be clunky and unfriendly. "We had nurses and non-financial people, and people that didn't really understand reporting and visualization, trying to interpret these reports." The result, she said, left much to be desired. Users often didn't notice the data that should have stood out.
"We created the corporate analysis department to work closely with the managers and senior executives on different projects they were doing, to not only pull the data for them, but also look at it, present it, and dig deep into the details, and find things that they should be looking at, and then highlight them in PDF files or PowerPoint presentations using Tableau," said Kuebler.
Kuebler said she spends 95 percent of her day – and runs all of her calculations – in Tableau, primarily pulling data from Oracle databases into Excel first. For monthly analytics, she extracts data directly into Tableau from the data warehouse and is able to save and re-run queries, which is a huge time-saver when dealing with millions of records, with 40+ fields per record.
Speaking of the previous version of Tableau she noted, "I was always able to use, to pull in, as many records as I wanted, but it just ran so incredibly slow that I'd do things in pieces rather than all at once," she said.
The new version eliminated that problem. "Instead of having to re-run everything, it's just a couple clicks. A lot of other people will just run high level reports or summaries and they can't really dig into the details, whereas I start at the detail level then create the summaries. So if somebody wants somethings different, I already have a file with all the details. It's just a matter of moving things around."
Blending data from Excel files and databases
Besides speed, another feature of Tableau 6.0 is the ability to link different tables. Kuebler said she uses this function to merge files to an Excel table or link them to different extracts. One example is if she has an extract by zip code, but wants to look at data by county. "If I don't have county in my file, I have an Excel file that links all the ZIP codes to a county, so I can just link it to that, and the run information by county."
Kuebler's team was asked to look at the emergency room and the patients who visit it more than ten times a year. The data revealed that there was a problem among the Medicaid population: they were frequently using ER and ambulance services inappropriately for stomachaches, headaches, fever.
"It kind of spiraled and spiraled, and the next thing you know, it was a local news story, using the data that we pulled from Tableau," said Kuebler. "And when they did the news story, they made it sound like there was this great research project and the team digging for months. And it was really just a one-day project."