headline »

Network Analysis

Use Network Analysis to Understand Your Customers with SAS Visual Analytics 8.2

2018-01-21 – 7:10 PM

You can use the SAS Visual Analytics 8.2 Network Analysis object to visualize relationships. For some recent data analysis, I was trying to understand the customer to sales office relationship. My suspicion was that it wasn’t evenly distributed and that there were some customers not assigned together.
Understanding the Network Analysis Object
The network analysis object shows the relationship between two entities with a series of linked …

Read the full story »
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

Data Visualization, Visual Analytics »

My 7 Favorite Features in SAS Visual Analytics 8.2 on Viya

2018-01-14 – 12:06 PM

In December 2017, SAS Visual Analytics 8.2 was recently released along with some fantastic functionality. Here’s the seven features that I find useful.

1 – Autosave and Auto Recovery

I’ve made the mistake of walking away from a browser session with a report I was building. True I didn’t save it but to my defense I didn’t think I’d be gone so long. Inevitably the report would close, and I would lose all of my work. SAS Visual Analytics does an autosave of your report and offers to restore the report the next time you open the report. This is first on my list probably because I’m so forgetful and easily distracted.

2 – Replace the Active Data Table

If you made a change to your data table and wanted to replace the data table, it wasn’t always obvious what was going on. Plus, you had to unload the data and then re-load the data. This new import interface makes it easy to understand that you are replacing the data.

You can take advantage of cloud-based data.  If you have data on your Google drive, you can import it directly to SAS Viya. It can even be a Google spreadsheet.  Watch this …

3 – Easy to Create Aggregated Data Items

How about easier calculations – for instance I can easily create the Cumulative or Rolling Average values based on a measure. Just create a new calculation and then select the aggregation that you want.

Here’s an example of the Moving Average plotted with the actual values. Easy!

4 – Undo/Redo Function

This Undo/Redo functionality is helpful. When you are designing a report sometimes you realize the way you had the object was preferable. As far as I can tell it applies to the last few actions in the report. It did allow me to remove several objects and a page that I had inserted.

5 – Duplicate Object as Another Data Object

You can duplicate the current data object. Or you can duplicate the object as another object! If you have a bar chart, you can duplicate it as a table or dual axis bar chart. Whatever makes more sense to your current report goal. All with one click of the button.

6 – Assigning Geographic Items is Easier

When creating geographic data items, you get lots of extra information. When I assigned the customer country I see that two country names were invalid. It’s true! The SAS lookup tables have a country called “Russian Federation” but not a “Russia”. This is help – now I can update my data tables.

7 – Control the Background Map Brightness

You can use Open Street Maps for your data or you can use one of the ESRI maps. Sometimes I think the ESRI maps are a little bright and don’t allow enough contrast. You can control the brightness by changing the background transparency.

There are some other features I’m anxious to try. You can add JavaScript D3 and other interactive charts which I think will be fun. You can also add your own shape maps. This is going to take a little more time to learn so keep watch for some future posts.

Seize the Day! Submit an #SASGF Abstract

2016-09-21 – 6:32 AM

Are you considering submitting an abstract for SAS Global Forum 2017? Maybe you have already read the posts about how it helps your career and the excitement of sharing ideas. What is holding you back? Maybe you don’t have an idea, maybe you fear presentations, or maybe you just are unsure of the process.
I don’t have a idea
I bet this is the number one concern …

Need a Dynamic X-Axis with Your SAS Visual Analytics Report?

2016-07-31 – 11:52 AM

I like to read the SAS Visual Analytics area of SAS Communities site. From the site I have overcome issues I had as well as learned other ways to think how you can solve common issues. As many long time SAS users know – there’s always more than one way to accomplish something with SAS! Recently, as user was asking how to expand parameters to create a …

Why Dashboard Gauges Aren’t as Bad as You Think

2016-05-22 – 2:57 PM

Dashboard gauges were once the darling of the executive suite. Some designer took inspiration from a car dashboard and its gauges. A gauge is useful because it tells us how fast we are going or how much gas is in the tank. My newer model dashboard still has gauges but it also states how many miles until empty. That information is more useful than knowing how much gas is in the …

SAS Visual Analytics: Bubble Plots for Less Toil and Trouble

2016-04-24 – 12:55 PM

You cannot research bubble plots from any data visualization expert without reading a reference to the Hans Rosling’s Ted Talk Let My Dataset Change Your Mindset. It may have been the first time a bubble plot gained a mainstream appeal noted Stephen Few in his Show Me the Numbers book. Rosling provided an intense amount of information in one data visualization and he changed my mindset. Here’s some …

SAS VA Data Builder: Add a New Data Item

2016-02-05 – 9:25 AM

The SAS Visual Analytics Data Builder allows you to prepare and load data to the SAS LASR Server so you can complete analysis or build reports and dashboards. It’s a little more tricky to use than some of the other parts of SAS Visual Analytics but can usually be mastered within a day. If you need to add a data item to your data table, …