Data Visualization Topics

Designing Dashboards: Finding the Fantastic Five Colors

Color may have the most impact on your design. People react strongly to color either through culture values or personal choices. As with fonts, color is another element of style. And just like fonts, colors communicate meaning as well. [Read: Understanding the Importance of Color in Reporting] SAS offers many pre-chosen styles or palettes that […]

Read More

Creating a Web Analytics Report in SAS Visual Analytics 8.1

Recently I was asked to create a Web Analytics dashboard on spec. I decided to use the latest version SAS Visual Analytics 8.1 so I could review the new features. When we wrote the Introduction to SAS Visual Analytics book, we were using beta versions of the application. Here’s some of the process I used […]

Read More

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

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 […]

Read More

Planning Your SAS Visual Analytics Dashboard

A dashboard starts with planning. In my last post, we talked about gauges and when you want to use them. In this post, we will apply the gauges to a dashboard. Gauges cannot live by themselves – they need supporting information. It must be clear how the information supports the gauges. I’ll use the same dashboard […]

Read More

Why Dashboard Gauges Aren’t as Bad as You Think

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 […]

Read More
Coding & Data Topics

Dealing with Missing Dates in SAS Visual Analytics

It’s nearing the new year and you may have already started preparing reports that have the organization’s goals and the progress toward those goals. However your chart may not be displaying correctly. If your data is not setup properly then you’ll notice that you only have one or two months when you want to see […]

Read More

Oh Snap! Upload Data to the LASR Server Just Like That!

In a past life I worked at a company who had an excellent general manager, she was professional, intelligent, and a role model. It was a small company competing with giants and kicking their butt successfully. She set a new mission for the organization –  we needed to not only meet a customer’s product needs […]

Read More

Yes It’s Your Job to Manage Your Career Goals

Staying current in your chosen field is a challenge for all those specializing in an IT field. Here’s some tips for keeping up in an ever-changing field.

Read More

How Do You Flowchart a SAS Program?

I’m a visual person – I always need a picture. As a consultant, many times I’m given a thumb drive full of code and asked to make modifications.  When you are on a project with me, you’ll grow weary of hearing me say “Can you draw it?” Something magical happens for me when I see a flow […]

Read More
sas va labels on map

Creating Better Data for Visual Analytics Users

One factor for self-service BI is ensuring that the data is easily understood by the end user. The idea of self service BI is that users with less training can build charts and reports to help them answer their questions. This does put some onus on the data creator to make sure that the data […]

Read More
Business Intelligence Topics

It’s Easy to Add a Stored Process to SAS Visual Analytics

Not all data belongs in SAS Visual Analytics – it’s true. You may have situations where you want to filter and zoom on data and then look at the data in another system. Maybe it’s a list of items that the user wants to follow-up on in a different method. If you are using a […]

Read More
5a46377r library of congress truck overturn

Working with Large Prompt Population Lists

In my last post, I warned you about hooking up your huge dataset to a dynamic prompt.  Impending disaster, user unhappiness and worst of all – rework!  Ahhhh the horror of it all!!! I wish I knew a way to tell you when the dataset was too large for the dynamic prompt, but it is […]

Read More
sas dynamic prompts

Which population method should I use for my SAS prompt?

During our Debugging and Tuning SAS Stored Processes session, an attendee asked “Why would I choose a dynamic versus static prompt for my stored process?” It was a good question because the choice might make a difference in the stored process speed. Here’s some guidelines. What are the different Population Methods? Stored Processes take user […]

Read More

Building a SAS Stored Process Log

As a SAS stored process developer, a question sometimes pokes its way into my head: “Are people using the stored processes I write?”  In fact, really I have four questions: What stored processes are being used?  Who is using them? When are they being used? How are they using them? I realized what I’ve been missing. […]

Read More
1636r_library_of_congress_Karmi_mystery_india

SAS Stored Process: Dealing with Disappearing Results

The world needs magicians or illusionist.  I love watching illusions.  When I was at the SAS Professional Forum in the UK, there was a illusionist who just knew one card trick after another. Even when he seemed to mess up, he would then point to the card box and say, “Oh your card must be […]

Read More