12 Extend and Customize

You can create your own datasets and data flows, and review the available data mapping sheets for your subject areas. You can also extend a subject area’s dimensions by joining them to custom datasets.

A dataset defines the structure of usable data that can be leveraged in a workbook. There are a few different types of datasets:

• Subject areas that are constructed within a logical model. Oracle Utilities Analytics Visualization includes pre-built subject areas that span customer, meter, and asset data. See Subject Areas Out of Box for details.
• Datasets based on a direct connection to a source database
• Datasets from an imported file

Enrich and Transform Data

Data preparation involves cleansing, standardizing, and enriching your dataset before you visualize the data. See Enrich and Transform Data for more information.

Create Datasets Using Data Flows

You can use data flows to create datasets by combining, organizing, and integrating data. See Create Datasets Using Data Flows for more information.

Note that Oracle Utilities Analytics Visualization does not support Graph Analytics Functions.

Manage Datasets

You can manage datasets in a variety of ways, such as renaming a dataset, viewing a dataset’s elements, and downloading or duplicating a dataset. See Manage Datasets for more information. Oracle Utilities Analytics Visualization supports the following features described on that page:

• Dataset Type Icons

  Note:

  The following icons are not applicable to Analytics Visualization: The icon representing two or more database connections, and the icon representing an Oracle Applications connection.
• View a List of Datasets and Information About Them
• Inspect a Dataset's Properties
• Rename a Dataset and Change Its Description
• View a Dataset's Data Elements

The other features described on Manage Datasets are not applicable to Analytics Visualization.

Data Mapping Sheets

Use the data mapping spreadsheets linked below for a list of the Analytics Visualization subject areas, dimensions, and attributes. This information will allow you to gain a deeper understanding of each subject area's attributes and which attributes they are mapped to in your Oracle Utilities source application (such as Customer Cloud Service or Meter Solution Cloud Service).

Subject Area	Data Mapping Sheet
Asset	Data Mapping Sheet - Asset.xlsx
Common	Data Mapping Sheet - Common.xlsx
Customer	Data Mapping Sheet - Customer.xlsx
Meter	Data Mapping Sheet - Meter.xlsx
Operations	Data Mapping Sheet - Operations.xlsx