Data Mart: Setting up R

The PEARS data mart can be used in combination with R and RStudio as follows. Prerequisites Setup R can connect directly to the data mart using the RMariaDB library. Please follow these instructions carefully as the PEARS data mart requires a custom configuration file to support the required encryption. First, install the binary packages within … Read more

Data Mart Overview

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 MySQL Workbench (MySQL :: MySQL … Read more

Download a Summary Export

The Summary Export provides a high level compilation of data across most PEARS modules. Unlike other Exports in PEARS, not all related data points are included. Instead, the Summary Export provides key data points and links to records for further review. Review the instructions below for information on downloading and reviewing a Summary Export. Download … Read more

Collaborators

The following article outlines how to use the Collaborators section that is found within most PEARS modules. More information is provided in each section below. To jump to a specific section, click a link from the following list: Overview Add a Collaborator Edit a Collaborator Delete a Collaborator View Collaborator Data Overview In the Collaborators … Read more

N-PEARS Export

Hover over the Analyze menu and choose N-PEARS Export from the list below.  The N-PEARS Export filters display: Choose the correct Fiscal Year for the export.  Choose the Unit from the dropdown list provided. Optionally, choose a user within PEARS in the Reported by box. Click the checkbox in order to include only the Noteworthy Success Stories. Click the Start … Read more

Export Data

Under the Analyze menu, exports for each module are listed. Exports allows users to download data from PEARS into an Excel spreadsheet. Users can export data from records they have entered (or records they have access to view) into an Excel spreadsheet where they can perform additional analysis. Once the data is exported, users can … Read more

Export Survey Responses by Survey

Under the Analyze menu, exports for each module and for survey data are listed. Exports allows users to download data from PEARS into an Excel spreadsheet. Three types of survey exports are available in PEARS: Responses by Survey, Responses by Question, and Responses by Matched ID. Users can export data from surveys they have entered … Read more

Export Survey Responses by Question

Under the Analyze menu, exports for each module and for survey data are listed. Exports allows users to download data from PEARS into an Excel spreadsheet. Three types of survey exports are available in PEARS: Responses by Survey, Responses by Question, and Responses by Matched ID. Users can export data from surveys they have entered … Read more

Export Survey Responses by Matched ID

Under the Analyze menu, exports for each module and for survey data are listed. Exports allows users to download data from PEARS into an Excel spreadsheet. Three types of survey exports are available in PEARS: Responses by Survey, Responses by Question, and Responses by Matched ID. Users can export data from surveys they have entered … Read more

Export Site Data

Programming Managers and Organization Administrators can use the Manage Sites page to add, edit, merge, or delete sites. Staff with these roles can also mark sites inactive and export site data. Exporting site data allows you to review site details in bulk. The following article provides more information on exporting site data from PEARS. To jump … Read more