KB logo

KUB Datalab: Analysing

Tools for analysing data

Tools

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.

Tools for analysing data

Excel 2019 logo

Excel

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 logo

NVivo

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.)

R logo

R

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 logo

SQL

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.

VBA logo

VBA

Visual Basic for Applications is the programming language used when we get behind the scenes in Excel (and the other Microsoft Office applications). VBA gives us the opportunity to customize spreadsheets and do data cleaning and analysis that Excel is not able to do out of the box. We do not provide training i VBA, but use the tool to troubleshoot and solve more advanced problems in Excel as necessary.

Voyant Tools logo

Voyant Tools

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 smart ten explore, analyze and interpret text corpora and smart to gain insight into what different text analysis algorithms do and can do. It is most widespread in the digital humanities, but will also be relevant in other fields, such as digital social sciences.