Comments
yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Expo on Google News
SYS-CON.TV

2008 West
DIAMOND SPONSOR:
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
PLATINUM SPONSORS:
Red Hat
The Opening of Virtualization
GOLD SPONSORS:
Appsense
User Environment Management – The Third Layer of the Desktop
Cordys
Cloud Computing for Business Agility
EMC
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Intel
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Sensedia
Return on Assests: Bringing Visibility to your SOA Strategy
Symantec
Managing Hybrid Endpoint Environments
VMWare
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
PLATINUM SPONSORS:
Appcelerator
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
GOLD SPONSORS:
ICEsoft
How Can AJAX Improve Homeland Security?
Isomorphic
Beyond Widgets: What a RIA Platform Should Offer
Oracle
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
The Taming of the Skew | @CloudExpo #Cloud #BigData #Analytics
Two types of skewness: the statistical skew impacts data analysis, and the operational skew impacts operational processes

The Taming of the Skew
By Dr. Laura Gardner, VP, Products, CLARA Analytics

In the famous comedy by William Shakespeare, "The Taming of the Shrew," the main plot depicts the courtship of Petruchio and Katherina, the headstrong, uncooperative shrew. Initially, Katherina is an unwilling participant in the relationship, but Petruchio breaks down her resistance with various psychological torments, which make up the "taming" - until she finally becomes agreeable.

An analogous challenge exists when using predictive analytics with healthcare data. Healthcare data can often seem quite stubborn, like Katherina. One of the main features of healthcare data that needs to be "tamed" is the "skew" of the data. In this article, we describe two types of skewness: the statistical skew, which impacts data analysis, and the operational skew, which impacts operational processes.

The Statistical Skew
Because the distribution of healthcare costs is bounded on the lower end - that is, the cost of healthcare services is never less than zero but ranges widely on the upper end, sometimes into the millions of dollars - the frequency distribution of costs is a skewed distribution. More specifically, in the following plot of frequency by cost, the distribution of healthcare costs is right-skewed because the long tail is on the right (and the coefficient of skewness is positive):

This skewness is present whether we are looking at total claim expense in the workers' compensation sector or annual expenses in the group health sector. Why is this a problem? Simply because the most common methods for analyzing data depend on the ability to assume that there is a normal distribution, and a right-skewed distribution is clearly not normal. It fails to conform to the assumption of normality. To produce reliable and accurate predictions and generalizable results from analyses of healthcare costs, the data need to be "tamed" (i.e., various sophisticated analytic techniques must be utilized to deal with the right-skewness of the data). Among these techniques are logarithmic transformation of the dependent variable, random forest regression, machine learning, topical analysis and others.

It's essential to keep this in mind in any analytic effort with healthcare data, especially in workers' compensation. To get the required level of accuracy, we need to think "non-normal" and get comfortable with the "skewed" behavior of the data.

Operational Skew
There is an equally pervasive operational skew in workers' compensation that calls out for a radical change in business models. The operational skew is exemplified by:

  • The 80/20 split between simple, straightforward claims that can be auto-adjudicated and more complex claims that have the potential to escalate or incur attorney involvement (i.e., 80 percent of the costs come from 20 percent of the claims).
  • The even more extreme 90/10 split between good providers delivering state-of-the-art care and the "bad apples" whose care is less effective, less often compliant with evidence-based guidelines or more expensive for a similar or worse result. (i.e., 90 percent of the costs come from 10 percent of the providers).

How can we deal with operational skew? The first step is to be aware of it and be prepared to use different tactics depending on which end of the skew you're dealing with. In the two examples just given, we have observed that by using the proper statistical approaches:

  • Claims can be categorized as early as Day 1 into low vs. high risk with respect to potential for cost escalation or attorney involvement. This enables payers to apply the appropriate amount of oversight, intervention and cost containment resources based on the risk of the claim.
  • Provider outcomes can be evaluated, summarized and scored, thus empowering network managers to fine-tune their networks and claims adjusters to recommend the best doctors to each injured worker.

Both of these examples show that what used to be a single business process -managing every claim by the high-touch, "throw a nurse or a doctor at every claim" approach, as noble as that sounds - now requires the discipline to enact two entirely different business models in order to be operationally successful. Let me explain.

The difference between low- and high-risk claims is not a subtle distinction. Low-risk claims should receive a minimum amount of intervention, just enough oversight to ensure that they are going well and staying within expected parameters. Good technology can help provide this oversight. Added expense, such as nurse case management, is generally unnecessary. Conversely, high-risk claims might need nurse and/or physician involvement, weekly or even daily updates, multiple points of contact and a keen eye for opportunities to do a better job navigating this difficult journey with the recovering worker.

The same is true for managing your network. It would be nice if all providers could be treated alike, but in fact, a small percentage of providers drives the bulk of the opioid prescribing, attorney involvement, liens and independent medial review (IMR) requests. These "bad apples" are difficult to reform and are best avoided, using a sophisticated provider scoring system that focuses on multiple aspects of provider performance and outcomes.

Once you have tamed your statistical skew with the appropriate data science techniques and your operational skew with a new business model, you will be well on your way to developing actionable insights from your predictive modeling. With assistance from the appropriate technology and operational routines, the most uncooperative skewness generally can be tamed. Are you ready to "tame the skew"?

Read Dr. Gardner's first two articles in this series:

Five Best Practices to Ensure the Injured Workers Comes First

Cycle Time is King

As first published in Claims Journal.

###

Laura B. Gardner, M.D., M.P.H., Ph.D., is an expert in analyzing U.S. health and workers' compensation data with a focus on predictive modeling, outcomes assessment, design of triage and provider evaluation software applications, program evaluation and health policy research. She is a successful entrepreneur with more than 20 years of experience in starting and building Axiomedics Research, Inc.

Dr. Gardner earned her bachelor's degree in biology (magna cum laude) from Brandeis University, her M.D. from Albert Einstein College of Medicine and both an M.P.H. in health policy and a Ph.D. in health economics from the University of California at Berkeley. As a physician, she is board certified in General Preventive Medicine and Public Health and is a fellow of the American College of Preventive Medicine.

For more information, visit http://www.claraanalytics.com/ and follow CLARA Analytics on LinkedInFacebook and Twitter.

About CLARA Analytics
Laura B. Gardner, M.D., M.P.H., Ph.D., is an expert in analyzing U.S. health and workers' compensation data with a focus on predictive modeling, outcomes assessment, design of triage and provider evaluation software applications, program evaluation and health policy research. She is a successful entrepreneur with more than 20 years of experience in starting and building Axiomedics Research, Inc.

Dr. Gardner earned her bachelor's degree in biology (magna cum laude) from Brandeis University, her M.D. from Albert Einstein College of Medicine and both an M.P.H. in health policy and a Ph.D. in health economics from the University of California at Berkeley. As a physician, she is board certified in General Preventive Medicine and Public Health and is a fellow of the American College of Preventive Medicine.

Latest AJAXWorld RIA Stories
Coca-Cola’s Google powered digital signage system lays the groundwork for a more valuable connection between Coke and its customers. Digital signs pair software with high-resolution displays so that a message can be changed instantly based on what the operator wants to communicat...
In his session at 21st Cloud Expo, Raju Shreewastava, founder of Big Data Trunk, provided a fun and simple way to introduce Machine Leaning to anyone and everyone. He solved a machine learning problem and demonstrated an easy way to be able to do machine learning without even cod...
The question before companies today is not whether to become intelligent, it’s a question of how and how fast. The key is to adopt and deploy an intelligent application strategy while simultaneously preparing to scale that intelligence. In her session at 21st Cloud Expo, Sangeeta...
Bert Loomis was a visionary. This general session will highlight how Bert Loomis and people like him inspire us to build great things with small inventions. In their general session at 19th Cloud Expo, Harold Hannon, Architect at IBM Bluemix, and Michael O'Neill, Strategic Busin...
DX World EXPO, LLC, a Lighthouse Point, Florida-based startup trade show producer and the creator of "DXWorldEXPO® - Digital Transformation Conference & Expo" has announced its executive management team. The team is headed by Levent Selamoglu, who has been named CEO. "Now is the ...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021


SYS-CON Featured Whitepapers
ADS BY GOOGLE