Custom Visuals in Pyramid Analytics
by Michael Raam , Principal Data Analytics and Mark Khoroshansky, Development
Pyramid Analytics provides a wide range of data-driven visualizations. However, there are scenarios where the creation of custom visuals driven by Pyramid-supplied data is required.
In order to accommodate such scenarios, we have introduced a process that enables our customers to create their own data-driven custom visuals via Pyramid’s API. This enables our customers to further utilize the BI Office platform to best meet their business needs.
Flow Process for Creating Custom Visuals
The flow process includes the following steps:
Data – The data used for custom visuals is provided via one of the many data sources that can be used within Pyramid, including:
SSAS (multi-dimensional and tabular)
DB (SQL, Oracle, Hadoop, MySQL, etc.)
Files (CSV, Excel, etc.)
Data Feeds (Twitter, Google Analytics, Salesforce, OData, etc.)
Other ODBC/OLEDB data sources
Pyramid Content – Pyramid’s analytical Data Discovery interface is used to retrieve data, apply business logic, perform formatting, and apply powerful analytics, including R script.
API Call – Once the data has been made available and the analytics have been applied, the result set can be pulled via a full-stacked API — including the ability to apply slicers and other analytic operations via the code.
Custom Visuals – Users can create their own custom visuals. Please note that custom visuals are shown via a web/mobile interface and must use the supported technologies. For examples and ideas, see https://d3js.org or http://bl.ocks.org/d3noob.
Embedding in Story Board – Once a custom visual has been created, it can be embedded in the Pyramid Story Board interface and may interact with other elements in Story Board.
Example of Custom Visuals
In this example, we have used a network chart from the following location:
Figure 1. Sample Image for Integration.
Data – The source data is a .CSV (and copies to Notepad++) file downloaded from the example site.
Figure 2. Source Data.
Pyramid Content – A Pyramid Data Discovery report is created (based on the source data).
Figure 3. Sample Data Discovery Report.
API Call – The initial step in creating a custom visual is to retrieve data from Pyramid content.
Figure 4. API Call
Custom Visuals – Once the data is retrieved, the custom visual is created and then added to the Pyramid site.
Figure 5. Add Additional Site.
Embedding in Story Board – The final step is to add the custom webpage to the Pyramid Story Board and to create an interaction to it via a slicer (shown by the red dotted line).
Figure 6. Add to Storyboard.
The end result provides a dynamic, data-driven visualization. In this example, it is possible to filter/slice the data by department, and as a result the graphic is updated dynamically.
Figure 7. BI Office with New Visual.
Please download the galaxy with slicer.zip file from this blog post as a code example to get started!