https://wiki.uio.no/mn/ifi/camsem/index.php?title=Tutorial2&feed=atom&action=historyTutorial2 - Revisjonshistorikk2024-03-28T18:06:20ZRevisjonshistorikk for denne sidenMediaWiki 1.27.4https://wiki.uio.no/mn/ifi/camsem/index.php?title=Tutorial2&diff=158&oldid=prevLarsereb@uio.no på 5. jul. 2010 kl. 10:322010-07-05T10:32:26Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='nb'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Eldre revisjon</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revisjonen fra 5. jul. 2010 kl. 10:32</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l9" >Linje 9:</td>
<td colspan="2" class="diff-lineno">Linje 9:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>mistake to think of municipality as a subclass of county. This is of course wrong; a municipality is not a kind of county, but lies within a county. Therefore, we must add a property, for instance “has County” with municipality as domain, and county as range. This is a functional property.  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>mistake to think of municipality as a subclass of county. This is of course wrong; a municipality is not a kind of county, but lies within a county. Therefore, we must add a property, for instance “has County” with municipality as domain, and county as range. This is a functional property.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>Let us make a new ontology named “Geography”, with two classes “Municipality” and “County”. The class Municipality should in this example have tree properties: Its name, its identifying number and name, and its county. The county-class needs, in this example, just a name-property. (The example-picture has more properties, but don’t worry about <del class="diffchange diffchange-inline">this </del>for this tutorial.) <br>Be sure to add the ontology to the correct Linked Data Set! For this tutorial, create a Linked Data Set with an appropriate name and be sure to add “Geography” to this Linked Data Set.  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>Let us make a new ontology named “Geography”, with two classes “Municipality” and “County”. The class Municipality should in this example have tree properties: Its name, its identifying number and name, and its county. The county-class needs, in this example, just a name-property. (The example-picture has more properties, but don’t worry about <ins class="diffchange diffchange-inline">that </ins>for this tutorial.) <br>Be sure to add the ontology to the correct Linked Data Set! For this tutorial, create a Linked Data Set with an appropriate name and be sure to add “Geography” to this Linked Data Set.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>''Step 1.2: Making the matching-table''<br>Now we need to make a table in Excel, matching the correct counties to the appropriate municipalities using their names. This tutorial should have an appendix included with such a table over the municipalities and counties in the region of Nord-Norge (North of Norway) in Norway. (Tutorial 2.xls). A source for information about the relations between counties and municipalities could for instance be Wikipedia. Just make sure that all the information is correct.  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>''Step 1.2: Making the matching-table''<br>Now we need to make a table in Excel, matching the correct counties to the appropriate municipalities using their names. This tutorial should have an appendix included with such a table over the municipalities and counties in the region of Nord-Norge (North of Norway) in Norway. (Tutorial 2.xls). A source for information about the relations between counties and municipalities could for instance be Wikipedia. Just make sure that all the information is correct.  </div></td></tr>
</table>Larsereb@uio.nohttps://wiki.uio.no/mn/ifi/camsem/index.php?title=Tutorial2&diff=86&oldid=prevHaavarot@uio.no på 29. jun. 2010 kl. 14:492010-06-29T14:49:14Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='nb'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Eldre revisjon</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revisjonen fra 29. jun. 2010 kl. 14:49</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l33" >Linje 33:</td>
<td colspan="2" class="diff-lineno">Linje 33:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 9.jpg]]<br> <br>Click Upload, and wait while the data is being uploaded.<br>Do the same operations for the data about Kindergarten Coverage:  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 9.jpg]]<br> <br>Click Upload, and wait while the data is being uploaded.<br>Do the same operations for the data about Kindergarten Coverage:  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 10.jpg]]<br> <br>'''4. Inspecting the statistics in Anzo on the Web'''<br>We now want to create a view in Anzo on the Web, so we can inspect our lovely data in the form of graphs. Log in to your Anzo on the Web-homepage and select "Create a new view". Type in a title and press OK.<br> [[Image:Tutorial 2 bilde 11.jpg]]<br>Add the dataset which contains data about Sick Leave and Kindergarten coverage, by clicking Add Linked Data Sets, search for the Data Set, click it and press OK.<br>Select the types of data you want to see. This would be Kindergarten Coverage and Sick Leave.<br>Create a new lense (from template), choose the chart-template, and give it a cool name as title. Choose Column, and press OK. <br> [[Image:Tutorial 2 bilde 12.jpg]]<br>Choose Column and press OK. In the next window, <del class="diffchange diffchange-inline">hook on that you want </del>to <del class="diffchange diffchange-inline">see the </del>legend. <br>[[Image:Tutorial 2 bilde 17.jpg]]<br>Then go to the Data-tab on the left. Type in “Kindergarten coverage” as the series-name. In label, choose Municipality, then County then Name under “Kindergarten coverage”.<br>In value, select “Kindergarten coverage”.<br>In Group By, make the same selection as in Label. In the drop-down box “Value”, choose Avg.<br> [[Image:Tutorial 2 bilde 13.jpg]]<br>Press “Add new series configuration” and do the same for Sick leave.<br> [[Image:Tutorial 2 bilde 14.jpg]]<br>Press Save and wait. After some seconds, this screen should show up:  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 10.jpg]]<br> <br>'''4. Inspecting the statistics in Anzo on the Web'''<br>We now want to create a view in Anzo on the Web, so we can inspect our lovely data in the form of graphs. Log in to your Anzo on the Web-homepage and select "Create a new view". Type in a title and press OK.<br> [[Image:Tutorial 2 bilde 11.jpg]]<br>Add the dataset which contains data about Sick Leave and Kindergarten coverage, by clicking Add Linked Data Sets, search for the Data Set, click it and press OK.<br>Select the types of data you want to see. This would be Kindergarten Coverage and Sick Leave.<br>Create a new lense (from template), choose the chart-template, and give it a cool name as title. Choose Column, and press OK. <br> [[Image:Tutorial 2 bilde 12.jpg]]<br>Choose Column and press OK. In the next window, <ins class="diffchange diffchange-inline">check the check box next </ins>to legend. <br>[[Image:Tutorial 2 bilde 17.jpg]]<br>Then go to the Data-tab on the left. Type in “Kindergarten coverage” as the series-name. In label, choose Municipality, then County then Name under “Kindergarten coverage”.<br>In value, select “Kindergarten coverage”.<br>In Group By, make the same selection as in Label. In the drop-down box “Value”, choose Avg.<br> [[Image:Tutorial 2 bilde 13.jpg]]<br>Press “Add new series configuration” and do the same for Sick leave.<br> [[Image:Tutorial 2 bilde 14.jpg]]<br>Press Save and wait. After some seconds, this screen should show up:  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 15.jpg]]<br>We can now view information about kindergarten coverage and sick leave in three counties, based on the municipalities!<br> <br>There is one huge problem about this procedure. Let’s say you want to view just information about one year, and create a filter for years. We make the filter, and select 2007. Now we can just view graphs only for sick leave or from kindergarten coverage. So you can’t actually compare the counties in just one year. Anzo calculates the average over the years:<br>  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 15.jpg]]<br>We can now view information about kindergarten coverage and sick leave in three counties, based on the municipalities!<br> <br>There is one huge problem about this procedure. Let’s say you want to view just information about one year, and create a filter for years. We make the filter, and select 2007. Now we can just view graphs only for sick leave or from kindergarten coverage. So you can’t actually compare the counties in just one year. Anzo calculates the average over the years:<br>  </div></td></tr>
</table>Haavarot@uio.nohttps://wiki.uio.no/mn/ifi/camsem/index.php?title=Tutorial2&diff=85&oldid=prevHaavarot@uio.no på 29. jun. 2010 kl. 14:442010-06-29T14:44:51Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='nb'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Eldre revisjon</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revisjonen fra 29. jun. 2010 kl. 14:44</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l19" >Linje 19:</td>
<td colspan="2" class="diff-lineno">Linje 19:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 2.jpg]]<br> Chose the menu-option “Link the active workbook”. Select the proper Data Set which you created in the previous step. Under Type, select Municipality (the class) below Geography (the ontology). Make sure the orientation is set to row, and that the Headers-option is correct. Select the property Name, and then hook off the check-box “Search on Name”. The Name-property should now look like the picture below. (Please ignore properties in the picture which don’t exist in your own ontology.)<br> [[Image:Tutorial 2 bilde 3.jpg]]<br>Next, double-click on County, select Name and press “Search on name”.<br> <br> [[Image:Tutorial 2 bilde 4.jpg]]<br>Press the Upload-button, and the data should be uploaded. You may be prompted with the following:  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 2.jpg]]<br> Chose the menu-option “Link the active workbook”. Select the proper Data Set which you created in the previous step. Under Type, select Municipality (the class) below Geography (the ontology). Make sure the orientation is set to row, and that the Headers-option is correct. Select the property Name, and then hook off the check-box “Search on Name”. The Name-property should now look like the picture below. (Please ignore properties in the picture which don’t exist in your own ontology.)<br> [[Image:Tutorial 2 bilde 3.jpg]]<br>Next, double-click on County, select Name and press “Search on name”.<br> <br> [[Image:Tutorial 2 bilde 4.jpg]]<br>Press the Upload-button, and the data should be uploaded. You may be prompted with the following:  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 5.jpg]]<br> <br><del class="diffchange diffchange-inline">Please hook on </del>“Add key values from the workbook to this Municipality” and double-click on “Auto create a new Municipality”. <del class="diffchange diffchange-inline">Similar </del>must be done for County.  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 5.jpg]]<br> <br><ins class="diffchange diffchange-inline">Hook off </ins>“Add key values from the workbook to this Municipality” and double-click on “Auto create a new Municipality”. <ins class="diffchange diffchange-inline">The same </ins>must be done for County.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 2: Making the connections between quarters and years'''<br>The procedure here is <del class="diffchange diffchange-inline">quite the same as for </del>municipalities and <del class="diffchange diffchange-inline">states</del>. Make an ontology for <del class="diffchange diffchange-inline">time</del>, name it <del class="diffchange diffchange-inline">i.e. </del>Time periods. Make a class for Year and a class for Quarter, and let Quarter have a Year-property, pointing to its proper year. Also make two literal properties for quarter, one for the number of the quarter, and one for textual representation of year and quarter. Also add a literal property for the year in the Year-class.  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 2: Making the connections between quarters and years'''<br>The procedure here is <ins class="diffchange diffchange-inline">very similar to </ins>municipalities and <ins class="diffchange diffchange-inline">counties</ins>. Make an ontology for <ins class="diffchange diffchange-inline">Time</ins>, name it<ins class="diffchange diffchange-inline">, for instance, "</ins>Time periods<ins class="diffchange diffchange-inline">"</ins>. Make a class for Year and a class for Quarter, and let Quarter have a Year-property, pointing to its proper year. Also make two literal properties for quarter, one for the number of the quarter, and one for textual representation of year and quarter. Also add a literal property for the year in the Year-class.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 6.jpg]]<br> <br>The statistics we will use in this tutorial represent quarters as a string with the year and the quarter thus: “2007Q1”. We will then need a table matching years with the respective quarters. We have included such a table in the “Tutorial 2.xls”-file:<br> [[Image:Tutorial 2 bilde 7.jpg]]<br>With the values under the Quarter-row, we are able to sum up values for on quarter, across the years, in a graph. This enables us to view graphs based on quarters, and compare the quarters with each other.<br>Upload the table in the same fashion you uploaded the data for municipalities and <del class="diffchange diffchange-inline">conties</del>.  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 6.jpg]]<br> <br>The statistics we will use in this tutorial represent quarters as a string with the year and the quarter thus: “2007Q1”. We will then need a table matching years with the respective quarters. We have included such a table in the “Tutorial 2.xls”-file:<br> [[Image:Tutorial 2 bilde 7.jpg]]<br>With the values under the Quarter-row, we are able to sum up values for on quarter, across the years, in a graph. This enables us to view graphs based on quarters, and compare the quarters with each other.<br>Upload the table in the same fashion you uploaded the data for municipalities and <ins class="diffchange diffchange-inline">counties</ins>.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 3: Adding statistics'''<br>''3.1 The ontology for the statistics''<br>Make an ontology representing all the data you want to cover. In our case we are using statistics from Statistisk Sentralbyrå (SSB), a.k.a. Statistics Norway. We named the ontology SSB Data. We want to upload statistics about kindergarten coverage and authorized sick leave (obviously to see if there is some kind of connections between these <del class="diffchange diffchange-inline">phenomenon’s</del>). <br>  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 3: Adding statistics'''<br>''3.1 The ontology for the statistics''<br>Make an ontology representing all the data you want to cover. In our case we are using statistics from Statistisk Sentralbyrå (SSB), a.k.a. Statistics Norway. We named the ontology SSB Data. We want to upload statistics about kindergarten coverage and authorized sick leave (obviously to see if there is some kind of connections between these <ins class="diffchange diffchange-inline">two</ins>). <br>  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 8.jpg]]<br>The process of making classes and properties should be familiar by now. Make a class for each of the <del class="diffchange diffchange-inline">subject </del>you have statitics <del class="diffchange diffchange-inline">about</del>. Add municipality-properties to both the Sick Leave and Kindergarten-classes, a Quarter-property for Sick Leave, a Year-property for Kindergarten. All of these should have their respective ranges set to the proper classes from the Geography and Time periods-ontologies. Add one literal-property belonging to each class with a suitable name, and make the range of it a Double.<br>You may also want to make <del class="diffchange diffchange-inline">a </del>ontology for Demographics at this point, since the statistics about Sick Leave <del class="diffchange diffchange-inline">also have data about the </del>gender. You could also just make this property a literal for this exercise, as we have done above.  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 8.jpg]]<br>The process of making classes and properties should be familiar by now. Make a class for each of the <ins class="diffchange diffchange-inline">subjects </ins>you have statitics <ins class="diffchange diffchange-inline">on</ins>. Add municipality-properties to both the Sick Leave and Kindergarten-classes, a Quarter-property for Sick Leave, a Year-property for Kindergarten. All of these should have their respective ranges set to the proper classes from the Geography and Time periods-ontologies. Add one literal-property belonging to each class with a suitable name, and make the range of it a Double.<br>You may also want to make <ins class="diffchange diffchange-inline">an </ins>ontology for Demographics at this point, since the statistics about Sick Leave <ins class="diffchange diffchange-inline">are specified by </ins>gender. You could also just make this property a literal for this exercise, as we have done above.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>''3.2 Uploading your data''<br>Go to the Worksheet with the data about Sick Leave. Select the proper Data Set and then, under Type, select the proper class. Tag the data in your worksheet, the result should look like the below.  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>''3.2 Uploading your data''<br>Go to the Worksheet with the data about Sick Leave. Select the proper Data Set and then, under Type, select the proper class. Tag the data in your worksheet, the result should look like the <ins class="diffchange diffchange-inline">example </ins>below.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 9.jpg]]<br> <br>Click Upload, and wait <del class="diffchange diffchange-inline">for it</del>.<br>Do the <del class="diffchange diffchange-inline">similar </del>operations for the data about Kindergarten Coverage:  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 9.jpg]]<br> <br>Click Upload, and wait <ins class="diffchange diffchange-inline">while the data is being uploaded</ins>.<br>Do the <ins class="diffchange diffchange-inline">same </ins>operations for the data about Kindergarten Coverage:  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 10.jpg]]<br> <br>'''4. Inspecting the statistics in Anzo on the Web'''<br>We now want to create a view in Anzo on the Web, so we can inspect our lovely data in the form of graphs. Log in to your Anzo on the Web-homepage and select Create a new view. Type in a <del class="diffchange diffchange-inline">nice </del>title and press OK.<br> [[Image:Tutorial 2 bilde 11.jpg]]<br>Add the dataset which contains data about Sick Leave and Kindergarten coverage, by clicking Add Linked Data Sets, search for the Data Set, click it and press OK.<br>Select the types of data you want to see. This would be Kindergarten Coverage and Sick Leave.<br>Create a new lense (from template), choose the chart-template, and give it a cool name as title. Choose Column, and press OK. <br> [[Image:Tutorial 2 bilde 12.jpg]]<br>Choose Column and press OK. In the next window, hook on that you want to see the legend. <br>[[Image:Tutorial 2 bilde 17.jpg]]<br>Then go to the Data-tab on the left. Type in “Kindergarten coverage” as the series-name. In label, choose Municipality, then County then Name under “Kindergarten coverage”.<br>In value, select “Kindergarten coverage”.<br>In Group By, make the same selection as in Label. In the drop-down box “Value”, choose Avg.<br> [[Image:Tutorial 2 bilde 13.jpg]]<br>Press “Add new series configuration” and do the same for Sick leave.<br> [[Image:Tutorial 2 bilde 14.jpg]]<br>Press Save and wait. After some seconds, this screen should show up:  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 10.jpg]]<br> <br>'''4. Inspecting the statistics in Anzo on the Web'''<br>We now want to create a view in Anzo on the Web, so we can inspect our lovely data in the form of graphs. Log in to your Anzo on the Web-homepage and select <ins class="diffchange diffchange-inline">"</ins>Create a new view<ins class="diffchange diffchange-inline">"</ins>. Type in a title and press OK.<br> [[Image:Tutorial 2 bilde 11.jpg]]<br>Add the dataset which contains data about Sick Leave and Kindergarten coverage, by clicking Add Linked Data Sets, search for the Data Set, click it and press OK.<br>Select the types of data you want to see. This would be Kindergarten Coverage and Sick Leave.<br>Create a new lense (from template), choose the chart-template, and give it a cool name as title. Choose Column, and press OK. <br> [[Image:Tutorial 2 bilde 12.jpg]]<br>Choose Column and press OK. In the next window, hook on that you want to see the legend. <br>[[Image:Tutorial 2 bilde 17.jpg]]<br>Then go to the Data-tab on the left. Type in “Kindergarten coverage” as the series-name. In label, choose Municipality, then County then Name under “Kindergarten coverage”.<br>In value, select “Kindergarten coverage”.<br>In Group By, make the same selection as in Label. In the drop-down box “Value”, choose Avg.<br> [[Image:Tutorial 2 bilde 13.jpg]]<br>Press “Add new series configuration” and do the same for Sick leave.<br> [[Image:Tutorial 2 bilde 14.jpg]]<br>Press Save and wait. After some seconds, this screen should show up:  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 15.jpg]]<br>We can now view information about kindergarten coverage and sick leave in three counties, based on the municipalities!<br> <br>There is one huge problem about this procedure. Let’s say you want to view just information about one year, and create a filter for years. We make the filter, and select 2007. Now we can just view graphs only for sick leave or from kindergarten coverage. So you can’t actually compare the counties in just one year. Anzo calculates the average over the years:<br>  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 15.jpg]]<br>We can now view information about kindergarten coverage and sick leave in three counties, based on the municipalities!<br> <br>There is one huge problem about this procedure. Let’s say you want to view just information about one year, and create a filter for years. We make the filter, and select 2007. Now we can just view graphs only for sick leave or from kindergarten coverage. So you can’t actually compare the counties in just one year. Anzo calculates the average over the years:<br>  </div></td></tr>
</table>Haavarot@uio.nohttps://wiki.uio.no/mn/ifi/camsem/index.php?title=Tutorial2&diff=84&oldid=prevHaavarot@uio.no på 29. jun. 2010 kl. 14:322010-06-29T14:32:29Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='nb'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Eldre revisjon</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revisjonen fra 29. jun. 2010 kl. 14:32</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l9" >Linje 9:</td>
<td colspan="2" class="diff-lineno">Linje 9:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>mistake to think of municipality as a subclass of county. This is of course wrong; a municipality is not a kind of county, but lies within a county. Therefore, we must add a property, for instance “has County” with municipality as domain, and county as range. This is a functional property.  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>mistake to think of municipality as a subclass of county. This is of course wrong; a municipality is not a kind of county, but lies within a county. Therefore, we must add a property, for instance “has County” with municipality as domain, and county as range. This is a functional property.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>Let us make a new ontology named “Geography”, with two classes “Municipality” and “County”. The class Municipality should in this example have tree properties: Its name, its identifying number and name, and its county. The county-class needs in this example just a name-property. (The example-picture <del class="diffchange diffchange-inline">got </del>more properties, don’t worry about <del class="diffchange diffchange-inline">that </del>for this tutorial.) <br>Be sure to add the ontology to the correct Linked Data Set! For this tutorial, create a Linked Data Set with an appropriate name and be sure to add “Geography” to this Linked Data Set.  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>Let us make a new ontology named “Geography”, with two classes “Municipality” and “County”. The class Municipality should in this example have tree properties: Its name, its identifying number and name, and its county. The county-class needs<ins class="diffchange diffchange-inline">, </ins>in this example<ins class="diffchange diffchange-inline">, </ins>just a name-property. (The example-picture <ins class="diffchange diffchange-inline">has </ins>more properties, <ins class="diffchange diffchange-inline">but </ins>don’t worry about <ins class="diffchange diffchange-inline">this </ins>for this tutorial.) <br>Be sure to add the ontology to the correct Linked Data Set! For this tutorial, create a Linked Data Set with an appropriate name and be sure to add “Geography” to this Linked Data Set.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>''Step 1.2: Making the matching-table''<br><del class="diffchange diffchange-inline">Then </del>we need to make a table in Excel, matching the <del class="diffchange diffchange-inline">county and </del>the <del class="diffchange diffchange-inline">municipality by </del>their names. This tutorial should have an appendix included with such a table over the municipalities and counties in the region of Nord Norge (North of Norway) in Norway. (Tutorial 2.xls). A source for information about the relations between counties and municipalities could for instance be Wikipedia. Just make sure that all the information is correct.  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>''Step 1.2: Making the matching-table''<br><ins class="diffchange diffchange-inline">Now </ins>we need to make a table in Excel, matching the <ins class="diffchange diffchange-inline">correct counties to </ins>the <ins class="diffchange diffchange-inline">appropriate municipalities using </ins>their names. This tutorial should have an appendix included with such a table over the municipalities and counties in the region of Nord<ins class="diffchange diffchange-inline">-</ins>Norge (North of Norway) in Norway. (Tutorial 2.xls). A source for information about the relations between counties and municipalities could for instance be Wikipedia. Just make sure that all the information is correct.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>''Step 1.3: Upload the information with the ontology''<br>Finally we need to upload the data. Select the matching-table in the workbook.<br>  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>''Step 1.3: Upload the information with the ontology''<br>Finally we need to upload the data. Select the matching-table in the workbook.<br>  </div></td></tr>
</table>Haavarot@uio.nohttps://wiki.uio.no/mn/ifi/camsem/index.php?title=Tutorial2&diff=83&oldid=prevHaavarot@uio.no på 29. jun. 2010 kl. 14:282010-06-29T14:28:12Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='nb'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Eldre revisjon</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revisjonen fra 29. jun. 2010 kl. 14:28</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3" >Linje 3:</td>
<td colspan="2" class="diff-lineno">Linje 3:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>When having data for municipalities, you often want graphs about the counties they are a part of instead. In the Anzo-tools by Cambridge Semantics, this is an easy task. A quite similar strategy would work in cases where you want to show years, and have data for the months, quarters, etc. This tutorial will show you the step-by-step procedure to accomplish these tasks, both for municipalities and counties, and quarters and years.  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>When having data for municipalities, you often want graphs about the counties they are a part of instead. In the Anzo-tools by Cambridge Semantics, this is an easy task. A quite similar strategy would work in cases where you want to show years, and have data for the months, quarters, etc. This tutorial will show you the step-by-step procedure to accomplish these tasks, both for municipalities and counties, and quarters and years.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 1: Making the connections between municipality and county'''<br>''Step 1.1: Making the ontology''<br>First off, we need the ontology <del class="diffchange diffchange-inline">who says </del>something about the relation between counties and municipalities. When making such an ontology, it is a common&nbsp;  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 1: Making the connections between municipality and county'''<br>''Step 1.1: Making the ontology''<br>First off, we need the ontology <ins class="diffchange diffchange-inline">to say </ins>something about the relation between counties and municipalities. When making such an ontology, it is a common&nbsp;  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 1.jpg|right]]  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Tutorial 2 bilde 1.jpg|right]]  </div></td></tr>
</table>Haavarot@uio.nohttps://wiki.uio.no/mn/ifi/camsem/index.php?title=Tutorial2&diff=53&oldid=prevLarsereb@uio.no på 28. jun. 2010 kl. 15:102010-06-28T15:10:28Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='nb'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Eldre revisjon</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revisjonen fra 28. jun. 2010 kl. 15:10</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3" >Linje 3:</td>
<td colspan="2" class="diff-lineno">Linje 3:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>When having data for municipalities, you often want graphs about the counties they are a part of instead. In the Anzo-tools by Cambridge Semantics, this is an easy task. A quite similar strategy would work in cases where you want to show years, and have data for the months, quarters, etc. This tutorial will show you the step-by-step procedure to accomplish these tasks, both for municipalities and counties, and quarters and years.  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>When having data for municipalities, you often want graphs about the counties they are a part of instead. In the Anzo-tools by Cambridge Semantics, this is an easy task. A quite similar strategy would work in cases where you want to show years, and have data for the months, quarters, etc. This tutorial will show you the step-by-step procedure to accomplish these tasks, both for municipalities and counties, and quarters and years.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 1: Making the connections between municipality and county'''<br>''Step 1.1: Making the ontology''<br>First off, we need the ontology who says something about the relation between counties and municipalities. When making such an ontology, it is a common&nbsp;</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 1: Making the connections between municipality and county'''<br>''Step 1.1: Making the ontology''<br>First off, we need the ontology who says something about the relation between counties and municipalities. When making such an ontology, it is a common&nbsp;  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_1</del>.jpg|right]]</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 1</ins>.jpg|right]]  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>mistake to think of municipality as a subclass of county. This is of course wrong; a municipality is not a kind of county, but lies within a county. Therefore, we must add a property, for instance “has County” with municipality as domain, and county as range. This is a functional property.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>mistake to think of municipality as a subclass of county. This is of course wrong; a municipality is not a kind of county, but lies within a county. Therefore, we must add a property, for instance “has County” with municipality as domain, and county as range. This is a functional property.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>Let us make a new ontology named “Geography”, with two classes “Municipality” and “County”. The class Municipality should in this example have tree properties: Its name, its identifying number and name, and its county. The county-class needs in this example just a name-property. (The example-picture got more properties, don’t worry about that for this tutorial.) <br>Be sure to add the ontology to the correct Linked Data Set! For this tutorial, create a Linked Data Set with an appropriate name and be sure to add “Geography” to this Linked Data Set.  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>Let us make a new ontology named “Geography”, with two classes “Municipality” and “County”. The class Municipality should in this example have tree properties: Its name, its identifying number and name, and its county. The county-class needs in this example just a name-property. (The example-picture got more properties, don’t worry about that for this tutorial.) <br>Be sure to add the ontology to the correct Linked Data Set! For this tutorial, create a Linked Data Set with an appropriate name and be sure to add “Geography” to this Linked Data Set.  </div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l15" >Linje 15:</td>
<td colspan="2" class="diff-lineno">Linje 15:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>''Step 1.3: Upload the information with the ontology''<br>Finally we need to upload the data. Select the matching-table in the workbook.<br>  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>''Step 1.3: Upload the information with the ontology''<br>Finally we need to upload the data. Select the matching-table in the workbook.<br>  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"><br> </ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Image:Tutorial 2 bilde 2.jpg]]<br> Chose the menu-option “Link the active workbook”. Select the proper Data Set which you created in the previous step. Under Type, select Municipality (the class) below Geography (the ontology). Make sure the orientation is set to row, and that the Headers-option is correct. Select the property Name, and then hook off the check-box “Search on Name”. The Name-property should now look like the picture below. (Please ignore properties in the picture which don’t exist in your own ontology.)<br> [[Image:Tutorial 2 bilde 3.jpg]]<br>Next, double-click on County, select Name and press “Search on name”.<br> <br> [[Image:Tutorial 2 bilde 4.jpg]]<br>Press the Upload-button, and the data should be uploaded. You may be prompted with the following: </ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_2</del>.jpg]]<br> <del class="diffchange diffchange-inline">Chose the menu-option “Link </del>the <del class="diffchange diffchange-inline">active workbook”. Select the proper Data Set which you created in the previous step. Under Type, select Municipality (the class) below Geography (the ontology). Make sure the orientation is set </del>to <del class="diffchange diffchange-inline">row, </del>and <del class="diffchange diffchange-inline">that the Headers-option is correct. Select the property Name, and then hook off the check-box “Search on Name”. The Name-property should now look like the picture below. (Please ignore properties in the picture which don’t exist in your own ontology.)<br> [[Image:Tutorial_2_bilde_3.jpg]]<br>Next, </del>double-click on <del class="diffchange diffchange-inline">County, select Name and press “Search on name”.<br> <br> [[Image:Tutorial_2_bilde_4</del>.<del class="diffchange diffchange-inline">jpg]]<br>Press the Upload-button, and the data should </del>be <del class="diffchange diffchange-inline">uploaded</del>. <del class="diffchange diffchange-inline">You may be prompted with the following:</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 5</ins>.jpg]]<br> <ins class="diffchange diffchange-inline"><br>Please hook on “Add key values from </ins>the <ins class="diffchange diffchange-inline">workbook </ins>to <ins class="diffchange diffchange-inline">this Municipality” </ins>and double-click on <ins class="diffchange diffchange-inline">“Auto create a new Municipality”</ins>. <ins class="diffchange diffchange-inline">Similar must </ins>be <ins class="diffchange diffchange-inline">done for County</ins>.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">[[Image:Tutorial_2_bilde_5.jpg]]</del><br> <br><del class="diffchange diffchange-inline">Please hook on “Add key values from </del>the <del class="diffchange diffchange-inline">workbook </del>to <del class="diffchange diffchange-inline">this Municipality” </del>and <del class="diffchange diffchange-inline">double-click on “Auto create </del>a <del class="diffchange diffchange-inline">new Municipality”. Similar must be done </del>for <del class="diffchange diffchange-inline">County</del>.  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br><ins class="diffchange diffchange-inline">'''Step 2: Making the connections between quarters and years'''</ins><br><ins class="diffchange diffchange-inline">The procedure here is quite </ins>the <ins class="diffchange diffchange-inline">same as for municipalities and states. Make an ontology for time, name it i.e. Time periods. Make a class for Year and a class for Quarter, and let Quarter have a Year-property, pointing </ins>to <ins class="diffchange diffchange-inline">its proper year. Also make two literal properties for quarter, one for the number of the quarter, and one for textual representation of year </ins>and <ins class="diffchange diffchange-inline">quarter. Also add </ins>a <ins class="diffchange diffchange-inline">literal property </ins>for <ins class="diffchange diffchange-inline">the year in the Year-class</ins>.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"><br>'''Step 2: Making the connections between quarters and years'''<br>The procedure here is quite the same as for municipalities and states. Make an ontology for time, name it i.e. Time periods. Make a class for Year and a class for Quarter, and let Quarter have a Year-property, pointing to its proper year. Also make two literal properties for quarter, one for the number of the quarter, and one for textual representation of year and quarter. Also add a literal property for the year in the Year-class.</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 6</ins>.jpg]]<br> <br>The statistics we will use in this tutorial represent quarters as a string with the year and the quarter thus: “2007Q1”. We will then need a table matching years with the respective quarters. We have included such a table in the “Tutorial 2.xls”-file:<br> [[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 7</ins>.jpg]]<br>With the values under the Quarter-row, we are able to sum up values for on quarter, across the years, in a graph. This enables us to view graphs based on quarters, and compare the quarters with each other.<br>Upload the table in the same fashion you uploaded the data for municipalities and conties.  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_6</del>.jpg]]<br> <br>The statistics we will use in this tutorial represent quarters as a string with the year and the quarter thus: “2007Q1”. We will then need a table matching years with the respective quarters. We have included such a table in the “Tutorial 2.xls”-file:<br> [[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_7</del>.jpg]]<br>With the values under the Quarter-row, we are able to sum up values for on quarter, across the years, in a graph. This enables us to view graphs based on quarters, and compare the quarters with each other.<br>Upload the table in the same fashion you uploaded the data for municipalities and conties.  </div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 3: Adding statistics'''<br>''3.1 The ontology for the statistics''<br>Make an ontology representing all the data you want to cover. In our case we are using statistics from Statistisk Sentralbyrå (SSB), a.k.a. Statistics Norway. We named the ontology SSB Data. We want to upload statistics about kindergarten coverage and authorized sick leave (obviously to see if there is some kind of connections between these phenomenon’s). <br>  </div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 3: Adding statistics'''<br>''3.1 The ontology for the statistics''<br>Make an ontology representing all the data you want to cover. In our case we are using statistics from Statistisk Sentralbyrå (SSB), a.k.a. Statistics Norway. We named the ontology SSB Data. We want to upload statistics about kindergarten coverage and authorized sick leave (obviously to see if there is some kind of connections between these phenomenon’s). <br>  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_8</del>.jpg]]<br>The process of making classes and properties should be familiar by now. Make a class for each of the subject you have statitics about. Add municipality-properties to both the Sick Leave and Kindergarten-classes, a Quarter-property for Sick Leave, a Year-property for Kindergarten. All of these should have their respective ranges set to the proper classes from the Geography and Time periods-ontologies. Add one literal-property belonging to each class with a suitable name, and make the range of it a Double.<br>You may also want to make a ontology for Demographics at this point, since the statistics about Sick Leave also have data about the gender. You could also just make this property a literal for this exercise, as we have done above.  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 8</ins>.jpg]]<br>The process of making classes and properties should be familiar by now. Make a class for each of the subject you have statitics about. Add municipality-properties to both the Sick Leave and Kindergarten-classes, a Quarter-property for Sick Leave, a Year-property for Kindergarten. All of these should have their respective ranges set to the proper classes from the Geography and Time periods-ontologies. Add one literal-property belonging to each class with a suitable name, and make the range of it a Double.<br>You may also want to make a ontology for Demographics at this point, since the statistics about Sick Leave also have data about the gender. You could also just make this property a literal for this exercise, as we have done above.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>''3.2 Uploading your data''<br>Go to the Worksheet with the data about Sick Leave. Select the proper Data Set and then, under Type, select the proper class. Tag the data in your worksheet, the result should look like the below.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>''3.2 Uploading your data''<br>Go to the Worksheet with the data about Sick Leave. Select the proper Data Set and then, under Type, select the proper class. Tag the data in your worksheet, the result should look like the below.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_9</del>.jpg]]<br> <br>Click Upload, and wait for it.<br>Do the similar operations for the data about Kindergarten Coverage:</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 9</ins>.jpg]]<br> <br>Click Upload, and wait for it.<br>Do the similar operations for the data about Kindergarten Coverage:  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_10</del>.jpg]]<br> <br>'''4. Inspecting the statistics in Anzo on the Web'''<br>We now want to create a view in Anzo on the Web, so we can inspect our lovely data in the form of graphs. Log in to your Anzo on the Web-homepage and select Create a new view. Type in a nice title and press OK.<br> [[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_11</del>.jpg]]<br>Add the dataset which contains data about Sick Leave and Kindergarten coverage, by clicking Add Linked Data Sets, search for the Data Set, click it and press OK.<br>Select the types of data you want to see. This would be Kindergarten Coverage and Sick Leave.<br>Create a new lense (from template), choose the chart-template, and give it a cool name as title. Choose Column, and press OK. <br> [[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_12</del>.jpg]]<br>Choose Column and press OK. In the next window, hook on that you want to see the legend. <br>[[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_17</del>.jpg]]<br>Then go to the Data-tab on the left. Type in “Kindergarten coverage” as the series-name. In label, choose Municipality, then County then Name under “Kindergarten coverage”.<br>In value, select “Kindergarten coverage”.<br>In Group By, make the same selection as in Label. In the drop-down box “Value”, choose Avg.<br> [[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_13</del>.jpg]]<br>Press “Add new series configuration” and do the same for Sick leave.<br> [[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_14</del>.jpg]]<br>Press Save and wait. After some seconds, this screen should show up:  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 10</ins>.jpg]]<br> <br>'''4. Inspecting the statistics in Anzo on the Web'''<br>We now want to create a view in Anzo on the Web, so we can inspect our lovely data in the form of graphs. Log in to your Anzo on the Web-homepage and select Create a new view. Type in a nice title and press OK.<br> [[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 11</ins>.jpg]]<br>Add the dataset which contains data about Sick Leave and Kindergarten coverage, by clicking Add Linked Data Sets, search for the Data Set, click it and press OK.<br>Select the types of data you want to see. This would be Kindergarten Coverage and Sick Leave.<br>Create a new lense (from template), choose the chart-template, and give it a cool name as title. Choose Column, and press OK. <br> [[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 12</ins>.jpg]]<br>Choose Column and press OK. In the next window, hook on that you want to see the legend. <br>[[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 17</ins>.jpg]]<br>Then go to the Data-tab on the left. Type in “Kindergarten coverage” as the series-name. In label, choose Municipality, then County then Name under “Kindergarten coverage”.<br>In value, select “Kindergarten coverage”.<br>In Group By, make the same selection as in Label. In the drop-down box “Value”, choose Avg.<br> [[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 13</ins>.jpg]]<br>Press “Add new series configuration” and do the same for Sick leave.<br> [[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 14</ins>.jpg]]<br>Press Save and wait. After some seconds, this screen should show up:  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_15</del>.jpg]]<br>We can now view information about kindergarten coverage and sick leave in three counties, based on the municipalities!<br> <br>There is one huge problem about this procedure. Let’s say you want to view just information about one year, and create a filter for years. We make the filter, and select 2007. Now we can just view graphs only for sick <del class="diffchange diffchange-inline">view </del>or from kindergarten coverage. So you can’t actually compare the counties in just one year. Anzo calculates the average over the years:<br>  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 15</ins>.jpg]]<br>We can now view information about kindergarten coverage and sick leave in three counties, based on the municipalities!<br> <br>There is one huge problem about this procedure. Let’s say you want to view just information about one year, and create a filter for years. We make the filter, and select 2007. Now we can just view graphs only for sick <ins class="diffchange diffchange-inline">leave </ins>or from kindergarten coverage. So you can’t actually compare the counties in just one year. Anzo calculates the average over the years:<br>  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<del class="diffchange diffchange-inline">Tutorial_2_bilde_16</del>.jpg]]</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:<ins class="diffchange diffchange-inline">Tutorial 2 bilde 16</ins>.jpg]]  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>And this concludes the second tutorial.<br></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>And this concludes the second tutorial.<br></div></td></tr>
</table>Larsereb@uio.nohttps://wiki.uio.no/mn/ifi/camsem/index.php?title=Tutorial2&diff=52&oldid=prevLarsereb@uio.no på 28. jun. 2010 kl. 15:082010-06-28T15:08:16Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='nb'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Eldre revisjon</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revisjonen fra 28. jun. 2010 kl. 15:08</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Linje 1:</td>
<td colspan="2" class="diff-lineno">Linje 1:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''Tutorial 2: Compare counties while having data for municipalities'''</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''Tutorial 2: Compare counties while having data for municipalities'''  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>When having data for municipalities, you often want graphs about the counties they are a part of instead. In the Anzo-tools by Cambridge Semantics, this is an easy task. A quite similar strategy would work in cases where you want to show years, and have data for the months, quarters, etc. This tutorial will show you the step-by-step procedure to accomplish these tasks, both for municipalities and counties, and quarters and years.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>When having data for municipalities, you often want graphs about the counties they are a part of instead. In the Anzo-tools by Cambridge Semantics, this is an easy task. A quite similar strategy would work in cases where you want to show years, and have data for the months, quarters, etc. This tutorial will show you the step-by-step procedure to accomplish these tasks, both for municipalities and counties, and quarters and years.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 1: Making the connections between municipality and county'''<br>''Step 1.1: Making the ontology''<br>First off, we need the ontology who says something about the relation between counties and municipalities. When making such an ontology, it is a common <del class="diffchange diffchange-inline">mistake to think of municipality as a subclass of county. This is of course wrong</del>; <del class="diffchange diffchange-inline">a municipality is not a kind of county, but lies within a county. Therefore, we must add a property, for instance “has County” with municipality as domain, and county as range. This is a functional property.<br>Let us make a new ontology named “Geography”, with two classes “Municipality” and “County”. The class Municipality should in this example have tree properties: Its name, its identifying number and name, and its county. The county-class needs in this example just a name-property. (The example-picture got more properties, don’t worry about that for this tutorial.) <br>Be sure to add the ontology to the correct Linked Data Set! For this tutorial, create a Linked Data Set with an appropriate name and be sure to add “Geography” to this Linked Data Set.</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>'''Step 1: Making the connections between municipality and county'''<br>''Step 1.1: Making the ontology''<br>First off, we need the ontology who says something about the relation between counties and municipalities. When making such an ontology, it is a common<ins class="diffchange diffchange-inline">&nbsp</ins>;</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"><br>''Step 1.2</del>: <del class="diffchange diffchange-inline">Making the matching-table''<br>Then we need to make a table in Excel, matching the county and the municipality by their names. This tutorial should have an appendix included with such a table over the municipalities and counties in the region of Nord Norge (North of Norway) in Norway. (Tutorial 2.xls). A source for information about the relations between counties and municipalities could for instance be Wikipedia. Just make sure that all the information is correct</del>.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[Image</ins>:<ins class="diffchange diffchange-inline">Tutorial_2_bilde_1</ins>.<ins class="diffchange diffchange-inline">jpg|right]]</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"><br>''Step 1.3: Upload the information with the ontology''<br>Finally we need </del>to <del class="diffchange diffchange-inline">upload the data</del>. <del class="diffchange diffchange-inline">Select the matching-table in the workbook.<br> <br> Chose the menu-option “Link the active workbook”. Select the proper Data Set which you created in the previous step. Under Type, select Municipality (the class) below Geography (the ontology). Make sure the orientation </del>is <del class="diffchange diffchange-inline">set to row</del>, <del class="diffchange diffchange-inline">and that the Headers-option is correct</del>. <del class="diffchange diffchange-inline">Select the property Name</del>, <del class="diffchange diffchange-inline">and then hook off the check-box “Search on Name”. The Name-</del>property <del class="diffchange diffchange-inline">should now look like the picture below. (Please ignore properties in the picture which don’t exist in your own ontology.)<br> <br>Next</del>, <del class="diffchange diffchange-inline">double-click on County</del>, <del class="diffchange diffchange-inline">select Name </del>and <del class="diffchange diffchange-inline">press “Search on name”</del>.<del class="diffchange diffchange-inline"><br> <br> <br>Press the Upload-button, and the data should be uploaded. You may be prompted with the following:<br> <br>Please hook on “Add key values from the workbook to this Municipality” and double-click on “Auto create </del>a <del class="diffchange diffchange-inline">new Municipality”. Similar must be done for County</del>.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">mistake </ins>to <ins class="diffchange diffchange-inline">think of municipality as a subclass of county</ins>. <ins class="diffchange diffchange-inline">This is of course wrong; a municipality </ins>is <ins class="diffchange diffchange-inline">not a kind of county</ins>, <ins class="diffchange diffchange-inline">but lies within a county</ins>. <ins class="diffchange diffchange-inline">Therefore</ins>, <ins class="diffchange diffchange-inline">we must add a </ins>property, <ins class="diffchange diffchange-inline">for instance “has County” with municipality as domain</ins>, and <ins class="diffchange diffchange-inline">county as range</ins>. <ins class="diffchange diffchange-inline">This is </ins>a <ins class="diffchange diffchange-inline">functional property</ins>.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br><del class="diffchange diffchange-inline">'''Step 2: Making the connections between quarters and years'''<br>The procedure here is quite the same as for municipalities and states. Make an </del>ontology <del class="diffchange diffchange-inline">for time</del>, <del class="diffchange diffchange-inline">name it i</del>.<del class="diffchange diffchange-inline">e. Time periods. Make a </del>class <del class="diffchange diffchange-inline">for Year and a class for Quarter, and let Quarter </del>have <del class="diffchange diffchange-inline">a Year-property</del>, <del class="diffchange diffchange-inline">pointing to </del>its <del class="diffchange diffchange-inline">proper year. Also make two literal properties for quarter, one for the </del>number <del class="diffchange diffchange-inline">of the quarter</del>, and <del class="diffchange diffchange-inline">one for textual representation of year and quarter</del>. <del class="diffchange diffchange-inline">Also add </del>a <del class="diffchange diffchange-inline">literal </del>property <del class="diffchange diffchange-inline">for the year in the Year-class</del>.<del class="diffchange diffchange-inline"><br> <br></del>The <del class="diffchange diffchange-inline">statistics we will use in </del>this tutorial <del class="diffchange diffchange-inline">represent quarters as a string with the year and the quarter thus: “2007Q1”. We will then need a table matching years with the respective quarters. We have included such a table in the “Tutorial 2</del>.<del class="diffchange diffchange-inline">xls”-file:</del><br> <del class="diffchange diffchange-inline"><br>With </del>the <del class="diffchange diffchange-inline">values under the Quarter-row, we are able </del>to <del class="diffchange diffchange-inline">sum up values for on quarter, across </del>the <del class="diffchange diffchange-inline">years</del>, <del class="diffchange diffchange-inline">in </del>a <del class="diffchange diffchange-inline">graph. This enables us to view graphs based on quarters, and compare the quarters </del>with <del class="diffchange diffchange-inline">each other.<br>Upload the table in the same fashion you uploaded the data for municipalities </del>and <del class="diffchange diffchange-inline">conties</del>.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br><ins class="diffchange diffchange-inline">Let us make a new </ins>ontology <ins class="diffchange diffchange-inline">named “Geography”</ins>, <ins class="diffchange diffchange-inline">with two classes “Municipality” and “County”</ins>. <ins class="diffchange diffchange-inline">The </ins>class <ins class="diffchange diffchange-inline">Municipality should in this example </ins>have <ins class="diffchange diffchange-inline">tree properties: Its name</ins>, its <ins class="diffchange diffchange-inline">identifying </ins>number <ins class="diffchange diffchange-inline">and name</ins>, and <ins class="diffchange diffchange-inline">its county</ins>. <ins class="diffchange diffchange-inline">The county-class needs in this example just </ins>a <ins class="diffchange diffchange-inline">name-</ins>property. <ins class="diffchange diffchange-inline">(</ins>The <ins class="diffchange diffchange-inline">example-picture got more properties, don’t worry about that for </ins>this tutorial.<ins class="diffchange diffchange-inline">) </ins><br><ins class="diffchange diffchange-inline">Be sure to add </ins>the <ins class="diffchange diffchange-inline">ontology </ins>to the <ins class="diffchange diffchange-inline">correct Linked Data Set! For this tutorial</ins>, <ins class="diffchange diffchange-inline">create </ins>a <ins class="diffchange diffchange-inline">Linked Data Set </ins>with <ins class="diffchange diffchange-inline">an appropriate name </ins>and <ins class="diffchange diffchange-inline">be sure to add “Geography” to this Linked Data Set</ins>.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br><del class="diffchange diffchange-inline">'</del>''Step <del class="diffchange diffchange-inline">3</del>: <del class="diffchange diffchange-inline">Adding statistics'''<br>''3.1 The ontology for </del>the <del class="diffchange diffchange-inline">statistics</del>''<br><del class="diffchange diffchange-inline">Make an ontology representing all the data you want </del>to <del class="diffchange diffchange-inline">cover. In our case we are using statistics from Statistisk Sentralbyrå (SSB)</del>, <del class="diffchange diffchange-inline">a.k.a. Statistics Norway. We named </del>the <del class="diffchange diffchange-inline">ontology SSB Data. We want to upload statistics about kindergarten coverage </del>and <del class="diffchange diffchange-inline">authorized sick leave (obviously to see if there is some kind of connections between these phenomenon’s). <br> <br>The process of making classes and properties should be familiar by now. Make a class for each of </del>the <del class="diffchange diffchange-inline">subject you have statitics about. Add </del>municipality<del class="diffchange diffchange-inline">-properties to both the Sick Leave and Kindergarten-classes, a Quarter-property for Sick Leave, a Year-property for Kindergarten</del>. <del class="diffchange diffchange-inline">All of these </del>should have <del class="diffchange diffchange-inline">their respective ranges set to the proper classes from the Geography and Time periods-ontologies. Add one literal-property belonging to each class </del>with a <del class="diffchange diffchange-inline">suitable name, </del>and <del class="diffchange diffchange-inline">make </del>the <del class="diffchange diffchange-inline">range </del>of <del class="diffchange diffchange-inline">it a Double</del>.<del class="diffchange diffchange-inline"><br>You may also want to make a ontology </del>for <del class="diffchange diffchange-inline">Demographics at this point, since the statistics about Sick Leave also have data </del>about the <del class="diffchange diffchange-inline">gender</del>. <del class="diffchange diffchange-inline">You could also just </del>make <del class="diffchange diffchange-inline">this property a literal for this exercise, as we have done above</del>.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>''Step <ins class="diffchange diffchange-inline">1.2</ins>: <ins class="diffchange diffchange-inline">Making </ins>the <ins class="diffchange diffchange-inline">matching-table</ins>''<br><ins class="diffchange diffchange-inline">Then we need </ins>to <ins class="diffchange diffchange-inline">make a table in Excel</ins>, <ins class="diffchange diffchange-inline">matching </ins>the <ins class="diffchange diffchange-inline">county </ins>and the municipality <ins class="diffchange diffchange-inline">by their names</ins>. <ins class="diffchange diffchange-inline">This tutorial </ins>should have <ins class="diffchange diffchange-inline">an appendix included </ins>with <ins class="diffchange diffchange-inline">such </ins>a <ins class="diffchange diffchange-inline">table over the municipalities </ins>and <ins class="diffchange diffchange-inline">counties in </ins>the <ins class="diffchange diffchange-inline">region </ins>of <ins class="diffchange diffchange-inline">Nord Norge (North of Norway) in Norway. (Tutorial 2.xls)</ins>. <ins class="diffchange diffchange-inline">A source </ins>for <ins class="diffchange diffchange-inline">information </ins>about the <ins class="diffchange diffchange-inline">relations between counties and municipalities could for instance be Wikipedia</ins>. <ins class="diffchange diffchange-inline">Just </ins>make <ins class="diffchange diffchange-inline">sure that all the information is correct</ins>.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>''3<del class="diffchange diffchange-inline">.2 Uploading your data''<br>Go to </del>the <del class="diffchange diffchange-inline">Worksheet </del>with the <del class="diffchange diffchange-inline">data about Sick Leave. Select the proper Data Set and then, under Type, select the proper class. Tag the data in your worksheet, the result should look like the below.<br> <br>Click Upload, and wait for it.<br>Do the similar operations for the data about Kindergarten Coverage:<br> <br>'''4. Inspecting the statistics in Anzo on the Web'</del>''<br><del class="diffchange diffchange-inline">We now want to create a view in Anzo on the Web, so </del>we <del class="diffchange diffchange-inline">can inspect our lovely data in the form of graphs. Log in </del>to <del class="diffchange diffchange-inline">your Anzo on </del>the <del class="diffchange diffchange-inline">Web-homepage and select Create a new view. Type in a nice title and press OK.<br> <br>Add the dataset which contains </del>data <del class="diffchange diffchange-inline">about Sick Leave and Kindergarten coverage, by clicking Add Linked Data Sets, search for the Data Set, click it and press OK</del>.<del class="diffchange diffchange-inline"><br></del>Select the <del class="diffchange diffchange-inline">types of data you want to see. This would be Kindergarten Coverage and Sick Leave.<br>Create a new lense (from template), choose the chart</del>-<del class="diffchange diffchange-inline">template, and give it a cool name as title. Choose Column, and press OK. <br> <br>Choose Column and press OK. In the next window, hook on that you want to see the legend. <br> <br>Then go to the Data-tab on the left. Type </del>in <del class="diffchange diffchange-inline">“Kindergarten coverage” as </del>the <del class="diffchange diffchange-inline">series-name. In label, choose Municipality, then County then Name under “Kindergarten coverage”</del>.<br><del class="diffchange diffchange-inline">In value, select “Kindergarten coverage”.<br>In Group By, make the same selection as in Label. In the drop-down box “Value”, choose Avg.<br> <br>Press “Add new series configuration” and do the same for Sick leave.<br> <br>Press Save and wait. After some seconds, this screen should show up:</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br>''<ins class="diffchange diffchange-inline">Step 1.</ins>3<ins class="diffchange diffchange-inline">: Upload </ins>the <ins class="diffchange diffchange-inline">information </ins>with the <ins class="diffchange diffchange-inline">ontology</ins>''<br><ins class="diffchange diffchange-inline">Finally </ins>we <ins class="diffchange diffchange-inline">need </ins>to <ins class="diffchange diffchange-inline">upload </ins>the data. Select the <ins class="diffchange diffchange-inline">matching</ins>-<ins class="diffchange diffchange-inline">table </ins>in the <ins class="diffchange diffchange-inline">workbook</ins>.<br>  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br>We can now view information about kindergarten coverage and sick leave in three counties, based on the municipalities!<br> <br>There is one huge problem about this procedure. Let’s say you want to view just information about one year, and create a filter for years. We make the filter, and select 2007. Now we can just view graphs only for sick view or from kindergarten coverage. So you can’t actually compare the counties in just one year. Anzo calculates the average over the years:<br>  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[Image:Tutorial_2_bilde_2.jpg]]<br> Chose the menu-option “Link the active workbook”. Select the proper Data Set which you created in the previous step. Under Type, select Municipality (the class) below Geography (the ontology). Make sure the orientation is set to row, and that the Headers-option is correct. Select the property Name, and then hook off the check-box “Search on Name”. The Name-property should now look like the picture below. (Please ignore properties in the picture which don’t exist in your own ontology.)<br> [[Image:Tutorial_2_bilde_3.jpg]]<br>Next, double-click on County, select Name and press “Search on name”.<br> <br> [[Image:Tutorial_2_bilde_4.jpg]]<br>Press the Upload-button, and the data should be uploaded. You may be prompted with the following:</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[Image:Tutorial_2_bilde_5.jpg]]<br> <br>Please hook on “Add key values from the workbook to this Municipality” and double-click on “Auto create a new Municipality”. Similar must be done for County. </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"><br>'''Step 2: Making the connections between quarters and years'''<br>The procedure here is quite the same as for municipalities and states. Make an ontology for time, name it i.e. Time periods. Make a class for Year and a class for Quarter, and let Quarter have a Year-property, pointing to its proper year. Also make two literal properties for quarter, one for the number of the quarter, and one for textual representation of year and quarter. Also add a literal property for the year in the Year-class.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[Image:Tutorial_2_bilde_6.jpg]]<br> <br>The statistics we will use in this tutorial represent quarters as a string with the year and the quarter thus: “2007Q1”. We will then need a table matching years with the respective quarters. We have included such a table in the “Tutorial 2.xls”-file:<br> [[Image:Tutorial_2_bilde_7.jpg]]<br>With the values under the Quarter-row, we are able to sum up values for on quarter, across the years, in a graph. This enables us to view graphs based on quarters, and compare the quarters with each other.<br>Upload the table in the same fashion you uploaded the data for municipalities and conties. </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"><br>'''Step 3: Adding statistics'''<br>''3.1 The ontology for the statistics''<br>Make an ontology representing all the data you want to cover. In our case we are using statistics from Statistisk Sentralbyrå (SSB), a.k.a. Statistics Norway. We named the ontology SSB Data. We want to upload statistics about kindergarten coverage and authorized sick leave (obviously to see if there is some kind of connections between these phenomenon’s). <br> </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[Image:Tutorial_2_bilde_8.jpg]]<br>The process of making classes and properties should be familiar by now. Make a class for each of the subject you have statitics about. Add municipality-properties to both the Sick Leave and Kindergarten-classes, a Quarter-property for Sick Leave, a Year-property for Kindergarten. All of these should have their respective ranges set to the proper classes from the Geography and Time periods-ontologies. Add one literal-property belonging to each class with a suitable name, and make the range of it a Double.<br>You may also want to make a ontology for Demographics at this point, since the statistics about Sick Leave also have data about the gender. You could also just make this property a literal for this exercise, as we have done above. </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"><br>''3.2 Uploading your data''<br>Go to the Worksheet with the data about Sick Leave. Select the proper Data Set and then, under Type, select the proper class. Tag the data in your worksheet, the result should look like the below.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[Image:Tutorial_2_bilde_9.jpg]]<br> <br>Click Upload, and wait for it.<br>Do the similar operations for the data about Kindergarten Coverage:</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[Image:Tutorial_2_bilde_10.jpg]]<br> <br>'''4. Inspecting the statistics in Anzo on the Web'''<br>We now want to create a view in Anzo on the Web, so we can inspect our lovely data in the form of graphs. Log in to your Anzo on the Web-homepage and select Create a new view. Type in a nice title and press OK.<br> [[Image:Tutorial_2_bilde_11.jpg]]<br>Add the dataset which contains data about Sick Leave and Kindergarten coverage, by clicking Add Linked Data Sets, search for the Data Set, click it and press OK.<br>Select the types of data you want to see. This would be Kindergarten Coverage and Sick Leave.<br>Create a new lense (from template), choose the chart-template, and give it a cool name as title. Choose Column, and press OK. <br> [[Image:Tutorial_2_bilde_12.jpg]]<br>Choose Column and press OK. In the next window, hook on that you want to see the legend. <br>[[Image:Tutorial_2_bilde_17.jpg]]<br>Then go to the Data-tab on the left. Type in “Kindergarten coverage” as the series-name. In label, choose Municipality, then County then Name under “Kindergarten coverage”.<br>In value, select “Kindergarten coverage”.<br>In Group By, make the same selection as in Label. In the drop-down box “Value”, choose Avg.<br> [[Image:Tutorial_2_bilde_13.jpg]]<br>Press “Add new series configuration” and do the same for Sick leave.<br> [[Image:Tutorial_2_bilde_14.jpg]]<br>Press Save and wait. After some seconds, this screen should show up: </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[Image:Tutorial_2_bilde_15.jpg]]</ins><br>We can now view information about kindergarten coverage and sick leave in three counties, based on the municipalities!<br> <br>There is one huge problem about this procedure. Let’s say you want to view just information about one year, and create a filter for years. We make the filter, and select 2007. Now we can just view graphs only for sick view or from kindergarten coverage. So you can’t actually compare the counties in just one year. Anzo calculates the average over the years:<br>  </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[Image:Tutorial_2_bilde_16.jpg]]</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>And this concludes the second tutorial.<br></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>And this concludes the second tutorial.<br></div></td></tr>
</table>Larsereb@uio.nohttps://wiki.uio.no/mn/ifi/camsem/index.php?title=Tutorial2&diff=31&oldid=prevLarsereb@uio.no: Ny side: '''Tutorial 2: Compare counties while having data for municipalities''' <br>When having data for municipalities, you often want graphs about the counties they are a part of instead. In the…2010-06-28T14:49:18Z<p>Ny side: '''Tutorial 2: Compare counties while having data for municipalities''' <br>When having data for municipalities, you often want graphs about the counties they are a part of instead. In the…</p>
<p><b>Ny side</b></p><div>'''Tutorial 2: Compare counties while having data for municipalities'''<br />
<br />
<br>When having data for municipalities, you often want graphs about the counties they are a part of instead. In the Anzo-tools by Cambridge Semantics, this is an easy task. A quite similar strategy would work in cases where you want to show years, and have data for the months, quarters, etc. This tutorial will show you the step-by-step procedure to accomplish these tasks, both for municipalities and counties, and quarters and years.<br />
<br />
<br>'''Step 1: Making the connections between municipality and county'''<br>''Step 1.1: Making the ontology''<br>First off, we need the ontology who says something about the relation between counties and municipalities. When making such an ontology, it is a common mistake to think of municipality as a subclass of county. This is of course wrong; a municipality is not a kind of county, but lies within a county. Therefore, we must add a property, for instance “has County” with municipality as domain, and county as range. This is a functional property.<br>Let us make a new ontology named “Geography”, with two classes “Municipality” and “County”. The class Municipality should in this example have tree properties: Its name, its identifying number and name, and its county. The county-class needs in this example just a name-property. (The example-picture got more properties, don’t worry about that for this tutorial.) <br>Be sure to add the ontology to the correct Linked Data Set! For this tutorial, create a Linked Data Set with an appropriate name and be sure to add “Geography” to this Linked Data Set.<br />
<br />
<br>''Step 1.2: Making the matching-table''<br>Then we need to make a table in Excel, matching the county and the municipality by their names. This tutorial should have an appendix included with such a table over the municipalities and counties in the region of Nord Norge (North of Norway) in Norway. (Tutorial 2.xls). A source for information about the relations between counties and municipalities could for instance be Wikipedia. Just make sure that all the information is correct.<br />
<br />
<br>''Step 1.3: Upload the information with the ontology''<br>Finally we need to upload the data. Select the matching-table in the workbook.<br> <br> Chose the menu-option “Link the active workbook”. Select the proper Data Set which you created in the previous step. Under Type, select Municipality (the class) below Geography (the ontology). Make sure the orientation is set to row, and that the Headers-option is correct. Select the property Name, and then hook off the check-box “Search on Name”. The Name-property should now look like the picture below. (Please ignore properties in the picture which don’t exist in your own ontology.)<br> <br>Next, double-click on County, select Name and press “Search on name”.<br> <br> <br>Press the Upload-button, and the data should be uploaded. You may be prompted with the following:<br> <br>Please hook on “Add key values from the workbook to this Municipality” and double-click on “Auto create a new Municipality”. Similar must be done for County.<br />
<br />
<br>'''Step 2: Making the connections between quarters and years'''<br>The procedure here is quite the same as for municipalities and states. Make an ontology for time, name it i.e. Time periods. Make a class for Year and a class for Quarter, and let Quarter have a Year-property, pointing to its proper year. Also make two literal properties for quarter, one for the number of the quarter, and one for textual representation of year and quarter. Also add a literal property for the year in the Year-class.<br> <br>The statistics we will use in this tutorial represent quarters as a string with the year and the quarter thus: “2007Q1”. We will then need a table matching years with the respective quarters. We have included such a table in the “Tutorial 2.xls”-file:<br> <br>With the values under the Quarter-row, we are able to sum up values for on quarter, across the years, in a graph. This enables us to view graphs based on quarters, and compare the quarters with each other.<br>Upload the table in the same fashion you uploaded the data for municipalities and conties.<br />
<br />
<br>'''Step 3: Adding statistics'''<br>''3.1 The ontology for the statistics''<br>Make an ontology representing all the data you want to cover. In our case we are using statistics from Statistisk Sentralbyrå (SSB), a.k.a. Statistics Norway. We named the ontology SSB Data. We want to upload statistics about kindergarten coverage and authorized sick leave (obviously to see if there is some kind of connections between these phenomenon’s). <br> <br>The process of making classes and properties should be familiar by now. Make a class for each of the subject you have statitics about. Add municipality-properties to both the Sick Leave and Kindergarten-classes, a Quarter-property for Sick Leave, a Year-property for Kindergarten. All of these should have their respective ranges set to the proper classes from the Geography and Time periods-ontologies. Add one literal-property belonging to each class with a suitable name, and make the range of it a Double.<br>You may also want to make a ontology for Demographics at this point, since the statistics about Sick Leave also have data about the gender. You could also just make this property a literal for this exercise, as we have done above.<br />
<br />
<br>''3.2 Uploading your data''<br>Go to the Worksheet with the data about Sick Leave. Select the proper Data Set and then, under Type, select the proper class. Tag the data in your worksheet, the result should look like the below.<br> <br>Click Upload, and wait for it.<br>Do the similar operations for the data about Kindergarten Coverage:<br> <br>'''4. Inspecting the statistics in Anzo on the Web'''<br>We now want to create a view in Anzo on the Web, so we can inspect our lovely data in the form of graphs. Log in to your Anzo on the Web-homepage and select Create a new view. Type in a nice title and press OK.<br> <br>Add the dataset which contains data about Sick Leave and Kindergarten coverage, by clicking Add Linked Data Sets, search for the Data Set, click it and press OK.<br>Select the types of data you want to see. This would be Kindergarten Coverage and Sick Leave.<br>Create a new lense (from template), choose the chart-template, and give it a cool name as title. Choose Column, and press OK. <br> <br>Choose Column and press OK. In the next window, hook on that you want to see the legend. <br> <br>Then go to the Data-tab on the left. Type in “Kindergarten coverage” as the series-name. In label, choose Municipality, then County then Name under “Kindergarten coverage”.<br>In value, select “Kindergarten coverage”.<br>In Group By, make the same selection as in Label. In the drop-down box “Value”, choose Avg.<br> <br>Press “Add new series configuration” and do the same for Sick leave.<br> <br>Press Save and wait. After some seconds, this screen should show up:<br />
<br />
<br>We can now view information about kindergarten coverage and sick leave in three counties, based on the municipalities!<br> <br>There is one huge problem about this procedure. Let’s say you want to view just information about one year, and create a filter for years. We make the filter, and select 2007. Now we can just view graphs only for sick view or from kindergarten coverage. So you can’t actually compare the counties in just one year. Anzo calculates the average over the years:<br> <br />
<br />
And this concludes the second tutorial.<br></div>Larsereb@uio.no