After validating multiple visualization concepts. I restructured the data files so its easily readable and consistent, later used the javascript library D3.js to visualize the data. Allowing the department to keep adding new entries without changing their workflow and sync it immediately with the application so its easily visualized and shared.