Moscow Open Budget Business Intelligence Portal

Moscow City (Russia)

Customer information

Customer profile: Moscow IT Department develops and implements state IT and communication policies and acts as state customer and chief budget owner. The department awards public contracts for supplying software, information technology, and other equipment; and renders information and telecommunication services to ensure the operation of Moscow information systems.

Description

Public confidence in government transparency depends on a large extent to the rate and amount of information provided and the methods used to disclose this information. To inform citizens and entrepreneurs about the availability of funds for expenditures and to monitor the attainment of planned development indicators, the Government of Moscow initiated the development of the Moscow Open Budget Business Intelligence Portal. Prognoz was engaged to develop this portal due in part to our expertise in producing Business Intelligence systems for various government bodies.

Scope

The portal provides open online access to information on current Moscow expenses and presents the results of urban development programs, which constitute 90% of the city’s budget. The portal’s feedback mechanism encourages users to suggest more efficient ways to allocate funds. Portal visitors can compare Moscow development indicators with those of other large cities, including Paris, Shanghai, and Los Angeles.

The portal is primarily designed for average citizens; no special knowledge of public administration, finance, and budgeting is assumed. Thus, the portal strives to provide easily comprehensible information, with an emphasis on visual data representations, including tables, charts, and graphs.

The portal includes the following functional modules:

  • The home page contains news, key information on budgetary process, and portal navigation.
  • The Budget Reference Data module provides a brief description of the budgetary process, key terms and definitions, and explanations of the relevant regulations.
  • The Moscow Budget and Budget Law module contains information about key areas of the city’s budgetary policy in the form of tables and graphs, the draft wording of budget legislation with its attachments, and the text of the adopted law.
  • The Budget Implementation module enables the online monitoring of revenues, expenses, sources of budget deficit financing, and public debt.
  • The Executive Power Activity module enables executive offices to publish reference and contact information for selected departments, analyze the networks of subordinate authorities, and track provided services and performance indicators.
  • The Moscow Public Debt module contains information on Moscow’s public debt, including schedules for security repayment and attraction and debt structure.
  • The Moscow National Programs module provides in-depth information about national program profiles and their expenditure patterns.
  • The Budget Institution Network module provides information about budget institutions, including the complete list of services that they render.
  • The Key Socioeconomic Indicators module displays cumulative information on Moscow socioeconomic development indicators.
  • The Feedback and Personal Account area contains information about the budget implementation of individual governing bodies and provides a mechanism for direct feedback from portal visitors.

For efficient module operation, the following tools were developed:

  • Data collecting and loading
  • Data storing
  • Administration
  • Site map
  • Full-text search
  • OLAP data analysis
  • Data acquisition Web service

Key features:

  • A simple and understandable tool that enables ordinary Moscow citizens to access detailed visual information about the city budget, with a user-friendly interface that requires no special training and the functionality to create interactive graphs and diagrams in 2-3 clicks.
  • An efficient feedback mechanism that encourages average citizens to participate in the approval of the budget, ask questions relating to the budgeting process, and receive immediate answers from specialists.
  • A centralized data warehouse containing data on the budgetary process collected from disparate sources.
  • Open system integration and modular architecture, which facilitates future enhancements to the portal.

Results of the implementation of the system

  • Improved citizen awareness about the budgetary procss
  • Increased transparency of budget planning and spending
  • Better governmental decision making related to the implementation of budgetary programs.