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.

• This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.

Creator

• Wang, Siqi

Contributori

• Leaves, Terry

Publisher

• Worcester Polytechnic Institute

Identifier

• E-project-031412-142437

Advisor

• Gerstenfeld, Arthur
• Abraham, Jon P.

Year

• 2012

Center

• Wall Street-FinTech Project Center (Boston or New York) - MQP

Sponsor

• BNP Paribas

Date created

• 2012-03-14

luogo

• New York

Resource type

• Major Qualifying Project

Rights statement

• In Copyright