SAS Visual Analytics for SAS Viya

SAS Visual Analytics for SAS Viya

by SAS Institute SAS Institute Inc.
Released December 2020
Publisher(s): SAS Institute
ISBN: 9781952365119

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Discover your data and create reports in an elegant and intuitive web-based interface!

SAS Visual Analytics for SAS Viya is a practical guide designed to get you started investigating your data and creating reports with SAS Visual Analytics, a web-based tool that enables you to explore huge volumes of data to identify patterns, trends, and opportunities. Learn how to report, share, and collaborate on insights from data with no SAS programming skills necessary – this book is accessible to all, including decision makers, business analysts, report creators, and citizen data scientists.

SAS Visual Analytics for SAS Viya first introduces the basics needed to prepare and explore your data, make discoveries, and create a report in SAS Visual Analytics. Then, the second section describes more advanced topics, such as using automated explanation and creating advanced interactive reports with parameters.

The book covers:

  • Adding and manipulating data items within SAS Visual Analytics
  • Analyzing data with SAS Visual Analytics
  • Designing and sharing reports using SAS Visual Analytics

Demonstrations and practices are included for you to follow to gain hands-on experience with SAS Visual Analytics, and the data sets used in the book are also provided to download.

Table of contents

  1. About This Book
  2. Acknowledgments
  3. Chapter 1: Introduction to SAS Visual Analytics
  4. 1.1 Introduction
    1. SAS Visual Analytics
    2. SAS Visual Analytics in SAS Viya
    3. SAS Viya Architecture
    4. SAS Viya Applications
  5. 1.2 SAS Visual Analytics Process
    1. Understanding Roles
    2. Introducing the Data
    3. Demo 1.1: Exploring SAS Drive
  6. 1.3 Viewing SAS Visual Analytics Reports
    1. Demo 1.2: Viewing Reports
    2. Practice 1.1
    3. Quiz 1.1
  7. Chapter 2: Accessing and Investigating Data
  8. 2.1 Introduction
  9. 2.2 Accessing the Data
    1. Importing Local Files
    2. Importing Social Media Data
    3. Accessing Server Files
  10. 2.3 Investigating the Data
  11. 2.4 Objects
    1. Tables
    2. Automatic Chart
    3. Demo 2.1: Accessing and Investigating Data
    4. Practice 2.1
  12. 2.5 Transforming Data Using SAS Data Studio
    1. Activity 2.1
    2. Demo 2.2: Preparing Data
    3. Practice Scenario
    4. Practice 2.2
  13. Chapter 3: Analyzing Data Using SAS Visual Analytics
  14. 3.1 Introduction
    1. SAS Data Studio Versus SAS Visual Analytics
    2. Data Views
    3. Demo 3.1: Working with Data Items
    4. Practice3.1
  15. 3.2 Exploring Data with Charts and Graphs
    1. Histograms and Box Plots
    2. Bar Charts
    3. Demo 3.2: Exploring Data – Part 1
    4. Practice3.2
    5. Demo 3.3: Exploring Data – Part 2
    6. Practice 3.3
  16. 3.3 Creating Data Items and Applying Filters
    1. Creating Data Items
    2. Calculated Items Versus Aggregated Measures
    3. Activity 3.1
    4. Custom Category
    5. Demo 3.4: Creating Data Items
    6. Activity 3.2
    7. Practice 3.4
    8. Filters
    9. Geography Maps and Data Item
    10. Hierarchies
    11. Demo 3.5: Applying Filter
    12. Practice 3.5
  17. 3.4 Performing Data Analysis
    1. Bubble Plots and Tree Plots
    2. Demo 3.6: Analyzing Data
    3. Practice 3.6
    4. Relationship Plots
    5. Fit Lines
    6. Time Plots
    7. Forecasting
    8. Demo 3.7: Adding Data Analysis
    9. Practice 3.7
    10. Quiz 3.1
  18. Chapter 4: Creating a Simple Report
  19. 4.1 Introduction
    1. Activity 4.1
  20. 4.2 Graphs
    1. Pie Charts
    2. Word Clouds
    3. Dual Axis Charts
    4. Demo 4.1: Creating a Simple Report
    5. Practice 4.1
  21. 4.3 Creating Interactive Reports
    1. Multiple Pages
    2. Demo 4.2: Working with Pages and Ranks
    3. Practice 4.2
    4. Filtering
    5. Controls and Prompts
    6. Actions
    7. Demo 4.3: Working with Prompts and Actions
    8. Practice 4.3
    9. Adding Links
    10. Demo 4.4: Working with Hidden Pages and Page Links
    11. Practice
  22. 4.4 Working with Display Rules
    1. Graph Level
    2. Table Level
    3. Report Level
    4. Demo 4.5: Working with Graph-Level Display Rules
    5. Practice 4.5
    6. Quiz 4.1
  23. Chapter 5: Advanced Topics – Automated Explanations
  24. 5.1 Introduction
  25. 5.2 Automated Explanation
    1. Demo: 5.1 Using Automated Explanation: Threat Level
    2. Practice 5.1
    3. Activity 5.1
  26. Chapter 6: Advanced Topics – Restructuring Data for Geographic Mapping
  27. 6.1 Introduction
  28. 6.2 SAS Data Studio
    1. Activity 6.1
    2. Casing Transforms
  29. 6.3 Restructuring Data
    1. Demo 6.1: Creating a Geographic Data Source
    2. Practice 6.1
    3. Alternate Practices (Optional)
  30. 6.4 Analyzing Geographic Information
    1. Demo 6.2: Analyzing a Geographic Data Source
    2. Practice 6.2
    3. Quiz 6.1
  31. Chapter 7: Advanced Topics – Restructuring Data for Forecasting
  32. 7.1 Introduction
  33. 7.2 Restructuring Data
    1. Transposing Data
    2. Demo 7.1: Creating a Forecasting Data Source
    3. Practice 7.1
  34. 7.3 Forecasting
    1. Underlying Factors and What-If Analysis
    2. Business Scenario
    3. Demo 7.2: Analyzing a Forecasting Data Source
    4. Practice 7.2
  35. Chapter 8: Advanced Topics – Performing Network Analysis
  36. 8.1 Introduction
  37. 8.2 Analytics Network
  38. 8.3 Data Network Shape
  39. 8.4 Restructuring Data for Network Analysis
    1. Splitting Columns
    2. Custom Code
    3. Business Scenario
    4. Demo 8.1: Creating a Network Analysis Data Source
  40. 8.5 Creating a Network Analysis Object
    1. Options for a Network Analysis Object
    2. Arranging Nodes in a Network Analysis Object
    3. Controlling the View of a Network Analysis Object
    4. Using Maps with the Network Analysis Object
    5. Practice 8.1
  41. Chapter 9: Advanced Topics – Performing Path Analysis
  42. 9.1 Introduction
  43. 9.2 Path Analysis Object
    1. Data Roles for a Path Analysis Object
  44. 9.3 Path: Data Shape
    1. Business Scenario
    2. Demo 9.1: Analyzing a Path Analysis Data Source
    3. Practice 9.1
  45. Chapter 10: Advanced Topics – Performing Text Analytics
  46. 10.1 Introduction
  47. 10.2 Text Topics Object
    1. Sentiment Analysis
    2. Activity 10.1
  48. 10.3 Data Shape
  49. 10.4 Text Analytics: How It Works
    1. Sentiment Analysis Steps
  50. 10.5 Derive Topics
    1. Business Scenario
    2. Demo 10.1: Analyzing a Text Analysis Data Source
    3. Practice 10.1
  51. Chapter 11: Advanced Topics – Creating Advanced Data Items
  52. 11.1 Introduction
  53. 11.2 Creating Calculated Items
    1. Vector Plot
    2. Demo 11.1: Creating a Numeric Calculated Item
    3. Business Scenario
    4. Butterfly Chart
    5. Practice 11.1
    6. Needle Plot
    7. Demo 11. 2: Creating a Character Calculated Item
    8. Dot Plot
    9. Practice 11.2
  54. 11.3 Creating Aggregated Measures
    1. Demo 11.3: Creating an Aggregated Measure
    2. Practice 11.3
    3. Periodic Operator
    4. Demo 11.4: Creating a Periodic Aggregated Measure
    5. Practice 11.4
    6. The Suppress Operator
    7. Demo 11.5: Creating an Advanced Aggregated Measure
    8. Practice 11.5
  55. Chapter 12: Advanced Topics – Creating Advanced Filters
  56. 12.1 Introduction
    1. Activity 12.1
  57. 12.2 Post-Aggregate Report Filters
    1. Create a Post-Aggregate Report Filter
    2. Demo 12.1: Applying an Advanced Filter
    3. Practice 12.1
    4. Activity 12.2
    5. Adding Ranks
    6. Demo 12.2: Applying an Advanced Rank
  58. 12.3 Creating Advanced Interactive Filters
    1. Links
    2. Demo 12.3: Applying Automatic Actions: Linked Selection
    3. Practice 12.2
    4. Using a Parameter in an External Link
    5. Practice 12.3
  59. Chapter 13: Advanced Topics – Using Parameters to Create Advanced Reports
  60. 13.1 Introduction
  61. 13.2 Numeric Parameters
    1. Demo 13.1: Using a Numeric Parameter in a Rank
    2. Practice 13.1
  62. 13.3 Character Parameters
    1. Demo 13.2: Using a Character Parameter in a Calculation
    2. Practice 13.2
  63. 13.3 Using Date Parameters
    1. Activity 13.1
    2. Demo 13.3: Using a Date Parameter in an Advanced Filter
    3. Practice 13.3
  64. Appendix: Solutions
  65. Chapter 1
    1. Solutions to Activities and Questions
    2. Practice Review
  66. Chapter 2
    1. Solutions to Activities and Questions
    2. Practice Review
  67. Chapter 3
    1. Solutions to Activities and Questions
    2. Practice Review
  68. Chapter 4
    1. Solutions to Activities and Questions
    2. Practice Review
  69. Chapter 5
    1. Solutions to Activities and Questions
    2. Practice Review
  70. Chapter 6
    1. Solutions to Activities and Questions
    2. Practice Review
  71. Chapter 7
    1. Practice Review
  72. Chapter 8
    1. Practice Review
  73. Chapter 9
    1. Practice Review
  74. Chapter 10
    1. Solutions to Activities and Questions
    2. Practice Review
  75. Chapter 11
    1. Practice Review
  76. Chapter 12
    1. Solutions to Activities and Questions
    2. Practice Review
  77. Chapter 13
    1. Solutions to Activities and Questions
    2. Practice Review

Product information

  • Title: SAS Visual Analytics for SAS Viya
  • Author(s): SAS Institute SAS Institute Inc.
  • Release date: December 2020
  • Publisher(s): SAS Institute
  • ISBN: 9781952365119