management reporting in salesforce - third sector...
TRANSCRIPT
![Page 1: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/1.jpg)
Management Reportingin Salesforce
Copyright 2013, Third Sector IT. All rights reserved
This document contains proprietary information of Third Sector IT; it is provided under a license agreement containing restrictions on use, duplication and disclosure and is also protected by copyright law. Permission is granted to customers ofThird Sector IT to use and modify this document for their internal business purposes only. Resale of this document or its contents is prohibited.
![Page 2: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/2.jpg)
Housekeeping
• Fire Alarm procedure
• Facilities
• Audio and Video (loud and large?)
• Questions during and after
• Workshop based approach
• Course length
• Feedback forms
![Page 3: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/3.jpg)
Two Salesforce Orgs
• Log into the Training Org
– Shows TrainingUser on upper right
• Log into your Own Org as well
– Use a different web browser! Firefox, IE, etc.
– Shows your name in upper right
– Don’t break anything – we aren’t responsible!
– If you only create reports and dashboards and save to My Personal Folder, you (probably) won’t break anything
![Page 4: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/4.jpg)
About Us
• We provide Salesforce implementation, training and support
• Seats on our training courses are available individually, as part or a support contract, or as a bulk discount
![Page 5: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/5.jpg)
Introduction
• Please introduce yourself
• Tell us a specific reporting goal you have for today, such as:
– I want to know what percent of our…
– In the last three months, how many…
– Which of our staff are the top…
– What is the average days that…
![Page 6: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/6.jpg)
Course Goals
• Show aggregate data (w/ and w/out details)
• Perform numerical calculations on that Data
• Compare month to month, or percentage of total
• Identify data ranges through highlighting
• Display data graphically through Dashboards
![Page 7: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/7.jpg)
Applicability
• You can report on every Object/Tab
• 98% of what you learn today will be relevant to your unique customisations
• These methods can be applied to all your data!
• Non-Profits: Opportunities = Donations/Grants
• If you can drive a car in England, you can probably drive in France
![Page 8: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/8.jpg)
Bespoke Training & Creation
• Attendees get a complimentary 60 minute Report & Dashboard Session **
• Email [email protected] with 3 proposed one hour slots
• Sessions delivered remotely via screen sharing
• MUST be used within 4 weeks
• We also offer Bespoke Training, and half and full day Report & Dashboard Creation
![Page 9: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/9.jpg)
Background
Views Not Useful for Management Reporting
Tabular Reports
Shows multiple objects, and single values. The most basic Management Reporting
SummaryReports
Grouping feature allows for different subsets to be shown, and compared. Powerful formulas
MatrixCross–visualisation of data, with vertical and
horizontal grouping.
Joined Reports
Multiple Summary Reports intelligently shown together by Grouping Level (bonus material)
![Page 10: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/10.jpg)
Views
![Page 11: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/11.jpg)
Tabular Reports
![Page 12: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/12.jpg)
Summary Reports
With Details Hidden
With Details Shown
![Page 13: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/13.jpg)
Matrix Reports
Almost Always shown With Details Hidden
![Page 14: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/14.jpg)
Scenario
• What is this quarter’s revenue?
• Based on how many Opportunities/Donations?
– Show just these two numbers and nothing else.
– Save as “This Quarter’s Revenue”
– Remember, in current form can’t be used in any Dashboard
![Page 15: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/15.jpg)
Your totals might be different! That’s OK
![Page 16: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/16.jpg)
Extending This
• Group Opportunities into Small/Medium/Large (<4k<8k<) using Bucket Fields
– Group by this, and show just the record count and summed amount for each size, and the grand total
– Hide Details (may have to briefly show details in Report Builder)
– Save as “This Quarter’s Revenue by Size”
![Page 17: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/17.jpg)
Your numbers may not be the same, that’s OK!
![Page 18: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/18.jpg)
Analysing This
• What percent of these Opportunities make up each category, by amount and number?
– In the Report Builder, insert a formula, and use ParentGroupVal
– If you change your summary fields, your formulas disappear
– Save as “This Quarter’s Revenue with Percents”
![Page 19: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/19.jpg)
![Page 20: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/20.jpg)
![Page 21: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/21.jpg)
Your numbers might be different.
Save this Report!
![Page 22: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/22.jpg)
Creating Dashboards
• Show all of these values
– Trick – the tabular report won’t help you
– The summary report will be the basis of the gauge and the pie chart
– The bar chart can show the two percent values side by side
![Page 23: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/23.jpg)
All widgets came from one Summary Report. Your numbers may be different.
![Page 24: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/24.jpg)
Exploring Month on Month
• Scenario – you are asked about your month on month revenue
– In the training org, use week on week to accommodate the dummy data
– Show change from last week
– Show percentage change from last week
– Add conditional highlighting at -20% and -10% (or another percent)
![Page 25: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/25.jpg)
Create a
• Summary Report
• Grouped by Close Date
• Display Date Values as…
• Add two formulas (example next slides)
• Add conditional highlighting to one formula
![Page 26: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/26.jpg)
![Page 27: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/27.jpg)
![Page 28: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/28.jpg)
![Page 29: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/29.jpg)
Exploring Month on Month
• Dashboards
– Line Chart on Percent Change
– Horizontal Bar Chart on Amount Change
– Second Vertical Bar Chart, Amount Change and Amount Sum
– What happened to Highlighting in the Report?
![Page 30: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/30.jpg)
If using your own Salesforce org, use Month on Month
![Page 31: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/31.jpg)
Understanding Staff
• Reports
– Summary Report of All Closed Won Opps by Staff (Sum on Amount)
– (Homework) Matrix Report of Closed Won Opps by Staff and Calendar Month (Sum on Amount)
– (Homework) Matrix Report of All Opps by Staff and Calendar Month (Record Count Only) with Highlighting
![Page 32: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/32.jpg)
![Page 33: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/33.jpg)
Homework! Try this with highlighting.
![Page 34: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/34.jpg)
Understanding Staff
• Reports (In your Own Org)
– Summary Report of Contacts by Staff (Created By)
– (Homework) Matrix Report of Contacts by Staff (Modified By) and Calendar Month
![Page 35: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/35.jpg)
Use Created By rather than Contact Owner if working in your own org
![Page 36: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/36.jpg)
Understanding Staff
• Dashboards (Homework)
– 2 Dashboard Tables, Hall of Fame / Shame (Top 5 staff by Closed Won)
• Dashboards (Homework)
– 2 Dashboard Tables, Hall of Fame / Shame (Top 5 staff my Contacts Created)
• Use Summary Report as Basis, Tabular Widget with Maximum Values Displayed to limit rows
![Page 37: Management Reporting in Salesforce - Third Sector ITthirdsectorit.org/wp-content/uploads/2013/02/Management-Reporting.pdf · •Attendees get a complimentary 60 minute Report & Dashboard](https://reader033.vdocuments.us/reader033/viewer/2022041422/5e1fa59b9104ea56c00cf111/html5/thumbnails/37.jpg)
Thank You!
• Please fill in the course feedback survey
• Remember, schedule your free 60 minute session within 4 weeks by emailing [email protected] with 3 possible one-hour slots (delivered via screen sharing) **
• Stick around to ask any follow up questions