I need an excel guru to develop a dashboard interface for some background data to make the presentation of the information more interactive and user friendly.
The end result being a report that will need to have the background data updated by myself quarterly. We currently use a cloud based platform that has the capability to generate raw data excel spreadsheets with all the required information - I wish to be able to generate this data report and copy and paste the data into the developed excel spreadsheet where to front page dashboard will update automatically (or to something of that effect).
The data that will need to be represented is manufacturing data - criteria being manufacturing production weights, versus how much energy is used to produce this product, how much water is required, and how much waste and greenhouse gases are generated due to our operations. I have a sketch of what I wish the dashboard to include but there will need to be a number of background calculations applied to the raw data to enable to functionality of the graphs on the dashboard.
There will also need to be year on year graph comparisons as to how the site is tracking each consecutive year (using historical data).