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 imported on each device. For further assistance, see Data Mart: Importing Certificates. Package Installation R can connect directly to the data … 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
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
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
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
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
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
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
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