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.