MYPE inserted sample data in this example, not to disclose any confidential information.
Client : Orange IMT (Innovation Marketing et Technologies), Technocentre
Project duration : 2 months
Location : Orange Gardens, Châtillon
Project background : Creation of a Reporting solution using Excel in order to see in one click the statistical evolution for Orange applications ,with custom date periods.
MYPE built a tool that compares a range of products over a specific period. The user selects "start period" and "end period", and the system automatically shows the percentage of evolution between the periods for a given KPI (here, it is "Sales" by units, but it could be anything else).
This tool is particularly valued by sales and finance departments because in one single overview they can see the performance evolution of a large bundle of data.
Client Benefits :
-delivery of an automated Excel tool allowing the performance comparison for a portfolio of products
-possibility to draw performance comparisons over a custom period (custom start date and custom end date)
-automatic generation of a chart related to the request made by the user