Travel Dashboard of Brazil’s Public Administration

This is a project for Brazil’s Ministry of Economy. The Travel Dashboard provides an interactive panel which gathers information about the public expendituries made by public employees when they travel for work.

An incredible data engineering work has been done. To build the Data Lake and the Data Warehouse which feeds the panel we had to integrate data from multiple sources and data bases.

I joined this product when it was almost concluded. I was responsible for writing the Data Warehouse’s documentation and data dictionary. Also I give mantainance to the product and I made some evolutions.

Travel Analysis. Tickets bought directly from airlines. Tickets bought through travel agency. Export data.
Galery with dashboard images.