MenuMenu

Resources & Support

The Resources and Support page highlights the popular user-facing data reporting tools and systems currently in use at UK.  HANA (or SAP HANA)  is the user-facing database from which you can pull operational data on students, faculty, and much more. Tableau (as well as other tools utilizing an ODBC connection) can directly connect with HANA allowing users to create data visualizations and reports. 

Request access to Tableau Server / Desktop Tableau Open Lab Information Log on to Tableau Server HANA Codebook

News & Information

Analytics News  Features information for Tableau Open Labs, updates & changes to HANA, and miscellaneous information that will be of benefit to the Tableau/HANA community. 


Tableau Access

Tableau Server is a front end reporting tool to access HANA data and other data sources.  The majority of users looking for student information will find that Tableau Server meets their reporting needs.  Those who wish to do more advanced data visualizations will want to check out Tableau Desktop.  The information below will assist you in getting started using Tableau.  We encourage you to come to a Tableau Open Lab (information below) to see the benefits of Tableau Server and Desktop.

Request access to Tableau Server / Desktop  This is the starting point for beginning to use Tableau Server / Desktop. After submitting the request,  your Area Security Officer will review your application for approval.

Log on to Tableau Server  Once you have received notification of access to Tableau Server this is the link  to begin using the server (http://analytics.uky.edu).

Download and Setup the trial version of Tableau Desktop (pdf)  The trial is only available for 14 days from the time you activate it.  Before beginning the trial period, be sure to allocate enough time to work with Tableau.  To purchase Tableau Desktop, please contact Tom Byrum with Tableau Software for educational pricing.

How to Install HANA Client and setup an ODBC connection to HANA (pdf)  In order to connect Tableau Desktop to data in HANA you will need to follow the steps in this document to connect to the HANA databases. Access to HANA is provided once your request to access Tableau Server/Desktop has been approved.
 
Need assistance?  Please complete the Advanced Analytics Contact Us form.

Tableau Open Lab

The Advanced Analytics team conducts an open lab to discuss and demonstrate the use of Tableau and HANA. The meetings occur every 2 weeks on Friday (effective 12/05/2014).  The location of the meeting is computer lab/room 72 in McVey Hall. You may use one of the computers in the lab or bring your own laptop.
The purpose of the meetings is to learn new ways to approach data and analysis through tools like Tableau and HANA. The goal of the meetings is to assist learning and knowledge sharing. The open lab format is broken into two meetings to accommodate beginner and advanced users.

  • Beginner / refresher session from 9:00 - 10:00 
  • Advanced / questions session from 10:00 - 11:00

Please feel free to come to part or all of the open lab.  As a beginner you may learn from the advanced sessions and advanced users may learn helpful information in the beginner sessions. To be added to the open lab email notification list, please follow the steps to subscribe to our listserv on the Analytics Community of Practice Listserv page.


Tableau Resources

HANA Codebook   The HANA Codebook is located in the Student Reports project folder on Tableau Server.  Access to Tableau Server is required to view the HANA Codebook.  Please complete the Request access to Tableau Server form. After submitting the request,  your Area Security Officer will review your application for approval.

Introduction to HANA and Tableau (pdf)   This is basic information about Tableau and the presentation material used in the introduction time of Tableau Open Lab Beginner session.

Introduction to Joins in Tableau Desktop (pdf)   This document is an advanced topic that demonstrates joining database tables.  This is an example of topics covered in the Tableau Open Lab Advanced session.

Upgrading Tableau Desktop to Version 8.2.1 - This document contains instructions for those that publish workbooks to the analytics.uky.edu, an upgrade of Tableau Desktop and the SAP HANA client will be required after 8/31/14. 


HANA Access & Data Connection Setup 

Most data needs can be fulfilled with access to Tableau Server and Desktop. When you need to work with HANA data in Excel, SAS, or other reporting tools you will need to access HANA directly. Below are links to request access to the HANA databases and installation instructions.

Request access to HANA  This is the starting point for accessing HANA. This is NOT for Tableau Server / Desktop. After submitting your request for HANA access, your Area Security Officer will review your application for approval.

How to Install HANA Client and setup an ODBC connection to HANA (pdf)

How to access HANA tables in Excel using MS Query (pdf)