Australia's Freelance Marketplace
Please read very carefully
I require a complex excel dashboard developed.
High level requirements are
Require a weekly, Rolling 4 weeks, quarterly, 6 months and YTD view of around 12 metrics
The dashboard itself is to be traffic lighted based on KPI's but only for the weekly view.
If you google " Excel Traffic light dashboards" and click on images this will give you an idea of what i'm looking for.
I will require a separate tab for historical analytics with graphs and or trend lines
On the weekly view i'm looking for a exception report that can then show me any KPI's with orange or Red results.
on the Rolling 4 weeks, quarterly, 6 months and YTD views i will require trend lines
Based on historical data example 6 months i then want to take the averages so i can set a benchmark or target for the next 6 months.
The data sets are made up of 4 locations that do the same activities.
The successful applicant will further get detail on the project. Please no time wasters as i require the final submission next week.
| Submitted | 6 Feb 2017 at 08:47 |
| Expired | 7 years ago |
| Bidding guide | $250 - $750 |
| Average bid | $898.75 |
I have completed this type of request on a daily basis for various call centres for over 16 years would enjoy the chance to assist you please consider
I work at American Express in Sydney and my main job is create and maintain dashboard for business by visualisation, I have 17 years experience and know that how to build up effective and efficient dashboards,
I have built something similar to this for use by our 40+ Project Managers around Australia to review their project mix revenues for the past 12 months. I am a CPA accountant working in the Finance area of a large multinational company so I understand the need of actual business users without finance background.
I have built similar web-based reports for previous clients, and will be able to produce this in Excel to achieve the desired outcome. Please feel free to call me and discuss further on 0430131001.
Hi, I'm an Excel (VBA) developer with qualifications and many years experience in Supply Chain, specialising in the creation of customised solutions and performance analysis and reporting for business.
I have just completed a major project for a large national Australian retail chain that combines multiple MS Excel front end interfaces connected to an MS Access backend, for use by a team of 20+ Merchandise Planners and Category Managers.
Details of other projects competed, and a capability statement specifying past projects, clients and professional indemnity insurance are available upon request.
Please view a sample report using traffic lights at: http://www.calcul8ors.com.au/media/docs.php
Further details are also available at: http://www.calcul8ors.com.au/
I am a freelance Excel developer with a lot of experience in this type of work. More details at www.geekette.com.au. It is difficult to estimate the time it will take me without more information but I have availability in the next week to make it happen.
Hi, I'm a professional Qlik consultant with 9 years of experience and the big part of my job is to convert Excel reports into interactive Qlik applications with drill down, filtering in any object and getting your answers on the fly. Depending on where is your data stored, the application can be updated automatically without any manual work.
That's why what is the point to build Excel report, if you can get more from the start. Please take a look at the product Qlik.com I can build in either Qlik Sense or QlikView, depending on your needs.
Looking at your requirements I can estimate from 1,5 to 5 days of work.
The plan is
Regards, Sergey
Hi there,
This is a really interesting project. I have previously completed a similar dashboard for an Australian wholesaler that compared actual sales $ to budget sales $ - I assume your dashboard will be for a similar use. One question is how is the data the dashboard reports on entered and will this data be kept in the same Excel document.
Thanks Damien
OzLance © 2006-2024 • Site powered by OctoberCMS
I have completed similar dashboards representing various KPI's for large mining companies where the focus has been on clarity and ease of use for the end user.