Exploring on Salesforce: August 2019

Motivation behind this

I have done few proof-of-concepts on Big Objects which has limitations of showing records in Salesforce Standard reports and dashboards. Big Objects can hold millions and billions of records which are good for data archival purpose. To display data in reports data must exist in Salesforce objects (Standard, Custom or External) where as for Big Objects, Standard reporting is not supported.

Today, I was going through the trailhead module Integrate Local and Remote Data in Einstein Analytics and thought of displaying Big Objects data using Einstein Analytics Studio and to overcome this limitation in a different ways.

Little bit information about Big Objects

It stores billions of data on Salesforce Platform and we can archive data from other objects or datasets.
There are two type of Big Objects: Standard and Custom
Only following field types are available: Lookup Relation, Number, Text, Long Text Area and Date/Time
Big Object supports custom Lightning and Visualforce components rather than standard UI elements home pages, detail pages, list views etc.
We can create up to 100 Big Objects in per org.
It doesn't support encryption.

For more information, refer Big Objects Implementation Guide

Use Case

Business has a requirement to show Big Objects data as reports and dashboards so that archived data can be viewed without loading them in Salesforce objects again.

Though developers can build custom UI screen using Lightning or Visualforce but Business wants them as reports/dashboards so that even Salesforce Administrator can maintain those.

Expected Outcome

After creating dashboard using Einstein Analytics Studio, it will look like this, though there are various types of charts are supported.

Solution Approach

First, create Big Object called Application (API name: Application__b) as follows:

Secondly, insert few records into this Application Big Object. For sake of simplicity, I have chosen 2 Accounts and inserted total 7 records with the following script.

Account acct = [SELECT Id, Name FROM Account WHERE Id='0012v00002RuJp7AAF'];
  
Application__b appObj = new Application__b();  
appObj.Name__c = 'My Application';  
appObj.Amount__c = 100;  
appObj.Description__c = 'Testing with data';  
appObj.Account__c = acct.Id;  
appObj.StartDate__c = System.today();  
  
Database.insertImmediate(appObj);

For archival purpose, if data needs to be inserted then it can be done through batch processing.

Some terminology of Einstein Analytics

An Einstein Analytics app - is a curated set of analyses and paths through your data, plus powerful tools for spontaneous, deep explorations. Analytics starts with apps. Apps organize data projects, run presentations directly from dashboards, and control asset sharing.

A lens - is a visualization of data in a dataset. You use the lens to explore data graphically and to build queries for a dashboard.

A Dataset - which contains the data to be displayed.

Configuring Einstein Analytics Studio

If we follow step by step the above trailhead project, it will be very easy.

Sign Up for an Analytics Developer Edition Org

Link: Wave Analytics Developer Edition

For actual development, Customer has to procure the licenses.

Create a Dataflow

Navigation: Analytics Studio -> Data Manager -> Dataflows & Recipes

I have create a dataflow named Big Object Dataflow.

Here Application object is the root object and Account is related object. You can also see that, Application object has a lookup relationship to Account.

Create a Dataset