Week 3

On Monday we received detailed data in a JSON file. At the beginning we had not only difficulties to understand the file structure but also to convert the data in a practicable format. In the end we used the tool Altova XMLSpy 2015 to export the data into XML format which allowed us to generate an Access data base.

Converting the XML file into an Access Database

The software generated eight tables. Unfortunately, the converter was not able to set the primary and foreign keys. Therefore we had to implement them manually.

Setting the primary and foreign keys

Afterwards, we started analyzing the new data set. We identified heaps of redundancies especially on the user side. Now we are trying to eliminate those redundancies for a more precise analysis. Furthermore we are setting up scenarios for our future analysis.