Find Jobs
Hire Freelancers

Set up two automatic customer scorecards in XLS or with database

€750-1500 EUR

已完成
已发布大约 5 年前

€750-1500 EUR

货到付款
Goal Set up two customer scorecards. Results need to be shown in Dashboards, best case in xls. Xls needs to be set up in the way we can add data by our own when the database is finished. Input is delivered by xls; sell out figures by product by month (in units) for appr. 100 + 50 products delivered by a) 6 partners for the first scorecard + b) ~30 partners for the second scorecard. Requires technical requirements : xls incl. pivot knowledge / Database knowledge business requirements : input data and expected results can be further explained via live WebEx data NDA needed in advance Description: First Scorecard for 6 top partners Result needs to be displayed in one dynamic Dashboard. - needs to show performance (=sell out development) by brands in total (across all 6 partners) and by partner individually (what is the development in total, by brand, by partner and by partner+brand) - and needs to show the development of the most important top products (approx. 15-20) Details development: - needs to show (time measure): month to month same year, current month vs. selective month last year, past 3 month, past 6 month, YTD vs. Prior YTD, MAT vs. Prior MAT + calendar year - needs to include share % of brand at total (and at partner level) - needs to include share % of most important product at total (and by each partner) - needs to include trendline on development for each partner and each brand Basics - consolidate product list into 4 - 6 brands - break down of "virtual product combinations" into corresponding product lines, if information is available how the "virtual product combination" is set up - monthly reporting: needs to allow to add monthly data into the created "Scorecard" by our own - input will be delivered in xls files. 6 partners, historic data inlude 2017 and 2018 on month level plus Jan 19 + Feb 18 data Description: Second Scorecard for ~30 partners Same as above but for ~30 partners Your time is needed for: - briefing live: (2 hours) - data cleansing and sorting the data - preparation of analytics - designing + layout of Dashboard - refinement after feedback Fluent english or german language is needed
项目 ID: 18947281

关于此项目

45提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hello, as a database developer very experienced in both Access/Excel I can build your required dashboards. I have read the description to get a glance of what you need. I see it is data processing tasks and performing statistical operations but I will be happy to hear more about required input and output. I am very fluent in English but I can also speak German, recruiter informed me that you are interested in that. In any case, feel free to contact me if you would like to share info about your required scoreboard and inputs/outputs and would like me to work on your project. Thank you for the consideration and Best Regards, Neno
€1,176 EUR 在10天之内
5.0 (25条评论)
7.4
7.4
45威客以平均价€1,163 EUR来参与此工作竞价
用户头像
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€1,500 EUR 在20天之内
4.9 (444条评论)
8.3
8.3
用户头像
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have two scorecards in Excel. I plan to use a combination of formulas, VBA code, and Pivot Tables to accomplish this. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 280 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you 1,100€ and can deliver within a week more or less (two milestones to release once you're satisfied with the draft and final version respectively). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
€1,100 EUR 在7天之内
4.9 (374条评论)
8.0
8.0
用户头像
Dear, I m highly interested. I have a large experience in Excel/formula/macro Access and SQL. Best regards, Issam ********************************************************
€1,250 EUR 在15天之内
4.9 (322条评论)
7.8
7.8
用户头像
Hello! I am Branislav, fluent in English but only good with German (not fluent, but I understand quite a lot - I was learning it for 9 years in school, and that was a long time ago - 26 years ago). Regarding the project, I see there are lots of things to do. How I see it and what can I deliver is an MS Access database (after all, this looks like a database by the data description) which will have several functions, including importing the data from Excel file, with the Dashboard that can display different charts. For charting system, I will use Excel (running behind, to create a chart) and not Access charting system because Excel has a more advanced charting system. However, all the charts will be displayed on the Dashboard in Access. It will be good if you can create a sample of the chart in the desired layout, colors, font, etc. and I will reproduce them. Regarding the deadline, the recruiter told me it will be 5-7 days and no more than 10 and for now, I must say that is a tight schedule but I think it is doable with hard work. On my profile, there are screen-shots of something not as close to this, but there you can see a dashboard with 9 charts. Of course, we will need to add probably the combo boxes to narrow the selection and selection of what charts you will need to see. What will be this: "data cleansing and sorting the data"? Not all data are in the same datasheet layout? Regards, Branislav Mihaljev
€1,323 EUR 在20天之内
5.0 (295条评论)
7.8
7.8
用户头像
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
€1,250 EUR 在20天之内
4.9 (473条评论)
7.9
7.9
用户头像
Good day, my name is Andrés and I'm the data analyst and Excel expert of our team. I've gone through the requirements listed here in the project and I can help you create these scoreboards in an automatic way so it can be refreshed with new inputs of data. I'm eager to take the challenge and would like to discuss the details with you via chat or call to have all clear and go through each point. Looking forward to talking with you very soon and work together. Thanks for considering me
€1,000 EUR 在20天之内
4.9 (166条评论)
7.6
7.6
用户头像
Hi there,I am Excel and Database development expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
€1,176 EUR 在10天之内
4.9 (174条评论)
7.7
7.7
用户头像
I am a financial experts and gurus in Excel/VBA/Macro with extensive knowledge and expertise in financial modelling,advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports & charts, accounting, consolidating, forecasting, budgeting, cost acquisition,  financial reports,   With these skills, I develop modules which incorporate complex components of business in a simplified and logical manner. I did similar successful projects, and our cooperation will lead to perfect results.
€1,200 EUR 在20天之内
4.9 (94条评论)
7.2
7.2
用户头像
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards
€1,175 EUR 在12天之内
4.9 (305条评论)
7.3
7.3
用户头像
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
€833 EUR 在10天之内
4.7 (92条评论)
7.4
7.4
用户头像
Hello, I can build you beautiful scorecards and dashboards in Excel or Power BI as i have advanced skills in these reporting platforms and over 8 years in the field. Please check my portfolio to see my work. Thanks!
€1,070 EUR 在10天之内
4.9 (64条评论)
6.9
6.9
用户头像
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
€1,323 EUR 在7天之内
5.0 (153条评论)
6.8
6.8
用户头像
Hello there, I am an expert in Excel and have designed and developed more than 500 projects in Excel, many of them Dashboards like the one you have described in the requirements brief. I am happy to sign the NDA, get on a webEx to understand the input data, desired output metrics and any calculations that I may need to know. Based on that, I would be able to design a very nice intuitive and professional scorecard for your purpose. I would also be able to set it up in such a way that it allows easy import of data and show results dynamically. Infact, if you send message over the freelancer chat, I would be able to share some screenshots from the dashboards I have created (you may see some in my profile as well) and if we have a webEx, I would be able to show you some of those in action as well. Do let me know if you would like to discuss this project with me and detail and if you need any more information. I look forward to hear from you. Best Regards, Rishi
€1,764 EUR 在30天之内
4.9 (156条评论)
6.7
6.7
用户头像
Hi there, I have read your project brief and understand that you require to develop TWO dashboards each for your 6 partners group and 30 partners group. I am a Management Graduate having advance skills in MS Excel. I have also developed several of dashboards for various clients and you can see sample of some of them on my portfolio page. I would require a soft copy of various products, performance over a period of time, and details of the partners to create a Business Dashboard to showcase the performance. It is imperative that we discuss further details over a freelancer chat to better grasp the requirements and deliverable. Thank you very much for the opportunity.
€1,000 EUR 在10天之内
4.9 (60条评论)
6.3
6.3
用户头像
Hi there, I have checked the details I have great experience with Data Entry, Data Processing, Excel, Microsoft Access, Visual Basic. Please start the chat so we can discuss this job more in detail. Thanks
€1,250 EUR 在20天之内
5.0 (5条评论)
6.0
6.0
用户头像
Programmer with more than 10 years of development experience here. I can create these dashboards with excel functions and VBA programming. We will import the performance data of all vendors using the excel itself and graphs will be generated on run-time from VBA task. Excellent user interface guaranteed. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone / webex 4. Daily / Weekly status reporting Some reference projects: a) Responsive website on .NET - https://www.freelancer.com/projects/C-Sharp-Programming-ASP-NET/ASP-Net-Responsive-Web-Application/ --> Review -> “Thanks Hardik! Great work.” b) VB 2013 Desktop Application with AWS integration -https://www.freelancer.com/projects/Amazon-Web-Services-Windows/Visual-Basic-Express-Desktop-Application/ --> Review--> "Great Job! Would hire again!" c) Data pull application from Facebook using VB.NET -https://www.freelancer.com/projects/PHP-Social-Networking/Timeline-Posts-Extraction-with-Likes/ --> Feedback by Client --> "I was extremely satisfied by hardikshah83's work. Excellent communication skills. Very professional. I asked for a couple of changes in the course of the project and he delivered them gracefully." Let's discuss and make this project a success.
€800 EUR 在20天之内
4.9 (39条评论)
5.9
5.9
用户头像
Hi, I can build the excel dashboard that you described in your project post. You can find in my portfolio a sample of a dynamic dashboard that I made in excel. Best regards, Florin Enache
€1,200 EUR 在7天之内
5.0 (23条评论)
5.7
5.7
用户头像
Hello I hope all's well with you. I would like you to consider me as a programmer for your project. I can code all based on your instructions - professionally and on time. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses- please see my portfolio here. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab Esartia
€1,500 EUR 在20天之内
4.7 (66条评论)
6.2
6.2
用户头像
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
€1,250 EUR 在9天之内
4.6 (105条评论)
6.2
6.2
用户头像
Hi there, Sir i read your initial requirements and i have some question regarding to your customer scorecard project. please send me message so that we could discuss it further.
€794 EUR 在5天之内
4.9 (19条评论)
5.5
5.5

关于客户

GERMANY的国旗
Berlin, Germany
5.0
7
付款方式已验证
会员自1月 28, 2018起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。