Skip to main content

Salesforce Analytics for Analytics Newbies - Dataflow


I debated naming this post "dataflow for dummies", but mom says that "dummies" is a naughty word.  Adults seem to say a lot of words that are taboo for a baby like me.  I would share some of them, but my mom might find out and put me in time out.

Let's start with definitions- What is a dataflow and why would you need one?  A dataflow is:
  • A way to bring data from Salesforce into an analytics project
  • A place to combine data from multiple datasets
  • A simple way to manipulate data without code.
Here's an example of a dataflow from the Einstein Analytics Data Preparation Specialist Superbadge.









HINT: If you are having trouble with this superbadge, click here to link to a thread on the Salesforce developer community that should help.  Also, peruse these articles from help.Salesforce.com:  Create Datasets with Dataflow.  You are always welcome to ask me for help by leaving a comment!

One more quick definition before we dive into the different options within dataflow: JSON
JSON is a programming language, but don't worry, you don't have to be a JSON expert to pass the superbadge!  The most important thing to know is that you can download the JSON for a dataflow in order to save your progress.  If you download the JSON, then do something that causes your dataflow to no longer run, you can always upload the JSON to start over.  If you are feeling keen to learn more about JSON, this 134 page reference guide may be of interest: Analytics Dashboard JSON Reference


It's time for *cue a deep voice* dataflow transformations...also known as "the buttons on the dataflow editor."  If you are tired of reading the Trailhead Baby blog, you can always peruse a few Salesforce resources:


Next up: Dataflow transformations round 2!  Formulas, filters, and more! 

Comments

Post a Comment

Popular posts from this blog

Process Automation Specialist Superbadge - 5

A project with Daddy: My favorite daily process! Making dinner for Mom! Tonight's challenge involves the creation of two processes.   Processes.  Have you guessed the theme of the photos that go along with the Trailhead - Process Automation Specialist Superbadge series?They are a few of my favorite day to day processes!  You, my amazing reader, get more than tips for a Salesforce Superbadge.  You also get personal insight into the life of a Trailhead Baby!  I hope that you feel inspired. Process Builder sketch Last night, I drew a rough sketch of my process: Was it pretty?  No. Did it help?  Yes! The sketch allowed me to organize all of the instructions into a reasonable order before I started clicking.  It also removed the approval steps from Process Builder and highlighted (with *'s) the prerequisite items to building my process. * Email Alerts I needed the Email Alerts set up before I could create either the process or ...
336 comments
Read more

Security Superbadge -2

Challenge 2: Record-Level Security Settings I created the three user profiles last time, so the starting point tonight was the next tier of security - roles.  I set up the roles per the provided org chart, making sure to follow the opportunity restrictions from the directions. Next, I set up the required user and assigned her to the correct profile and role. Hint:   Use a real email address for Samantha Cordero.  You will need to login as Samantha in order to create an opportunity for her.  While you are at it, go ahead and login to Salesforce1 as Samantha. Once Salesforce1 is enabled, you can set up the appropriate permissions.  You may want to take take a peek at a Salesforce Knowledge Article .   Me - as a Project Manager. Next, I addressed the special role - Project Managers Project Managers require a role, permission set, and a  sharing rule.  Whew! For the final step, I set up the remaining sharing rules in     ...
205 comments
Read more

Einstein Analytics Data Preparation Specialist Superbadge - 1,2,3

Hello all! It's time for another superbadge! I started this superbadge a long time ago... it's time to finish it!  My goal is to complete this badge before my little brother starts to walk.  He's getting close... Step 1 - A quiz.  You're on your own! Step 2- This is one checkbox in setup.  You're on your own! Step 3- Let's talk about that.... Dataflow. The best tool to use when crafting your dataflow is the data monitor.  It can help troubleshoot issues to find which part of the process needs some work. For example.... Why were rows not created? The problem? A box was checked that should not be checked.... The alias name was not correct for the "register" node. Once you see that beautiful green "Success" message, it's time to check the challenge.  Do not be discouraged if you get a few error messages.  This superbadge is EXTREMELY picky on syntax.  A few common errors: You can see this error and st...
192 comments
Read more