Talk to our
insurance agent

+92 (003) 68-090

Call to Our Experts

Microdados Objetos
Data Source: Observatório da Segurança Pública do Espírito Santo

The Citizen Security Observatory of Espírito Santo State (OSC/ES) is an initiative by the Government of Espírito Santo aimed at supporting strategic actions for crime and violence prevention and control.

Analysis of data extracted from the Public Security Observatory related to the theft and robbery of mobile devices, vehicles, and bicycles.

The Citizen Security Observatory was established by Decree No. 4551-R and serves as the core entity that integrates data, information, and knowledge on public security, criminal justice, social protection, and related areas. It fosters the development of information, studies, and research through collaboration with institutions such as the Secretariat of Public Security (SESP), the Espírito Santo Military Police (PMES), the Espírito Santo Civil Police (PCES), the Espírito Santo Military Fire Department (CBMES), the Espírito Santo State Traffic Department (DETRAN/ES), the Secretariat of Justice (SEJUS), the Espírito Santo Socio-Educational Assistance Institute (IASES), the Secretariat of Human Rights (SEDH), the Secretariat of Labor, Social Assistance, and Development (SETADES), the Secretariat of Health (SESA), the Secretariat of Education (SEDU), among others.

Main features

The project uses Power BI for visualizations, DBT for data manipulation, advanced filters for quick information access, and comprehensive metadata management.


  • Visualization created in Power BI

  • All data manipulation performed with DBT

  • Filters for quick access to information

  • Complete metadata management carried out

  • Optimized Process

    An optimized data treatment process ensures the seamless creation of reliable and well-structured tables for advanced analytics.

  • Preprocessing

    Data preprocessing in R Studio validates data consistency and quality, setting a solid foundation for accurate insights.

  • Storage in MySQL

    Efficient storage in MySQL guarantees structured access, scalability, and optimal performance for data-driven applications.

Technologies Used in This Project

  • 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