Excel Dashboard and KPI from Pivot tables

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: Data Mining, Excel

See more: hotel dashboard excel, hotel kpi dashboard, excel pivot table kpi, dashboard kpi excel, excel dashboard hotel, kpi pivot, excel kpi pivot table, kpi excel dashboard free, kpi pivot table, dashboards pivot tables, pivot charts dashboards, kpi dashboard pivot tables, dashboard excel pivot table, pivot table dashboards, excel kpi pivot, kpi dashboard hotel, kpis pivot table, pivot table dashboard, kpi tab bids, project kpi dashboard excel, hotel kpi excel, kpi tab tab excel, pivot table kpi dashboard, excel occupancy dashboard, kpi pivot tables

About the Employer:
( 0 reviews ) Mauritius

Project ID: #4388418

22 freelancers are bidding on average $109 for this job


Hello, Excel VBA expert here. You know what you need and you have described it well. Let's go with the 3 Sheet Workbook; I've completed similar projects. Please check PM for details. Thanks!

$192 USD in 5 days
(57 Reviews)

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b More

$200 USD in 10 days
(39 Reviews)

Hi, I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% More

$82 USD in 2 days
(38 Reviews)

Dear Zicitron, I already built hundreds of dashboards. The method you describe is the good one. 3 sheets. 1 for the data, an other for the pivot and a third for the dashboard. I can do somthing really amazing... with More

$154 USD in 3 days
(24 Reviews)

I believe action speaks louder than words. So pls see sample works in PMB.

$150 USD in 7 days
(15 Reviews)

I am interested, please let me know more of it.

$50 USD in 3 days
(23 Reviews)

Hi, as a top-rated freelancer, excel vba expert, I am interested with your project. kindly let us discuss details. regards,

$70 USD in 7 days
(17 Reviews)

More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Best regards Filipe Francisco , VB Expert =============== More

$55 USD in 1 day
(9 Reviews)

Dear Employer, I am experienced Financial Analyst (in my day to day job). Such tasks are in my daily practise. Please check my feedback and completion rate. About this task: instead of creating primitive pivot ta More

$140 USD in 7 days
(3 Reviews)

Raedy to [url removed, login to view]

$100 USD in 3 days
(2 Reviews)

I did several similar projects before and am ready to start on this project today. Instead of using pivot tables you could consider using dynamic code in VBA to get the same result, without ending up with a huge Excel More

$99 USD in 3 days
(2 Reviews)

Hi I have more than nine years experience Database Administration and I am also expert in developing data warehouse for business intelligence report. Please see PM. Thanks.

$110 USD in 3 days
(0 Reviews)

Hi..I am well versed with this kind of job..let me know if we can start.

$50 USD in 1 day
(0 Reviews)

Please check your PM

$100 USD in 3 days
(0 Reviews)

I have extensive experience (16years) as a Finance Manager in various multinational semiconductor companies here in the Philippines. My last employment was with International Rectifier representative office here in th More

$45 USD in 1 day
(0 Reviews)

Hi, I'm proficient in MS Excel work and I've been a Reports Analyst for a year in one of the known BPO company here in Philippines as a part of daily task before was creating templates that can be used in the operation More

$35 USD in 2 days
(0 Reviews)

Hi, I am Mechanical Engineer with Executive MBA from IIM Calcutta & Six Sigma Black Belt Certification with over 12 years of comprehensive experience gained in the field of Operations, Inventory Management, Production, More

$50 USD in 7 days
(0 Reviews)

I'm new to freelancer and do not have any ongoing projects, which means I'll be able to dedicate my time exclusively to you. My bid reflects this and I will be able to deliver your new Dashboard and KPIs after 1 workin More

$250 USD in 1 day
(0 Reviews)

I am expert at handling data with pivot tables.

$110 USD in 3 days
(0 Reviews)

I have developed many complex and interactive dashboards that represents client's data in summarized manner, hence helped them take marketing initiatives. Prepared an interactive dashboard for Japan's top rated online More

$165 USD in 2 days
(0 Reviews)