Excel-lence

+216 99941193
+216 98171490
Centre El Khalil , Bureau 141, 2010 Manouba
b.belloumi@excel-lence.com

Development of a statistics statistics automation tool

Context

*The end client is a multinational banking corporation with subsidiaries in 71 countries, approximately two hundred thousand employees, and a vast amount of data to process.
*Communication between the various subsidiaries is facilitated through video conferencing technology.
*The central management desires to obtain statistics regarding the utilization of this technology across different subsidiaries and for each employee.
*The starting point consists of raw data contained within Call Details Record extractions in the form of .txt files.

Constraints:

* Before these raw data can be used, they need to be enriched based on matching rules.
* The number of lines to process is enormous, so the solution needs to be optimized to mitigate the risk of crashes.
Sviluppo di Excel VBA e elaborazione dati

Our solution :

An Excel development that provides the following features:
* Check the source file and eliminate non-significant records (Filter).
* Enhance raw data by implementing optimized matching algorithms.
* Process the data and generate various custom statistics and dashboards.