Did you change your LinkedIn password yesterday? (If you didn’t, you should!) But did it happen to be the same as your corporate password? First, tisk tisk. Second, change your corporate password NOW! Ok, now that this is done ~ don’t let your saved connection profile for SAS applications lock
Tag: Business Intelligence
What if you would like to make a copy of an existing stored process to test out your changes before making them live? The copy command is available from within SAS Management Console or from the SAS Enterprise Guide Open Stored Process GUI as seen below (note you can only
During the SAS Global Forum this past week, SAS offered several demos on mobile technology including: Michael Hecht, SAS, JMP iPad App Super Demo Chris Hemedinger hosted a Live Tech Talk on Tuesday that covered the new SAS Visual Analytics Explorer with demos on Microsoft Surface and iPad Apps Remember everyone is using mobile devices
A storyboard is a blueprint of drawings/ideas in a specific sequence to illustrate a story. Let’s take the Pixar film Toy Story as an example (I have a two-year-old and admittedly have watched this movie more than the hairs on my head). Before they ever began animating with the design
Unfortunately, my clone attempt didn't work like Chris Hemedinger's did. With all my papers, presentations, and demo hall duties, I realized yesterday that I certainly missed a lot. Included is my to-do list for items to watch and catch up on this weekend. Not really sure how I missed the
Reducing the data gatekeeper role helps people at all levels of the organization quickly interact with data and uncover significant value. That's business intelligence in a nutshell, but what's new with BI these days?
Whether you call it Business Intelligence, Business Analytics, Visual Analytics, etc. - getting information to the users when they need it and make it actionable requires more than just software. BI Content Developers can have a certification but to be successful they really need to have an understanding of human
One of the biggest hits of the demo hall at SAS Global Forum was the cute Koala bear swag from MetaCoda.com. Everyone wanted to stop by the booth and pick one up for their badge. Driving people to your booth is the first step, but then you must have cool
My friend and fellow blogger Steve Overton was tasked with presenting not one by two papers in a single one hour block. My original strategy was to take Instagram pictures of him running down the hall to get to the second session on time, but since both were in the
We already miss you and wish you could be here. WAIT! Don't cry in your office! There are so many ways to stay connected to the SAS Global Forum happenings this year. If you are not able to attend in person, here is a list of sites that you can
This past Monday, Tricia and I released our 2nd book this year. "The 50 Keys to Learning SAS Stored Processes" provides a step-by-step approach to transitioning from SAS code into user driven (prompted) stored processes. Trimming down all the things you can do with SAS Stored Processes is next to
By now, I’m sure you have created your personal agenda for SAS Global Forum – so guess I will see you on Tuesday morning (9:30 am) in the Southern Hemisphere V area for the Get Your “Fast Pass” to Building Business Intelligence with SAS and Google Analytics presentation. Angela Hall
There are only four more days before the big kickoff! But for many of us (including me), the countdown to SAS Global Forum 2012 began last fall with the submission of paper ideas to the incredibly awesome section chair volunteers. I live for this event, the networking, training opportunities, customer
PROC STP is a new procedure for SAS 9.3 Stored Processes. It's so new and different that I have not had the opportunity to use it yet in a customer engagement. When writing about it for the now released "The 50 Keys to Learning SAS Stored Processes" book, I had
I'm a sucker for the sampler platter at restaurants - it gives you a little taste of everything. "The crispy, gooey cheese sticks are delicious, but man, I really want more of the chicken skewers as my meal," is typically how my thought process goes. SAS Training is offering the
In my last blog post I revealed the WOW factor of SAS Visual Analytics. In summary: analyzing billions of rows of data, across vast numbers of columns, via 100+ correlation calculations in SECONDS (wow). What exactly does that mean? SAS Visual Analytics takes full advantage of SAS’ high-performance analytics technology.
I remember the first time I saw a Cirque du Soleil® performance—the artistry, the split-second timing, that repeating sense of WOW. I was an instant fan. Funny… but I got that same sense of awe the first time I saw a demo of SAS® Visual Analytics. I’d read the project
I have previously spoken about using custom formats and from SAS Information Maps and how they can be used to categorize data differently for your end users. The problem for some is that this requires establishing the format on the SAS server, typically on lockdown by the SAS Administrator. Another
You can keep track of and report anything with SAS, even motivation - or the lack thereof. This team has developed a portal to analyze and report their ride data. It could just as easily be used for groups who want to work together to lose a few pounds, train
When you are constantly taking the data tables and completing joins to begin working on your reports or analysis it might be time to consider creating permanent views. Then you can just add the view to the Enterprise Guide project rather than dealing with the joins in a Query Builder
After unwittingly getting involved recently in a code vs GUI discussion another pro GUI vote came in yesterday when presenting to a customer's internal user group. When creating and using prompts in SAS Enterprise Guide, it is a no-brainer to recommend leveraging the %_eg_WhereParam as it handles all the special
In my role at SAS I have the great fortune to meet with business intelligence and analytic (BI&A) teams all across the United States to share and discuss best practices and pain points, particularly around the ability to execute and operationalize insight internally and externally throughout the organization. In these
This week I attended the inaugural Insurance and Finance SAS User Group conference at the SAS Headquarters in Cary, NC. The two-day conference was well attended by 80 members of our insurance and financial services customer community, and attendees were treated to a variety of presentations focused on these industry
During IFSUG yesterday, Sunil Gupta gave attendees to his presentation a special homework assignment. Look into the SAS Enterprise Guide task 'Characterize Data'. Sunil suggested that this was a simple approach to quickly getting a summary of all the variables within your data table. Of course, some programmers will use
Today at IFSUG, Chuck Patridge presented a wonderful talk about how to complete fuzzy matching using BASE SAS tools. Chuck has been programming SAS since 1979 and has been tasked multiple times with coming up with in-house solutions to address business needs without the software costs that are typically associated
At the IFSUG conference this week in Cary, NC I met Stephen Harris from Bank of America. Stephen gave the talk "Manage Your Partners Before You Manage Your Dashboards: Designing Great Dashboards" covering the business aspects of successfully implementing dashboards. When you back up for a second to consider the
Well, we can't really afford to give everyone a free copy of the Building Business Intelligence Using SAS: Content Development Examples. But copies will be presented to two randomly selected participants of today's AllAnalytics.com eChat! Then you can be a part of the celebrations! Yes, that's right! People have been
Unlike BASE SAS tables, OLAP cubes must exist in within the metadata in order to access from any of the OLAP Viewers. In addition to having some metadata OLAP cubes have a physical file structure presence (at least for MOLAP/HOLAP because it's a different story for ROLAP). When you refresh
One of the cool things with SAS OLAP Viewer in Add-in to Microsoft Office is your ability to skip right into a specific value. Out of the box, viewing OLAP cubes can lead you to believe that in order to view a specific value you need to click-thru a hierarchy
Unlike prior versions of SAS OLAP technology, 9.2 provides more options for maintaining and refreshing OLAP cubes. With this comes some discussion about what each one does alone, and how pairing these techniques really provides SAS OLAP Server Administrators and cube developers a cornucopia of OLAP options. PROC OLAPOPERATE Remember