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.
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!
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
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
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
I believe action speaks louder than words. So pls see sample works in PMB.
Hi, as a top-rated freelancer, excel vba expert, I am interested with your project. kindly let us discuss details. regards,
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
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
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
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.
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
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
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
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
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