Data Warehouse Frequently Asked Questions (FAQs)

 


 

How do I get the Microsoft Add-ins installed?

The Microsoft Add-in is used to access the Data Warehouse through the Microsoft Office suite of tools. This provides the ability to run reports and return the results into Excel, Word, or Power Point.

  • Submit an Analytics & Reporting work request using the following link: Work Request.

How do I change the output format of a report to CSV or HTML?

The default output format when the Microsoft Add-in is installed is a proprietary SAS format. You can run reports and output to Excel by using the *Select a File for Delivery Type? See steps below.

If the option to excel is missing, please submit a work request to see if we can make it available to the report.

The "SAS" tab in Excel disappeared, how do I get it back?

Under certain conditions the SAS Add-in may be deactivated, causing the "SAS" tab to disappear. You can call the help desk (x-5555) and they can walk you through the steps to reactivate the SAS Add-in, or you can follow the link below for directions:

I attended a training class and want to know where can I get a copy of the material?

The material is available for download from the following links:

Some coworkers are being trained on how to access the Data Warehouse, how can I receive training?

Training sessions are scheduled through the Valencia EDGE. 

Please Log into Atlas & navigate to the My Development Channel on the Employee Tab to access Valencia EDGE.

 

I need access to the Data Warehouse to perform my job, how do get access?

An online form is available to request access to the Data Warehouse. Supervisor approval is required for general access and AVP approval is needed for access to secure areas.

Data Warehouse access request.

Why am I getting a message that my logon is incorrect when I enter my Atlas ID and password to access the Data Warehouse?

The first possible cause is that you may not have been granted access. Before you can access the Data Warehouse for the first time you need to be authorized and your ID needs to be setup. Access to the Data Warehouse request.

If you have previously been able to access the Data Warehouse and you are able to access Atlas, your account may need to be refreshed. The OIT Help Desk (X-5555) is able to perform the necessary refresh.

If you are still having problems, contact the Data Warehouse team using the Contact Us link or send an email directly to DWHELP@valenciacollege.edu.

Why can't I run reports in Excel after changing my password in Atlas?

Your Data Warehouse logon ID/Password is tied to your Atlas logon ID/Password. If, when you run a report in Excel, you are prompted for an ID/Password, use your new password immediately after changing it in Atlas.

If you are not prompted for a password when you run a report in Excel then your password is being stored and it will need to be updated if you change your password in Atlas.

Directions on how to update your password in the Excel add-in are available by following the link below:

How do I request a change to an existing report or to request a new report?

The Data Request Form has been setup to receive and track Analytics & Reporting requests. Submit requests via the Data Request Form.

Why do I get an error message when I try to access the Data Warehouse Portal from outside of Valencia?

The Data Warehouse is only available while connected to the Valencia network. When on campus, this can be accomplished by either plugging directly into the network (like the PC in your office or a laptop that is plugged into a network outlet via a network cable) or connecting to the Valencia Wireless Network (WiFi). Off campus if you establish a VPN (Virtual Private Network) connection you will be able to access the Data Warehouse portal. After establishing the VPN connection simply open a browser and connect to the Data Warehouse portal page.

The question I have isn't addressed in the FAQ, what can I do?

You can send your question to the Data Warehouse team using the Contact Us link or send an email directly to DWHELP@valenciacollege.edu. Who knows, you question may show up on the FAQ page.

What are reports DQ0001 and DQ0002 telling me?

These reports are used for Data Quality purposes to ensure Credit Hours are properly assigned at the Course, Section, and Meet Time levels. For a complete explanation read  DQ0001 and DQ0002 Explained.