Bento Ferreira - Vitória - Espírito Santo - Brazil
Bento Ferreira - Vitória - Espírito Santo - Brazil
The Open Data Portal of the State of Espírito Santo is an online platform based on open-source software, implemented with the aim of facilitating citizens' access to public data in various formats—from statistical to geospatial—generated by governmental bodies and entities.
A wide range of data is made available to the public, including expenses, revenues, information about public servants, purchases, among other details related to areas such as health, education, security, and all others provided by the agencies and entities of Espírito Santo.
The files are published in open formats, meaning they have no access restrictions, allowing you, the citizen, to freely use, modify, and share them according to your needs.
The 2021 expense spreadsheet was in CSV format and exhibited excellent data consistency, with missing values being handled in R.
Initial interaction with the data in Excel
Preprocessing performed in R
Data transformation executed using DBT
Visualization created in Power BI
Empowering decision-making with advanced analytics on an extensive dataset of Espírito Santo's expenses, featuring thousands of records.
Interactive dashboards provide managers with clear, data-driven insights to guide strategic decisions efficiently.
Seamlessly integrates with historical series, enabling robust trend analysis and long-term financial planning.
Let's schedule a conversation so I can better understand your needs. Whether it's your data project or in-company training sessions, we will find the best solution. I would be happy to give you a call.
Craig Larman