Talk to our
insurance agent

+92 (003) 68-090

Call to Our Experts

Espírito Santo Expenses
Data Source: The Open Data Portal of the State of Espírito Santo

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.

This initiative is managed by the State Secretariat of Control and Transparency (SECONT), with support from the Institute of Information Technology and Communication of Espírito Santo (PRODEST).

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.

Main features

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

  • High-Volume Data Handling

    Empowering decision-making with advanced analytics on an extensive dataset of Espírito Santo's expenses, featuring thousands of records.

  • Actionable Dashboard

    Interactive dashboards provide managers with clear, data-driven insights to guide strategic decisions efficiently.

  • Incorporating Historical Trends

    Seamlessly integrates with historical series, enabling robust trend analysis and long-term financial planning.

Technologies Used in This Project

  • excel
  • r
  • mysql
  • dbt
  • power_bi

Get in Touch with Me

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.

Agile is not a practice. It is an organizational and employee quality of being adaptable.

Craig Larman