Altair Monarch Exercise 24 - FCR250 Failed Claim Requirements Analysis

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited October 2024 in Altair RapidMiner

Exercise Info

  • Application (Classic vs Data Prep Studio): Data Prep Studio
  • Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
  • Skills/Features Tested: Detail & Append Templates, Join (Inner Join), Analyze
  • Systems of Record: Allscripts McKesson HBOC STAR Patient Accounting
  • Estimated Time to Solve: 15 mins
  • Exercise files required are attached in the Zip File Below;
    • FCR250 - Failed Claim Requirements.txt
    • Physician Data.xlsx

Exercise Overview

You are a Revenue Cycle Analyst at a Healthcare System and your Manager has asked you to perform some research on Failed Claims. Specifically to answer the following questions:

  1. What is the Total of 'Account Balance' in the FCR250 Failed Claim Requirements text file?
  2. How many unique Attending Physicians (Attend Phys) were associated with a failed claim?
  3. Which Attending Physician had the most number (count) of Failed Claims?
    1. What is their first & last name?
    2. What department do the work in?

Exercise Answer

Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.

 


Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.