Excel Dashboard and KPI from Pivot tables
- Status Closed
- Budget N/A
- Total Bids 24
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.Get free quotes for a project like this
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online