Page History
To request access to Tableau, submit a ticket to the ONHRDB Service Desk.
| Expand | ||
|---|---|---|
| ||
|
Steps to Access the NEP & ONP Raw Data Report in Tableau
To run to run the NEP & ONP Raw Data report log into Tableau (link).: https://tableau.datis-camh.ca/
Navigate to the "Explore" Section:
- You can access "Explore" in two ways:
- From the Home screen.
- From the Menu Panel on the left side of the screen.
| Info |
|---|
| Users can also access reports from Favorites, Recents, and Recommendations once a report has been run or favorited. |
Access the ONHRDB Folder:
- Click on the ONHRDB Folder
Open the Reports Folder:
- Click on ONHRDB Agency Reports to view all available reports.
Choose the report you are trying to run:
- Select the A04 - NEP & ONP Raw Data Report:
- Select NEP ONP Raw Data Report
Setting Filters for Your Report
Filters allow you to customize your report to display only the most relevant data. Key filters include:
Date Filter:
- Enter dates manually or use the calendar to select the start and end dates.
PHU Filter:
Select your organization's Public Health Unit (this field will auto-populate).
Agency Filter:
- Choose any associated agencies linked with your PHU, if applicable.
Site Filter:
- View all sites associated with your organization in NEO. Deselect any sites you do not wish to include in the report.
Additional filters are available for the NEP/NSP Transactions and NEP/NSP Pack Transactions. These filter can filters can be utilized to isolate and focus on specific sets of data within this tab.
NEP/NSP Transactions tab filters
Item Type:
- The item type refers to the specific category or classification under which items are grouped. This data can be utilized to isolate and focus on specific sets of information within this tab.
Item:
- The item dropdown refers to the specific item(s) being tracked.
NEP/NSP Pack Transactions tab filters
Item Type (Pack Transactions):
Item (Pack Transactions):
Additional Filters for Your Report
Additional filters are available at the top of your report to help manage and adjust or reset filters as needed:
Export/Download a Report
Users can select choose their preferred format for downloading a the report. It For optimal formatting, it is recommended to download this report as Crosstab for optimal formatting as this report is a Crosstab since it contains aggregate data.
Steps to Download Your Report:
To download your report, click on the download button button 
at the top right of the screen.
Select the format you prefer. Once the format is selected a new window will appear with further customization options to download the report.
Follow these steps if one of the following formats PDF or Crosstab is selected:
Crosstab
To download to Excel or CSV Crosstab must be selected. The report must be downloaded by sheet, the user must be in the sheet that they want to download.
Only
| Info |
|---|
Only the Client Info tab will be downloaded. |
To open the downloaded Excel file, locate it in your system's default download folder or the location where it was saved, and double-click it. Ensure you have spreadsheet software, such as Microsoft Excel or Google Sheets, installed to view the file.
To download to the report as a PDF, select the PDF must be selectedoption. The whole entire report will be downloaded to PDF.
Each page will display each tab of NEP ONP Raw Data Report
For more details on the report calculations, please click hereincluded in the download.
To open the downloaded PDF, locate the file in your system's default download folder or the location where it was saved, and double-click it. Ensure you have a PDF reader, such as Adobe Acrobat Reader, installed to view the file.
