URGENT Excel 2007 Dashboard Required (Deadline 01 OCT 2013)
Have an urgent requirement to build and Excel 2007 Dashboard. (Deadline 01 OCT 2013).
Data Layer: Data Source originates on SQL server however the raw data will be pulled into a number of worksheets via ODBC refresh. (The data will already be aggregated).
Analysis layer: Needs someone to produce the 'staging tables' on a hidden worksheet that gets to data into shape for the charts on the Dashboard.
Presentation Layer: Need someone to produce the Dashboard as per supplied Compont layout. End users will need to filter the information via a combo boxes and the Charts update accordingly.