|
Warehouse User Group (WUG) Meetings
Adobe Acrobat Reader Needed to View WUG Handouts.
|
All
documents are PDF files that require Adobe Acrobat
Reader in order to download and print them.
|
|
Adobe
Acrobat is FREE and
easy to use. Click below to download Adobe Acrobat
Reader.
|
|
|
How To FIX a BROKEN QUERY in Brio When Affiliate ID Is Added To A Table
Setting
Up Access 2000 to Query the Warehouse
August 2005 handouts (Note: Error on page 2 of 1st Time Freshman is fixed here!)
How To Fix A Query with Sync to Database (Nancy Dickson)
Zip Code Info and Hyperion Pivot Features (John Rome)
DOWNLOAD... Zip Code Info Query (.bqy file)
What's New With the CENSUS Database? - (Melinda Gebel and Nancy Dickson)
What is a First-Time Freshman? - (Nancy Dickson)
First-Time Full-Time Freshman Persistence and Graduation Rates - (Melinda Gebel)
DOWNLOAD... FTFT Freshman Persistence and Graduation Query (.bqy file)
Fall to Fall Academic Progression - (Melinda Gebel)
DOWNLOAD... Fall to Fall Academic Progression Query (.bqy file)
December 2004 handouts
Update on Brio/Hyperion - The New Company... The Software - PowerPoint Presentation (by Nancy Dickson)
What's New With the Student and Course Databases? - PowerPoint Presentation (by John Rome)
What is a Cluster Schedule Line Number? - PowerPoint Presentation (by Katherine Alford)
Query That Shows Cluster and Component SLN's (by Katherine Alford)
Who's Taking My Classes? - Course Loading Between Colleges and Departments (by Troy Buchanan)
Note: Since the session ran long, we are saving the topics we didn't get to for the next WUG.
September
2003 handouts
Facility
Data Background and Brief History - PowerPoint
Presentation
Overview
of Facility Data and Tables
Identifying
Assignable and Non-Assignable Square Footage by Building
by Department
DOWNLOAD... Building
info by Department(.bqy file) for Brio 6.6 version
Setting
Up Access 2000 to Query the Data Warehouse
Looking
at Employee Work Locations and Job Functions by Department
Data Mining to Compare Spaces
DOWNLOAD... Comparision
of Space(.bqy file) for Brio 6.6 version
Data
Warehouse User Group - Festival Day, December
2002
I.
Brio 6 Tips and Tricks Plus Report Design (by Nancy
Dickson)
Brio
6 Tips and Tricks
Brio
Report Primer
II.
DARS Data on the Warehouse (by Millie Torre and
Susan Moore)
DARS
- Finding Students Enrolled in the Education Concentration
DARS - Finding Communications BS Students that are pursuing
a minor
DARS
- Finding 2002 Journalism Majors
DARS
- Finding Currently Enrolled Business Management Students
III.
Competency Data (by Mike Dickson) and the New
CENSUS Database (by Melinda Gebel)
Undergraduate
Competency Table Overview
Undergraduate
Competency Table Description
Biology
Major Competencies
Psych
majors in danger of being dismissed
Census
overview
Applied
Admitted Enrolled
September 2002 handouts
History
Of Data Warehouse - PowerPoint
Presentation
Using
Next and Prior in Computed Columns
Excel and Brio
One
Step at a Time Analysis BACKWARDS
Putting
Salary and ERE Together with a UNION
DOWNLOAD... Salary
and ERE Union Query(.bqy file) for Brio 6.6 version
Brio
6.6 Play Time Handouts Summer 2002
Brio
Play Time Outlook Note
Top
10 BrioQuery 6.6 Differences
How
To Use The Brio 6 Welcome Box
Top
10 BrioQuery 6.6 Cool New Features
Play Time default
oce
Before
you leave Play Time Checklist
September 2000 handouts
Data Administration's
Thoughts on Brio Query 6.0
Overview of Brio Query Explorer
6.0
Planning a smooth migration to
Brio.Enterprise v6
Brio 6.0 Presentation
May 2000 handouts
Manipulating transcript data
with Excel and Access
Making sense of the Immunization Table (Nancy is reworking query to include measles
test.)
Using MAC's data with the Immunization
Table
Calculating with undergrad
exam scores
May HR BOM Meeting
Grouped positions, with
job titles, by department
Employee funding source,
by department
Departmental employees by
account with account stop dates
Identifying Sponsored accounts
Annual salary changes
What time limits do I set
on this query?
Departmental faculty by
title and years in rank
How to add a computed column
March 2000 handouts
December 99 handouts
September 99 handouts
Presenting new tables and additional
fields to existing tables
How much leave balance accrued?
How many employee leave hours
available?
New employees on HRMS?
Which pay lines have not been
extended?
May 99 handouts
Student Table Overview
Students Applying for Graduation
Converting Date of Birth to
Age
April 99 handouts
Transaction Document Research
Account Rollup and Financial
Users
Open Purchase Orders
Purchase Order Information
by College
February 98 handouts
Brio 5 Web Install procedure
December 97 handouts
Degree Query Download (for
Windows, click here)
Brio Query 5.5 Upgrade Details
Brio's Pesky Dates
Finding New Undergrads for
Spring to Do Batch DARS Runs
Degree Reports
November 97 handouts
Combining Revenue and
Expenditure Data Using Access Macros to Update Excel
Union Theory
Union Query in Brio 3.5
(Getting Transfer and ASU courses and grades in one
file)
Access Parameter-driven
Union Query to Obtain an Expenditure
October 97 handouts
Limiting and Sorting
Results
Graduate Assistant Salary
Analysis
Table of the Month-Student
Degree
Degrees Granted Reporting
May 97 handouts
Show Remarks
A study of Arizona Community
College Transfer Credits Obtained by Degree Recipients
Creating an Autorun Query
to look at Class Capacity
April 97 handouts
Using the Limit Line
to Alter Limit Logic
Student Wages reporting
March 97 handouts
What's Wrong with this
Query?
Getting Friendly with a Table
One-step-at-a-time Analysis
Using one Affiliate ID to zero
in on Warehouse Tables
The Multiplicities of Tables
Student Class Table
Average Grades for Calculus
I Classes
February 97 handouts
Mysteries of the SQL.INI file
SQLEDIT.EXE and editing
the SQL.INI file
Setting up Access 7.0 to link
to the ASU Data Warehouse
Student Credit Hours (not
official) from the Student Class Table
January 97 handouts
New E/R Diagrams:
Census
Course
Financial
Student
Human Resources
Client Server for Dummies
Setting up ODBC drivers so
Access 2.0 can attach to the Data Warehouse (16bit)
Attaching Access 2.0 to the
Data Warehouse
User Tables available
Putting a set of IDs in your
User Table
An Access query and report
on a User Table
December 96 handouts
Finding Students Who Have
Applied for Graduation
Finding General Studies Courses
Access Importing Tip
November 96 handouts
Agribusiness Graduates
and Time to Graduation (alias Modify Madness)
Checking Engineering Prerequisites
Two Brio Bugs
|
