Investigation App

The system, written in Python using the Plotly/Dash framework, provides a clean interface that automates many complex data extractions and analysis. Elaborate SQL queries with hundreds of lines can be executed with only a few clicks of the web interface and the addition of dynamic graphs to help the analysis. This was possible thru a previous Data Engineering step of generating tables from transactional systems.

The app aims to replace the need for going thru many different financial data systems. Today, it assists hundreds of tax auditors in extracting and analyzing various data inputs. This app helped improve fraud investigation by accelerating data gathering, enhancing complex data analysis and enabling more efficient reporting.