Lesson 2: Data Preparation, Recipes, Transformations, SAQL, and Performance
Lesson Overview
This lesson develops practical skills in data preparation, recipes, transformations, saql, and performance for Salesforce CRM Analytics and Einstein Analytics Training.
Topics Covered
Data Prep recipes, joins, transformations, formulas, filters, aggregates, and outputs
Date, numeric, text, case, window, and business calculations
Incremental processing, volume, refresh, query performance, and optimization
Recipe, query, and dataset troubleshooting
Practical Activity
Configure or analyze a scenario involving data prep recipes, joins, transformations, formulas, filters, aggregates, and outputs.
Build and validate an exercise covering dataflows concepts, compute expressions, augment, flatten, digest, and legacy migration awareness and saql load, group, foreach, filter, order, cogroup, union, bindings, and queries.
Use tests, logs, reports, or documentation to verify recipe, query, and dataset troubleshooting.
Key Takeaways
Explain data prep recipes, joins, transformations, formulas, filters, aggregates, and outputs in the context of Salesforce CRM Analytics and Einstein Analytics Training.
Apply practical methods for dataflows concepts, compute expressions, augment, flatten, digest, and legacy migration awareness and saql load, group, foreach, filter, order, cogroup, union, bindings, and queries.
Test, document, and troubleshoot recipe, query, and dataset troubleshooting.