For those who’ve worked with inpatient claims data, how do you handle vendor data that doesn’t line up with what you know internally or just fails the gut check? I understand penetration and utilization gaps, but some numbers seem far off (for example, a very small hospital showing three times the volume of a much larger one). How do you approach adjusting or validating data when you see discrepancies like that?

like
Posting as :
works at
You are currently posting as works at

Probably source dependent. MEDPAR is 100% of discharges but commercial / MA data sets have sampling issues from the clearinghouse / you may have to use scalers.

like

U find a proof point

like

Love that you’re using FB for an actual work question 🤓

like

I think I would start looking at the top: Are we double counting claims? Do we have incorrect claim codes? Are the claim codes too broad? Is it a programming / sql counting error? Does this get replicated with another disease area as well?

like

All claims data goes through a clearinghouse and various vendors get different proportions of the claims in the claims universe.

If a subset of hospitals sends its claims through a clearinghouse that's better represented in your vendor's data, then you may not have an equal distribution. Look for patterns in your data to see if this is true. Indeed you may need different scales.

But, like others have mentioned, there may be other reasons. Do you really need claims, or are patients the right count? If claims, are you looking at the final one? Is there a reason the smaller hospital could actually be doing more of said procedure (they have more doctors in that department, it's their specialty area, they happen to have a high volume clinician)?

Claims data is as much art as it is science. Think of it as a puzzle to solve :)

like

^ only MCO claims, FFS claims do not but I agree with your statements on the clearinghouse challenges

Related Posts

After getting kicked out of McK late last year, this gives me schadenfreude 🤣

Post Photo
likefunny

Interesting. Let’s see if the uptick In cases continues to drive an uptick in hospitalizations and then in fatalities. Depends on how many of the cases are incidental or in very young people not prone to severe cases. But either way, look at the hospital capacity utilization figures! This is the untold story. Were we bending the curve to avoid unnecessary deaths due to overcrowded hospitals, or were we bending the curve to buy time for treatments and vaccine, or just to slow fatalities?

Post Photo
like

I don’t understand how people keep posting about the bench and being unassigned. I’m in advisory(not audit) and my entire LoS is trending 90%+ utilization

like

What other performance factors are considered for PDM besides utilization?

like

I wish admin utilized Tier 1 supports with teachers. Smiles, appreciations and acknowledging ones efforts would do a great deal to boost morale and climate. I just don’t understand what that is so hard to do.

like

Got offer from BCG for ECT. Read numerous comments about ECT being not attractive compared to Generalist track. Also heard challenges about billability/utilization. Any views/ guidance appreciated!
I am not super keen to become a partner (selling) and main reason to join will be working with different clients, smart talented people and a good brand. End goal (at the moment atleast) is to stay for few years and return to the industry. 15 YOE

like

Does anyone recall what senior consultant utilization targets are at Deloitte?

like

What is the target utilization for a Senior 2? Or number of chargeable hours goal? Is this ever hard to meet?

like

How do people increase their credit score? Mine’s only around 790/770 for transunion/equifax respectively and its been like that for a while now. I have 100% payment rate, only 3% credit utilization, and 0 hard inquiries for the past 6 months or so. So far I only have credit cards, no loans yet. Thanks in advanced!

likehelpful

How does it feel to earn less than US Consultants while also struggling for utilization

like

My utilization is 90% but all of my clients are small jobs. Does that look worse than someone who works on the larger, higher revenue generating jobs with all else equal (utilization/performance)?

like

What time frame is used to measure our utilization metric? I'm pretty sure it's not our fiscal year, but sometime around April '16 - March '17?

What are ways to deal with high latency mricroservice in a given region. Given that it's Cpu utilization is not exhausted.. So no vertical scaling ???

How does your firm measure utilization? I work for a small boutique that defines it as utilization = number of billable hours/2,080 and full bonus payout occurs at 80% plus.

like

What were some challenges y’all faced this week?

I’ll start. Trying to get non local resources utilized. National Leadership thinks this is the answer to our problems but local leadership is hesitant.

Here's a question I wish I never had to ask. Is it better to use the code for bereavement leave or just burn pto I'm going to lose anyway? Does it make a difference from a utilization standpoint?

like

Are FPX projects considered under utilization? I heard something about adjusted utilization... does that still exist?

like

In the last PDM town hall, they said they were going to lower utilization targets for those that work on projects with capped hours. For those people, have you seen your utilization target lowered? I haven’t seen shit change for me.

like

Thoughts on leaving PA primarily due to the metrics based culture (utilization, dtc, use of X digital tool, revenue, margin, etc). I find this aspect of PA stressful and exhausting but not sure if this is something you just get used to. Currently a manager and seems like the metrics just change over time / don’t get easier.

like

Wooohoo just landed a data project! Woohoo data! Data runs the world! Hello super high utilization! Hello cushy bonus! 🙌🏽

like

More Posts

Has anyone put solar panels on their house? What was the cost? Was your power bill completely removed? Was it worth it?

like

Hi guys, trying to put together a list of low pressure high paying jobs in the UK. If you know (or have heard or any) please let me know.

likefunny

What is the Apta test in hsbc ? How difficult it is?

How do I get bitcoins from coinbase to Bittrex with no to minimal fees. I just want to do some trades and bummed that coinbase is charging a hefty fee just to move my coins out?

like

Other than Airbnb, what is the best way to find month to month rental options?

like

Is an IPO in anyone’s FIRE strategy? Maybe this is specific to the Bay Area, but it doesn’t seem that unrealistic to negotiate enough equity to make $1.5 mill off an IPO. Or maybe I’m dreaming 😂

like

Hi Fishes, I recently joined Pwc AC and was informed to update my checkpoint portfolio where we update all our investments. If we have some investments and if we do not declare them, will it be a problem or can I update it as Nothing to report. Recently I joined here so I'm having some confusion regarding this.

like

Couples without kids, how do you justify buying a house and paying school taxes? Almost all of the good residential areas are with a high school tax. Just curious if childless couples can ever buy and live in nice areas or rent forever

likehelpful

What are some good professional goals to set in your first five years of practice? For context, commercial lit associate at boutique firm, so lots of opportunity for hands on experience. Just want some ideas of what I should be thinking about and aiming for. Thanks!

like

Any other GSAPpers using GSAP for the tech stipend and for other perks during school but not planning to come back? Pce Deloitte

likefunny

Incoming new joiner here- starting at Monitor Deloitte in a few weeks. Wondering if D/MD Australia give EOY bonuses or anything of the sort?

like

Could anyone share some insight on the Deloitte transformation and Ops case interview process? Is it both quantitive and qualitative?

Hello peeps,
I’m an SC and new to Deloitte Australia. I had few questions.
1. When/which month do we get increments/hikes in a year? Is it twice a year or just once?
2. What’s an average % increase in pay each year?
3. How many years does it usually take for a promotion from SC to M?

Hi, moving to Hyderabad first week of may, looking for someone to share a pg room in gachibowli (near mindspace rd), Hit me up.

like

I've received a feedback of being too honest, and too personable which could potentially damage my work reputation (haven't yet). It made me feel personally attacked. Is this a real thing?

like
like

Hi All, How many days do I need to wait to receive offer letter from @ Wells Fargo. I have submitted all required documents. How can I know the status?

like

Hi Fishes,

Please suggest :

Data Analytics - 5.4 YOE | 11 LPA CTC

Skills - Python, SQL, Power BI, Azure

Have one offer from EY GDS - Tax GCR - Data Analytics - Senior with 17 LPA fixed + min 10% variable VPB.

Need views on this offer/package & opportunity.

Suggest your views. @EY

like

Hello please can I find Victoria’s boot camp I keep hearing about this being great to study for shrm exam but I can’t find it anywhere thank you

like

Additional Posts in Life Sciences Consulting

Do others know of businesses who intend of disposing if GMP Manufacturing locations in the upcoming 24 months?

Anyone working in global pricing & market access (P&MA) consulting? New to the field and conscious which firms are top in their game

like

does anyone here work for Veeva Crossix?

like

Any 🐠 interested in joining a boutique pharma consulting firm based in Philly and Boston? We’re growing and need consultants!

likefunny

Implications of a PE firm selling and a company bringing on a new investment partner?

funnylike

Are there any life sciences firms that ACTUALLY have good WLB? And are hiring? Asking… for a “friend” 🥴

like

(1) What are your experiences with Regeneron? Burn and churn culture or reasonable people you would work with long term? (2) what BC/TC would you target for AD within global development?

like

ZS 🐠 - can you receive sponsorship for MBA prior to having tenure of 3 years? If not, what is the downside of applying after 1 or 2 years? I am coming in with 3+ YOE in consulting, so my application would be competitive for next fall (or ‘23)

like

Does anyone at ZS know when we will be finding out our bonuses?

likefunny

ZS (strategy insights & planning) or Putnam or CV?? Taking into consideration culture, long term earning potential and exit opps

like

ZS 🐠, how often are you at the office vs client site? I’m curious because I’ve heard they don’t travel much

like

I am a business development manager in a small biotech incubator. My end goal is to work in commercial, BD or operations within a big pharma/biotech company. What would be best for me:

1) stay in my company to quickly become BD Director and then exit (however my learning opportunities within my current company might be limited)
2) go do consulting for a few years
3) any other recommendations?

Thanks!

like

What is generally the salary range for a consultant role in the UK at Iqvia, CV and Putnam? Glassdoor gives some estimates but just want to double check with anyone that is part of these companies that might give a more accurate representation?

like

What are the best consulting companies to work for in life science consulting? Specifically for supply chain.

like

CRO companies as an exit? Yes or no?

like

Does anyone know specifically comp numbers at AbbVie for grade 20-21 in a commercial role? I'm having trouble understanding specifically what comp would be at the level they are considering me for. Really like the people / opportunities but I'm afraid the comp will be a big drop off from where I'm at now at the level they have me pegged at and would rather tell them now before proceeding

like

Anybody have a rough idea of the comp breakdown of a 1st year LEK Engagement Manager?

like

Which firms (if any) shut down for the holidays?

like

What cloud data platform should I learn to be successful in pharma consulting? AWS vs GCP vs Azure.

Has anyone interviewed with syneos commercial advisory?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal