Use case: Portfolio Management System Error Identification


For a wealth management boutique, fixing bugs in data quality for highly heterogeneous data sources as well as generating personalized and efficient client reporting is highly time-consuming.


Develop dashboards to enhance client reporting as well as monitor data quality of its Portfolio Management System.


  • Microsoft Access DB
  • R Shiny


For the client reporting side, a PowerBI dashboard enables the client to navigate their portfolio and historic performances as well as to perform “What if” analysis on their allocations.

For the data quality side, a R Shiny app automatically detecting data inconsistencies in PMS system and enables smart navigation to swiftly solve issues