Find Jobs
Hire Freelancers

Excel Dashboard and KPI from Pivot tables

$30-250 USD

Closed
Posted almost 11 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 4388418

About the project

21 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $105 USD for this job
User Avatar
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
4.9 (328 reviews)
8.0
8.0
User Avatar
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 bugs and minor changes are included in the bid without any additional fees. When considering the delivery time in my bid please take into account that job specification is not yet completed, and the design phase of a project comes out at a very significant percentage of the total completion time! Regards!
$200 USD in 10 days
4.9 (64 reviews)
5.7
5.7
User Avatar
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% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. Please see my private message(PM) for more details and my profile (with feedbacks received from previous employers ) , for reference. Regards Fibin
$82 USD in 2 days
4.9 (50 reviews)
5.4
5.4
User Avatar
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 dynamic changes when onmouse move event occurs.. Feel free to ask me for examples. Best regards. Pierre
$154 USD in 3 days
4.9 (30 reviews)
5.4
5.4
User Avatar
I believe action speaks louder than words. So pls see sample works in PMB.
$150 USD in 7 days
4.9 (24 reviews)
5.5
5.5
User Avatar
I am interested, please let me know more of it.
$50 USD in 3 days
4.9 (62 reviews)
5.2
5.2
User Avatar
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 ============================== Tablassus Software "Simple Solutions for Complex Problems"
$55 USD in 1 day
5.0 (14 reviews)
4.8
4.8
User Avatar
Zi, I am sending you a sample dashboard showing interactive "speedo" dials and "four quadrant" graph, and KPI data grid. This will allow you to decide for yourself whether I will provide what you want. Can start work as soon as you pay the retainer into the site and send me your database. More information on Private Message Board Bob Allen-Turl
$140 USD in 3 days
4.6 (11 reviews)
4.5
4.5
User Avatar
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
4.9 (4 reviews)
3.5
3.5
User Avatar
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 table, I would rather recommend creating dynamic data table. It is much more elegant solution.
$140 USD in 7 days
5.0 (3 reviews)
2.3
2.3
User Avatar
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 file. Thanks, Exopad
$99 USD in 3 days
5.0 (2 reviews)
1.6
1.6
User Avatar
I am expert at handling data with pivot tables.
$110 USD in 3 days
4.6 (1 review)
0.6
0.6
User Avatar
Hi..I am well versed with this kind of job..let me know if we can start.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have done data consolidation, analysis, extraction, charting, etc over 2 years in my experience from previous employment. the job included creating database using Ms Excel uploading to or extracting from Relational Database Management Software or Database Server for short with applying some concept in database management essentially to done job immediately and manageable. Data Management in MS Excel is my best and I am confident that I can done this job as early in deadline
$50 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please check your PM
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 the Philippines as Operations Finance Manager; my tasks include Budget and Controls, Financial forecasting, Costing, and Capital Investment review. I am not currently employed, after receiving a separation package last May2011 due to company restructuring. I am immediately available.
$45 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 operations. I'm pretty sure that I can help you on this project. I just hope you can give me a chance to work on this project. You can check out my odesk profile if you want.. Cheers, Veronica B.
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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, Quality System, Improvement Projects, Operations, Process Enhancement, and Man Management. I am well versed KPI & Balance Score card and have implemented my last organization.
$50 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 retail store for their key marketing metrics. Also prepared a dashboard that measures their campaign performance. It would be great to work with you so that I could showcase my data visualization capacity at my best. Thanking you in anticipation, Warm regards, Aanshi
$165 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MAURITIUS
Mauritius
0.0
0
Member since Apr 1, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.