Difference between revisions of "Portal:Business Intelligence/From IMSMA to MINT"

From IMSMA Wiki
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[File:Overview_IMSMA_to_MINT.png|left|400px]] What steps are concretely required in order to get information out of raw data? If {{IMSMANG}} is used for collecting and storing data, a reporting database called [[IMSMA_Staging_Area|staging area]] can be generated using the [[Staging_Area_Generator|staging area generator (SAG)]]. This is a "flat" version of the IMSMA database that is directly and easily accessible for [[MINT]], Geo-analysis tools or any [[External_Reporting_Tools|other reporting and analysis tool]], such as Tableau and Excel. If the raw data is not in IMSMA, but in another database or in spreadsheets, MINT (and other tools) can also connect to it - contact your [[Information Management Team|GICHD IM focal point]] for investigating a specific use case.
+
[[File:Overview_IMSMA_to_MINT.png|left|400px]] What steps are concretely required in order to get information out of raw data? <br/>
 +
From within the {{IMSMANG}} application it is possible to [[Export Search Result | export search results]] to Excel or using [[Use iReport | iReport]] templates with charts.
 +
 
 +
When the built in reporting functions in {{IMSMANG}} are not covering your needs then we recommend using the '''[[IMSMA_Staging_Area|Staging Area]]'''. The Staging Area is a "flat" stand-alone version of the IMSMA database especially suitable for reporting/statistics/GIS. The Staging Area database is generated by using the '''[[Staging_Area_Generator|Staging Area Generator (SAG)]]''' application.
 +
The Staging Area data is directly and easily accessible for different types of reporting and analysis tool, such as [https://www.tableau.com/ Tableau] and Excel.  
 +
 
 +
If not all data that you would like to use is not from IMSMA e.g. in another database or in spreadsheets, the tools can also connect to it - contact your '''[[Information Management Team|GICHD IM focal point]]'''.

Latest revision as of 19:58, 20 February 2020

Overview IMSMA to MINT.png
What steps are concretely required in order to get information out of raw data?

From within the IMSMANG application it is possible to export search results to Excel or using iReport templates with charts.

When the built in reporting functions in IMSMANG are not covering your needs then we recommend using the Staging Area. The Staging Area is a "flat" stand-alone version of the IMSMA database especially suitable for reporting/statistics/GIS. The Staging Area database is generated by using the Staging Area Generator (SAG) application. The Staging Area data is directly and easily accessible for different types of reporting and analysis tool, such as Tableau and Excel.

If not all data that you would like to use is not from IMSMA e.g. in another database or in spreadsheets, the tools can also connect to it - contact your GICHD IM focal point.