Altair Monarch Exercise 24 - FCR250 Failed Claim Requirements Analysis

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited October 18 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.