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

Service Cloud Specialist Superbadge - 4,5,6,7

Part of doing the Service Cloud Specialist superbadge is trying new things, so I am putting up picture of new things that I've tried recently.  One of my favorite new things this week was taking a shower with my whole block collection.  Mom put me in the shower, and I sneaked out to grab the block bin and dumped it in.  I'm concerned to share photos because of the slight nudity, however, I can assure you that it was a glorious adventure.  Instead, I'll share my favorite Saturday new thing- walking to the coffee shop for a sprinkle donut!  Back to the superbadge... Challenge 4 Case Routing If you haven't taken the Onmi Channel module yet, now is a good time! I kept that particular module open one on screen while I walked through this step.  It is hard to give many hints about this step without giving away too many details - so - the best advice is to read through the challenge and label each step with the corresponding Salesforce term.  (IE - "The channel, Sto
171 comments
Read more

Service Cloud Specialist Superbadge - 1,2,3

A confession - I know next to nothing about service cloud.  While I was excited that a new superbadge was available, it made me a little nervous that I had to do all of the prerequisites and tackle new things like macros.  New things - new year - let's get started! (Right after I finish guitar practice) If you are also a service cloud novice, the Omni-Channel Basics is a crucial prerequisite even though it is not officially required. Challenge 1 App Appearance  This, like all superbadges, requires a careful read through the instructions prior to any clicking.  I found it helpful to take a separate notebook and write down the steps that I would need for each challenge step - for example -  My rough notes for challenge 1: Create 2 profiles  Tweak service Console 3 new items on utility bar Allow access for new profiles Create User  Beware - After editing the service console, you might have to edit the new profiles.  I found it necessary to click "edit&quo
124 comments
Read more

Business Administration Specialist Superbadge- 3 & 4

This afternoon, I added a genius wig in an attempt to look a little older and more experienced.  The free lemonade offer worked!  I made two dollars today!  A huge thank you to Jocelyn Fennewald , Salesforce MVP, for pointing out the "remove all columns" option within the report creator.  When you start a create a new report, simply click to start with a clean screen.  If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete.  Below are tips and gotchas for each report / dashboard.  If you need more help, leave a comment! Reports Accounts by Market To create the "Market" row grouping, use a bucket field. Make sure that the correct date range is selected. High Value Residential  This report includes: 1 filter, 1 grouping, and 1 summarized field.  Rated Accounts by State The record count for state and account rating are automatically added. Note the filter.  Open Support Cases You ma
120 comments
Read more