Visualization of analytical information

The data warehouse is a significant part of the Vysocina Region’s information system. It provides for the fast accessibility of data from various areas for managers, the Regional Authority staff, and also for the Region’s inhabitants and all regionally established organizations. The data warehouse simplifies and speeds up the analytical and statistical work with data, and significantly improves its quality and reporting value.



Main goal

Analytical and Statistical Services of the Vysocina Region is on-line web interface of The Data Warehouse of the Vysocina Region. You can find here on-line generated reports from public part of our data warehouse.

The data warehouse is a central, regional multi-dimensional database, integrating data from operating systems and external sources into a data structure that allows for fast and comprehensive analysis. The data warehouse is physically and logically separated from the operating systems. Data from the operating systems are transferred to the data warehouse, where they are transformed and stored in a way which suits the analytical and presentational processing of the outputs. The data warehouse has two layers: the "zero" layer contains un-cleaned data, which is downloaded from various sources at the set intervals. Subsequently, the data is cleaned, integrated, summarised, and their accuracy is checked. This consolidated data is saved in the "first" layer, which is the foundation for all types of outputs. The foundation for the processing of data is an OLAP analysis (OLAP = on-line analytical processing), which manipulates the data in so-called multidimensional data objects. Internal users enter the data warehouse through the Regional Authority's intranet; external users via a web interface.

Lessons learned

The data warehouse is still in progress and will be developed in terms of the tools for the strategic and procedural management of the organization (e.g., balanced - scorecard), on-line connection of the database to map outputs, or a further increase in the volume of the data processed. The benefits and results of this solution in the Vysocina Region are evident, and we expect it to develop further, using for example subsidies from the European Union's Structural Funds.

Recommendations

Recommendation1 To pay more attention to the end user’s needs in sense of their demands related to governmental data availability and quality.
Recommendation2 To reflect the needs of all stakeholders, including re-users.
Recommendation3 To ensure practical steps towards simplification and standardisation of conditions for the third parties (profit or non-profit) in providing them with the data for the re-use.
Recommendation4 To use modern visualisation tools for presenting governmental and regional data.

http://analytika.kr-vysocina.cz/ 

Location

Vysocina, Czech Republic

Author

Martina Rojkova

Info

rojkova.m@kr-vysocina.cz

Files