Recent polls by GE and Accenture show that big data analytics is a priority for almost 90% of organizations within healthcare. Data is an essential tool for market participants that want to increase share while improving the quality of customer deliverables. And, in the not too distant future, healthcare providers and stakeholders that implement an analytics strategy will excel in clinical quality and prevention of operational bottlenecks.
If I were going to design the worst possible health care analytics department in a health plan, TPA, or benefits consultancy, this is what I would do. First, I would go out and buy all the hardware and software licenses I needed, not to mention the database administrators and IT personnel necessary to support it. Why use the cloud? That's just a trend, right? And what about data security? The cloud can’t be nearly as secure as my data warehouse, right?
Traditional population health analytics vendors calculate utilization through the use of ‘summary tables’. This approach aggregates information from medical claims about a visit, service or procedure and stores that information in a slimmed down format (the summary table itself) that is digestible on lower performing SQL servers. Each utilization type has a summary table – an ER Visit summary table, an Admission summary table, a CT Scan summary table – and these summary tables, rather than[...]