Create a graphical dashboard in Excel

Hello,
I want to show graphical representations of the data in an Excel Dashboard along with grouped tabular display of the data.
Legal:
1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
2b) Any website server-side deliverables must be installed by the worker in ready-to-run condition in the employer's environment.
2c) Any website server-side deliverables must be provided with complete instructions and assistance so that the employer may install them in ready-to-run condition in the employer's environment.
2d) Any website server-side deliverables must be installed as described elsewhere by the employer.
2e) If there are any server-side deliverables (intended to only exist in one place in the employer's environment) then they must be installed by the worker in ready-to-run condition (unless specified elsewhere by the employer).
2f) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the employer).
3) All deliverables will be considered 'work made for hire' under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased.
3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's 'Worker Legal Agreement'.
Detailed Requirements:
Hello,
I have some data in a Database (sql). It is not complicated data, there are 2 main tables that use about 6 look up tables.
I want to show graphical representations of the data in an Excel Dashboard along with grouped tabular display of the data.
The graphics need to be interactive, ie there should be some dropdown or option boxes or check boxes that will filter the results and change the graphics.
Im open to suggestion as to how the dashboard should function ie we can use direct connection to SQL server or We can just paste all the data on one sheet of the Excel work book. If we paste the data onto a sheet, Im not sure how the data would be organised? - Would it be pivot tables? I need your suggestion on this.
The data is not complex at all , but I need the functionality of the excel dashboard to be very efficient and very well presented. There should be an option to format for printing too.
Im looking for somebody who has Data Analysis/ Business Intelligence experience in creating Dashboards in Excel. Also Excel VBA.

Apply for this Job