En cours

Set up two automatic customer scorecards in XLS or with database

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

Compétences : Saisie de Données, Traitement de Données, Excel, Microsoft Access, Visual Basic

en voir plus : excel dashboard youtube, google sheets dashboards, excel dashboard tutorial pdf, connect excel to odbc data source, why does excel import data so easily from other external sources?, best excel dashboards, how to create a dashboard in excel from scratch, excel dashboard template, sql, excel, microsoft access, analytics, visual basic for apps, microsoft excel

Concernant l'employeur :
( 5 commentaires ) Berlin, Germany

Nº du projet : #18947281

Décerné à:

Neno585

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% EUR en 10 jours
(23 Commentaires)
7.3

45 freelance font une offre moyenne de €1163 pour ce travail

schoudhary1553

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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 20 jours
(333 Commentaires)
7.9
bouslimi1979

Dear, I m highly interested. I have a large experience in Excel/formula/macro Access and SQL. Best regards, Issam ********************************************************

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 15 jours
(286 Commentaires)
7.6
dgled

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, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 20 jours
(76 Commentaires)
7.0
zekovicm

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(120 Commentaires)
7.2
paris2785

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(233 Commentaires)
7.3
branislavm

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 20 jours
(228 Commentaires)
7.4
P0L

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 20 jours
(289 Commentaires)
7.2
fabest

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(90 Commentaires)
7.3
shoguna2m

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 20 jours
(96 Commentaires)
6.7
elqueabandona

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 rega Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 12 jours
(225 Commentaires)
6.9
shikhamehta

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, ge Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 30 jours
(153 Commentaires)
6.6
periyannas

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(97 Commentaires)
6.2
sonarkaushik

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 9 jours
(104 Commentaires)
6.2
antoinepal

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. Than Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(29 Commentaires)
6.0
aimefx

Hi, I am an expert in Excel, Access VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Tim Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(64 Commentaires)
5.8
AwaisChaudhry

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 20 jours
(5 Commentaires)
5.6
zu02

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 wit Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 20 jours
(52 Commentaires)
6.1
KavTan

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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(49 Commentaires)
5.6
hardikshah83

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 g Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 20 jours
(32 Commentaires)
5.6
vaidyag

Hi I have extensive experience in Analytics and Visualization. I have worked in analytics for the past 3 years . I was in Infosys for more than 16+ years and as part of this i was managing anaytics projects for m Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 20 jours
(15 Commentaires)
5.3