Standardising Data Analysis and Information Reporting - Revision history

Alnaucler at 11:44, 4 May 2021

2021-05-04T11:44:12Z

← Older revision		Revision as of 13:44, 4 May 2021
Line 70:		Line 70:
	\|}		\|}
	</center>		</center>
	[[Image:BI in context graph.png\|center\|700px~~\|''The different reporting options in context'~~']]		[[Image:BI in context graph.png\|center\|700px']]
	~~<div align="center">~~
	~~''The different reporting options in context''~~
	~~</div>~~

	==Basic Reporting==__NOEDITSECTION__		==Basic Reporting==__NOEDITSECTION__

Alnaucler at 11:41, 4 May 2021

2021-05-04T11:41:23Z

← Older revision		Revision as of 13:41, 4 May 2021
Line 70:		Line 70:
	\|}		\|}
	</center>		</center>
	[[Image:~~MINT~~ in context graph.png\|center\|700px\|''The different reporting options in context'']]		[[Image:BI in context graph.png\|center\|700px\|''The different reporting options in context'']]
	<div align="center">		<div align="center">
	''The different reporting options in context''		''The different reporting options in context''

Alnaucler at 11:20, 4 May 2021

2021-05-04T11:20:10Z

← Older revision		Revision as of 13:20, 4 May 2021
Line 8:		Line 8:
	{\| class="wikitable" width="1000"		{\| class="wikitable" width="1000"
	\|-		\|-
	\| align="center" colspan="7" \| '''Comparison of {{IMSMANG}} Reporting Options'''		\| align="center" colspan="6" \| '''Comparison of {{IMSMANG}} Reporting Options'''
	\|-		\|-
	\| width="20pt" \|		\| width="20pt" \|
Line 14:		Line 14:
	\| width="195pt" \| '''iReport'''		\| width="195pt" \| '''iReport'''
	\| width="195pt" \| '''Data export'''		\| width="195pt" \| '''Data export'''
	~~\| width="195pt" \| '''MINT'''~~
	\| width="195pt" \| '''Other external reporting tool'''		\| width="195pt" \| '''Other external reporting tool'''
	\|-		\|-
Line 21:		Line 20:
	\| align="left" \| Includes building iReport templates for more sophisticated reporting as well as exporting data for use in external tools such as Microsoft Excel		\| align="left" \| Includes building iReport templates for more sophisticated reporting as well as exporting data for use in external tools such as Microsoft Excel
	\| align="left" \| Includes exporting data to CSV format for use in Excel as well as cutting and pasting from tables.		\| align="left" \| Includes exporting data to CSV format for use in Excel as well as cutting and pasting from tables.
	~~\| align="left" \| Web-based reporting and data analysis tool allowing ad-hoc data exploration, creating dashboards for tracking indicators and creating reports.It is best used with the staging area.~~
	\| align="left" \| The most complicated kind of reporting where users connect to backend databases using SQL, Crystal Reports, ArcGIS Desktop, etc., to perform queries and generate reports		\| align="left" \| The most complicated kind of reporting where users connect to backend databases using SQL, Crystal Reports, ArcGIS Desktop, etc., to perform queries and generate reports
	\|-		\|-
Line 36:		Line 34:
	*Manipulating data using external tools		*Manipulating data using external tools
	*Pivot tables and charts based on one item		*Pivot tables and charts based on one item
	~~\| align="left" \|~~
	*Creating dashboards targeted to specific audiences
	*Ad-hoc online data analysis (reports and charts can be created online)
	*Creating reports online or uploading them from iReport or Jaspersoft Studio
	*Sharing data and/or dashboards/reports/chart
	*Scheduling, executing, storing and sharing reports
	\| align="left" \|		\| align="left" \|
	*Linking or exporting {{IMSMANG}} data for use in external tools		*Linking or exporting {{IMSMANG}} data for use in external tools
Line 60:		Line 52:
	*Easiest way to get {{IMSMANG}} data into Excel		*Easiest way to get {{IMSMANG}} data into Excel
	*Can manipulate data in common applications		*Can manipulate data in common applications
	~~\| align="left" \|~~
	*Several data sources can be combined or integrated
	*Roles and users can be created and permissions managed at a detail level
	*The tool can be customised for different organisations/roles/users
	\| align="left" \|		\| align="left" \|
	*Most powerful and customisable way of accessing data for reports		*Most powerful and customisable way of accessing data for reports
Line 78:		Line 66:
	*Limited customisation of resulting data (formats, conditional display, etc.)		*Limited customisation of resulting data (formats, conditional display, etc.)
	*Not ideal for incorporating multiple reports together within a larger report		*Not ideal for incorporating multiple reports together within a larger report
	~~\| align="left" \|~~
	*An decent internet connectivity needs to be available
	*Requires initial training for administrators (almost no training for end users though)
	\| align="left" \|		\| align="left" \|
	*Requires expert level understanding of SQL		*Requires expert level understanding of SQL
Line 152:		Line 137:
	{{note\|{{IMSMANG}} searches return information on only one item at a time, and data export is limited to the data returned by the search. Data from linked items (such as victim data linked to accidents) is not available for export.}}		{{note\|{{IMSMANG}} searches return information on only one item at a time, and data export is limited to the data returned by the search. Data from linked items (such as victim data linked to accidents) is not available for export.}}

	~~==Reporting Tools provided for IMSMA==__NOEDITSECTION__~~

	~~===MINT===__NOEDITSECTION__~~
	The Mine Action Intelligence Tool (MINT) is available as of {{IMSMANG}} version 6.0. It is a web-based tool for reporting, data analysis and indicator tracking. As such, it allows users to create and view digital dashboards, perform ad-hoc data analysis online in a very intuitive way, create reports and charts online, and upload reports created in a report designer tool. MINT is available on a web server managed by GICHD. Each organisation/programme/country can however manage its own space, create roles and users, manage data sources and data domains, etc. MINT is the most advanced and complete reporting solution provided for IMSMA. It is recommended to connect MINT to the [[IMSMA Staging Area]]. A more detailed description, instructions, how-to pages etc. are available on the [[MINT\|MINT pages of this WIKI]].

	~~[[Image:MINT_dashboard.png\|center\|700px\|''Example of a dashboard created in MINT'']]~~
	~~<div align="center">~~
	~~''Example of a dashboard created in MINT''~~

	~~</div>~~
	==External Reporting Tools==__NOEDITSECTION__		==External Reporting Tools==__NOEDITSECTION__
	{{IMSMANG}} also allows information managers to connect advanced reporting tools such as Crystal Reports or ArcGIS Desktop directly to its relational database for highly advanced report generation. With this capability, information managers can use custom reporting solutions to connect with {{IMSMANG}}, allowing for complete control of {{IMSMANG}} outputs. Or, managers can modify existing reporting solutions to connect to {{IMSMANG}}, which leverages technology already implemented in the programme and limits the need for retraining.		{{IMSMANG}} also allows information managers to connect advanced reporting tools such as Crystal Reports or ArcGIS Desktop directly to its relational database for highly advanced report generation. With this capability, information managers can use custom reporting solutions to connect with {{IMSMANG}}, allowing for complete control of {{IMSMANG}} outputs. Or, managers can modify existing reporting solutions to connect to {{IMSMANG}}, which leverages technology already implemented in the programme and limits the need for retraining.

Alnaucler at 19:24, 20 February 2020

2020-02-20T19:24:37Z

← Older revision		Revision as of 21:24, 20 February 2020
Line 229:		Line 229:
	{{NavBox IMSMA NG Administration}}		{{NavBox IMSMA NG Administration}}

	[[Category:~~VIE~~]]		[[Category:NAA]]

Alnaucler at 14:18, 29 May 2017

2017-05-29T14:18:45Z

← Older revision		Revision as of 16:18, 29 May 2017
Line 227:		Line 227:
	}}		}}

	{{NavBox ~~Getting started with~~ IMSMA}}		{{NavBox IMSMA NG Administration}}

	[[Category:VIE]]		[[Category:VIE]]

Alnaucler at 17:16, 9 April 2017

2017-04-09T17:16:41Z

← Older revision		Revision as of 19:16, 9 April 2017
Line 170:		Line 170:
	The process for connecting external reporting tools is essentially the same for all tools. External tools connect to the {{IMSMANG}} relational database via an ODBC connection. Information managers establish this connection by installing the ODBC driver for PGSQL. When this is complete, information managers can connect any ODBC-compliant tool to the {{IMSMANG}} database, including reporting tools, other database packages and SQL management tools. Examples include:		The process for connecting external reporting tools is essentially the same for all tools. External tools connect to the {{IMSMANG}} relational database via an ODBC connection. Information managers establish this connection by installing the ODBC driver for PGSQL. When this is complete, information managers can connect any ODBC-compliant tool to the {{IMSMANG}} database, including reporting tools, other database packages and SQL management tools. Examples include:

	Reporting tools		{\| class="wikitable"
	*Crystal Reports		! scope="col" \| Reporting tools \|\| scope="col" \| Database packages \|\| scope="col" \| SQL management tools
	*ArcGIS Desktop		\|-
	*iReport		\| Crystal Reports \|\| Microsoft Access \|\| PGSQL Query Browser
	*Microsoft Excel		\|-
	~~Database packages~~		\| ArcGIS Desktop \|\| OpenOffice Base \|\| Navicat
	*Microsoft Access		\|-
	*OpenOffice Base		\| iReport \|\| Microsoft SQL Server \|\| TOAD SQL
	*Microsoft SQL Server		\|-
	*Oracle		\| Microsoft Excel \|\| Oracle \|\| Heidi SQL
	SQL ~~management tools~~		\|}
	*PGSQL Query Browser
	*Navicat
	*TOAD SQL
	*Heidi SQL

	When connecting an external reporting tool to {{IMSMANG}}, it is recommended that information managers build database views within the database to do any necessary data transformations. While it is possible to directly import or connect {{IMSMANG}} database tables in external tools and perform transformations within the external tools, the recommended method is to do transformations within the {{IMSMANG}} database using database views and then import the resulting views into the external tools.		When connecting an external reporting tool to {{IMSMANG}}, it is recommended that information managers build database views within the database to do any necessary data transformations. While it is possible to directly import or connect {{IMSMANG}} database tables in external tools and perform transformations within the external tools, the recommended method is to do transformations within the {{IMSMANG}} database using database views and then import the resulting views into the external tools.

Alnaucler at 17:10, 9 April 2017

2017-04-09T17:10:01Z

← Older revision		Revision as of 19:10, 9 April 2017
Line 1:		Line 1:
	~~__NOEDITSECTION__~~		{{TOC right}}
	~~The primary purpose~~ of ~~any~~ information system ~~must be to~~ support operational use of the information it ~~collects~~. That’s why {{IMSMANG}} was designed with a robust reporting and analysis component that supports various reporting options. These options include:		Two of most important purposes of an information system are:
			* ensure high quality of data and
			* support operational use of the information.
			One important use of the data is reporting. If it not possible in an easy way to create reports/statistics which reflect the data correctly the credibility of the data is lost. That’s why {{IMSMANG}} was designed with a robust reporting and analysis component that supports various reporting options. These options include:

	<center>		<center>
Line 162:		Line 165:
	{{IMSMANG}} also allows information managers to connect advanced reporting tools such as Crystal Reports or ArcGIS Desktop directly to its relational database for highly advanced report generation. With this capability, information managers can use custom reporting solutions to connect with {{IMSMANG}}, allowing for complete control of {{IMSMANG}} outputs. Or, managers can modify existing reporting solutions to connect to {{IMSMANG}}, which leverages technology already implemented in the programme and limits the need for retraining.		{{IMSMANG}} also allows information managers to connect advanced reporting tools such as Crystal Reports or ArcGIS Desktop directly to its relational database for highly advanced report generation. With this capability, information managers can use custom reporting solutions to connect with {{IMSMANG}}, allowing for complete control of {{IMSMANG}} outputs. Or, managers can modify existing reporting solutions to connect to {{IMSMANG}}, which leverages technology already implemented in the programme and limits the need for retraining.

	{{note\|~~Using~~ external reporting tools ~~is a complex activity requiring an advanced understanding~~ of ~~SQL, reporting tools and~~ the {{IMSMANG}} data model.}}		{{note\|When using external reporting tools we recommend to connect to the '''[[IMSMA Staging Area \| Staging area]]''' instead of the {{IMSMANG}} database. It does require knowledge about the IMSMA data model. Contact contact your [[Information Management Team \| GICHD IM advisor]] if you have questions.}}

	===Connecting other External Reporting Tools===__NOEDITSECTION__		===Connecting other External Reporting Tools===__NOEDITSECTION__

Dionysia at 12:32, 10 January 2017

2017-01-10T12:32:25Z

← Older revision		Revision as of 14:32, 10 January 2017
Line 11:		Line 11:
	\| width="195pt" \| '''iReport'''		\| width="195pt" \| '''iReport'''
	\| width="195pt" \| '''Data export'''		\| width="195pt" \| '''Data export'''
	~~\| width="195pt" \| '''lightMINT'''~~
	\| width="195pt" \| '''MINT'''		\| width="195pt" \| '''MINT'''
	\| width="195pt" \| '''Other external reporting tool'''		\| width="195pt" \| '''Other external reporting tool'''
Line 19:		Line 18:
	\| align="left" \| Includes building iReport templates for more sophisticated reporting as well as exporting data for use in external tools such as Microsoft Excel		\| align="left" \| Includes building iReport templates for more sophisticated reporting as well as exporting data for use in external tools such as Microsoft Excel
	\| align="left" \| Includes exporting data to CSV format for use in Excel as well as cutting and pasting from tables.		\| align="left" \| Includes exporting data to CSV format for use in Excel as well as cutting and pasting from tables.
	~~\| align="left" \| Browser-based reporting tool for scheduling, executing, storing and sharing reports developed with iReport or Jaspersoft Studio. It is best used with the staging area.~~
	\| align="left" \| Web-based reporting and data analysis tool allowing ad-hoc data exploration, creating dashboards for tracking indicators and creating reports.It is best used with the staging area.		\| align="left" \| Web-based reporting and data analysis tool allowing ad-hoc data exploration, creating dashboards for tracking indicators and creating reports.It is best used with the staging area.
	\| align="left" \| The most complicated kind of reporting where users connect to backend databases using SQL, Crystal Reports, ArcGIS Desktop, etc., to perform queries and generate reports		\| align="left" \| The most complicated kind of reporting where users connect to backend databases using SQL, Crystal Reports, ArcGIS Desktop, etc., to perform queries and generate reports
Line 35:		Line 33:
	*Manipulating data using external tools		*Manipulating data using external tools
	*Pivot tables and charts based on one item		*Pivot tables and charts based on one item
	~~\| align="left" \|~~
	*Scheduling, executing, storing and sharing reports
	\| align="left" \|		\| align="left" \|
	*Creating dashboards targeted to specific audiences		*Creating dashboards targeted to specific audiences
Line 61:		Line 57:
	*Easiest way to get {{IMSMANG}} data into Excel		*Easiest way to get {{IMSMANG}} data into Excel
	*Can manipulate data in common applications		*Can manipulate data in common applications
	~~\| align="left" \|~~
	*Allows having a structured repository of reports
	*If an email server is set up, emails with reports as attachments can be sent automatically
	*Can be set up online or for an office network
	\| align="left" \|		\| align="left" \|
	*Several data sources can be combined or integrated		*Several data sources can be combined or integrated
Line 83:		Line 75:
	*Limited customisation of resulting data (formats, conditional display, etc.)		*Limited customisation of resulting data (formats, conditional display, etc.)
	*Not ideal for incorporating multiple reports together within a larger report		*Not ideal for incorporating multiple reports together within a larger report
	~~\| align="left" \|~~
	*Based on a free software, lightMINT has very limited functionality compared to MINT
	*Reports cannot be created in lightMINT directly, they need to be created in iReport or Jaspersoft Studio and then uploaded to lightMINT
	\| align="left" \|		\| align="left" \|
	*An decent internet connectivity needs to be available		*An decent internet connectivity needs to be available

Dionysia at 12:22, 10 January 2017

2017-01-10T12:22:52Z

← Older revision		Revision as of 14:22, 10 January 2017
Line 161:		Line 161:

	==Reporting Tools provided for IMSMA==__NOEDITSECTION__		==Reporting Tools provided for IMSMA==__NOEDITSECTION__

	~~===lightMINT===__NOEDITSECTION__~~
	The "light" version of MINT, the Mine Action Intelligence Tool, is available as of {{IMSMANG}} version 6.0. It is a browser-based tool for storing, executing, scheduling and sharing reports designed in iReport or Jaspersoft Studio. It can be installed locally or on a server in an office network, or if desired it can be made available over the internet. It allows user to access a structured repository of reports, schedule report executions, and share reports inside a programme or organisation. It is based on a free software and has thus limited functionality compared to MINT. It is recommended to connect MINT to the [[IMSMA Staging Area]]. A more detailed description, instructions, how-to pages etc. are available on the [[lightMINT\|lightMINT pages of this WIKI]].

	===MINT===__NOEDITSECTION__		===MINT===__NOEDITSECTION__

Alnaucler at 15:49, 24 August 2015

2015-08-24T15:49:10Z

← Older revision		Revision as of 17:49, 24 August 2015
Line 120:		Line 120:
	===iReports===__NOEDITSECTION__		===iReports===__NOEDITSECTION__
	{{HowTo's		{{HowTo's
	\|[[Use ~~i-Report~~ \| Use ~~i-Report~~]]		\|[[Use iReport \| Use iReport]]
	}}		}}
	With the iReport tool, information managers have access to an entire suite of report generation functions. iReport provides the ability to design report templates from the desired data elements; add page layout and formatting information including images, colours and text; and import the reports into {{IMSMANG}} for data entry personnel to run. Information managers can also design complex reports to summarise data using sum, count, average, subreports and other statistical reporting functions similar to packages such as Crystal Reports. Being fully integrated into {{IMSMANG}}, iReport can be translated into any language supported by the system. Using this approach, only information managers are presented with the complexity of designing reports while traditional users simply have to select a report (and any preceding search) and run it.		With the iReport tool, information managers have access to an entire suite of report generation functions. iReport provides the ability to design report templates from the desired data elements; add page layout and formatting information including images, colours and text; and import the reports into {{IMSMANG}} for data entry personnel to run. Information managers can also design complex reports to summarise data using sum, count, average, subreports and other statistical reporting functions similar to packages such as Crystal Reports. Being fully integrated into {{IMSMANG}}, iReport can be translated into any language supported by the system. Using this approach, only information managers are presented with the complexity of designing reports while traditional users simply have to select a report (and any preceding search) and run it.