Get Started
Oracle Utilities Analytics Visualization is a suite of analytics applications that provides real-time access to data in the Oracle Utilities Customer Cloud Service (CCS), Oracle Utilities Meter Solution Cloud Service (MSCS), and Oracle Utilities Work and Asset Cloud Service (WACS). Oracle Utilities Analytics Visualization includes rich pre-built analytical subject areas, measures, key performance indicators, visualizations, and workbooks that allow you to derive strategic insights from your data through exploration, discovery, visualization, and analysis.
On this page:
Audience and Scope
This guide is intended for consumers and creators of visualizations and workbooks using Oracle Utilities Analytics Visualization. Consumers work with their favorite visualizations and workbooks delivered with the application or built by your organization. Creators understand the business needs of the consumers and create visualizations and workbooks that answers their business questions.
This guide also covers configuration tasks that must be performed by an administrator or implementer. See Administer the Service for more information.
Subject Areas
One of the key benefits of Oracle Utilities Analytics Visualization is that it comes with predefined subject areas that are specific to the utilities industry. A subject area is a data model that presents business data for analysis in a manner that reflects the structure of the business. Data models enable analysts to structure queries in the same intuitive fashion as they ask business questions. The data models of Oracle Utilities Analytics Visualization are simple and mask the complexity of the underlying data structure. For examples of questions that the application can help you answer, see Subject Areas Out of the Box.
Oracle Data Visualization
Oracle Utilities Analytics Visualization leverages Oracle Data Visualization, which is a component of Oracle Analytics Server. Oracle Data Visualization enables you to easily create visualizations and workbooks that reveal trends in your company’s data and help you answer questions and discover important insights about your business. Creating visualizations and workbooks is easy in Data Visualization, because the application is designed so that your data analysis work is flexible and exploratory. Exploring data in Data Visualization is different than using pre-built analytics and dashboards because Oracle Data Visualization allows you to experiment with your data by adding or removing columns, creating filters, or applying different visualizations to your data. You can understand your data from different perspectives and fully explore your data to find correlations, discover patterns, and see trends. For more information, see Explore, Visualize, and Analyze Data.
Terminology
These are some of the terms that might be unfamiliar to you as you learn about Oracle Utilities Analytics Visualization.
Term | Description |
---|---|
Calculation |
A predefined SQL query that can be dragged and dropped onto a canvas to create visualizations for key areas of your business operations. |
Canvas |
A canvas is a page within a workbook that contains one or more visualizations. |
Data Actions |
Data actions configured on a canvas can be used to navigate to another canvas in the current workbook, to a canvas in another workbook, or to your source Oracle Utilities enterprise SaaS application by specifying the appropriate an URL. See Use Data Actions to Connect Canvases and Launch Enterprise Applications for more information. Data actions (navigations) can be configured on any data element. The contextual value can be passed to CCS, WACS, or to internal canvases with various interactions and context passing options. Once configured, actions appear in the right-click menu in visualization where the column is used. Configuring data actions is a task that must be performed by a user with authoring privileges. See Role Types for more information. |
Data Panel |
The Data Panel is used to select data elements and visualization options when creating a canvas. |
Data Set |
A data set defines the structure of usable data that can be leveraged in a workbook. There are a few different types of data sets: (1) subject areas that are constructed within a logical model, (2) data sets based on a direct connection to a source (such as a database), and (3) data sets from an imported file (such as a spreadsheet). |
Dimension Folder / Dimension |
A dimension contains attributes that describe business entities (like Customer, Account, Service Point, or Asset). Dimension attributes provide context to numeric data, such as being able to categorize count of To Do Entries by To Do Type. |
Fact Folder / Fact |
Facts contain measures that have aggregations built into their definitions. Measures are typically calculated values, such as a dollar value (Amount Billed) or a quantity (number of failed assets). For example, you might want to determine the sum of dollars for a given product in a given market over a given time period. Each measure has its own aggregation rule such as SUM, AVG, MIN, or MAX. A business might want to compare values of a measure and need a calculation to express the comparison. Note: The words “measure” and “metric” are used interchangeably in this documentation. |
Workbook |
A grouping of canvases which can include one or more subject areas. |
Subject Area |
A subject area is a logical grouping of data that can be analyzed in a manner that reflects the structure of the business. Subject areas mask the complexity of the underlying data structures. A subject area consists of a one fact folder and multiple dimension folders. Subject areas are the building blocks of your visualizations and workbooks. A workbook is built by choosing an appropriate subject area that has information that answers the business question you’re analyzing. |
Visualization |
Visualizations are graphical displays that help you to analyze your data in a productive and meaningful way. |
Visualization Type |
A type of graphic such as a pie chart, bar chart, tree map, etc. |
Naming Conventions
Oracle Utilities Analytics Visualization uses prefixes in the names of workbooks and subject areas to indicate the type of data used or exposed in it.
Prefix | Description |
---|---|
Asset |
This prefix is used in subject areas and workbook names to indicate that they only include asset-specific data such as asset types, work orders, and activities. |
Customer |
This prefix is used in subject areas and workbook names to indicate that they only include customer-specific data. Examples of customer-specific data include Accounts, Persons, Premises, and Service Agreements. |
Meter |
This prefix is used in subject areas and workbook names to indicate that they only include data specific to meters. Some examples of meter data are: Service Points, Usage Subscriptions, Devices, Events, and Activities. |
Common |
This prefix is used in subject areas and workbook names to indicate that they are shared across all services. Some examples of common data are: To Do and Batch. |
Analytics Table - Subject Area Metadata
Your Oracle Utilities SaaS application (Customer Cloud Service, Work and Asset Cloud Service, or Meter Solution Cloud Service) includes an Analytics Table portal that holds the metadata and definitions of each fact, dimension, and measure of every subject area available in Analytics Visualization. This information can be useful to see and understand as you work in the application.
To access the Analytics Table portal:
Do one of the following:
- Sign into the source application and then click Admin Menu, select Analytics Configuration, and then select Analytics Table.
- Search for "Analytics Table" using the search bar at the top of the screen.
For more information about the structure and content of the portal, go to the documentation library of any of the Oracle Utilities enterprise SaaS applications. Once there, search for and select the Administrative User Guide link, and then go to the section ‘Defining Analytics Tables.'
- Customer Cloud Service Documentation Library
- Meter Solution Cloud Service Documentation Library
- Work and Asset Cloud Service Documentation Library
Note: Changes to the Analytics Table metadata (such as editing the structure of the dimension and facts, or adding a new measure) can be made, but they will not be reflected in Oracle Utilities Analytics Visualization. We therefore recommend that you do not modify the metadata and instead use it for reference only.
Base Data Visualization Workbooks
Oracle Utilities Analytics Visualization comes with a set of pre-built data visualization (DV) workbooks. See Base Data Visualization Workbooks for details.
Related Documentation
This section shows a list of guides that contain information related to the cloud services and product areas covered in this guide.