Excel Dashboard and KPI from Pivot tables

This project received 24 bids from talented freelancers with an average bid price of $114 USD.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description

I am on the lookout for a freelancer to perform the following task in Excel: To design an elegant Dashboard and KPIs (key performance indicators) that will display Sales Revenue, Booking Lead Times, Occupancy Rates, etc from a hotel database. All these variables are already found in the database and no cleaning is required from the freelancer. By "elegant", I mean "simple and professional looking", no 3D charts or flashy colours around.

The Dashboard and KPIs should be dynamically updated when the pivot table is updated/refreshed. However, since the pivot table that will be generated will vary depending on the variables chosen by the end user, that change in variables should show up in the dashboards and KPIs. (I don't know if that is feasible.)

My vision of this is to have 3 tabs on an Excel worksheet (the raw data tab, the pivot table tab and the Dashboard/KPIs tab). If you can come up with a more practical layout, I am ready to consider it.

If this project is properly priced and the work is up to standard, more works of similar nature may be awarded to the freelancer in the near future. I need a freelancer who shows good professionalism and communication on this project.

Awaiting your bids! Feel free to contact me if you need any clarifications.

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online