PATIENTS EMERGENCY ROOM VISIT REPORT IN POWER BI

Report on patients’ emergency room visits. A total of 9,216 patients are accounted for, with a 50.04% administrative schedule and a 75.10% no rating. The average score is 5.47, the average waiting time is 35.26, and the average SAT score is 4.99.

The data is broken down into several categories including referral by department, patient gender by race, Sat score by age group, and patient race with corresponding SAT scores in different age groups.

The majority of referrals come from the emergency room (5.4K), followed by general practice (1.8K).

The gender-race pie chart shows White at 27.9%, Two or More Races at 16.89%, Asian at 11.5%, Declined to Identify at 11%, African American at 21%, and Native American/Alaska Native at about 5%.

The SAT score graph indicates that adults have the highest average score of about 5 while infants have the lowest around just above zero.

In terms of patient race and SAT scores across different age groups, African Americans have consistent scores in their late thirties across all ages while Asians peak in their early thirties but decline as they age.