Home | Contact Us

About ASSIST
Administration
Data
Web Access
Training
F.A.Q.
Related Links

ASSIST Frequently Asked Questions (FAQs)

This page contains answers to commonly asked questions, along with some tips and tricks that we have found useful.

  1. How can I get access to ASSIST data?
  2. Who is my ASSIST Steering Committee Representative?
  3. How can I connect to ASSIST to get data?
  4. What types of data items are available in ASSIST?
  5. Where do the data come from?
  6. How timely are the data?
  7. Did we turn in our institution’s ASSIST file and has it been loaded?
  8. What is Hyperion/BrioQuery?
  9. What else can HyperionBrioQuery do besides extracting data?
  10. What is Hyperion? What happened to Brio?
  11. What other software programs can be used to analyze ASSIST data?
  12. How do I get training on using the ASSIST database with the Hyperion/BrioQuery software?
  13. I’ve had some basic training using the ASSIST database and Hyperion/Brio from my institution. Does ASSIST offer any additional resources?
  14. When and where is the next Hyperion/Brio training opportunity?
  15. Is there anyone else from whom I can get help?
  16. I forgot my password. Who can help me?
  17. How do I change my password?
  18. How can I get help with a particular query?
  19. Why can’t I see other institutions’ data to use as comparison?

  20. How can I check the validity of the ASSIST data with our institutional student data?

horizontal rule

How can I get access to ASSIST data?

Researchers desiring access to ASSIST must be an employee of a participating institution and be approved by the institutional ASSIST Steering Committee representative. Authorized ASSIST users must sign nondisclosure agreements and submit the form to their institutional ASSIST Steering Committee representative.

ASSIST Nondisclosure Agreement

< back to top >

horizontal rule

Who is my ASSIST Steering Committee Representative?

 Representatives to the ASSIST Steering Committee are listed on the following roster:

ASSIST Steering Committee Members

< back to top >

horizontal rule

How can I connect to ASSIST to get data?

The design of ASSIST makes it possible for institutions to retrieve information using standard query language or SQL statements. You can connect to ASSIST using a Hyperion/BrioQuery web version (plug-in), Hyperion/BrioQuery desktop version (client), or a SQL tool. It is the responsibility of the researcher to purchase this software and connect to the Internet.

< back to top >

horizontal rule

What types of data items are available in ASSIST? 

DEMOGRAPHIC DATA

 

Student age, Arizona residency type, high school year, high school diploma type, US visa type, gender, minority status, ethnicity

 

COURSE DATA

 

Course enrollment and grade by term

 

ENROLLMENT DATA

 

Enrollment census flag, hours attempted, developmental hours attempted, developmental hours completed, total earned hours, major, CIP major, term GPA, cumulative GPA, transfer hours

 

TRANSFER DATA

 

Transfer institution(s), transfer hours by institution, number of transfer institutions, number of AZCC institutions attended

 

DEGREE DATA

 

AGEC completion type, AGEC completion year, Associate degree type, Associate degree year, Bachelor degree type, Bachelor degree semester

 

< back to top >

horizontal rule

Where do the data come from?

The participating institutions submit ASSIST data annually. The records are matched and loaded into the ASSIST data warehouse. Students are assigned an anonymous ASSIST ID, which becomes the primary key in the ASSIST data warehouse.

< back to top >

horizontal rule

How timely are the data?

Community college data are submitted on an academic year basis, typically in February of the following year (e.g., AY year 2002-2003 data by February 2004). University data are submitted on a semester basis.

< back to top >

horizontal rule

Did we turn in our institution’s ASSIST file and has it been loaded? 

File status may be checked at:

    Community College File Submission Status

    University File Submission Status

    Carl Perkins Data Submission Status

< back to top >

horizontal rule

What is Hyperion/BrioQuery?

Hyperion/BrioQuery is the software recommended for querying and manipulating data from ASSIST. Hyperion/Brio is preferred over other query tools such as Microsoft Access for two important reasons:

EASE OF USE

 

Hyperion/Brio is much easier for non-technical staff to master.

 

EFFICIENT, FAST RUNNING QUERIES

 

Hyperion/Brio uses native Sybase SQL software (the language ASSIST understands) and creates well-structured, efficient queries.

 

< back to top >

horizontal rule

What else can Hyperion/BrioQuery do besides extracting data?

 With Hyperion/BrioQuery, you can make pivot tables, charts, and reports.

< back to top >

horizontal rule

What is Hyperion? What happened to Brio?

In late 2003, Hyperion acquired Brio and is currently supporting the Brio products. BrioQuery is now also referred to as Hyperion Intelligence. During the transition, ASSIST is using the term Hyperion/Brio.

< back to top >

horizontal rule

What other software programs can be used to analyze ASSIST data? 

You can export ASSIST data from Hyperion/BrioQuery and import it into spreadsheet software such as Excel or databases such as Access.

< back to top >

horizontal rule

How do I get training on using the ASSIST database with the Hyperion/BrioQuery software? 

Institutions with current account holders are responsible for providing individual training for new authorized users. If no current authorized users are available, copies of training modules are also available at:

    http://www.asu.edu/assist/training/training.htm

< back to top >

horizontal rule

I’ve had some basic training using the ASSIST database and Hyperion/Brio from my institution. Does ASSIST offer any additional resources? 

ASSIST sponsors an annual statewide meeting for all Steering Committee members and authorized users. Each meeting includes demonstrations and discussion on various ASSIST issues. The ASSIST meeting is held in conjunction with the Arizona Association for Institutional Research (AZAIR) annual conference. 

ASSIST user groups--one for community college users and one for university users--also offer opportunities for users to further develop their knowledge and experience with ASSIST data.

In addition, ASSIST maintains ASSIST-Q@asu.edu that responds to customers’ questions concerning ASSIST as well as the use of Hyperion/Brio software.  

Two key resources for new ASSIST users are the data diagram and the data documentation. 

    http://www.asu.edu/assist/data/data_models.htm

    http://www.asu.edu/assist/data/data_documentation.htm

< back to top >

horizontal rule

When and where is the next Hyperion/Brio training opportunity? 

Hyperion offers classroom and e-training sessions for BrioQuery or Hyperion Intelligence. The schedule of courses available is listed at the Hyperion Education Services web page.

< back to top >

horizontal rule

Is there anyone else from whom I can get help?

ASSIST users interested in learning more about using Hyperion/Brio may join one of several users groups. Some ASSIST users are currently involved with Hyperion’s Community of Practice, a higher education users group, and Yahoo’s Brio User group.

    http://hyperion.communityzero.com/

    http://groups.yahoo.com/group/Brio/

< back to top >

horizontal rule

I forgot my password. Who can help me? 

Send a message to ASSIST-Q@asu.edu. Your password will be reset and emailed back to you as soon as possible.

< back to top >

horizontal rule

How do I change my password?

If you connect using the Hyperion/BrioQuery desktop version (client):

  1. Go to the Tools/Connections Manager.

  2. Under the Connections Manager, select the first connection available.

  3. The Change Database Password will only light up IF:(1) a connection is  highlighted; and (2) you are logged on to it. This will change your password for all future logins.

If you connect using the HyperionBrioQuery web version (plug in):

  1. Go to Tools.

  2. Go to Change Database Password.

< back to top >

horizontal rule

How can I get help with a particular query? 

ASSIST users may attach their query with a description of the purpose of the query and the problem with the results to ASSIST-Q@asu.edu. If the query is over 1GB (1,000KB) with the results, please save it without the results before sending. To do that in Hyperion/Brio desktop client or the web version, click File/Save Options/Save Query with Document and uncheck the query results box. Resave before attaching and emailing.

< back to top >

horizontal rule

Why can’t I see other institutions’ data to use as comparison? 

Each participating institution retains ownership and control over their data and approves all research involving ASSIST data. Therefore, an institution may only access records for their current and former students. Any other institutional comparison data can only be obtained directly from the other institution.

< back to top >

horizontal rule

How can I check the validity of the ASSIST data with our institutional student data?

Personally identifiable characteristics such as name, birth date, and student ID are removed from the database accessed by researchers to ensure student privacy and compliance with federal law. Therefore, verification of individual ASSIST student records against your own institutional data is not possible. You should, however, be able to confirm high-level aggregate numbers for enrollment headcount.

< back to top >

horizontal rule

Home | About ASSIST | Administration | Data | Web Access | Training | F.A.Q. | Related Links

Questions or problems regarding this web site should be directed to assist-q@asu.edu.
Copyright © 2005, ASSIST.  All rights reserved.  This website is maintained by Arizona State University
Last modified:  01/11/06.