FAQs

The Controlling and Data Portal is a comprehensive Business Intelligence System for the University of Konstanz. The web-based portal allows for systematic analysis, evaluation and illustration of data in electronic format.

The Controlling and Data Portal allows you to collect web-based data from all service areas of the university. The portal allows you, for example, to retrieve aggregated data on student (bachelor, master, doctoral), publication and funding numbers (including in time series format). Beyond that, you have access to detailed reports that Provide a structured overview of the contractual periods, project budgets and available positions.

The goal of the Business Intelligence System is to efficiently fulfill internal and external reporting requirements. (E.g. monitoring reports on study and teaching, providing rankings, reports for donors), and to reduce the growing workload for reporting tasks. University employees who are involved with internal and external decision-making, controlling, and/or management responsibilities in their daily work, are supported by the availability and usability of the data. This will significantly strengthen the strategic management of the university on all levels.

The portal is available to all all employees of the University of Konstanz as self-service BI, pursuant to its legal and user concepts.

The Division of Finance and Controlling / Unit Controlling along with Communication, Information, Media Centre (KIM) are responsible for implementing the comprehensive Business Intelligence System at the University of Konstanz.

You need an up-to-date web browser (e.g. Firefox, Chrome, Safari) as well as a device with internet access (PC, laptop, tablet, smart phone) to use the Controlling and Data Portal Your device can then access the controlling and data portal under the following URL: www.controllingdaten.uni.kn

Due to security reasons, access to the portal is only available from your office computer on the internal university network . You can also log into the controlling and data portal from external sites with various devices (laptop, tablet, smart phone) and through different operating systems (Windows, iOS, Android, Linux). In this case, you will require a VPN-connection from the university (Cisco AnyConnect). For iOS, a specific App is available in the respective App store free of charge.

All employees of the University of Konstanz can log into the controlling and data portal at any time by entering first name.last name and their email password.

The simultaneous login from more than one device is not possible due to security reasons. If this were to be attempted, you would receive notification that will allow you to discontinue the second connection to the portal. Please only use the controlling and data portal on devices that are configured to the security regulations of the university.

You can change your password using the IT Service Centre user account administration. Please take note, that changing your central password here will automatically change your password for other university services (e.g. SoGo).

If you use the university’s VPN application (Cisco AnyConnect), you can also access the Controlling and Data Portal from locations outside the university campus network.

You can access the Controlling and Data Portal by opening your mobile device’s (laptop’s, tablet’s or smart phone’s) web browser (e.g. Chrome, Firefox, Safari) and entering the respective URL. www.controllingdaten.uni.kn. The portal is optimised for a variety of display sizes and adjusts automatically to fit the device.

It is even easier to use the portal with the applicable iOS  application which is available free of charge from the respective App Store. Simply enter the following connection information for the App in order to access the Controlling and Data Portal from a mobile device.

Connection name: Controllingdatenportal

User name: firstname.lastname

Password: *******

Server adress: https://www.controllingdaten.uni.kn

Organisation:

Connection Input: 10

The analyses and reports in the controlling and data portal are based on data that is extracted from various operative feeder systems and then collected, stored, and prepared in the university's data warehouse.

Study and Teaching

• Application Process: HISinOne APP (Division of Student Affairs)
• Students: HisInOne STU (Division of Student Affairs)
• Examinations: HisInOne EXA (Division of Student Affairs)
• Incoming Exchange Students: HisInOne STU (Division of Student Affairs)
• Survey Results: EvaSys (Quality Management)

Research

• Publications: KOPS (KIM)
• Citations: Google Scholar, Web of Science (Division of Finance and Controlling)
• Research Metadata: HisInOne RES (Staff Unit University Development, Research and Transfer)

Promotion of Young Researchers

• Doctoral Degrees: ProKon (Division of Student Affairs)
• Habilitationen (Post-Doctoral Qualifications): HabilKon (Division of Student Affairs)
• Number of Postdocs: HIS SVA GX (Human Resources Division)

Equal Opportunities

• Appointment Processes: BV DB (Office for Equal Opportunity and Family Affairs)

Finances

• General and Equipment Funding HIS FSV GX (Division of Finance and Controlling)
• Cost Accounting: HIS COB GX (Division of Finance and Controlling)

Human Resources

• Positions and Personnel: HIS SVA GX (Human Resources Division)

Infrastructure

• Rooms and Space: MORADA (Facility Management)
• Marketing: Website visits Matoma data (KIM)

The data available from the Controlling and Data Portal is updated each night through the operative feeder systems. The information available today reflects the data collected during the update from the previous day. Only the citation data for KOPS publications from Google Scholar and Web of Science are updated on a quarterly basis.

In addition to the Controlling team, you can also contact certain individuals in the relevant divisions with questions on a specific topic:

Study and Teaching

• Application Process: Thomas Piekorz (Division of Student Affairs)
• Students: Thomas Piekorz (Division of Student Affairs)
• Examinations: Thomas Piekorz (Division of Student Affairs)
• Incoming Exchange Students: Christina Fritz (International Office)
• Outgoing Exchange Students: Christina Fritz (International Office)
• Survey Results: Johanna Vogt (Quality Management)

Research

• Publications: Susanne Bohner (KIM)
• Citations: Monika May (KIM)
• Patents: Staff Unit University Development, Research and Transfer (researchcontracts@uni-konstanz.de)
• Research Metadata: Stefanie Preuß (Staff Unit University Development, Research and Transfer)

Promotion of Young Researchers

• Doctoral Degrees: Thomas Piekorz (Division of Student Affairs)
• Habilitationen (Post-Doctoral Qualifications): Thomas Piekorz (Division of Student Affairs)
• Number of Postdocs: Julia Fritz (Human Resources Division)

Equal Opportunities

• Percentage of Women: Tanja Edelhaeusser (Office for Equal Opportunity and Family Affairs)

Finances

• Budget Resources: Petra Walk (Division of Finance and Controlling)
• Third-party Funding: Project Administration Team (Division of Finance and Controlling)
• Cost Accounting: Nicola Baur (Division of Finance and Controlling)

Human Resources

• Positions and Personnel: Julia Fritz (Human Resources Division)

Infrastructure

• Rooms and Space: Heike Frommer (Facility Management)
• Marketing: Miriam Leifeld (Communication and Marketing)

The controlling and data portal offers you comfortable and user friendly access to relevant data for university management purposes. Many of its basic functions are intuitive and easy to understand. The first time you access the Controlling and Data Portal, we recommend you refer to our Quick Reference Instructions, as you take your first steps. In addition, more detailed help and background information are available in our Glossary and Handbook. You can get to know the whole palette of possibilities the Controlling and Data Portal has to offer by taking part in a the university continuing education programme accessible on the “Operating Procedures and Internal Know-How” section of the website.

You can take a brief orientation tour that will provide you with a quick overview of the most important functions and content of the controlling and data portal. Once you log-in, the orientation storyboard is available by entering “Willkommen” into the “Search” box at the top right of the page and then clicking on the search button (magnifying glass). You may then click to open the (German) orientation tour „Willkommen im Datenportal“.

University of Konstanz employees have access to a variety of help information, training programmes and background information, in order to learn how to use the Controlling and Data Portal.

• The simplified Quick Reference Instructions offer users well-structured assistance with getting started on the Controlling and Data Portal.
• The Glossary explains important key figures as well as report subjects and filters.
• The manufacturer’s own Wiki is available in English and provides a well-structured overview of all the Controlling and Data Portal’s functions. This web-based handbook also includes a large number of screen shots and short instructional videos.
• Taking part in a personalised training programme can give you the best overview of the many different functions and content available in the Controlling and Data Portal. For this reason Controlling offers multiple introductory and advanced courses in small groups within the University of Konstanz's continuing education programme each semester. While the two-hour long introductory course provides a solid overview of the various analysis techniques and contents, the one-hour advanced course offers participants a deeper look into specific report areas (e.g. Personnel and Positions). You can easily register at no cost to you for the individual courses via the continuing education programme website in the section on Operating Procedures and Internal Know-How.

Controlling offers multiple introductory and advanced courses in small groups within the University of Konstanz's continuing education programme each semester. While the two-hour long introductory course provides a solid overview of the various analysis techniques and contents, the one-hour advanced course offers participants a deeper look into specific report areas (e.g. Personnel and Positions). You can easily register at no cost to you for the individual courses via the continuing education programme website in the section on Operating Procedures and Internal Know-How.

The team of the Division of Finance and Controlling will be glad to answer any questions you may have. If you have questions about the Controlling and Data Portal, please contact Matthias Schäfer (Phone: +49 7531 88 3990).

You can also contact the entire portal team via email with any questions or technical problems you may have: controlling@uni-konstanz.de

The data in the Controlling and Data Portal is sometimes of a sensitive nature and are thus protected by a range of technical and conceptional measures from being accessed by external users. An IT security company confirmed the very high level of security by using a penetration test. Within the portal, sensitive data are additionally protected by assigning user based access privileges, which can, however, be transferred to authorised users upon request. The security concept for the Controlling and Data Portal is constantly being updated by the security representative at the Communications, Information, Media Centre (KIM) in order to be able to respond to current threats.

The data accessed on the Controlling and Data Portal is only as secure as the device used to access them. For this reason, please only use the portal on devices that are configured to the security regulations of the university.

We take the protection of your personal information very seriously. We, therefore, only process the personal information that is collected when you visit the Controlling and Data Portal in accordance with current data protection regulations. Details are available in the Controlling and Data Portal’s privacy policy.

Certain reports are only accessible if you have special access privileges. Upon access authorisation request, the access privileges can be assigned to you quickly and easily once your application has been approved.

In the standard role of “report consumer” you are only allowed to view reports, dashboards and storyboards. If you would like to be assigned the role of “report designer”, please contact Matthias Schäfer (+49 7531 88 3990) or the team of the Division of Finance and Controlling / Unit Controlling (controlling@uni-konstanz.de).

Please take advantage of the possibility to provide the Controlling team with feedback on all aspects of the controlling and data portal (usability, reports, data, needs, problems) via phone or email. Please contact Matthias Schäfer (Phone: +49 7531 88 3990) or controlling@uni-konstanz.de.

To report errors to the responsible individuals, simply use the comments function accessible directly from the reports that is included in the Controlling and Data Portal. You can comment on a report privately to the corresponding contact person by clicking on the "Y" on the right. Then select "Neue Unterhaltung" / "New conversation"  and the symbol with the lock "Sicheren Kommentar hinzufügen" / "Add secure comment". Your current filter settings will also be included in the comment. Please also include the correct contact information, so your message will reach the right person. If you are unsure who to contact, simply send your comment to Matthias Schäfer, E-mail: matthias.schaefer@uni.konstanz.de (Phone: +49 7531 88 3990).

You will automatically be included in the Controlling-News mailing list after logging on to the portal for the first time. This mailing list informs you about planned maintenance work, training courses, new reports and functions.