INTERNAL
TRAINING
SAS Visual Analytics 6.1:
Essentials
Course Notes
SAS Visual Analytics 6.1: Essentials Course Notes was developed by Bobbie Wagoner, Marjorie Shelley,
Kelly Gray. Additional contributions were made by Dave Naden. Editing and production support was
provided by the Curriculum Development and Support Department.
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of
SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product
names are trademarks of their respective companies.
SAS Visual Analytics 6.1: Essentials Course Notes
Copyright © 2013 SAS Institute Inc. Cary, NC, USA. All rights reserved. Printed in the United States of
America. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in
any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written
permission of the publisher, SAS Institute Inc.
Book code NULL, course code TTV61VA, prepared date 19Mar2013. TTV61VA_001
ISBN NULL
For Your Information iii
Table of Contents
Course Description ..................................................................................................................... vii
Prerequisites .............................................................................................................................. viii
Chapter 1 SAS Visual Analytics ............................................................................ 1-1
1.1 SAS Visual Analytics Overview ...................................................................................... 1-3
1.2 SAS Visual Analytics Architecture and Technology ...................................................... 1-37
1.3 SAS Visual Analytics Deployments ............................................................................... 1-60
1.4 The Training Environment ............................................................................................. 1-74
Chapter 2 SAS Visual Analytics Administration .................................................. 2-1
2.1 SAS Visual Analytics Users and Groups ......................................................................... 2-3
2.2 SAS Visual Analytics Roles and Capabilities .................................................................. 2-7
2.3 Managing the SAS Visual Analytics Environment ........................................................ 2-18
2.4 Authentication and Authorization .................................................................................. 2-49
2.5 Managing Mobile Devices ............................................................................................. 2-75
Chapter 3 SAS Visual Data Builder ...................................................................... 3-1
3.1 SAS Visual Data Builder Overview ................................................................................. 3-3
3.2 Defining Queries ............................................................................................................ 3-10
3.3 Viewing Query Results .................................................................................................. 3-35
3.4 Importing Data ............................................................................................................... 3-38
3.5 Editing Code and Scheduling Queries ........................................................................... 3-42
Chapter 4 SAS Visual Analytics Explorer ............................................................ 4-1
4.1 Overview of SAS Visual Analytics Explorer ................................................................... 4-3
iv For Your Information
4.2 Working with Data ......................................................................................................... 4-22
4.3 Working with Visualizations .......................................................................................... 4-55
4.4 Performing Data Analysis ............................................................................................ 4-147
4.5 Sharing Reports and Visualizations ............................................................................. 4-153
4.6 Managing Explorations ................................................................................................ 4-162
4.7 Specifying Preferences ................................................................................................. 4-170
Chapter 5 SAS Visual Analytics Designer ........................................................... 5-1
5.1 Interface Overview ........................................................................................................... 5-3
5.2 Working with Data ......................................................................................................... 5-22
5.3 Creating Reports ............................................................................................................ 5-35
Chapter 6 Report Viewers: Mobile and Web-based ........................................... 6-1
6.1 Overview and Purpose ..................................................................................................... 6-4
6.2 Basic Functions ................................................................................................................ 6-9
6.3 Getting Help ................................................................................................................... 6-25
6.4 Security Levels on Mobile BI ........................................................................................ 6-29
6.5 Using the Web Viewer to View Reports ......................................................................... 6-31
Appendix A Exercises and Solutions ..................................................................... A-1
A.1 Chapter 1 Exercises ......................................................................................................... A-3
Section 1.5 Exercises ................................................................................................ A-3
A.2 Chapter 2 Exercises ....................................................................................................... A-14
Section 2.2 Exercises .............................................................................................. A-14
Section 2.3 Exercises .............................................................................................. A-16
Section 2.4 Exercises .............................................................................................. A-24
........................................................................................................................................ A-27
For Your Information v
A.3 Chapter 3 Exercises ....................................................................................................... A-29
Section 3.3 Exercises .............................................................................................. A-29
A.4 Chapter 4 Exercises ....................................................................................................... A-36
Section 4.3 Exercise ............................................................................................... A-48
Section 4.7 Exercise ............................................................................................... A-54
Optional Exercise ................................................................................................... A-63
A.5 Chapter 5 Exercises ....................................................................................................... A-68
Section 5.3 Exercises .............................................................................................. A-68
A.5 Chapter 6 Exercises ....................................................................................................... A-79
Section 6.5 Exercises .............................................................................................. A-79
Appendix B Course Demos ..................................................................................... B-1
B.1 Chapter 1 Demos ............................................................................................................. B-3
B.2 Chapter 2 Demos ............................................................................................................. B-4
B.3 Chapter 3 Demos ............................................................................................................. B-5
B.4 Chapter 4 Demos ............................................................................................................. B-6
Demonstration: First Look at the Explorer .............................................................. B-7
Demonstration: Working with Data within the Explorer ....................................... B-10
Demonstration: Working with Data – Part 2 .......................................................... B-14
Demonstration: Working with Visualizations ........................................................ B-19
Demonstration: Working with Visualizations – Part 2 ........................................... B-24
Demonstration: Autocharting ................................................................................. B-31
Demonstration: Bar Charts and Line Charts .......................................................... B-35
Demonstration: Scatter Plots .................................................................................. B-41
Demonstration: Bubble Plots ................................................................................. B-48
Demonstration: Histograms and Box Plots ............................................................ B-51
Demonstration: Heat Maps .................................................................................... B-56
Demonstration: Geo Maps ..................................................................................... B-60