Analytics Cloud – Creating Datasets

Share on facebook
Share on twitter
Share on linkedin
The Salesforce Analytics Cloud provides powerful insights into the data by integrating with Salesforce data and external data sources like CRM, ERP, and CSV files. Analytics cloud has four major components: Datasets, Lenses, Dashboards, and Apps.

The Salesforce Analytics Cloud provides powerful insights into the data by integrating with Salesforce data and external data sources like CRM, ERP, and CSV files. Analytics cloud has four major components: Datasets, Lenses, Dashboards, and Apps.

Datasets in the Analytics Cloud is the set of source data, and by using the Dataset Lenses can be created to explore data visually with Bar Chart, Pie Chart, and Donut Chart. Dashboards can be created with one or more Lenses and dynamic filters to drill down the data.

The Apps in the Salesforce Analytics Cloud are like folders that hold the Datasets, Lenses, and the Dashboards which can be private or shared.

The following two steps elaborate how to create Datasets with Salesforce objects and CSV files.

The first step is creating a Dataset with Salesforce Account Standard object with Account ID, Account Name, Annual Revenue and Billing City fields. While creating the Lenses using this Dataset, Annual Revenue can be used as a measure; Account Name and Billing City can be used for groupings and filtering.

The second step is creating a Dataset with CSV files; the mobile.csv file (for example) contains two fields: Mobile name, and Price with values. Once the CSV file is uploaded, the Dataset builder automatically creates an appropriate JSON file. While creating the lenses using this Dataset, measures are done based on the Price, and grouping & filtering are done based on the Mobile name and Price.

Steps to create Datasets with Salesforce objects:

  1. Open the Analytics app in the org.
analytics cloud

The window displays the existing Apps, Dashboards, Lenses and Datasets. It also contains tabs to navigate to other components.

  1. Navigate to Create → Dataset.
analytics cloud
  1. Enter the Dataset Name, select the App from the picklist, and select the Data Source as Salesforce.
analytics cloud
  1. The Dataset Builder window is open now; choose the Salesforce object from the list, click the + sign near the object, select the fields, and click the Create Dataset button.
analytics cloud

After clicking the Create Dataset button, the Salesforce Dataflow needs to be started to create the Dataset.

5. Click the wedge icon  at the top right, and select Data Monitor.

analytics cloud
  1. In the Default Salesforce Dataflow window, click the down arrow on the right and select Start.
analytics cloud

The Dataflow runs and shows the status as successful. Now, the Dataset is created.

7. The Account Sample Dataset appears in the Datasets list page.

analytics cloud

Steps to create Datasets with CSV files:

  1. Open the Analytics App in the org.
analytics cloud

2. Navigate to Create → Dataset.

analytics cloud
  1. Enter the Dataset Name, select the App from the picklist, and select the Data Source as CSV.

4. Enter the Dataset Name, and add the External Data File(CSV).

analytics cloud

Once the CSV file is added, the Metadata file (JSON) is automatically created.

5. Click the Create Dataset button.

analytics cloud

6. The Mobile Dataset is created, and it appears on the Datasets list page.

analytics cloud

While creating the Datasets from CSV files, Data flows do not need to be started as the datasets will be created automatically.

Summary

Salesforce provides key functionality to create Datasets using external data sources such asInformatica, Jitter bit, Snaplogic, Dell, MuleSoft, Salesforce, CSV files and IBM. By using the Datasets, Lenses can be created to provide insights into the data.

Reference Salesforce Analytics Cloud Data Integration

About MST

At MST Solutions our cornerstone is to adapt, engage and create solutions which guarantee the success of our clients. The talent of our team and experiences in varied business verticals gives us an advantage over other competitors.

Recent Articles

Mobile Responsive Testing

Mobile Responsive Testing is simply a Testing Process performed to make sure that your website or an app is working appropriately on all types of devices.
Whether it an app or website, they need to ensure that they are accessible from any device, anytime, anywhere.

Read Article »

Work with us.

Our people aren’t just employees, they are key to the success of our business. We recognize the strengths of each individual and allow them time and resources to further develop those skills, crafting a culture of leaders who are passionate about where they are going within our organization.