Universal Containers (UC) creates a dataset, "Book11", containing a budget per region per month for the first 6 months of the year, as shown in the graphic below. Now, UC wants to create a lens showing
the total budget for each region for each month. Every combination of region and month must be shown in the lens, even if there is no data.

How should a CRM Analytics consultant help UC build this lens?
Universal Containers has a dashboard for sales managers that want to visualize their win rate.
Which chart type should the consultant use to keep track of targets?
The CRM Analytics consultant at Cloud Kicks (CK) notices that a specific dashboard is showing a different date and time from their locale. Upon investigating, they find that the recipe and datasetswere created from a locale with a PST time zone while CK is in the CET time zone.
What led to this problem?
Universal Containers uses CRM Analytics to build dashboards for different departments: Sales, Service, and Marketing. Users in the samedepartment have the same role and need to have access to the same dashboards. Dashboards for different departments use some common datasets with the same row-level security.
How should a CRM Analytics consultant address this need?
For managing access to department-specific dashboards while leveraging common datasets, the best approach involves the use of apps and permission sets. Here's why:
App Segregation: Creating a separate app for each department (Sales, Service, Marketing) allows for tailored dashboards and datasets to be grouped by department, facilitating easier management and navigation.
Shared Common Datasets: Placing common datasets in a shared app ensures that all departments can access necessary data without duplication, maintaining consistency and reducing storage requirements.
Use of Permission Sets: Leveraging permission sets to control access to these apps is a flexible and scalable approach. Permission sets can be finely tuned to grant or restrict access based on user roles within the organization, and they can be easily adjusted as roles or organizational structures change.
This structure not only ensures data security and appropriate access but also enhances the efficiency of managing CRM Analytics resources across different departments.
consultant is tasked with creating an opportunity dataset for a new analytics app. One requirement is to make sure users only see the opportunities they have access to in Salesforce. Opportunity records are private but shared using the role hierarchy. The consultant runs
the sharing inheritance coverage assessment and finds that the VP of sales is not covered by the sharing inheritance. The consultant decides to proceed with using sharing inheritance for the dataset.
What else does the consultant need to do?
Manon Romano
5 days agoSanjay Shukla
24 days agoDuc Tran
1 month agoData Layer Martinez
2 months agoEinstein Discovery Brown
19 days agoSecurity Perez
1 month ago