Tactical Data Management

Siqi Wang, Worcester Polytechnic Institute

Abstract

The project focused on delivering a business intelligence system to BNP Paribas that would store data for easy access by the end users, while providing important auditing information for the business side. The solution integrated Microsoft Excel, Tableau, a Python module, and a standalone CSV module that could each communicate with a central database. By normalizing each data item, the data was independent of the originating program and could be successfully imported by any of the appropriate parts of the system. The intent is that this system will help to facilitate collaboration within the organization, reduce the time spent on data intensive tasks, and provide important records for compliance purposes.