Fermé

Create a dashboard using Excel

I want to show a dashboard of items that are created by one area in a factory and then handed onto another area. My data set measures the target date for handoff and the Dashboard will be required to show the following metrics: 1. how many items have disputed ownership

2. how many items have a RAG rating of ‘red’

3. how many items are late being sent from the first department

4. how many items are late to be completed By the second department

5. how many items have been rejected by the second department owing to quality received

6. How many items are less than 25% complete, 25-50% complete, 50-75% complete, More than 75% complete

Bar charts are fine to show the above

I will need some pivot tables to show lists of the above

Compétences : Excel, Traitement de Données, Saisie de Données

En voir plus : create documents using excel, script create account using excel, visual basic using excel create forms, using vbs create users domain excel, create client database using excel, create active directory accounts using excel, create roster using vba excel, create xml file using excel macro, create clock using excel macro, create pdf using excel macro, dynamic dashboard using excel front end, kpi dashboard using excel, report generation dashboard using excel, project portfolio dashboard using excel, mplementing fisher LDA method using MATLAB. - Write functions that take a data set and compute the optimal projection v, using excel and vba to get api data, how to create a dashboard using pivot tables and charts in excel (part 1), using excel and word to structure qualitative data, create folders using excel data, how to create a dashboard using pivot tables and charts in excel (part 2)

Concernant l'employeur :
( 0 commentaires ) Stanmore, United Kingdom

Nº du projet : #30090772

51 freelances font une offre moyenne de 413 £ pour ce travail

P0L

(479 Commentaires)
8.0
(334 Commentaires)
8.2
(420 Commentaires)
8.3
asin1987

Dear Employer, I will create one graphical and one Pivot analysis for each of the points mentioned. They will be professional with all the major analysis shown. Please share your data. I am an expert with over a deca Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(248 Commentaires)
8.1
(339 Commentaires)
8.0
(178 Commentaires)
7.8
(312 Commentaires)
7.1
(306 Commentaires)
7.3
(460 Commentaires)
7.3
(242 Commentaires)
6.8
(65 Commentaires)
6.9
(121 Commentaires)
6.9
(201 Commentaires)
6.9
(279 Commentaires)
6.4
(134 Commentaires)
6.6
(19 Commentaires)
6.3
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT expe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(70 Commentaires)
6.1
(34 Commentaires)
5.5
(81 Commentaires)
5.7
(76 Commentaires)
5.4