Maven Hospital Record Analysis

Balu Chelluri Avatar

Balu Chelluri

Power BI Dashboard

Additional project images

Balu Chelluri Avatar

Balu Chelluri

More projects by Balu

Velocity Edge Financial Analysis

0 Likes

0 Comments

Company Email Analysis [ Honorable Mention by Zoom Charts - Best Design]

3 Likes

0 Comments

CRM Pipeline Analysis [Zoom Charts - Winner]

2 Likes

0 Comments

Discussion and feedback(2 comments)

comment-1676-avatar

Emmanuel Agun

5 months ago

Hi Balu, nice Dashboard I have a question, how do you get the “Average Length of stay ” and the “Average patient visit” mostly the “Stay Duration” page I will be glad, if I get I a swift reply Thanks

comment-1684-avatar

Balu Chelluri

Project owner

5 months ago

Project owner

The Average length is calculated based on Encounter dim table. (We were provided start and encounter duration). For the Average patient visits I have summarized the encounters based on the yearly for each encounter type. (A patient can have multiple appointment for the same treatment). Used the summarised table to create the histogram for encounters. Hope this is useful.