Home » Need to Learn SAS BI this weekend?

Need to Learn SAS BI this weekend?

SAS BI Book CoverUse the SAS BI Bible

 

Purchase from SAS Press Purchase from Amazon

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 tool set and have no idea of its astonishing capabilities.pull_quote

Several times, Angela & I have both found ourselves pulling out the draft copy to reference an advanced technique. So we think intermediate and advanced users will find this book as a valuable reference tool.This book fulfills a unique spot in the marketplace; there is no other single book that leads you through each SAS BI component providing 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.

Since we cannot really go on a book tour, the next best thing is giving you a personal tour of each chapter.

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 reinforce 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 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 cut 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 more 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 set up all the cool indicators. This chapter teaches you how to add cascaded prompts, set up alerts, and integrate a stored process if you want. 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 lot 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 to Start Learning Today!

We think you’ll be glad to have it on your desk. Use one of these buttons to buy your copy! Get Chapter 1 free from the SAS Press site.

Buy from Amazon