Dashboard Financial

I need to create a dashboard that pulls in data from various XL sheets in order to provide a visualisation of metrics such as actual versus forecast versus budget other KPI such as employee headcount project schedule start and completion dates and other visualisation’s and tables. I will need one file that links and consolidates the data from the various files