Do a dashboard for attendance system

Do an analytics dashboard that read data from database tables and present it as bar chart on dashboard based on some columns for example
A grapgh that show the departments of corporation and the percentages of absent on each one