Regional government reporting and intelligence system
The government of Krasnodar Region
Krasnodar region is a federal subject of Russia, located in the Southern Federal District. The region population is about 5.5 million people on the territory of 75,485 sq. km.
The Region is characterized by industrial and agro-recreational type of development. The basis of the regional productive forces constitute 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 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 Winter Olympic Games of 2014.
GoalTo provide instant access to any indicator or report ever created by the departments of regional government, municipalities or state companies.
To build up a collection statement system that implements a dataflow of reports concentration 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 complex solution of six components:
- Workflow management subsystem.
- Database server.
- Reporting subsystem.
- Intelligence subsystem.
- Mobile applications.
- Desktop applications.
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 stored in the central database and divided in two parts. The operational database and the statistical database. Operational database stores all the data needed for proper system functionality and the indicator values that are still on revision. For example, the current values of indexes 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 includes interactive report constructor and reporting website. Interactive report constructor is the tool for visual and in code reports development. It supports different kind of data presentation such are charts, tables, lists and maps. In addition, it supports calculations and different kinds of data filtration. All the reports connected to the statistical database and use only accepted data values. The 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 veiw with different specifications and create their own data views in real time.
Mobile applications are pocket reporting tool With mobile app it’s easy to get any index of any branch, department or division managed. Mobile applications operate the same interactive report repository that created in the reporting subsystem. Also, all indicator values once downloaded to mobile phone is cached so it can be used in case of lack of internet connection, for example during the flight.
Desktop applications are the electronic documents, designed in office applications that support business intelligence or interactive reporting features. Most of them are built in Microsoft Excel with PoverPivot and PowerView tools. Some applications built in QlikTech Qlik Sense or Tableau Desktop. Platform choice depends on desires of 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 analyzing. The system will provide unified method for defining collecting parameters including list of indexes, information senders and receivers, frequency.
After creating collecting flow the system launches a schedule that informs participants about data status changes, deadlines, new information requests etc.
A 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 heating season, multi-functional centers efficiency etc.
Typical dashboard indicates the most important features of activity field and allows making decisions based on comparison between factual and planned values, observing current state, completion percentage on interactive graphics.
Pentaho Mondrian, PostgreSQL, Qlik Sense Desktop