Enthusiastic SAS Global Forum users flocked to the SAS Business Intelligence Development Roundtable for an interactive panel discussion on the current BI and reporting solutions portfolio including SAS Enterprise BI Server, SAS Enterprise Guide, SAS Mobile BI and SAS Visual Analytics and the future focus of the products. Panelists included SAS representatives from Product
Tag: Business Intelligence
Rick Styll from SAS presents the latest features of SAS® Enterprise Business Intelligence which include improved dashboards, navigation and better integration with Excel and email clients.
Tricia Aanderud from And Data and Angela Hall from SAS share the advantages of SAS® Stored Processes with the SAS Global Forum! In this discussion, you will learn tips and tricks for using stored processes within SAS BI clients. Watch their presentation, "Stop Your "Wine"ing: Use a Stored Process", now
I have been on a plane non-stop for four weeks travelling around Asia working with key customers looking to expand their analytics footprint. It's clear that analytics is no longer taking a back seat to business intelligence (BI). Customers I am talking to have squeezed as much value out of
Boris Evelson ist nicht irgendein Branchenkenner: Der Analyst ist vielleicht der BI Experte bei Forrester! Wie schon oft zuvor schaut er auch 2013 in die Glaskugel und trifft Voraussagen, welche Themen in diesem Jahr dominieren werden. Beim Lesen seines Artikels ist mir klar geworden, wie gut SAS® Visual Analytics den eigentlich erst noch
It was a moonless night in April 1912 when the pinnacle of ocean travel technology and luxury, the RMS Titanic, collided with an iceberg in the North Atlantic, resulting in the deaths of more than 1,500 passengers and crew. A primary cause of the tragedy was that the captain and
SAS Technical Support has a wonderful how-to guide for using one set of prompt values across multiple sections of a Web Report Studio report. This works great in 4.2, however there is one additional item that I discovered in a 4.3/9.3 install. With the addition of PROC STP and SAS
It goes without saying that if you know the value of analytics, it can sometimes be frustrating when leaders who may not have an analytic background do not understand or see the difference between basic reporting and advanced analytics. At SAS, we often refer to those two very different things
To read more ongoing tips and insights for small and midsize businesses, follow our SAS4SMB blog series or visit SAS for Small and MidSize Business. Data underpins the operations and strategic decisions of every business. Yet these days, data is generated faster than it can be digested, making it challenging
With an exponential growth in transactions, it may be hard to get a clear, single view of customer interactions. ICICI Bank , India's second largest bank, needed a single system that could replace multiple (complex to maintain) reporting systems - enterprise wide. The challenge - finding a solution to handle its growing
Each spring and fall, I start clearing out the kid's small clothes, old toys, etc. It can sometimes go too far and reach into my "digital pack-rat" issues. (Wait, what does that mean? Well, just ask the person who last week requested detail on a project I worked 3 years
BASE SAS users are already familiar with the autoexec file. This is a .sas file that typically resides in the installation folder of the SAS executable. Instructions for setting it up in UNIX, Windows, and other environments is readily available on the SAS website. In SAS BI configurations there are
After installing SAS Business Intelligence, I would also suggest verifying that all is working appropriately before adding users or importing content from another machine. (My template checklist is included below.) The act of creating the content is an extremely important test (to immediately rectify issues with accessing data, or saving
Last week I provided the steps for how to go on a date, at least by using dynamic prompts in BI Dashboard. Now that you have seen how to create them, lets discuss making them smarter. For this example, the customer is asking for two prompts to affect a single
Don't give up on the dating game. Just because there is no prompt type specifically for dates, it can still be accomplished with some stored process matchmaking. BI Dashboard offers a dynamic prompt indicator which provides the ultimate flexibility in developing prompt based reports and dashboards. The dynamic prompt indicator
As much as I enjoy dramatic reinterpretations, for this blog post I’m just going to talk to you about the complex challenges municipal organizations face in setting spending priorities. The complexity stems from competing aspects of the various projects vying for funding. Some of these factors are related to the
Who says anyone is an expert at something? I definitely do not when it comes to SAS (well, anything for that matter). Each time I sit through a presentation at a conference I learn something new. During the SAS Western Users Conference, fondly know as WUSS, this month I learned
Out of the box, the simple bar graph uses the same color for each bar. A frequent request from users is to define a standard color palette for the dashboard indicators so distinct bars are the same color in each indicator or from refresh to refresh. With most dashboard tricks,
This is a dramatic interpretation of an actual conversation I recently had with the CIO of one of North Carolina’s leading cities. We discussed his experience using data quality, data integration, business intelligence and analytics in the daily operation of the city. I may have taken some...well, a lot of
With limited time and budget, you can still thoroughly test SAS reports built in SAS BI Dashboard and SAS Web Report Studio by considering how all the tools were used to build the end report. An understanding of the functionality within each part of the chain from raw data to
Most management literature and studies posit that organizations with a clear mission and work objectives, understood by all levels of the organization, are the most productive. The key to that success is effectively communicating the mission, agreeing on key performance indicators and giving employees at all levels access to relevant
So are you now dreaming big? Coming up with other ideas for how SAS Stored Processes can be leveraged in your installation of SAS? As I mentioned in last week's post, you could use OLAP cubes as a data source for your SAS Stored Process. Here is how I would
One of my new work friends says this frequently. But the statement is lost in his translation from Portuguese, it is not that he does not believe me, it is just that he has questions about how things happen so he can learn. I debate on which version of this
Wizard Harry Potter makes magic just waving his wand around and shouting out spells. Using SAS Enterprise Guide (and you are welcome to shout out your own commands too) you can create some magic, allowing the Stored Process Wizard to code for you. On Step 2, the "Include code for"
After some discussion with SAS Product Marketing yesterday, we devised this response to everyone's question about the Business Analytic differentiator that SAS provides. ********************************************************************************************************* Business Intelligence is one of the key components from SAS that ties into a suite of analytic techniques, information handling and performance infrastructures needed to deliver
Questions (or search strings) lead people to my blog or my email box on a daily basis and many of these are related to what SAS Stored Processes can or cannot do. Can a SAS Stored Process query an RDBMS? Can a SAS Stored Process create a data table? Could
Six user import and synchronization macros are available in the SAS Foundation directory, these are documented as available in creating programs to retrieve information and compare authentication provider (such as LDAP) account information with what is stored in SAS Metadata to then synchronize the two. Try this code in BASE
A common question really and one that I get after posting code like yesterday's All SAS Stored Process Locations Report. The neat trick is just to type METABROWSE in a BASE SAS command window. (There are two other commands: METACON and METAFIND. Has anyone got any tips on when those
Stored process code can exist within the metadata itself for version 9.3 (the benefits of which I discussed earlier). But for all other versions (and as a option in version 9.3) the SAS code is stored as a .sas file within the server's file system (or mapped folder/drive structure). When editing
The date prompt from SAS Prompt Framework provides the options of single selection or a range, however what if you need to select multiple individual dates such as Monday (May 28), Wednesday (May 30), and Friday (June 1) of last week? There are a few alternatives to accomplishing this. Option