Queen's University

Student Counts

 

Hands-on Introduction to ASC Dashboards in Tableau for Queen's Faculty and Staff, with access to Tableau files on Queen's Active Directory:

  • Thursday, May 10th, 9-11am

Drop-in Sessions for Tableau advanced (or curious!) users for Queen's Faculty and Staff, with access to Tableau files on Queen's Active Directory:

  • Thursday, May 10th, 11am-noon

All sessions are in Jeffery 156, with Tableau Reader Version 10.5, on each computer. Each session is scheduled for 2 hours, but usually last about 1.5 hrs. (You only need to attend one session!)

Email Lydia and at reportsartsci@queensu.ca to register - or also if your Department would like your own session!

Reports for Arts and Science Departments

Requests to access detailed Tableau visualizations should be made via ASC Department Heads, to Lydia Scholle-Cotton, at reportsartsci@queensu.ca to request access to Queen's Arts and Science Active Directory folder \\ad.queensu.ca\asc\Shared\ASCDepts.

Reports for Other Queen's Units

Requests to access detailed Tableau visualizations should be made to  Lydia Scholle-Cotton, at reportsartsci@queensu.ca to request access to Queen's Active Directory folder \\ad.queensu.ca\edu\shared\Student Services\Tableau.

 

All Tableau files in these folders are .twbx files, in version 10.5, the same version as in Jeffery 156.

 

Compiled by Lydia Scholle-Cotton, Senior Research and Planning Analyst, x77170 Office of the Dean. See also PeopleSoft Queries Resources. Email Lydia at reportsartsci@queensu.ca.

How to Map the Shared Drive

Recommendation: map as drive F, if available:

  1. See Queen's Tutorials for Accessing Shared Directories for tutorial to map a directory.
  2. Copy and paste the file path as follows, depending on your computer configuration:
  • PC on Queen's Active Directory - ASC Departments:  \\ad.queensu.ca\asc\Shared\ASCDepts, or other Queen's units:  \\ad.queensu.ca\edu\shared\Student Services\Tableau
  • PC not on AD: \\qu-adfile01-prd.ad.queensu.ca\asc\Shared\ASCDepts or
    \\qu-adfile01-prd.ad.queensu.ca\edu\shared\Student Services\Tableau
  • Mac: //qu-adfile01-prd.ad.queensu.ca/asc/Shared/ASCDepts/ or
    //qu-adfile01-prd.ad.queensu.ca/edu/shared/Student Services/Tableau/ (may need to have prefix smb:, with none, 1, 2 or 3 /s). NB need Mac OS X 10.10 for Tableau Reader 10.0.
  1. When prompted, select "use other credentials" and set your username to be ad\netid.
  2. If you're having trouble mapping the drive, you can call Queen's ITServices for help - 613 533 6666.
  3. if you want to access this folder from off Queen's campus, you need to use Queen's Virtual Private Network. See VPN Tutorials, and select the "ADV" option to map Active Directory drives. The first time you log on, you will need to map the drive as indicated above, and the drive will be available on subsequent VPN sessions (and not available when you're off VPN).

Additional Reports

The following reports are linked from Tableau reports above - hover over graphs for links to the latest version of each report:

  • Summary Report for ASC Departments - Student Counts by Department, FTE for undergrad, grad and distance teaching, undergraduate and graduate plan counts by plan type, 2 fiscal years. Report in PDF, latest version linked from Tableau vizzes.
  • Summary of Degrees Granted in ASC Concentrations, linked from Degrees Granted Tableau viz.

Tableau in Education

University sites with Tableau

 Education & Tableau

Tableau Reader

To interact with the Tableau twbx files, you will need to download free Tableau Reader (version 10, latest version) to interact with detailed Tableau Visualizations.

 

Tableau .twbx files are in version 10.5. Current versions of Tableau reader can read prior versions. If you have a Tableau version earlier than the .twbx file, you will get an error message, and you need to download the latest version of Reader.

 

Tableau files written using previous versions are in folders (with version number) on the shared drives, but are not maintained with current data.

Tableau is Free for Students and Instructors!

See https://www.tableau.com/academic for more information!

How to access Tableau Server

Tableau Server may be accessed by logging in to https://analytics.cac.queensu.ca/#/signin

You need to be on the Queen's network, or logged on to Queen's using VPN to access the Tableau Server!

 

Landing pages for you to bookmark:

To request access, please email reportsartsci@queensu.ca.

 

Note: To access Tableau Server, you need to be logged on to the Queen's Network; if you are off campus, you need to connect to launch the Queen's VPN Client (Cicsco VPN).

 

Thanks to Queen's Centre for Advanced Computing for hosting!!

Files

PDF icon J1 ASC Degrees Granted, 2000 on (5p, pdf)
PDF icon B Summary Report for ASC Departments, 2yr (12p, pdf)