2011-11-29

Open Data: Open Public Procurements of Slovakia launched

I am happy to announce that Transparency International Slovakia launched a project I’ve been working on: Open Public Procurements of Slovakia.

The challenge was to get something understandable from many not-so-nice documents:

Visitors can browse and see graphical aggregations of the public procurement contracts. They can see either graphical reports for comparison, list of contracts or a contract details with reference to the contract data source document. The portal answers questions that Public Procurement Office answered with “we do not have enough human resources and time to go through all the contracts to provide you the number”.

The data are scraped daily from public procurement office pages. They are processed, cleansed and changed into useable analytical form.

My part of the work is the whole invisible extraction, transformation, loading (ETL) process behind and the online analytical processing (OLAP).

For technically curious: the project is built on top of my light-weight OLAP framework Cubes (github).

I hope this helps to increase transparency in our country and that other NGOs will follow the example of TIS.

Tags: opendata data