Difference between revisions of "Portal:Business Intelligence"

From IMSMA Wiki
Jump to: navigation, search
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Note | Illustrate the process "from an IMSMA database to a reporting solution" here, replacing the bullet points}}
+
{{Browsebar}}
 +
{| width="100%" cellpadding="5" cellspacing="10"
 +
| valign="top" style="padding: 0; margin:0;" |
  
''In this Portal BI Tool will be described.''
+
<div style="float:right; width:100%;">
''Specifically, the following topics will be addressed: Staging Area, lightMINT, MINT, external reporting tools.''
+
{{/box-header|<big>Business Intelligence</big>|{{FULLPAGENAME}}/Introduction|}}
 +
{{{{FULLPAGENAME}}/Introduction}}
 +
{{/box-footer|}}
 +
</div></div>
  
__NoTOC__
+
<div style="float:left; width:100%;">
<!--      Template Box      -->
+
{{/box-header|<big>From raw data to information</big>|{{FULLPAGENAME}}/From IMSMA to MINT|}}
{| id="mp-upper" style="width: 100%; margin:4px 0 0 0; background:none; border-spacing: 0px;"
+
{{{{FULLPAGENAME}}/From IMSMA to MINT}}
 +
{{/box-footer|}}
 +
</div></div>
  
<!--        WHAT IS MINE ACTION INTELLIGENCE      -->
+
<div style="float:right; width:100%">
| class="MainPageBG" style="width:55%; border:1px solid #cef2e0; background:#f5fffa; vertical-align:top; color:#000;" |
+
{{/box-header|<big>Topics</big>|{{FULLPAGENAME}}/Topics|}}
{| id="mp-left" style="width:100%; vertical-align:top; background:#f5fffa;"
+
{{{{FULLPAGENAME}}/Topics}}
| style="padding:2px;" | <h2 id="mp-tfa-h2" style="margin:3px; background:#cef2e0; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">What is "Mine Action Intelligence"?</h2>
+
{{/box-footer|}}
|-
+
</div></div>
| style="color:#000;" | <div id="mp-tfa" style="padding:2px 5px">Write a general intro on BI and a specific one on BI in MA here.''</div>
 
|-
 
| style="padding:2px;" | <h2 id="mp-dyk-h2" style="margin:3px; background:#cef2e0; font-size:120%; font-weight:bold; border:1px solid #a3bfb1; text-align:left; color:#000; padding:0.2em 0.4em;">MINT: the Mine action Intelligence Tool</h2>
 
|-
 
| style="color:#000; padding:2px 5px 5px;" | <div id="mp-dyk">Write an introduction to MINT here.</div>
 
|}
 
| style="border:1px solid transparent;" |
 
  
<!--        SPECIFIC TOPICS    -->
+
[[Category:NAA]]
| class="MainPageBG" style="width:45%; border:1px solid #cedff2; background:#f5faff; vertical-align:top;"|
 
{| id="mp-right" style="width:100%; vertical-align:top; background:#f5faff;"
 
| style="padding:2px;" | <h2 id="mp-itn-h2" style="margin:3px; background:#cedff2; font-size:120%; font-weight:bold; border:1px solid #a3b0bf; text-align:left; color:#000; padding:0.2em 0.4em;">Topics</h2>
 
|-
 
| style="color:#000; padding:2px 5px;" | <div id="mp-itn">
 
* [[IMSMA Staging Area]]
 
* [[lightMINT]]
 
* [[MINT]]
 
* [[External reporting tools]]</div>
 
|-
 
|}
 
|}
 

Latest revision as of 20:18, 20 February 2020

Business Intelligence

KPI.png

Business intelligence (BI) is a set of theories, methodologies, architectures, and technologies that transform raw data into meaningful and useful information [1]. While operational systems - such as IMSMANG and many others - are designed and optimised for data entry and updates, a BI system is read-only and designed for analysing and visualising data. The overall objective is to inform the decision making process, thus allow for evidence-based decision making. An important criterion of the underlying data is its quality - meaningful analysis can only be achieved if the input data is accurate, complete, and of known quality.

From raw data to information

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.