This course teaches how to build data with SAS Visual Analytics Data Builder and how to load it onto the SAS LASR server so that it resides in memory, ready to be used by business users

The special pre-loaded ready to go environment set up on the course machine at SAS Institute in Denmark is the same as the one on customer machines. On-site courses at SAS Institute, is an easy alternative if you and your colleagues plan on attending a SAS Visual Analytics course together!

Learn how to

• interact with the environment via the SAS Visual Analytics Hub
• work with the agile data preparation and load process
• work with the best practice turbocharged building environment
• use queries in the Visual Data Builder to enrich data
• load data into memory on to the SAS LASR Server

Who should attend

DI Developers, programmers, BI developers or Analysts who need to learn how to use the functionality provided by SAS Visual Analytics Data Builder

Formats available	Standard duration
Classroom:	1.0 day

No SAS experience or programming experience is required, although it is very beneficial to understand data processing and data structures.

This course addresses SAS Visual Analytics software.

Getting Started with SAS Visual Analytics

• exploring SAS Visual Analytics concepts and personas
• discussing Visual Analytics roles and user groups in metadata
• setting up preferences in the SAS Visual Analytics Home page
• discussing the course environment and scenario
• discussing the ready to go customer setup turbocharged for immediate use
• understanding the agile data load process
• understanding the difference between data enriching and data cleansing

Using the SAS Visual Analytics Explorer:

• understanding the concept of metadata:
• investigating predefined metadata for course tables
• understading how metadata is created for LASR tables and Data Builder queries
• looking at the ready to go autoexec for setting up formats, macros and special options
• accessing SAS tables
• accessing external data:
• understanding the prerequisites for accessing external data
• importing flat files - csv, text etc
• importing Excel files
• accessing RDBMS data
• creating queries:
• creating a simple query
• modifying an existing query
• creating a query with joins and filters
• creating a query with grouping and aggregations
• creating a query with user-defined formats and advanced filters
• creating a query with aggregations and sorting
• creating sub-queries
• creating a query based on transpose
• unlocking the code view so you can manually add/modify SQL clauses
• loading data and reloading data on to the SAS LASR Server
• unloading data from the SAS LASR Server
• appending data to data on the SAS LASR Server
• understanding the concept of row based security