Excel Dashboard (Excel Specialist Required)

This project has ended

The listing is below is no longer available. Feel free to search for other job listings.

Remote (anywhere)
Freelance / Casual

Please read very carefully

I require a complex excel dashboard developed.

High level requirements are

  1. Require a weekly, Rolling 4 weeks, quarterly, 6 months and YTD view of around 12 metrics

  2. The dashboard itself is to be traffic lighted based on KPI's but only for the weekly view.

  3. If you google " Excel Traffic light dashboards" and click on images this will give you an idea of what i'm looking for.

  4. I will require a separate tab for historical analytics with graphs and or trend lines

  5. On the weekly view i'm looking for a exception report that can then show me any KPI's with orange or Red results.

  6. on the Rolling 4 weeks, quarterly, 6 months and YTD views i will require trend lines

  7. 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.

  8. The data sets are made up of 4 locations that do the same activities.

  9. I have uploaded a sample of what the dashboard could look like.

The successful applicant will further get detail on the project. Please no time wasters as i require the final submission next week.

File attachments
Requested by
Joined Feb 2017
Submitted 6 Feb 2017 at 08:47
Expired 2 years ago
Bidding guide $250 - $750
Average bid $898.75

Nick Jones

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.

Deliver in 5 days
Hamilton Idealogy

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

Deliver in 5 days
[Deleted user]

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,

Deliver in 7 days
CPA Accountant

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.

Deliver in 7 days
[Deleted user]

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.

Deliver in 14 days
Calcul8ors Pty Ltd

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/

Deliver in 5 days

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.

Estimated 10 hours
Sergey M.

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

  1. Load data and create relevant data model.
  2. Clean it up
  3. Load predefined variables for weekly, Rolling 4 weeks, quarterly, 6 months and YTD
  4. Create user interface according to DAR (Dashboard Analysis Reporting) concept.
  5. Present to you and get feedback.
  6. Implement feedback

Regards, Sergey

Estimated 40 hours
Damien Brennan

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