Back to main page

 
 
Newsletter archive  
 

In this issue

A hitchhiker's guide to SAS Business Intelligence training (Alex Dmitrienko, Eli Lilly and Company)

Datagister.com: New portal for BI blog and SAS software demos (Curt Wehrley, Pinnacle Solutions)

 

A hitchhiker's guide to SAS Business Intelligence training

 

Alex Dmitrienko


Having spent numerous hours browsing through the web pages related to SAS Business Intelligence (BI) training, I have decided to provide a user-friendly summary of the available courses. As you can guess from the title of this article, my main inspiration was the famous book by Douglas Adams (The Hitchhiker's Guide to the Galaxy).

First of all, SAS offers three types of courses:

 
Classroom courses are taught by an instructor at a training facility. They are based on a familiar lecture format with computer workshops. The fee is about $300-400 per day.

 
Live web courses are taught by instructors via the Internet. They enable you to access training classes right from your desktop. The fee is about $250 per three-hour session. It is a very convenient alternative to regular instructor-led classes.

 
Self-paced web courses are also web-based but they are considerably less expensive than live web courses ($30-40) and there is even a freebie (Getting started with SAS Enterprise Guide). Also, you can take a tour of self-paced classes to see what this e-learning format looks like.

 

Also, you will notice that Enterprise Guide and other BI courses (for example, Add-in for Microsoft Office or Web Report Studio courses) are not grouped together on the SAS training website. So, if you are interested in reviewing available BI training options, you will need to go back and forth between several web pages. What you see below is an attempt to organize all SAS Business Intelligence courses in a more user-centric fashion.

Enterprise Guide

Most of the Enterprise Guide courses are web-based (either live web or self-paced courses).


Querying and Reporting Using SAS Enterprise Guide
This course was reviewed by Linda Lucek, Northern Illinois University. Read her review in March 2005 issue.


Advanced Querying Using SAS Enterprise Guide


SAS Enterprise Guide: ANOVA, Regression, and Logistic Regression


Administering SAS Enterprise Guide
This course was reviewed by Shawn Lee, University of Illinois at Urbana-Champaign. Read his review in May 2005 issue.


Programming Using SAS Enterprise Guide
This course was reviewed by Linda Lucek, Northern Illinois University. Read her review in January 2005 issue.


Querying Data Using SAS Enterprise Guide
This course was reviewed by Linda Lucek, Northern Illinois University. Read her review in January 2005 issue.


Performing Statistical Analyses Using SAS Enterprise Guide: Examples
This course was reviewed by Sunil Gupta, Gupta Programming. Read his review in February 2005 issue.


Creating and Customizing Reports Using SAS Enterprise Guide This course was reviewed by Sunil Gupta, Gupta Programming. Read his review in February 2005 issue.

General Business Intelligence courses

The general Business Intelligence courses, as well as courses covering individual software packages, are currently available only in a regular classroom training format.


Introduction to SAS Business Intelligence Applications


Creating, Distributing, and Using SAS Stored Processes


Creating and Exploiting OLAP Using the SAS System

Add-in for Microsoft Office


Accessing SAS from Microsoft Office Applications

Web Report Studio


Using SAS Web Report Studio for Thin-Client Reporting

Information Map Studio


Using SAS Information Map Studio to Create Information Maps


 
 

Datagister.com
New portal for BI blog and SAS software demos


Curt Wehrley, Pinnacle Solutions
Curt.Wehrley@psiconsultants.com

About the author
Curt Wehrley joined SAS Alliance Member Pinnacle Solutions three years ago as the Director of Business Development. Prior to Pinnacle Solutions, he spent 3 years developing new business for IT consulting startups, and 12 years in the total quality management field providing statistical analysis services to various Fortune 500 companies. He received a B.S. in Chemical Engineering from Rose-Hulman Institute of Technology and a Masters in Applied Statistics from Purdue University.

About Pinnacle Solutions
Pinnacle Solutions, a SAS Alliance Member based in Indianapolis, has been providing SAS application development and statistical analysis services for more than eight years.

Data explosion
As professionals in the business intelligence (BI) field, many of you are well aware of the forces that have spawned the creation of your job and/or the expansion of your duties. The arrival of the mainframe in the 1960s, the minicomputer in the '70s, and the PC in the '80s all provided the infrastructure for the digitization of corporate data. The growth of networking technologies in the 1990s made it much easier to share data, and the Internet revolution has sparked an explosion of data that took most everyone by surprise. The good news for those of us in BI is that, for the most part, we've got access to plenty of digitized data to crunch.

So much to do, so little time
These days, the bad news seems to be piling up fast. The data we're using to help ourselves and others make better decisions is often dirty, in multiple formats, sitting in multiple databases/locations, etc. The recent recession, globalization, increasing energy costs, and other economic forces have many executives and managers looking for more answers (usually ASAP) from the data in which they invested so heavily to digitize; as a result, the queue of user requests for reports and analyses is exceeding the capacity of many BI professionals to produce. In some organizations, the obvious answers - the proverbial "low hanging fruit" - have already been harvested, and demand for more complex analytic tools and skills is increasing. To top it all off, often the best analysis isn't enough; even the best managers realize that it takes more than the right data and IT tools to make quality decisions.

Even when I was a full-time statistician in the early- to mid-1990s, I just didn't have the time to keep up with developments in the BI field, so I sometimes felt like I was working on an island and falling behind the times. The Internet and the search engines hadn't yet taken off, so keeping my skills current meant taking a course, reading a book, and attending industry conferences - all good sources, yet none were very current. I always wanted to have an "agent" of sorts who was tracking the BI industry on my behalf. I would have loved to check out the latest SAS technologies, but had to wait for the annual conferences (e.g., SUGI, MWSUG), and even at those events there was too much to see and do and not enough time to really check it all out.

So what we have is an environment in which everyone is busy, and most don't have time to thoroughly explore new SAS technologies, monitor other parts of the BI field, or locate the information required to constantly improve our ability, and the abilities of our customers, to make better decisions.



The Portal
Datagister.com was launched in March as a portal for sharing articles, SAS software demos, and general information useful to BI professionals and decision makers alike. As a SAS consultancy, we must keep current on all things BI, so we're tracking the latest industry articles and constantly communicating with SAS Institute, BI industry thought leaders, SAS users, and decision makers. When weblogs (or "blogs") took off late last year, we thought, why not record some of our experiences, new ideas, and "word on the street" findings on a blog and share it with the BI crowd? So we built the datagister.com site, structured the home page as a blog, and started posting. Now we're looking for other SAS users to join the site and periodically post their ideas so that the entire BI community can benefit.



Our president, D.J. Penix, then came up with the idea of providing access to SAS software demonstrations. So now anyone can "kick the tires" on three analytic software solutions: SAS Web Report Studio, SAS Information Delivery Portal, and an interesting OLAP solution called Futrix (built using SAS by Futrix Ltd). What's really great is that access to the demos is free, and you can register some of your own custom data (scrambled of course to protect confidentiality!) in the metadata to review with your peers and management (visit datagister.com for more information). We're preparing to roll out a few more SAS solution demos, including Enterprise Guide and Enterprise Miner, later this summer.