Monthly and Yearly Dashboard

The objective of this project is to provide a visual performance analysis for Company ABC of 2021.

In this project, I collected information using SQL queries, and I developed two dashboards that allow managers to see the information in a better way.

The report includes the following information:

Totals Per Year

• Number of new patients
• Number of existing patients
• Number of Net paid claims
• Amount Paid
• Amount Submitted

Monthly distribution of:

• Number of net paid claims
• Number of unique patients
• Total paid
• Average paid per patient

Yearly Demographics

• Number of unique patients per Gender
• Number of unique patients per Age Band (Under 20, 20-29, 30-39, 40-49, 50-59, 60-69, 70+)
• Total paid per Gender
• Total paid per Age Band (Under 20, 20-29, 30-39, 40-49, 50-59, 60-69, 70+)

Interactive Filter(Slicers)

• By Province of claim
• By Claim Type