The PEARS data mart can be used in combination with Power BI as follows. Prerequisites Setup Power BI can connect directly to the data mart using the PostgreSQL provider, npgsql. This provider and its necessary drivers are installed with Power BI Desktop and Power BI Gateway. However, before a trusted connection can be established with … Read more
The PEARS data mart can be used in combination with R and RStudio as follows. Prerequisites Setup Certificates Before a trusted connection can be established with the data mart, Amazon’s RDS certificates must be downloaded to a local folder on the device. Package Installation R can connect directly to the data mart using the RPostgres … Read more
The PEARS data mart is a read-only nightly copy of the entire set of PEARS data for your organization(s), transformed into a more readable and usable database schema. You can connect directly to your data mart database using tools like TablePlus (TablePlus | Modern, Native Tool for Database Management.) or Power BI. Or, you can … Read more
Indirect activities in PEARS feed into the Indirect Education Channels section in National PEARS. A video walkthrough of this mapping document is provided here: Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Records Excluded: Any … Read more
Success stories in PEARS feed into the Success Stories section in National PEARS. A video walkthrough of this mapping document is provided here: Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Only records with a … Read more
Program activities in PEARS generally feed into the Direct Education section of Project and Activity Results in National PEARS. A video walkthrough of this mapping document is provided here: Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked … Read more
In order to assist with the transfer of data from PEARS to National PEARS (N-PEARS), the PEARS Team has built an N-PEARS Annual Report Export from PEARS for importation into N-PEARS. The current version of the N-PEARS export is 2.0. Known Issues: None at this time. Record Types Included This documentation serves to detail out … Read more
Coalitions in PEARS feed into the Multisector Partnerships and Coalitions sub-section (in Coordination and Collaboration) of N-PEARS. A video walkthrough of this mapping document is provided here Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked … Read more
PSE site activities in PEARS feed into the PSE Change Initiatives section of Project and Activity Results in National PEARS. A video walkthrough of this mapping document is provided here: Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as … Read more
Sites in PEARS feed into the Project Sites section of Project and Activity Results in National PEARS. A video walkthrough of this mapping document is provided here: Logic Applied Records Included: Any site linked to a Program Activity, PSE Site Activity, or Success Story meeting the logic criteria for those modules will be included. Field Mapping PEARS … Read more