contents

about this book

about these authors

acknowledgements

introduction

part one: getting started

chapter one: accessing content

Methods of accessing content

Accessing content with a web browser

Accessing content through the public portal

Accessing content with the mobile bi app

Understanding roles

Accessing SAS Visual Analytics

Transformation of the homepage

Understanding SAS home

Opening a report

Creating a shortcut

Creating a collection or content tile

Using the report viewer

Navigating a report

References

chapter two: building your first report

Accessing the designer

Introducing the designer layout

Building your first report

Adding a data source

Creating new data items

Populating your objects

Improving the data object appearance

Adding data to other objects

Working with data objects

Adding object interactions

Saving the report

Reviewing the report

References

chapter three: building your first dashboard

Dashboard building process

Understanding your customer

Establishing objectives

Tips for more useable dashboards

Building the dashboard

Adding the data objects

Creating the layout

Working with data objects

Linking to another section

Other dashboard enhancements

Adding text boxes

Adding artwork

Embedding a stored process

Summary

References

chapter four: using the data builder

Using the Data Builder

Creating a data query

Opening the Data Builder

Filtering the data

Create a summary data query

Updating the code

Scheduling a query

References

part two: customizing your data visualizations

chapter five: visualizing your data

Elements of an effective data visualization

Your message: know your point

Your audience: know who is listening

Your technique: follow the KISS principle

Line charts

Interpreting the results

Line charts: guidelines

Line charts: tips and tricks

Bar charts

Interpreting the results

Bar charts: guidelines

Bar charts: tips and tricks

Pie and donut charts

Interpreting the results

Pie and donut charts: guidelines

Pie and donut charts: tips and tricks

Treemaps

Interpreting the results

Treemaps: guidelines

Treemaps: tips and tricks

Waterfall charts

Interpreting the results

Waterfall charts: guidelines for use

Waterfall charts: tips and tricks

Gauges

Interpreting results

Gauges: Guidelines

Gauges: tips and tricks

Tip 1: Use display rules

Tip 2: Add a shared rule

Tables and cross tabs

Interpreting the results

Tables and crosstabs: guidelines for use

Tables and crosstabs: tips and tricks

Bubble plots

Interpreting the results

Bubble plots: guidelines

Bubble plots: tips and tricks

References

chapter six: the where of data

Using geospatial data effectively

When location is not part of the data story

When location is the data story

Preparing data for geospatial visualizations

Creating a predefined geographic data item

Creating a predefined geographic data item

Creating a custom geospatial data item

Creating a custom geographic data item

Displaying geospatial objects

Get to the point with geo coordinate data objects

Compare area with geo regional data objects

Show overall trends with bubble plots data objects

Expanding location intelligence

Understanding details about mapping technologies

References

chapter seven: approachable analytics

About the Explorer

Automatic chart feature

Box plots

Interpreting the results

Adding more data items

When to use box plots

Histograms

Changing objects in a visualization

Histogram options

Using a correlation matrix

Calculating a correlation

Understanding the matrix

Interpreting a correlation value

Forecasting

Working with the forecasting option

Using the scenario analysis

Word clouds

Loading social media data

Setting up the word cloud

Scatter plot

Data analysis

Adding categories

Heat map

Data analysis

Using a category

Other tips when using the Explorer

Include and exclude

Moving visualizations to the Designer

References

part three: administration and data loading

chapter eight: loading data

In-memory is different

It’s about speed

Understanding the non-distributed deployment

Understanding the distributed deployment

Loading data to LASR from HDFS

Enabling support for SASHDAT files

The exception to the rule

SASHDAT does not require SAS/ACCESS

Loading data to LASR from Base SAS

Loading data to LASR with SAS In-Database technology

Loading data to LASR from a different LASR Analytic Server

Loading data into LASR automatically

SAS Autoload to LASR facility

LASR Reload-on-Start feature

References

chapter nine: LASR administration

Administration overview

Administration tools

SAS Management Console

SAS Visual Analytics Administrator

SAS Environment Manager

SAS Program Code

Other tools

Interesting LASR Administration Tasks

The role of SAS metadata

Defining new LASR Analytic Servers

Defining new LASR libraries

Managing LASR Analytic Servers with code

Working with the Autoloader Facility

Monitoring resources used by LASR

References

chapter ten: performance considerations

LASR performance

Non-Distributed LASR (SMP)

Distributed LASR (MPP)

Load balancing by data distribution

High-volume access to smaller tables

Fast loading of data to distributed LASR Analytic Server

LASR and a remote data provider (asymmetric)

LASR symmetrically co-located with HDFS

LASR co-located with dedicated HDFS and loading data from remote HDFS

References

part four: SAS Visual Analytics 8.1

chapter eleven: introducing the SAS Viya platform

Overview of the SAS Viya platform

Understanding the CAS In-Memory Analytics Server

Introducing massively parallel analytics

Adding persistence

Providing more flexibility

SAS Viya and SAS 9.4 together

Managing the SAS Viya environment

Managing users and groups

Managing data

Managing content

References

chapter twelve: wrangling your data

Introducing a modern user interface

New features

References

chapter thirteen: visualizing and exploring your data

Introducing the new layout

Starting a new report

All-in-one application

Additional features

References

index