Visualization of Municipality’s Budget

From ICO wiki

Team page for Deploying IT Infrastructure Solutions.


  • Alexandros Kantas, Technological Educational Institute of Crete
  • Georgios Alexakis, Technological Educational Institute of Crete
  • Pijus Akelis, Vilnius University of Applied Sciences
  • Mindaugas Gedaminskas ,Vilnius University of Applied Sciences
  • Olga Trikk, The Estonian Information Technology College
  • Üllar Seerme, The Estonian Information Technology College


The goal of the project was to create a prototype tool for the City of Tartu, which enables ordinary citizens to have a visual overview of their municipality's budget. This would also allow for these citizens to manipulate the data to come up with their own ideas for a suitable budget. An example of was given as a possible solution. In terms of usability for the back-end, the administrator or municipality worker should have a simple interface, which allows him or her to easily insert data.



Personal input

Üllar Seerme

  • What I did:
    • Realized the mock-up design from the brainstorming
    • Wrote the documentation
    • Set up test platform with various software like Apache and MySQL
  • What I learned:
    • To use FreeBSD
    • To work with a team
    • To be more confident when doing presentations
    • To communicate more fluently

Olga Trikk

  • What I did:
    • Participated in database design
    • Restructurized the budget data we got from the client and imported it to database
    • Contacted with the client about the data structure
    • Implemented saving the budget data from database to .json file and reading data from .json file to jquery
  • What I learned:
    • Experience of doing a project in an international team
    • Experience of working on a real project
    • New knowledge about PHP, JavaScript, JSON, jQuery

Georgios Alexakis

  • What I did:
    • Design of sliders
    • Design of project
    • Help with final presentation
  • What I learned:
    • Ruby on Rails
    • Multicultural teamwork
    • Better communication skills
    • Gained presentation skills

Alexandros Kantas

  • What I did:
    • Excel macros for database
    • Database schema
    • JSON files
  • What I learned:
    • VBA for Excel
    • PHP and JSON syntax
    • Time management
    • More experience working with a team

Mindaugas Gedaminskas

  • What I did:
    • Implementation of sliders
    • Front-end
    • Styling
  • What I learned:
    • To work with a team
    • Working in a foreign language
    • Experience in front-end coding
    • To practice good documentation
    • Presentation skills

Pijus Akelis

  • What I did:
    • Admin panel
    • General back-end work
  • What I learned:
    • Working with a team
    • Stuff about Estonia