Techniques for comparing multirow in CRM Analytics Data Prep / Data Recipe using pivoting…Business Use case:Oct 4, 20241Oct 4, 20241
How to calculate subsequent records count using deeper to wider transpose and custom foreign key…This subsequent records aggregation is one of the real time example.Sep 21, 2024Sep 21, 2024
Demystifying Custom key use cases in CRM Analytics Data Prep / Data RecipeCustom key :Sep 9, 20242Sep 9, 20242
How to consolidate multiple columns into a single column through Transpose technique in Data Recipe…Business Use case:May 26, 20242May 26, 20242
How to obtain the most recent modified account’s contact information Using SAQLProblem Statement:May 20, 20241May 20, 20241
Salesforce Files and Content Downloads monitoring in CRM Analytics/Einstein Analytics/Tableau CRMThis CRMA dashboard helps to analyze how users are engaging with files and Salesforce CRM Content.Apr 13, 20244Apr 13, 20244
Automating the Data sources (objects) and field references in Data Recipe using Python script for…Problem statement :Mar 23, 20243Mar 23, 20243
Multi-Language Solution for Multi Value field in CRM Analytics/Tableau CRM/Einstein AnalyticsKnown Fact: -Jun 26, 20234Jun 26, 20234
One-hot Encoding Techniques in Data Recipe for Einstein Discovery DatasetOne of the most common feature engineering methods for categorical attributes is transforming each categorical attribute into a numeric…May 1, 20232May 1, 20232
Remove Special Characters from String Column and formatting using Nested String functions in Data…Business Use case:Mar 29, 2023Mar 29, 2023
How to make Image URL Dynamic in Data Recipe in CRM Analytics/Tableau CRMA picture speaks 1,000 words because Our human brains prefer visuals over text.so, if you use high-quality visual aids in your Dashboard…Mar 8, 20232Mar 8, 20232
Roll up all Child records to the Parent using collect_list(), collect_set() functions in Data Prep…Business Use case :-Dec 27, 2022Dec 27, 2022
Input Widget Reference in SAQL without bindings/Interactions in CRM AnalyticsYay!!!!!!!!!!!!!! I am really excited to see the Spring 23 releases enhancement of the “Input widget” Reference in SAQL features. Now no…Dec 23, 2022Dec 23, 2022
How to Make a What-If Analysis Using Input Widget in CRM AnalyticsI really excited to see the Winter 23 releases feature of the “Input widget”.Yay!!!!!!!!!!!!!! now we can easily perform the What-If…Aug 19, 20222Aug 19, 20222
Demystifying SAQL Date Function Equivalent in RecipesIf you’ve been doing the dataflow into Data Recipe conversion or date manipulations using the Date/DateTime functions in recipes, you may…Jul 30, 2022Jul 30, 2022
The start value specified for this query is invalid : dynamic Initial selection filter error…Use case’s : Dynamically selecting the start value for our filters/List Selector/Toggle based on logged in user Country.Jul 20, 20222Jul 20, 20222
Quick Glimpse of Compute Relative(Window functions) in Data prep aka Data RecipeAs Many of you experienced while converting a Dataflow to Data prep(data recipe) you could see some error in converted Recipe Compute…Jul 7, 2022Jul 7, 2022
Dynamic Date Filter in Data Prep 3. O Aka Data Recipe in Tableau CRM(Einstein Analytics)In Dataflow we would have the option to apply the dynamic date filters/custom filters in the filter node by using SAQL syntax. e.g…Feb 15, 2022Feb 15, 2022
Tableau CRM Spring 22 Releases — Data Prep 3. O Key Take Awayi). Manage Direct Data Filters in a Separate NodeDec 23, 2021Dec 23, 2021