How to Create Dataset using Salesforce object in 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
    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.Select the fields which you want to extract the data.
      Dataset-field
    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 jsonicon.
    12. To remove the related object there are two options to delete the branch object.
      Dataset
    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
  1. After clicking on the Create button
  2. Now the popup button is opened click on the Yes button you will be redirected to the Data Monitor page.
    Dataset-Json
  3. In this page select the Dataflow View.
    Dataset-Datflow
  4. On the right side of the panel click on the drop down button and click on the Start button
    Dataset-start
  5. The Dataflow has been started in the UI you will get the Dataflow as running state
    dataset-running
  6. Click on the + icon to check the status of the Dataflow.
    Dataset-pending
  7. Now navigate to the Analytics apps check the dataset has been created.
    Dataset-dataset1
  8. Click on the dataset you will be redirected to the New Lens.
  9. Slice and Dice your Dataset with the different charts.
    analytics

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.

Leave a Comment

Your email address will not be published. Required fields are marked *

Recent Posts

future-of-ai-powered-business-solutions
Dreamforce 2024: Unveiling the Future of AI-Powered Business Solutions
gitex 2024 worlds largest tech show
GITEX 2024 |  World's Largest Tech Show - ABSYZ
inclusive practices in women leadership equitable future
Inclusive Practices in Women’s Leadership: Equitable Future
salesforce dreamfest 2024 the highlights of dreamforce 2024
Dreamfest 2024: The highlights of Dreamforce 2024
DocuSign CLM the ultimate tool for managing contracts
DocuSign CLM: The Ultimate Tool for Managing Contracts
Document

How can i help you? close button

powered     by   ABSYZ
Scroll to Top