MINT Examples and Exercises - Revision history

Alnaucler at 19:19, 20 February 2020

2020-02-20T19:19:28Z

← Older revision		Revision as of 21:19, 20 February 2020
Line 62:		Line 62:
	</ol>		</ol>

	{{NavBox ~~Business Intelligence~~}}		{{NavBox Hub}}
	~~[[Category:VIE]]~~
	[[Category:NoPublic]]		[[Category:NoPublic]]

Evinek at 07:31, 16 October 2014

2014-10-16T07:31:27Z

@@ Line 4: / Line 4: @@
 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>

Evinek at 06:36, 16 October 2014

2014-10-16T06:36:12Z

← Older revision		Revision as of 08:36, 16 October 2014
Line 31:		Line 31:
	<ol>		<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>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. ''Hint: be sure to include the following:''</li>		<li>Inspect the available attributes for activities and choose pertinent ones. ''Hint: be sure to include the following (and others):''</li>
	<ul>		<ul>
	<li>end_report_period</li>		<li>end_report_period</li>

Evinek at 06:35, 16 October 2014

2014-10-16T06:35:52Z

← Older revision		Revision as of 08:35, 16 October 2014
Line 31:		Line 31:
	<ol>		<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>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>Inspect the available attributes for activities and choose pertinent ones. ''Hint: be sure to include the following:''</li>
			<ul>
			<li>end_report_period</li>
			<li>reduced_manual</li>
			<li>cleared_manual</li>
			<li>cleared_mdd</li>
			<li>area_released</li>
			<li>type_of_report</li>
			</ul>
	<li>Create a new set with activity attributes, at the same level as the ''Land'' set (not a sub-set)</li>		<li>Create a new set with activity attributes, at the same level as the ''Land'' set (not a sub-set)</li>
	</ol>		</ol>

Evinek at 06:32, 16 October 2014

2014-10-16T06:32:44Z

@@ Line 3: / Line 3: @@
 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:
 <ol>
 <li>How many hazards are there in total, by status?</li>
@@ Line 20: / Line 22: @@
 <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>
 </ol>

Evinek at 06:02, 16 October 2014

2014-10-16T06:02:42Z

← Older revision		Revision as of 08:02, 16 October 2014
Line 19:		Line 19:
	<li>Edit the domain and add the required data</li>		<li>Edit the domain and add the required data</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>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?</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>
	</ol>		</ol>

Evinek at 20:16, 15 October 2014

2014-10-15T20:16:56Z

← Older revision		Revision as of 22:16, 15 October 2014
Line 12:		Line 12:
	<li>Based on the data available in the Land domain, which organisations seem to be active in the country?</li>		<li>Based on the data available in the Land domain, which organisations seem to be active in the country?</li>
	<li>Show the extent of contamination by province in an appropriate chart</li>		<li>Show the extent of contamination by province in an appropriate chart</li>
			</ol>

			One of the indicators mentioned during the brainstorming on the first day of the training is the following: '''Sqkm by province and device'''. Let's try to get this displayed step-by-step:
			<ol>
			<li>What data is missing in the Land domain to get to this indicator?</li>
			<li>Edit the domain and add the required data</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?</li>
	</ol>		</ol>

Evinek at 20:10, 15 October 2014

2014-10-15T20:10:16Z

← Older revision		Revision as of 22:10, 15 October 2014
Line 10:		Line 10:
	<li>Is this difference somehow related to the estimation method and/or the existence of a sketch map?</li>		<li>Is this difference somehow related to the estimation method and/or the existence of a sketch map?</li>
	<li>List all the open hazards that have a high priority assigned. If you had to prioritize those now, which other attribute could you consider? ''This question is not about how a prioritization should be made, but about how data can be analysed in order to inform the prioritization process''.</li>		<li>List all the open hazards that have a high priority assigned. If you had to prioritize those now, which other attribute could you consider? ''This question is not about how a prioritization should be made, but about how data can be analysed in order to inform the prioritization process''.</li>
			<li>Based on the data available in the Land domain, which organisations seem to be active in the country?</li>
			<li>Show the extent of contamination by province in an appropriate chart</li>
	</ol>		</ol>

Evinek: Created page with "{{TOC right}} 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 H..."

2014-10-15T19:55:45Z

Created page with "{{TOC right}} 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 H..."

New page

{{TOC right}}

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:
<ol>
<li>How many hazards are there in total, by status?</li>
<li>What is the total (sum) of the areasize by hazard status?</li>
<li>Same question for the calculated area?</li>
<li>Identify those hazards where the difference between the areasize and the calculated area is big. ''Hint: use a table, create a custom field, sort the records''</li>
<li>Is this difference somehow related to the estimation method and/or the existence of a sketch map?</li>
<li>List all the open hazards that have a high priority assigned. If you had to prioritize those now, which other attribute could you consider? ''This question is not about how a prioritization should be made, but about how data can be analysed in order to inform the prioritization process''.</li>
</ol>

{{NavBox Business Intelligence}}
[[Category:VIE]]
[[Category:NoPublic]]