NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
In each participant's organisation, a Data Source named '''Staging Area Tajikistan''' has been created. A domain called '''Land''' has been created in the /Ad Hoc Components/Domains folder in each organization's repository. This domain contains attributes of Land (hazards) from the IMSMA staging area from Tajikistan. <br />
Create an Ad Hoc View based on the Land Domain and get familiar with the available data. Then, explore the data in more detail in order to find answers to the following questions:
== Exploring the Land Domain ==__NOEDITSECTION__
<ol>
<li>How many hazards are there in total, by status?</li>
<li>Before producing a chart, describe the relationship between a hazard and devices (in terms of one-to-one, one-to-many, etc.). What could that mean for the analysis. ''Hint: have a closer look at the hazard with the ID '''HZ TJ-24''' for example.</li>
<li>What is the issue here and how could it be solved? After thoughts and discussion, click [[MINT Example Contamination Type|here]] for a possible solution.</li>
<li>Are there any other interesting measures/indicators that you would like to show based on the available data?</li>
</ol>
== Including Activities (hazard reduction) ==__NOEDITSECTION__
Now that we have explored the Land attributes, we would like to analyse which activities have been carried out on the hazards.
<ol>
<li>Edit the Land domain and include attributes from activities</li>
<ol>
<li>Which tables do you need to join to the existing ones? Take into account that we would like to look into NTS efficiency, thus numbers of devices are an interesting measure too.</li>
<li>Inspect the available attributes for activities and choose pertinent ones.</li>
<li>Create a new set with activity attributes, at the same level as the ''Land'' set (not a sub-set)</li>
</ol>
<li>Test and explore the domain, dragging attributes from Land only, from Activity only, and then from both sets.</li>
</ol>
