University of South Bohemia in České Budějovice
The University of South Bohemia is a public university based in České Budějovice. It is an educational and research institution focusing on the natural sciences, humanities and social sciences.
The University is home to nearly 9,000 students studying in more than 230 bachelor‘s, master‘s and doctoral programmes at 8 faculties: the Faculty of Economics, Faculty of Fisheries and Protection of Water, Faculty of Arts, Faculty of Education, Faculty of Science, Faculty of Theology, Faculty of Health and Social Sciences and Faculty of Agriculture and Technology.
The University also offers lifelong learning courses and programmes to the general public.
Client’s requirements
The University of South Bohemia sought to simplify and increase the share of data-driven decision-making. The original data were maintained in different systems and outputs were recorded manually in Excel files, which led to a high risk of errors and complicated data operations.
The main requirement was to consolidate the data in one place and process the data automatically for subsequent visualization and reporting.
Solution
In order to meet the client’s requirements, an analysis of the source systems was carried out. Based on the results of the analysis, we created a data warehouse that processes data for reporting:
- analysis and definition of all users’ needs + mapping of university processes;
- architecture design and creation of a DWH model;
- integration of data from source systems;
- transformation and calculation of data in the DWH;
- connection of the prepared data source to the MS Power BI reporting platform;
- preparation of report templates;
- setting sharing of reports to defined users;
training of users so that they can maintain and develop the delivered solution themselves.
Benefits
Significant simplification of work, reduced risk of error, unified view of all current and historical data, comprehensive and clear basis for university management and strategic planning.
