๐ฏ Challenge of the Week: Build Insightful Opportunity Reports Showing KPI's! ๐ฏ
Hey Team! ๐ This weekโs challenge is here โ and itโs all about showcasing your skills with Reports in Salesforce! ๐Businesses rely heavily on opportunity data to drive decisions. As a Salesforce Admin, your ability to create clear, insightful reports can help leaders track progress, spot bottlenecks, and optimize sales processes. โ
The Pain Point: At Sainsburyโs Corporate Sales division (example), leadership is struggling to track the sales pipeline effectively. They canโt easily see: - How much revenue is in the pipeline - Which sales stages are underperforming - Which deals are small, medium and large - And which sales reps are performing best Your challenge is to help them gain clarity by building 2 summary reports capturing 4 powerful KPIs. ๐ Your Task:โก๏ธ Create two summary reports on the Opportunity object: ๐ Report 1: Opportunity Pipeline by Stage & Owner KPIs to capture 1๏ธโฃ Total Pipeline Amount (sum of Amount field) 2๏ธโฃ Number of Opportunities per Stage split by Sales rep (Opp Owner) 3๏ธโฃ Average Opportunity Opportunity Amount, Median Amount and Maximum Amount 4๏ธโฃ Bucket All Opportunities into 3 categories of Deal Size Using the Amount , (Small Deal, Medium Deal and Large Deal) NB: use any amount range of your choice to do the segmentatation ๐ Report 2: Closed Opportunities Performance KPIs to capture: 1๏ธโฃ Total Closed-Won Revenue 2๏ธโฃ Maximum Closed WOn Opp 3๏ธโฃ Average Closed Deal Size 4๏ธโฃ Top Performing Sales Rep (by revenue) Both reports should use Summary Reports, grouping as necessary, and adding any useful charts if youโd like. ๐ Submission Instructions: โ
Build your two reports in your Developer Org โ
Take clear screenshots of both report configurations and results and put in a document โ
Post your document with screenshots under this thread in the community โ
You will also demo your reports in the next session on Saturday, so come ready, with your Dev orgs ready ๐ก Bonus: Add a sentence or two explaining what insights each report provides to the business!