The government of the Krasnodar Region
Krasnodar region is a federal subject of Russia, located in the Southern Federal District. The region's population is about 5.5 million people on a territory of 75,485 sq. km.
The Region is characterized by industrial and agro-recreational types of development. The basis of the regional productive forces constitutes the industrial, construction and energy complexes, information and communication technologies, as well as agro-industrial, transport, resort and recreation, and tourist complexes. The last three - agriculture, transport, and hotel & tourist complexes - correspond to the priorities of the socio-economic development of Russia and determine the special status of the Krasnodar Krai in the national economy.
Also Krasnodar region city Sochi was the host city of the Winter Olympic Games of 2014.
To build up a collection statement system that implements a dataflow of reports concentrated on every government level.
To analyze, structure and import into system database reports for the period of three years.
To integrate an interactive reporting and dashboard platform.
To integrate a business intelligence platform for interactive multidimensional analysis and visualization.
Create the reports templates for people in charge by their areas of responsibility.
Spellsystems has developed a complex solution of six components:
- Workflow management subsystem.
- Database server.
- Reporting subsystem.
- Intelligence subsystem.
- Mobile applications.
- Desktop applications.
The workflow management subsystem allows state offices to create indicator lifecycles of any complexity and also it implements workflows created. It provides two key blocks of functionality. The first one is workflow development and the second is statement collection. Workflow development includes account and access management, government structure management, index management, workflow management, reporting schedule management, index integration rules management and index calculation rules management. The collection statement implements the created workflows: provides the reporting forms delivery, automated control of schedules, control of indicator values consistency, indicator integration and presentation.
All the indexes are stored in the central database and divided into two parts. The operational database and the statistical database. The operational database stores all the data needed for proper system functionality and the indicator values that are still in revision. For example, the current values of indexes are included in reports that are still in progress. The statistical database stores all the checked and accepted index values collected at any time.
The reporting subsystems include an interactive report constructor and reporting website. The interactive report constructor is the tool for visual and in-code reports development. It supports a different kinds of data presentation such are charts, tables, lists and maps. In addition, it supports calculations and different kinds of data filtration. All the reports are connected to the statistical database and use only accepted data values. A reporting website is a place where developed reports come to life. State officers and people in charge get the reports of their area of responsibility there.
The intelligence subsystem is a set of instruments for interactive data analysis. It includes pivot tables, pivot charts, timelines, drilling through, filtering and other tools for the best insights. It allows government and municipality analysts to watch data from different points of view with different specifications and create their own data views in real-time.
Mobile applications are pocket reporting tools With mobile apps it’s easy to get any index of any branch, department or division managed. Mobile applications operate the same interactive report repository created in the reporting subsystem. Also, all indicator values once downloaded to a mobile phone are cached so they can be used in case of lack of internet connection, for example during the flight.
Desktop applications are electronic documents, designed in office applications that support business intelligence or interactive reporting features. Most of them are built in Microsoft Excel with PowerPivot and PowerView tools. Some applications are built in QlikTech Qlik Sense or Tableau Desktop. Platform choice depends on the desires of the specific end user. All the desktop applications get the actual data values from the statistical database.
Our company is in a process of creating a web interface where all of the system participants can load the new data for analysis. The system will provide a unified method for defining collecting parameters including a list of indexes, information senders and receivers and frequency.
After creating the collecting flow the system launches a schedule that informs participants about data status changes, deadlines, new information requests etc.
The reliability of all incoming data portions is controlled in two ways: automatically and manually.
We have created over a dozen interactive dashboards on various fields governed by region authorities. The list includes budget revenues, application of funds, resettlement from dilapidated cost, fuel and energy infrastructure condition, house readiness for the heating season, multi-functional centres efficiency etc.
A typical dashboard indicates the most important features of the activity field and allows making decisions based on a comparison between factual and planned values, observing the current state, and completion percentage on interactive graphics.
Pentaho Mondrian, PostgreSQL, Qlik Sense Desktop