Blogs

Blogs

Data Visualization

Get the right information, with visual impact, to the people who need it

Analytics | Data Visualization

Tammi Kay GeorgeAugust 8, 2011 0

How to become more agile with mobile and visualization technologies

Agility. I've been giving a lot of thought to the term while here in San Diego for the TDWI World Conference. "Evolving Your Agile BI Environment" is the theme of this year's event and "agility" has definitely been embedded in the conversations I have had with customers the past few

Read More

Advanced Analytics | Data Visualization

Angela HallJuly 20, 2011 0

Building Identical Web Reports with Slight Filter Changes to Information Maps

I was presented with a design approach yesterday that included one web report duplicated multiple times for each group in the organization. Each web report then used essentially an identical information map with the difference of only a filter. Instead of using a single web report with a prompted filter (or copying the web

Read More

Analytics | Data Visualization

Rachel Alt-SimmonsJuly 18, 2011 0

My summer reading selection: Process improvement anyone?

I am one of those rare people that enjoys process; not rigid process and military-like discipline, but order. Wasted effort drives me insane. I’ve been on projects all through my career where I feel like the project teams are constantly reinventing the wheel, because nobody bothered to capture any documentation

Read More

Advanced Analytics | Data Visualization

Angela HallJuly 15, 2011 0

Where is the Stored Process Alert Portlet (4.3)?

When looking to add the Stored Process Alert Process (useful to see whether processes run in the BACKGROUND were completed successfully) the specific portlet type is not on the list. No worries, it's actually a personal portlet that is defined to present only YOUR stored process execution results. Therefore to locate

Read More

Advanced Analytics | Data Visualization

Angela HallJuly 14, 2011 0

Making OLAP Drill Through to Detail Data Available as Dataset in EG Project

In order to make the OLAP drill through data available as data tables in the Enterprise Guide, all you need to do is change the option to automatically insert the results as a data set in the project. This is extremely useful if part of your workflow includes navigating through

Read More

Analytics | Data Visualization

Rachel Alt-SimmonsJune 22, 2011 0

Visualize your thoughts with a mind map!

I have recently discovered “mind mapping.” Mind mapping is not a new concept, but since I (re)learned it, I’ve found it to be an excellent tool for analyzing business problems and processes. I thought you might find it interesting too! Here’s an example: The other day, I was thinking about

Read More

Analytics | Data Visualization

Rachel Alt-SimmonsJune 20, 2011 0

Making the jump to visual thinking

The SAS office in New York City has one of the best views in the city. Sitting on the 47th floor of a skyscraper on 7th Avenue, the Executive Briefing Room overlooks Central Park and it has a highly distracting view – especially on such a nice sunny day. What

Read More

Data Visualization | SAS Events

Waynette TubbsApril 6, 2011 0

Creating Circular Visualizations of Tabular Data

Contributed by Bill Roehl, Data Geek at Capella University (@garciasn) Analysts love raw data and end-users love to see that same data displayed in beautiful charts and pictures with exciting color. Dr. Danni Bayn, a Research Analyst at Capella University in Minneapolis, provides a drop-in method for SAS users to

Read More

Advanced Analytics | Data Visualization

Angela HallMarch 31, 2011 0

Manage the internal SAS 9.2 account policies

In SAS 9.2, internal accounts can be created and utilized within the metadata and then do not require host (or domain) accounts defined elsewhere. By default, the sasadm@saspw is one such internal account. Unless you specifically declare an exception, the server-level policies for routine password resetting and locking (such as

Read More

Data Visualization

Waynette TubbsMarch 23, 2011 0

SAS Rock Star, World Champ, wife, mom and entrepreneur: What’s next?

I believe I would have interviewed AnnMaria De Mars even if you hadn't sent me scads of e-mails and tweets suggesting her as a perfect candidate for the SAS Rock Stars series. I "met" AnnMaria when I started looking for SAS users on Twitter – nearly three years ago while

Read More

Advanced Analytics | Data Visualization

Angela HallMarch 21, 2011 0

Create a fully summarized table for OLAP Cubes

SAS procedure SUMMARY is a quick method of converting your detail table to a fully summarized one. Included is a sample. The key option to set is the NWAY - this generates the lowest level of summary for use in the OLAP cube. Essentially - the class statement contains all

Read More

Advanced Analytics | Data Visualization

Angela HallMarch 18, 2011 0

Star Schema Options in OLAP Cubes

In the past couple months, this scenario has occurred twice. So thought I'd share a quick remedy ~ and save for my future reference when this occurs again :). In Star Schemas, there are sometimes occasions where the data quality isn't exactly perfect. And sometimes, for some users/companies, this is

Read More

Advanced Analytics | Data Visualization

Angela HallMarch 12, 2011 0

Adding Negative Solve Orders to OLAP Calculated Members

OLAP Calculated Members need to be tested to ensure that the numbers are correct in various tools. What we recently found was that the member tested properly in the OLAP Studio View Cube but then in Web Report Studio, the measure wasn't correct. Essentially, it was calculating the custom measurement

Read More

Data Visualization

Lisa PappasMarch 11, 2011 0

How to reach enlightenment with business intelligence

Business Intelligence is a phrase that means many things to different organizations, which is why all BI vendors have their own definition. The term was coined in 1958 by Hans Peter Luhn of IBM*, who described it as “the ability to apprehend the interrelationships of presented facts in such a

Read More

Advanced Analytics | Data Visualization

Angela HallFebruary 21, 2011 0

Super Important Tip on Upgrading from 4.2 to 4.2 Add-in to MS Office

When upgrading from an existing 4.2 client install of SAS Add-in to MS Office, you are not prompted to enable the Outlook portion of the Add-in. As SAS points out in the KB Post http://support.sas.com/kb/40/272.html, there is a 'Switcher Utility' available in the client install. When running this, I would

Read More

Advanced Analytics | Data Visualization

Angela HallNovember 10, 2009 0

Using Multiple Selection Prompts in SAS Stored Process Code

It is definitely easier to force single selections for prompts used in SAS Stored Processes, however it isn't very usable when the majority of users need to select multiple values. For example, let us say we create a prompt for region (called 'region_prompt') and then use that in the query

Read More

Advanced Analytics | Data Visualization

Angela HallNovember 9, 2009 0

Mapping ESRI Style

The SAS Business Intelligence suite includes the ability to map data via the ESRI Map Service within various web clients (and even Enterprise Guide). Steps: Create an ESRI Map via ArcMap Publish to ArcGIS Server via ArcCatalog Define a New Map Service in SAS Management Console Set a cube dimension as

Read More

Advanced Analytics | Data Visualization

Angela HallNovember 3, 2009 0

Favorite Things about SAS 9.2 Add-in to MS Office

Have you seen the new SAS Add-in to MS Office? There are new features worth pointing out & hopefully this will help convince you that now is the time to switch! In SAS Management Console, three built in security roles have been estabilished to accurately assign functionality per user or group.

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 27, 2009 0

Analyzing Local Excel Data via SAS Addin to MS Office

With local data highlighted in Microsoft Excel, you can then "Copy to SAS Server" to run SAS analytical tasks. The menu bar ('SAS' -> 'Active Data' -> 'Copy to SAS Server') is also the image below: SAS provides a knowledge base entry at: http://support.sas.com/kb/32/009.html to show how this can be done with a

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 22, 2009 0

Information Map Studio 4.2 - Something to love!

Bulk editing of multiple data elements An example of this is when you have 10 items that are numerical and therefore are set to allow measures, but should be classified as categorical (such as serial numbers and ids), you can select all of these values, now you can in one

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 20, 2009 0

DistinctCount() vs NUNIQUE in OLAP 9.2

I was struggling with a calculated member that completes a distinctcount of members in a dimension, the performance was simply unacceptable. After attempting several other measures such as count(), processing changes on the source data, etc, I sent out a msg on Twitter asking for advice. Once again, why aren't

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 16, 2009 0

SAS 9.2 OLAP Server has some sweet new functionality!

Included are a few of my favorite things about the new OLAP Server (for SAS 9.2 EBI Installations). Export/Import via SAS spk file The .spk files are packages that contain everything needed to export from Development and import into Production. This is an IDEAL way to reduce dev-test-prod interactions on the

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 12, 2009 0

Shared Prompts in SAS BI 9.2 ~ Modifying via EG 4.2

After mentioning the requirements in SAS Management Console to create and edit Shared Prompts (https://blogs.sas.com/content/bi/2009/09/24/creating-a-shared-prompt-for-multiple-imaps-and-stps-9-2/), I then came across functionality in SAS Enterprise Guide 4.2. In the 'Server List', there is a small blue circle with a 1-2-3 and when you mouse over you will see 'Prompt Manager'. When adding

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 9, 2009 0

Metadata Backup Utility via SAS 9.2 Management Console

A user who is a member of the "SAS Administrators" group and has been granted the role "Management Console: Advanced" can create a Metadata Backup job via SAS 9.2 Management Console. Right Click on 'Backup and Restore' Task under 'Metadata Utilities'. Then select the Backup task created and choose either

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 8, 2009 0

Configuration Manager Plugin for SAS Management Console 9.2

Included are several of the key elements of the new Configuration Manager Plugin that I heart. 1. Modifying the Web Connection Information One of the MAIN items I love about the new version is the ability to modify the configuration of the Web Applications WITHOUT redeploying all the war files. You

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 6, 2009 0

Open up File Level Security for the BI Dashboard Configuration

(SAS 9.2) To get the SAS BI Dashboard to work appropriately, the users who have Role level access to modify and create Dashboards MUST also have read/execute/write access to the BIDashboard configuration folder (example of this location: C:SASEBIserverLev1AppDataSASBIDashboard4.2) 1. SAS Management Console: The Group "BI Dashboard Administrators" by default is

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 5, 2009 0

Automatic Updates of the SAS Data Libraries (and Tables) Metadata

The SAS 9.2 XML engine is very very very slick. I created an xml map to generate a dataset from xml generated during a metadata getobjects job to then run call execute statements for a proc metalib update. "Wait, you did what??!@#?&" you ask? Here are my simple steps. This

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 2, 2009 0

Migration Utility for EG 4.2 and Add in to MS Office (Part 2 of 2)

Would you like to make the Migration Utility easier to use for your users? There is a MappingInformation.xml file which can assist by completing the maps from old to new items (libraries, file references, information map locations, stored processes, etc) on pg 5 of the MigrationWizard.exe. In order to implement

Read More

Analytics | Data Visualization

Mike NemecekDecember 19, 2008 0

Visualize Whirled Peas?

Saw an interesting Tweet (a post on Twitter) from investor and writer Paul Kedrosky today: "geeks only: five best data visualization projects of the year http://is.gd/cwIk" The link takes you to the FlowingData blog (created by a PhD statistics student in NY), and a post on some amazing examples of

Read More

Advanced Analytics | Data Visualization

Angela HallAugust 1, 2008 0

Free SAS Training Material

Did you know that there is a wealth of SAS Training Material for free? I have this bookmarked for reference material and continued education. Free Tutorials: UPDATED URL (2009Aug03) http://support.sas.com/training/elearn/tutorials/ SAS Papers Online: http://support.sas.com/rnd/papers/ Users Group Proceedings: http://support.sas.com/events/sasglobalforum/previous/online.html

Read More

Previous 1 … 54 55 56 57 Next