PROC-X.com
An online (unofficial) SAS® journal – written by bloggers

Main menu

Skip to content
  • About
  • add your blog
  • Contact us
SAS

Peek Inside SAS BI Book: Building Business Intelligence with SAS

by Tricia Aanderud • February 4, 2012 • Comments Off on Peek Inside SAS BI Book: Building Business Intelligence with SAS

This post was kindly contributed by Business Intelligence Notes for SAS® BI Users - go there to comment and to read the full post.

SAS BI Book Cover

You may be aware by now, our new SAS BI book Building Business Intelligence with SAS:Content Development Examples launched last week on the SAS Press site. That’s right, SAS Press or Amazon will be delighted to bring a copy of this SAS BI book to your door.

When Angela and I set out to write this book, one of the first things we discussed was how new users get access to the SAS BI toolset and have no idea of its astonishing capabilities. This book guides you through each one so you understand it. Intermediate and advanced users will also find this book as a valuable reference. Several times, Angela & I have both found ourselves pulling out the draft copy to reference an advanced technique.

This book fulfills a unique spot in the marketplace; there is no other single book that leads you through each SAS BI component with step-by-step examples along with hundreds of tips and techniques to make you successful! SAS Institute offers over nine SAS BI courses to cover all the topics we have jammed packed into this book. Making this an excellent study guide for those planning to take the SAS BI Content Development Exam.

Your SAS BI Bible Personal Tour

Almost every reviewer said, “Wish I had this book when I first started!” After reviewing the book, several reviewer dubbed it the SAS BI Bible.  Since we cannot really go on a book tour, the next best thing is giving you a personal tour of each chapter.  Here’s some select screen shots to help you understand the book contents.

Chapter 1: Introducing the SAS BI Clients

The first chapter is as you would expect, providing an overview of the SAS BI clients and explaining how they interact with one another along with some common BI definitions.

Throughout the book many of the examples use SASHELP and SAS EG datasets so you can follow along to re-inforce your understanding. Look for the lighting bolt icons in each chapter, these icons highlight tips that contain essential information!

SAS BI Book Introduction

Chapter 2. Using SAS Enterprise Guide with SAS BI

SAS Enterprise Guide has extended functionality when used with the SAS BI clients. The first part to understanding the relationship is learning how to connect to the metadata. This chapter does not stop there – it introduces all the ways you can integrate the SAS BI clients including stored processes, prompts, and the OLAP viewer with SAS Enterprise Guide.

 

SAS BI Book Enterprise Guide

Chapter 3. Creating and Enhancing Stored Processes

Stored processes have so much power! Even if you do not know how to code in SAS – you will find this chapter makes it as easy as spelling SAS. We show you how to creat your first stored process and then provide advanced pointers for using stored processes with HTML code, multiple prompts, and the other SAS BI clients.

SAS BI Book Stored Processes

Chapter 4. Comprehensive Guide to the SAS Prompt Framework

Prompts take your stored processes to the next level when used correctly. This chapter describes each of the different prompt types: dynamic, dependant, grouped, and shared. We step you through a few examples to put the punch into your stored processes.

SAS BI Book Prompts

Chapters 5 and 6 – Preparing SAS BI Data Sources

You need OLAP cubes and information maps as data sources. A chapter is dedicated to each topic with examples of how to create your first information map and OLAP cube. In later chapters, you’ll see examples of how the information map and cube are used by content developers. 

SAS OLAP Cube Studio Builds Cubes Quickly! 

OLAP cubes can be tricky – but they are also the centerpiece of a great BI implementation. OLAP cubes make big data structure nimble and ease to navigate.  Learn to design and build your first cube with SAS OLAP Cube Studio and then learn to extend the cube’s functionality.

SAS BI Book OLAP Cube Studio

SAS Information Map Studio 

Information maps allow you to transform databases into business data. You can learn to create information maps that have filters and use cascading prompts. From there learn to add filters based on user identity to protect the data and reduce the maintenance nightmare. 

SAS BI Book Information Map Studio

 

Chapter 7. Learn Web Report Studio Tips from the Pros!

Web Report Studio is an amazingly easy interface to use. Just by walking through one example, most users are able to understand and build their own reports within minutes. This chapter explains the extras to help you understand how to create custom sort formats, integrate stored processes with your group breaks, and even smarten up your reports with conditional highlighting.

SAS BI Book Web Report Studio

Chapter 8. Learning to use SAS Add-In for MS Office

Using the SAS data with MS Office opens all kinds of possibilities to users. This chapter explains how to use the SAS Tasks to create graphs and table and how to share the data with the other MS Office applications for one button updating. There are additional tips for filtering the server-side data and using the OLAP viewer!

SAS BI Book Add-In for MS Office: Excel, Word, PowerPoint and Outlook

Chapter 9. SAS BI Dashboard

It may be a challenge to design a dashboard, but only because the SAS BI Dashboard gives you such a broad range of choices and abilities. You can take your dashboard from 0 mph to 60 mph in 2 seconds once you understand how to setup all the cool indicators. This chapter teaches you how to add cascaded prompts, set up alerts, and integrate a stored process if you desire. The US Sales Map in the figure was created with a stored process, how cool is that?

SAS BI Book BI Dashboard

Chapter 10. SAS Information Delivery Portal

Using the portlets, you can add a wide variety of content to the portal pages – everything from Web Report Studio reports, dashboards, and stored processes to external content such as RSS feeds or external Web sites. This chapter describes each portlet, explains how to work with the layouts, and some tips for allowing outside access if necessary.

SAS BI Book Information Delivery Portal

 

Get Your Own Copy! 

We think you’ll be glad to have it on your desk. Use one of these links to order it today.

Buy from SAS PressBuy from Amazon

Related content:

  1. Building Business Intelligence Using SAS Book
  2. SAS Business Intelligence Tools Overview
  3. SAS® Global Forum: Is Google Analytics and SAS BI a good subject?
  4. SAS BI Prompts: Gettin’ User Friendly
  5. SAS BI: Sample Data Sources

This post was kindly contributed by Business Intelligence Notes for SAS® BI Users - go there to comment and to read the full post.

Tags: Add-In for MS Office Best Practices BI Books BI Dashboard Building Business Intelligence career coding dashboards data Getting Started Information Map Studio information maps libname Metadata OLAP Cube Studio prompts SAS BI Content Exam SAS Enterprise Guide SAS Management Console SAS OLAP Cubes Stored Process Tips Stored Processes Web Report Studio

Post navigation

← Role-Based Access to Metacoda Security Plug-ins in SAS Management Console
Accessing files via SFTP in SAS →

Popular Posts

  • SAS – Lowercase (lowcase) / Uppercase (upcase) / Proper Case (propcase)
  • How do I export from SAS to Excel files: Let me count the ways
  • How to Get Row Numbers in SAS Proc SQL (and DO NOT Use the Undocumented MONOTONIC Function)
  • How to convert the datetime character string to SAS datetime value? (ANYDTDTM and MDYAMPM formats)
  • Using SAS Enterprise Guide to run programs in batch
  • Clear the Results viewer in SAS 9.3

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com

Contributors

  • AFHood Group Blog » SAS
  • Avocet Solutions
  • BI Notes
  • Blogging about all things SAS
  • BusinessKen
  • Computing from Out in Left Field
  • Data Steps
  • Enterprise Software Doesn’t Have to Suck
  • Gregor Gorjanc (gg)
  • Heuristic Andrew
  • Jared Prins’ Blog – SAS
  • Ken's SAS tricks
  • Michael @ Scorpio
  • Musings From an Outlier: The SAS Users Blog
  • NOTE: Development With SAS
  • Numbermonger » SAS
  • Peer Revue
  • Peter Flom blog (Statistical Analysis Consulting)
  • platformadmin.com
  • ProcRun;
  • SAS – BioStatMatt
  • SAS – Confounded by Confounding
  • SAS – From a Logical Point of View
  • SAS & Statistics
  • SAS | r4stats.com
  • SAS and R
  • SAS Learning Post
  • SAS Live!
  • Sas on Melinda Higgins, Ph.D
  • SAS Programming for Data Mining
  • SAS support site – SAS Users
  • SAS Users
  • SAS-BI Business Layers
  • SASopedia
  • SASTechies
  • Software & Service
  • Statistical Analysis Consulting
  • StudySAS Blog
  • The SAS Dummy

Recent Posts

  • New certification alert: SAS® Certified Specialist: Administration of SAS® Viya®
  • SAS training: 5 free sessions technologists love
  • Creating a Microsoft Excel report using SAS, Python and SQL!
  • Decode your SAS® macro code with the MFILE and MPRINT options
  • ESM and S9CA: Useful Tools for Migration from SAS 9 to SAS Viya
  • CAS-Action! Advanced Frequency Tables – Part 4
  • CAS-Action! Grouping Frequency Tables – Part 3
  • Using SAS to score a test
  • CAS-Action! Saving Frequency Tables – Part 2
  • CAS-Action! Simple Frequency Tables – Part 1
  • CAS-Action! Rename Columns in a CAS Table
  • Details, details: Updates to The Little SAS Book
  • SAS administrator tip: How to identify and prevent duplicate librefs in SAS metadata
  • Building an Open Source Software Community
  • Unexpected results from missing values with PROC SQL

Copyright © 2023 PROC-X.com. All Rights Reserved. The Magazine Basic Theme by bavotasan.com.

0