The “Division des Postes” of P&TLuxembourg is the leading operator of postal services in Luxembourg. Its network of 104 post offices across the country processes an average of 600.000 mails per day. The “Support Department” is in charge of maintaining the postal counter system and supporting the users.

In 2007, the “Division des Postes” aimed to implement an Operational Datastore in order to facilitate the analysis of information about the activity of postal counters and ATMs (visits, operations, volumes…). The data source is provided daily by the postal counter system (WebRiposte) in a proprietary XML format.

In collaboration with the “Support Department”, Agile Partner designed and implemented, in less than 6 months, an end-to-end business intelligence solution built with Microsoft SQL Server 2005:

• Design and implementation of the technical architecture,
• Data analysis, Datastore modelling, and ETL development,
• Reporting needs analysis, and reports development,
• Design and implementation of multidimensional model (OLAP cube),
• Database optimization and data archiving,
• Documentation and knowledge transfer.

This architecture enables to analyze 16 million visits and 60 million operations with a good performance level.
The “Division des Postes” now benefits from a robust and evolutionary solution to meet its needs for analysis and management of its sales activity.