At KUB Datalab we use and support a large array of software.
We have tried to organise our main tools into categories below. Bear in mind, that many types of software can be used for multiple purposes. We have tried to categorise by main purpose.
Microsoft Excel allows users to organize, format and calculate data with formulas using a spreadsheet system. It features the ability to perform basic calculations, use graphing tools, create pivot tables and a macro programming language called Visual Basic for Applications, among other useful features.
Spreadsheet applications such as MS Excel use a grid of cells arranged in numbered rows and letter-named columns to organize and manipulate data. They can also display data as charts, histograms and line graphs.
MS Excel permits users to arrange data in order to view various factors from different perspectives. Microsoft Visual Basic is a programming language used for applications in Excel, allowing users to create a variety of complex numerical methods.
NVivo is a qualitative data analysis program that allows you to collect, organise, analyse and visualise unstructured or semi-structured data.
With NVivo you can import data in different file formats, organise demographic data, code sources, capture ideas, run queries and visualise project items. You can import text, audio, video, emails, images, spreadsheets, online surveys, web content and social media from various sources into NVivo. When you have imported the data from multiple sources you can conduct mixed methods (quantitative and qualitative) in-depth analysis.
NVivo is available for both PC and Mac for employees and students at University of Copenhagen. You can download the program from the Software Libray at KUnet.
(Note that NVivo for PC and Mac differs somewhat as to interface, setup and terminology. The PC version has more features than the Mac version.)
Orange is a component-based visual programming software package for data visualization, machine learning, data mining, and data analysis.
Orange components are called widgets. They range from simple data visualization, subset selection, and preprocessing to empirical evaluation of learning algorithms and predictive modeling.
Visual programming is implemented through an interface in which workflows are created by linking predefined or user-designed widgets, while advanced users can use Orange as a Python library for data manipulation and widget alteration.
Python is a programming language available under an Open Source license. It is smart to know a bit about python programming, partly because the programming language is becoming more and more widespread and used in research, partly because more analyzes in the humanities, social sciences and natural sciences depend on algorithms and calculations. KUB Datalab’s python courses deal with e.g. on analyzes of text data and web scraping.
R is a programming language specifically designed for statistical data analysis. It is more or less the industry standard for explorative data analysis, data cleaning and visualization.
KUB Datalab offers courses, both general and tailored to specific needs in R. In our open workshops, we consults on how solve specific problems in and with R. You must find out on your own which statistical test you need to apply, and what visualization best suits your data. When that is decided – we will do our utmost to get you to your goal.
Our approach is based on the tidyverse. We find that Base R solutions, in general are more difficult for beginners to grasp. Close collaboration with our resident Python experts ensures that we are ready to switch gears if necessary.
SQL, Structured Query Language, is the language we use to get data from the most common databases. It is possible to do quite advanced analyses in SQL. Our primary focus working with SQL is to get our hands on the data, and then do the analysis in other software packages. We aim to provide training in elementary use of SQL, and incorporate the method in other situations where useful.
Voyant Tools is an Open Source software that can be used both online and offline, if you install it on your own computer. Voyant Tools can be used for text analysis. It houses several different tools that are combined on one platform. The program is useful for exploring, analysing and interpreting text collections and can be used for gaining insight into what different text analysis algorithms do and can do. It is most prevalent in the digital humanities, but will also be relevant in other areas such as digital social science.