Handouts / Presentations
- SAS Workshop Data
- Excel Pivot Tables
- Using MS Access to Query External Data Sources
Morning workshops: 10:00 a.m. – noon
Morning Option 1: SAS® Rapid Predictive Modeler
This workshop introduces SAS® Rapid Predictive Modeler, a new product that is an add-in to SAS® Enterprise Guide and the SAS® Add-in for Microsoft Office. SAS Rapid Predictive Modeler (RPM) allows business users to build predictive models based on their requirements, derive on-demand insights and act on it to solve business problems quickly and effectively. SAS RPM analyzes the data to decide which targets you need to predict, selects variables, transforms data, selects the best model and delivers results in easy-to-understand charts to help organizations to take better decisions Presented by Andre de Waal, Analytical Consultant with the Global Academic Program
Morning Option 2: Using Microsoft Excel® Pivot Tables to Turn Institutional Data into Institutional Knowledge
The workshop will provide insight into using the pivot table feature in Microsoft Excel® to quickly analyze and consolidate large amounts of data from your institutional data sources into informative reports. The workshop will also provide tips on how to track and analyze trends with your institutional data. The workshop will provide hands-on training with Microsoft Excel® using a provided sample data set. Presented by Scott Jenkins, North Carolina A&T State University
Lunch held on SAS campus
Afternoon workshops: 1:00 p.m. – 3:00 p.m.
Afternoon Option 1: SAS® Statistical Analysis Using SAS®9
This workshop will use SAS Enterprise Guide GUI as the foundation for conducting a series of statistical analyses such as descriptive statistics, analysis of means, regression analysis including logistic, and analysis of variance. For each analysis, we will examine the SAS code that is generated and explore modifications to this code. Presented by Dr. Jerry Oglesby, Director of Global Academic Program
Afternoon Option 2: Using MS Access to Query External Data Sources
This workshop will provide step-by-step instructions on how to use Microsoft Access® to either link directly to live institutional databases or to import tables from those databases, thus enabling the user to quickly query data from multiple data sources (ex. Jenzabar, PowerFaids, DataTel, Raiser’s Edge, homemade databases). The workshop will provide hands-on training with Microsoft Access® using a provided sample data set and will use real IR-life examples often needed for IPEDS and NCHEDS Presented by Eva Eisnaugle .