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

From IMSMA Wiki
Jump to: navigation, search
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 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 '''[[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 '''[[MINT]]''' or any [[External_Reporting_Tools|other 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, MINT (and other tools) can also connect to it - contact your '''[[Information Management Team|GICHD IM focal point]]'''.

Revision as of 10:45, 7 November 2017

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 MINT or any other 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, MINT (and other tools) can also connect to it - contact your GICHD IM focal point.