As you register your stored process, you may notice that the stored process wizard incorporates your code in Step 2. Ever wondered where the wizard places this code?
In step 3 of the creation process, you are actually selecting a location and the f…
Tag: Building Business Intelligence
Info Map: Why does the data item show as scientific notation?
When a data item is created in Information Map Studio, the defaults are assigned for classifications and aggregations. If the data item is a percentage, this defaults may not make sense. For instance, the following figure shows the Gross Margin in scientific notation instead of a percentage. When the data item was imported, the default aggregation method was SUM, which does not work in this case. The gross margin is your profit from this sale and it should remain constant or in other words. So how do you fix it? You need to change the default measurement for the data item. For a value like Gross Margin, there is not reason to aggregate this data item – when is a sum of all Gross Margins for a customer or product used? For this item, the gross margin is associated with the Product data item. Any product no matter to which customer in any region, the gross margin remains constant. You have to select a default aggregation method, so I chose Average. I thought it would make the most sense to the end user. I could have also used Minimum. In the following figure, minimum would have set the value to […]
Create, Access, and View Data – All the tools you need!
SAS EBI is comprised of several applications. Here is a quick overview: Make Data SAS OLAP Cube Studio Build OLAP cube using SAS datasets. SAS Information Map Studio Build information maps from SAS datasets and OLAP cubes. SAS Enterprise Guide Connect to SAS datasets, RDBMS, and even Excel spreadsheets SAS Add-In for Microsoft Office Possible to create data in MS Excel that you can save to the server and then use in other BI Tools. This would be an option for smaller datasets that are updated infrequently and not centrally stored, for instance, an department organization structure. Use Data Web Report Studio Create reports from OLAP Cubes, Info Maps, or SAS datasets. SAS Enterprise Guide Create reports and more from OLAP Cubes, Info Maps, or SAS datasets. Also create reports that can be shared as a stored process for the other SAS SAS Add-In for Microsoft Office In MS Excel – Create reports from OLAP Cubes, information maps, or SAS datasets. Mix SAS data with the data from Excel spreadsheets. In MS Office/PowerPoint – create reports from cubes, information maps, or datasets. Not as much flexibility as with MS Excel, but you can easily create report that you can share […]
Sample Data Sources
As you start to learn the SAS Information Map Studio and SAS Web Report Studio, you may want some sample data to play with or otherwise explore. Here is a list of free sources that I have found that can help as you learn and want to challenge yourself. Simple Data Tables Here are some sources for simple data tables. These are datasets with all of the data contained in one table and do not need to join to anything else. SASHELP This listing of data may be most familiar to BASE SAS users. This library has several ready made data sets (i.e. SHOES, CLASS, and CARS). If you do not see a SASHELP library in your list, then ask your SAS Administrator to add it. SAS Enterprise Guide Data EG 4.3 shipped with some fun ready-made simple datasets: Bullets, Drugs, and TotArrests. [Hmmm …. ] This data was located in this path on my EG 4.3 installation: C:\Program Files\SAS\EnterpriseGuide\4.3\Sample\Data DATA.GOV http://www.data.gov/ has a ton of simple raw data tables on a variety of topics: earthquake activity, income data by county for 2007, and unemployment statistics. It is actually just fun to poke around to see what is available. This site also has links to other […]
External SAS Press Review Process
We are now in the External Review Process!!
The SAS Press external review process takes 6 weeks. It includes internal SAS employees who were tasked with reviewing our first 3 chapters as well as several external reviewers. They are all tasked with re…
Final Workshop
Tricia and I are planning our final all-day working session, scheduled for this Sunday, to complete the final internal author review cycle. If all goes well, on Monday we will be handing the book off to the external reviewers for their 45-day review window! Writing this book has been a great learning expeirence. Not just with how to handle writing styles, image organization, formatting, etc – but other tricks to being a SAS Business Intelligence Content Developer! I’ve been using SAS BI since 2005, but just this past month I have learned two new & super neat tricks!
Book Cover Finalized
The big news from the SAS Press front is that our book cover is now finalized!
Consolidating various resources
There are a lot of resources out there for SAS BI/EBI users and it spans a wide range of locations. The more we research the more we agree that having a single book for the BI client tools will help new users getting started with the system.
Here is a…