An accounting office approached me in need of a dashboard to help calculate and visualize which tax regime is most beneficial to each client. They had several Excel spreadsheets to perform these calculations, but these were difficult to update and to visualize.

Using Python, I built an automation that extracts the raw data from their accounting system so that they no longer need to update each spreadsheet individually. I also automated the treatment of the data and unified it into a single .csv loaded into PowerBI. Finally, I built the visualization in visual way, simple to understand.