Salesforce · Wave Analytics

How to Create Dataset using Salesforce object in Wave Analytics

This blog post is 3rd in the series of posts for Wave Analytics. In my previous blog post How to Create Dataset, Lens, and Dashboard in Wave Analytics, I have explained you the how to create Dataset, Lens, and Dashboard using CSV file. In this blog post, I will explain you, How to create  Dataset using the Salesforce Objects.

How to create Dataset?

  1. In the Analytics app, click on the Create button and click on the Dataset.
    dataset-dataset
  2. Analytics provided the feature to pull the data from the different sources.Select Salesforce as the data source, and then click Continue.
    Dataset-Salesforce
  3. Now the dataset builder opens in a new Analytics tab.
    Dataset-object selection
  4. Select the object, that will be the root object and that root object will be the lowest level of the child object that you can add to the canvas.
  5. You can add the only parent objects of that root object, you can’t add its children objects.
  6. To change the root object you should refresh the page and again add the root object.
  7. To add the fields of that object hover the root object and click on the plus icon icon.Select the fields which you want to extract the data.
    Dataset-field plane
  8. If you want to add the parent objects click on the RELATIONSHIPS tab and click on the JOIN to add the related objects to the canvas.
    Dataset-Relation
  9. After clicking on the JOIN button, your canvas will look in this way.
    Dataset-Branches
  10. You can add fields and parent object relationships to that objects.
  11. To see the JSON code of the dataset on the left side of the panel click on the json icnicon.
  12. To remove the related object there are two options to delete the branch object.
    Dataset Delete1
  13. To delete the branch object go to the root object and hover on the root object and you will get the delete option and click on the delete button.
    Dataset-Delete2
  14. The above image is the second option to delete, click on the branch object you will get the option of the Delete Branch option and click on that you will delete the object.
  15. Now to click on the Create Dataset button.
    Dataset-create
  16. Now give the Dataset Name and click on the Create button.
    Dataset-create1
  17. After clicking on the Create button
  18. Now the popup button is opened click on the Yes button you will be redirected to the Data Monitor page.
    Dataset-Json popup
  19. In this page select the Dataflow View.
    Dataset-Datflow view
  20. On the right side of the panel click on the drop down button and click on the Start button
    Dataset-start
  21. The Dataflow has been started in the UI you will get the Dataflow as running state
    dataset-running
  22. Click on the + icon to check the status of the Dataflow.
    Dataset-pending
  23. Now navigate to the Analytics apps check the dataset has been created.
    Dataset-dataset1
  24. Click on the dataset you will be redirected to the New Lens.
  25. Slice and Dice your Dataset with the different charts.
    analytics Dashboard.PNG

You can refer how to create Lens and Dashboard in my previous blog post.

If you want to know the basics of the wave analytics you can refer to first blog post of this series Basics of wave analytics

Stay tuned for my upcoming blog post where I will show you how to Create Dataset using Informatica in Wave Analytics.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s