Data preparation carried out for dashboard application