BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » Archive by Category

Articles in BI Tools

SAS Add-In to MS Office: Refreshing the Data & Breaking the Link

February 9, 2012 – 7:51 am | 8 Comments

If you use SAS Add-In to Microsoft Office – specifically Excel, then you already know how awesome it is to link to the SAS data on the server. First, if you are using data that needs to be refreshed – just a click of the button brings you the new rows and your report or charts are updated immediately.  Awesome! Let the analysis begin … 
Refreshing …

SAS BI Dashboard: Measuring the Conversion Rate with Google Analytics

February 8, 2012 – 9:14 am | Comments Off on SAS BI Dashboard: Measuring the Conversion Rate with Google Analytics

Once you start looking at your Google Analytics, it is thrilling to see that visitors are coming to your humble Web site and some even return. Your first inclination is to create fancy dashboards to show the traffic patterns, compare the patterns by day of week, segment into New and Returning visitors, soon your charts may even be trending on #StuffDataGeeksDo.  
In the past few weeks …

Peek Inside SAS BI Book: Building Business Intelligence with SAS

February 4, 2012 – 1:38 pm | 2 Comments

You may be aware by now, our new SAS BI book Building Business Intelligence with SAS:Content Development Examples launched last week on the SAS Press site. That’s right, SAS Press will be delighted to bring a copy of this SAS BI book to your door.
When Angela and I set out to write this book, one of the first things we discussed was how new users …

SAS BI Dashboard Rocks My Google Analytics Data Analysis

February 1, 2012 – 7:32 am | Comments Off on SAS BI Dashboard Rocks My Google Analytics Data Analysis
sas bi dashboard spark table indicator new columns and ranges

I have to say I’m in love with the new SAS BI Dashboard and it’s many features. It really brings the Google Analytics to life and helps me understand how the Website traffic changed over time along with the key influences. The following figure gives you an idea of how you can integrate dashboard indicators for an interactive user experience. The best part is how …

SAS BI Dashboard: Google Analytics Dashboard Kicked Up a Notch

January 23, 2012 – 7:56 am | Comments Off on SAS BI Dashboard: Google Analytics Dashboard Kicked Up a Notch

Google Analytics uses data from your Website to prepare a neat looking application where you can explore your data and answer what I consider your first-level questions. First-level questions are the most basic things you might want to know, such as How many? What Time Period? It is the second- and third-level questions where the analysis and action plans come into play. After all, it’s …