Hello and welcome in 2023! If you are here, hopefully one of your new years resolutions is to practise your CRMA skills. The good thing is that it takes less effort than going to the gym and is arguably more fun as well!
From now on you can come back Wednesday each week to find a new problem with varying difficulty to solve.
We kick things off with 4 challenges that build up on each other to work on the basics of CRMA. If you don’t have access to the tool or would like to start from scratch, you can sign up for a new developer org here: https://trailhead.salesforce.com/promo/orgs/analytics-de
This week we focus on a simple recipe to get things going.
- Create a dev org or use an existing org you have access to
- Connect to the Opportunity, OpportunityLineItem, Product2 and Account objects
- Join all objects together
- Include only “Closed Won” opportunities for “Customer” accounts
- the total list price per line item
- the absolute discount for each line item
- a string field with the year of the close date of the opportunity
- List Price
- Total List Price
- Sale Price
- Total Price
- Absolute Discount
- Group By
- Billing Country
- Close Date Year
- Product Family
- Product Name
- Opportunity Type
- Output the data into a dataset (we’ll need it next week!)
The resulting dataset should look something like this:
I got 11 columns with 377 rows, but I don’t know if Salesforce changes the default data in their orgs, so use this as a guide.
Sign up for a dev org:
Engineer data in CRMA:
This week uses the data from the standard objects that come with the CRMA Dev-Org. If this is your first challenge, you can sign up for a dev org here: https://trailhead.salesforce.com/promo/orgs/analytics-de
After you finish your workout, share a screenshot of your solutions or interesting insights on Twitter using the hashtags #WOW2023 and #CRMA and tag @genetis, @PreenzJ, @LaGMills and @JaackParry. (Or you can use this handy link to do that)
Also make sure to fill out the Submission Tracker to track your progress and help us judge the difficulty of our challenges.