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.
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)
- 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
- 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
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 Daha Fazla
Bu iş için 45 freelancer ortalamada €1163 teklif veriyor
Dear, I m highly interested. I have a large experience in Excel/formula/macro Access and SQL. Best regards, Issam ********************************************************
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.
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.
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