I’m really excited, Angela and I were invited to speak at the SAS Global Forum in Orlando in April. We were asked to talk about the SAS BI package and we have narrowed down our topic to SAS Information Map Studio, SAS Web Report Studio, and, if time allows, the SAS Information Delivery Portal. The point of the presentation is learning about the SAS BI clients – getting the data has proved to be a journey of it’s own. Step 1: Need some interesting data … The hardest part of preparing a teaching presentation is find data that presents some mystery and allows you to tell a story that resonates. Right now the leading topic is along the lines of “How do you let people know you have a book out there? How do you build excitement?” For us, building a companion website (this blog) that gave the users an idea of the book content was our answer. Plus the website would be a continuation of the book information for the users. The next question is – “How do you know it’s working?” Using the data that Google Analytics collects for this blog, I have been researching what kind of […]
Tag: Web Report Studio
Web Report Studio: Where are the row numbers?
There are times when you need row numbers on your report. Maybe you are ranking items and you want to be clear that the list is ranked or maybe you have a report viewer who only feels the report is complete when the numbers are present. To add row numb…
Web Report Studio: Where are the row numbers?
There are times when you need row numbers on your report. Maybe you are ranking items and you want to be clear that the list is ranked or maybe you have a report viewer who only feels the report is…
[[ This is a content summary only. Visit my websit…
SAS BI: Conditional Highlighting for Reports
Conditional highlighting, also referred to as traffic lighting, helps report consumers quickly recognize when the data is showing the desired trends based on their targets. Today I’ll talk about the color choices for the highlighting from MS Ex…
Web Report Studio: Souped up Dashboard Speedometers, Sliders, and Dials
Sometimes SAS Web Report Studio needs some dashboard dials and sliders that seems like mission impossible for you. However, add a stored process with the trusty ole’ SAS GKPI procedure to bring the dashboard features to your local report. I know you are wondering – “What is this special magical procedure of which she speaks?” Oh you are about to find out my precious little SAS geeks. Adding Dashboard Goodies to SAS Web Report Studio You can easily add sliders, dials, and speedometers to your report using a stored process and the SAS GKPI procedure. In the following figure, the report contains a sample of the different gadgets you can add. Plus notice – there is not any data (cube, info map) being used – it’s all stored processes. Show me the Code! All of the code was based on the examples from the GKPI procedure SAS documentation. I’m only going to show how to create the one for the Avg Fix Response Time because there are just a few fine points to creating an registering the stored process. Otherwise, I basically used the examples from the SAS documentation and I think it’s easy enough to figure out. […]
Web Report Studio: I need a better date than this one …
In Web Report Studio, I was trying to create a bar chart that showed the total payments by month. However, the Payment Date was the actual date the company received the payment and as a result the chart had a “play-by-play” action instead o…
Web Report Studio: Who stole my pie (chart)?
Ok – I”ll just say it. I hate pie charts. If there are more than a few categories – then the user has to interpret the ranking order, it slows them down, and they may loose interest in the report that you so lovingly prepared. Maybe you say – “Tricia, add the numbers! Geez – you’re so dramatic!” Then I will calmly reply to your dramatic outburst, if I want to have numbers – then why not just provide a data table? Let’s look at some examples so I can use the power of screen captures to sway you to my way of thinking. 30-Second Test Consider the following beautiful pie chart from Web Report Studio – you have 30 seconds to decide the product had the largest sales. It will take 30 seconds because you have to determine which slice actually is the largest (and there are two competitors) and then correlate the slice color to the product name in the legend. Go ahead, I’ll wait. Ok – let’s try the method of adding the numbers. Note that this beauty contest winner is getting cluttered. To make room for the numbers, the chart is getting smaller. I could use percentages to make the […]
Link to a specific section of Web Report Studio
If you would like to link users to a specific section within a Web Report Studio report, there is a quick way to generate the URL. Just send yourself an email from Web Report Studio. A parameter &rsTS is included in the link which corresponds to th…