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 self-service data import features that enable you to access data
from the following
data sources:
-
-
-
-
-
Facebook, Google Analytics, and
Twitter
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