AD09
Integrating SAS Analytics with Microsoft-Based Desktop Applications
Contributed
Jim Tarantino
Nortel Networks
,Dr. Sam Yamamura
Nortel Networks
,John Payne
Nortel Networks Abstract:
Many corporations’ today use Microsoft-based applications (e.g. Visual Basic executables, Access Data Projects, OLAP for Excel, .NET services) to exploit the value of warehoused enterprise information. Several enabling technologies exist to leverage SAS a
s a "compute server", adding advanced analytical components to core Microsoft functionality. This paper compares the pros and cons of two SAS technologies, Integrated Technologies and Intrnet, as means for integrating SAS with Microsoft applications. Thr
ough case study, examples, and discussion, the authors will present tips and considerations for using SAS Intrnet with Excel web queries, Access Data Projects, and VB executables. Also, implications for .NET will be discussed.
Biography:
Originally from Pittsburgh, Pennsylvania, Jim relocated to Raleigh, NC in 1987 to attend North Carolina State University. He specialized in Industrial/Organizational Psychology, receiving his master's degree. Since then, he has held a variety of applied re
search roles including: Occupational Analyst with the US Department of Labor; and Survey Researcher with Nortel Networks. He currently leads a team that delivers reporting and analytical applications to Human Resources and Information Services clients with
in Nortel Networks. He plans to pursue his Ph.D in Information Technology Management to merge his psychology background with his appreciation for information technology. When not tinkering with computers, Jim can be found spending time with his wife and th
eir two dogs.
Osamu came to United States in 1991 from his hometown in Japan. After his undergraduate studies at the University of South Carolina, he received his Ph.D. in Industrial/Organizational Psychology from North Carolina State University. Both his master's thesi
s and doctoral dissertation were based on research projects conducted at Nortel Networks. Osamu currently works as a information systems analyst/developer for Nortel Networks where he serves as a key resource for advanced computation and research design. H
is work and academic experience allows him leverage his expertise in human resource issues to develop information collection, analysis and delivery systems using a variety of technologies, including SAS. Osamu was recently married and is enjoying living in
North Carolina with his new bride.
John is an information systems analyst/developer at Nortel Networks, specializing in web development and user-interface design. He is currently pursuing a Master of Science degree in Technical Communication at North Carolina State University. His academic
and professional interests include: human/computer interaction, effective user-interface design, semantic analysis, and text mining. Prior to joining Nortel, John was the e-Business Manager for the Chemical Products division at Lord Corporation, a privatel
y held chemical and mechanical products manufacturing company. In addition to school, John finds time to run and swim in various competitions throughout North Carolina. He is married and has two sons.