The data builder enables
analysts and data administrators to perform basic data preparation.
You can create data queries to perform joins, add calculated columns,
and subset and sort data. Several productivity features accelerate
the creation of columns based on common aggregation functions.
Once you create your
data queries, you can reuse them as subqueries for more sophisticated
data queries, export them as jobs for scheduling, or schedule them
directly from the user interface.
The data builder has
data import features that enable you to access data from the following
data sources:
-
Microsoft Excel spreadsheets
-
-
-
-
After you import the data, you can prepare it for
analysis or join it with existing data.
The
data builder provides a series of features that take advantage of
the in-memory tables in SAS LASR Analytic Server.
You can perform the
following operations to add data to memory in the server:
-
load an existing table directly
into memory
-
load the results of a data query
into memory (or stage the data and then load it into memory)
-
append rows to an in-memory table
After the data is in
memory, you can perform the following operations with in-memory tables:
-
join in-memory tables to form a
LASR star schema
-
append entire in-memory tables
to another in-memory table
-
save in-memory tables to HDFS for
persistence and fast reloads