Preview the results of hierarchical data in aggregate nodes and flatten transformations to ensure that you have the correct output before running your recipe. For example, if you’re flattening a role hierarchy to implement row-level security on a dataset, you can preview the results to verify that they’re as expected before proceeding.

Where: This change applies to CRM Analytics in Lightning Experience and Salesforce Classic. CRM Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions. This change also applies to Salesforce Data Pipelines in Lightning Experience. Salesforce Data Pipelines is available for an extra cost in Enterprise, Performance, and Unlimited editions.

How: In the Data Prep recipe, select an aggregate node (1) in the graph to view the preview results (2).

Visualize Hierarchies and Flatten Transformations with Preview in the Recipe Editor (salesforce.com)

Preview your hierarchical data before running your recipe. Allocate your concurrent data prep jobs to meet your orchestration needs. Get information on when each data prep job started and was canceled.

• Visualize Hierarchies and Flatten Transformations with Preview in the Recipe Editor
  Preview the results of hierarchical data in aggregate nodes and flatten transformations to ensure that you have the correct output before running your recipe. For example, if you’re flattening a role hierarchy to implement row-level security on a dataset, you can preview the results to verify that they’re as expected before proceeding.
• Control Your Data Prep Concurrency Allocation
  Allocate your dataflow concurrency towards recipe jobs to meet your orchestration needs. For example, instead of being limited to running two dataflows and one recipe at a time, you can share dataflow concurrency towards recipes and run three recipes at the same time.
• Audit Details of Running and Canceled Data Prep Jobs
  Enhanced data prep job information provides details for data prep jobs that are running off schedule or why they were canceled. Now you can see when each job started, who started it, and if a job was canceled, who canceled it and when. You can also view the last person who scheduled or unscheduled a recipe or connection in the job scheduler.
• Get More Usage Information in Data Manager
  Manage your data limits with more statistics on the Data Manager Usage page. New usage information includes the number of external uploads and the total number of dataflow and recipe runs in a rolling 24-hour period. You can also see the monthly count of rows output by recipes.
• Trigger Recipes to Run When an External Connection Syncs or a CSV Uploads
  Set your event-based recipe schedules to run when an external connection syncs or a CSV upload finishes. Instead of being limited to one event for your trigger, you can select multiple events. Create a recipe schedule to run after a local connection syncs and after an external connection syncs, keeping your recipe up to date regardless of the input source.
• Experience Better Recipe Error Messaging and Reliability
  Your recipes are now more reliable and easier to troubleshoot. If an issue occurs, the error message helps you identify the problem and resolve issues faster. In addition, if a recipe requires more resources to run successfully, the resources are automatically increased after the first failure and the job is restarted. The need for increased resources is remembered for subsequent runs. Previously, you needed to open a support case to increase a recipe’s resources.
• Append Data Faster with Incremental Uploads (Generally Available)
  Improve your data upload time when using the external data API by loading CSV files incrementally. By registering data faster, you can bring in more data to your existing datasets without causing the overall run time to grow exponentially.
• Connect to Amazon Athena (Generally Available)
  Sync Amazon Athena data to Data Manager by creating a remote connection.
• Connect to Databricks (Generally Available)
  Create a remote connection using the Databricks connector to sync data from Databricks to Data Manager.

Analytics Data Integration (salesforce.com)

Create cleaner queries with better performance and stop worrying about filter item limitations. Generate semi-join or anti-join results from different datasets in a single SAQL query using the join statement with a join_type specifier.

Where: This change applies to CRM Analytics in Lightning Experience and Salesforce Classic. CRM Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions.

How: Use the CRM Analytics SAQL editor to create your queries.

This example uses a semi-join statement to query for accounts with more than 10 opportunities.

account = load \"accounts\";
opp = load \"opportunities\";
opp = group opp by accountId;
opp = foreach opp generate accountId, count() as count;
opp = filter opp by count > 10;
q = join account by (id) semi, opp by (accountId)

This examples uses an anti-join statement to query for accounts with no opportunities.

account = load \"accounts\";
opp = load \"opportunities\";
q = join account by (id) anti, opp by (accountId)

Create More Efficient Queries with Semi-Joins and Anti-Joins (Generally Available) (salesforce.com)

Embed your CRM Analytics dashboards in Lightning Experience pages with the new, native CRM Analytics Dashboard Lightning web component. The component works seamlessly in Lightning Experience pages and LWR sites.

Where: This change applies to CRM Analytics in Lightning Experience and Salesforce Classic. CRM Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions.

How: Open Lightning App Builder for the page you want to edit. Find (Beta) LWC CRM Analytics Dashboard in the component palette and drag it onto the page.

Get More Functionality with the New Dashboard Lightning Web Component (Beta) (salesforce.com)

Let your customers view and interact with CRM Analytics dashboards in your Lightning Web Runtime (LWR) site by adding the CRM Analytics Dashboard component. For example, customers can view visualizations of account data alongside their account information.

Where: This change applies to CRM Analytics in LWR sites accessed through Lightning Experience and Salesforce Classic. CRM Analytics is available in Developer Edition and for an extra cost in Enterprise and Performance editions, and requires an Experience Cloud license.

How: Use the new CRM Analytics Dashboard Lightning web component in your Experience Cloud pages. From the component palette of an object detail page in Experience Builder, drag the dashboard component to the page.

Embed CRM Analytics Dashboards in LWR Sites (Beta) (salesforce.com)

Extract detailed insights and user-specific metadata that supports collaboration and informed decision-making through organized export files. With the new export option in CRM Analytics, you can download data from a lens or widget to an Excel file that contains information about the export. The Excel format with metadata can include the name of the user, the date and time of the export, dashboard and widget titles, groups and filters in the query, and the number of records downloaded.

Where: This change applies to CRM Analytics in Lightning Experience and Salesforce Classic. CRM Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions.

How: To access the new export option, select Share on a lens or dashboard widget and then click the Download tab.

Download Metadata from Lenses and Widgets (salesforce.com)

Your dashboards are now more responsive and load faster with improved caching. Dashboard query results are now cached, increasing performance with fewer calls to the server.

Where: This change applies to CRM Analytics in Lightning Experience and Salesforce Classic. CRM Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions.

How: Improved dashboard caching in the default behavior. If necessary, you can turn it off. From Setup, in the Quick Find box, enter Analytics, and select Settings. Select Disable dashboard query caching.

Get Improved Dashboard Performance with Better Caching (salesforce.com)

Experience more responsive dashboards that load faster with improved caching. Download data to Excel files that include metadata about the export.

• Get Improved Dashboard Performance with Better Caching
  Your dashboards are now more responsive and load faster with improved caching. Dashboard query results are now cached, increasing performance with fewer calls to the server.
• Download Metadata from Lenses and Widgets
  Extract detailed insights and user-specific metadata that supports collaboration and informed decision-making through organized export files. With the new export option in CRM Analytics, you can download data from a lens or widget to an Excel file that contains information about the export. The Excel format with metadata can include the name of the user, the date and time of the export, dashboard and widget titles, groups and filters in the query, and the number of records downloaded.
• Embed CRM Analytics Dashboards in LWR Sites (Beta)
  Let your customers view and interact with CRM Analytics dashboards in your Lightning Web Runtime (LWR) site by adding the CRM Analytics Dashboard component. For example, customers can view visualizations of account data alongside their account information.
• Get More Functionality with the New Dashboard Lightning Web Component (Beta)
  Embed your CRM Analytics dashboards in Lightning Experience pages with the new, native CRM Analytics Dashboard Lightning web component. The component works seamlessly in Lightning Experience pages and LWR sites.
• Create More Efficient Queries with Semi-Joins and Anti-Joins (Generally Available)
  Create cleaner queries with better performance and stop worrying about filter item limitations. Generate semi-join or anti-join results from different datasets in a single SAQL query using the join statement with a join_type specifier.

Analytics Experience and Visualizations (salesforce.com)

Explore dashboards faster with improved caching, and use your data offline more confidently with exported metadata in Excel. Orchestrate your data jobs more effectively with run details and shared concurrency.

• Analytics Experience and Visualizations
  Experience more responsive dashboards that load faster with improved caching. Download data to Excel files that include metadata about the export.
• Analytics Data Integration
  Preview your hierarchical data before running your recipe. Allocate your concurrent data prep jobs to meet your orchestration needs. Get information on when each data prep job started and was canceled.

CRM Analytics (salesforce.com)

Reduce context switching and increase workflow efficiency and collaboration with the new way to view and configure Lightning reports and dashboards subscriptions. Wherever you are in Slack, you can enter a slash command that opens a window for managing subscriptions, including adding and removing recipients. Previously, you could manage these items only within the CRM Analytics for Slack app.

Where: CRM Analytics for Slack is available for use where approved by a workspace admin and installed in Slack.

How: To access report subscriptions, enter /analytics-lx-rpt-subscriptions in the Slack message field.

To access dashboard subscriptions, enter /analytics-lx-db-subscriptions in the Slack message field.

Access Report and Dashboard Subscriptions with Slack Slash Commands (salesforce.com)