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.

Beceriler: Veri Madenciliği, Excel

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Mauritius

Proje NO: #4388418

Bu iş için 22 freelancer ortalamada $109 teklif veriyor


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!

in %bids___i_period_sub_35% gün içinde192%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(57 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(39 Değerlendirme)

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% Daha Fazla

in %bids___i_period_sub_35% gün içinde82%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(38 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(24 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde70%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)

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 =============== Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(9 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Raedy to [login to view URL]

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde99%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde110%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

Please check your PM

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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, Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

I am expert at handling data with pivot tables.

in %bids___i_period_sub_35% gün içinde110%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde165%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)