27.02 Buildling a bridge between data and YUTPA

Team -- City Rhythm AMS Researchers

Here you find a summary of a design meeting between Scott Cunningham, Caroline Nevejan and Pinar Sefkatli. We discussed building the bridge between data and the YUTPA model and conclude we need to use an Entity Relation Diagram. Below filmed summary of the meeting, pdf's of the sketches and the letter for Central Bureau of Statistics of the Netherlands to acquire the basic datasets.

Step 1:

To start with both Scott Cunningham, data scientist, and Caroline Nevejan, Social Scientist, each mapped the subject areas of CBS microdata o the different factor sand dimension of the YUTPA framework. Results here below. Some mapping was similar, some very different. Based on the similar mapping, already several datasets seemed to be appropriate.

Step 2:

In the second round Caroline Nevejan, who is also author of the YUTPA framework, took the elements of the chosen datasets and explored on which YUTPA factors these data sets shed light. It appears that different datasets shed light on particular factors. It appears that a specific dataset refers to specific factors in specific dimensions.

Step 3:

Then Nevejan tried to structure the dimensions according to the factor mapped datasets. She finds that some sets match with 2 and others with 3 or even 4 dimensions.

Step 4:

Th e mapping of dimensions and factors with datasets is discussed with Scott Cunningham. Cunningham recognises and proposes the Entity Relation Diagram which is a standard way of creating validity between different variables in database architectures.