Research Analytics

A: Click the green “Access Research Data Portal” button at the top of this page, or click here to go to the Research Data Portal home page. If not already completed, University of Kentucky faculty and staff with an active linkblue ID must complete the Tableau Server Access Request Form to view the Research Data Portal. When you receive access, see the Tableau Server page for more details on how to log in.

If you are not a UK employee and would like to request specific data, please contact the Office of the Vice President for Research at vpr@uky.edu.

Anyone can view the publicly available research data on our homepage.

To see more detailed data, University of Kentucky faculty and staff with an active linkblue account must complete the "access request form." For more details on how to log in, once you've been given access, see the Tableau Server page.

If you are not a UK employee and would like to request specific data, please contact the Office of the Vice President for Research at vpr@uky.edu.

No, the university has a server license with Tableau and any linkblue account holder can have access. Tableau Desktop is software for developers only. In order to use the data portal you will only need to complete the request form mentioned above, no need to download or buy anything.

All of the reports that have been accessed via the public OSPA website will now be available in the online portal for UK faculty and staff. Additionally, the portal will contain more reports than previously available and will have interactive dashboards that are updated monthly.

For the most part you will see the same data and aggregation of sponsored projects in the new portal. However, due to improved data quality processes, data clean‐up, and improved reporting, some monthly reports may differ from previously provided reports. Some of this has to do with the timing of when reports were previously published, and others are due to changes in when budgets were available. While monthly reports may differ slightly from previous reporting, the underlying aggregated award totals are the same and accurate for colleges and departments.

A custom view is a copy of a view that has your selections and filters applied. You can use Custom Views to save your filters, sorts, or selections, without changing the original view. Custom Views are a good option if you find yourself changing a report’s filters every time you open it.

How can I create a custom view?

To subscribe to a view or report, follow these steps:

1. Open and log into Tableau Server and navigate to the view you want to create a custom view for.
2. Filter the data, change sorting, select specific marks, zoom in or out, or add modifications.
3. Choose View in the toolbar.
4. In the Custom Views dialog, enter a name for the Custom View and select “Make it my default.”
5. Click Save.

Create a Custom View

To download data to a Microsoft Excel workbook in Tableau Server, you will first need to navigate the view that contains the data you want to export in Tableau Server. Once the view is open, follow these steps:

1. Click the "Download" button in the top right corner of the Tableau Server interface. This will open the "Download" window.
2. In the "Download" window, select the "Crosstab" button.
3. In the “Download Crosstab” window that appears, select the “Excel” radio button.
4. Click the "Download" button to begin exporting the selected worksheets to a Microsoft Excel workbook.
5. Once the download process is complete, the data will be downloaded to your computer as a Microsoft Excel file. You can then open the file in Excel to view and work with the data

Downloading Summary Data

The subscription feature in Tableau allows you to receive automatic updates (via email) to a view or report on a regular basis. This can be useful if you want to stay up-to-date on the latest data in a particular view, or if you want to share that view with other people and ensure that they always have access to the most current information.

How can I subscribe to a view or report?

To subscribe to a view or report, follow these steps:

1. Open and log into Tableau Server and navigate to the view that you want to subscribe to.
2. Click on the "Subscribe" button in the top-right corner of the view.
3. In the "Subscribe" window, check the “Subscribe me” box and complete the form in accordance to your business needs.
4. Select how often you want to receive updates to the view.
5. Click "Subscribe" to complete the process.

Subscribing to Tableau Views