MYPE inserted sample data in this example, not to disclose any confidential information.
Client : Orange IMT (Innovation Marketing et Technologies), Technocentre
Project duration : 1 an
Location : Orange Gardens, Châtillon
Project background : Création d'un outil Excel de suivi des données automatique, afin d'observer en un clic l'évolution des scores de performance (usage, satisfaction, qualité technique, agilité...) des applications mobiles du groupe Orange
Create an Overall Performance Management Solution of the Orange Applications Portfolio using advanced functions of Microsoft Excel. (Index + Match, VLookUp, SumIfS, AverageIfS, CountIfS).
This tool automates some reporting tasks such as counting the number of products which scores have increased/decreased over a custom period of time.
It also provides an overview with graphical elements in just a few seconds.
Client Benefits :
-delivery of an automated tool that is tailor-made for performance monitoring
-ease of use of the tool and possibility to make custom search (date period, products, score...)
-automatic generation of a chart related to the request made by the user