This page covers:
Analytics and Data Publishing: Overview
The Analytics and Data Publishing functionality in Amp Impact has two key components:
IATI Publishing: This feature facilitates creating XML files to publish to the International Aid Transparency Initiative (IATI) registry using the IATI Activity and IATI Organisation standards. Amp Impact has specific objects and fields for entering activity and transaction data and flows for generating XML files that can be uploaded to the IATI registry.
PowerBI templates: PowerBi is a Microsoft software for performing advanced analytics on data sets and creating dynamic dashboards. Amp Impact has a PowerBI template that can be used as a starting point for building dashboards to visualize Amp Impact data using PowerBI.
Analytics and Data Publishing: Data Model
[ADD DATA MODEL ONCE APPROVED]
In addition to this data model, the following objects have fields that may be added by the user to the object’s fieldset or page layout to account for IATI compatibility:
Account
ampi__Project__c
ampi__Project_Indicator__c
ampi__Geographical_Area__c
ampi__Project_Geographic_Area__c
ampi__Disbursement__c
ampi__Financial__c
ampi__Budget__c
ampi__Organization_Role__c
ampi__Project_Role__c
ampi__Project_Geographic_Area__c
ampi__Allocation__c
ampi__Objective__c
Analytics and Data Publishing: Summary of Key Relationships
There are three key relationships that are foundational to IATI Publishing:
IATI Sector through Project IATI Sector (junction object): This relationship enables organizations to relate specific IATI Sector records from the catalog of IATI Sectors to their Amp Impact Project/s.
IATI Policy through Project IATI Policy (junction object): This relationship enables organizations to relate specific IATI Policy records from the catalog of IATI Policies to their Amp Impact Project/s.
Transaction Project IATI Sector (junction object): This relationship enables organizations to relate Allocation, Budget, and Disbursement records to Project IATI Sector.
Here is a summary of these relationships:
Amp Object Label | Amp Object API name | Abbreviation | Object Description |
|---|---|---|---|
IATI Sector | ampi__IATI_Sector__c | None | The IATI Sector object holds the catalog of IATI-relevant sectors that can be added to Amp projects. It's only used in IATI publishing. Organizations not using IATI publishing will not use this object. |
IATI Policy | ampi__IATI_Policy__c | None | The IATI Policy object holds a catalog of IATI Policies records that can be linked to projects in Amp Impact. It's only used in IATI publishing. Organizations not using IATI publishing will not use this object. |
Project IATI Sector | ampi__Project_IATI_Sector__c | None | Project IATI Sector is a junction object storing the relationship between a Project and a specific IATI Sector in Amp. It's only used in IATI publishing. Organizations not using IATI publishing will not use this object. |
Project IATI Policy | ampi__Project_IATI_Policy__c | None | Project IATI Policy is a junction objects storing the relationship between catalog IATI Policies and Projects in Amp Impact. It's only used in IATI publishing. Organizations not using IATI publishing will not use this object. |
Transaction Project IATI Sector | ampi__Transaction_Project_IATI_Sector__c | None | Transaction Project IATI Sector is a junction object connecting Allocations, Budgets and Disbursements to Project IATI Sector. It's only used in IATI publishing. Organizations not using IATI publishing will not use this object. |