Build Powerful Dashboards Quickly with CRM Analytics
- Describe the benefit of using a template to create a dashboard.
- Describe how apps impact users’ access to dashboards.
Analytics Dashboards, From Millions of Records to Insights
How effectively can you describe a complex picture? Let’s find out. You and your partner are sitting back to back. Your partner needs to draw the picture shown below based solely on your description. You can’t show the image. Ready? Go!
It’s not easy. It’s just as challenging to describe your business data so others can visualize it. There’s so much information from sales, service, marketing, social media posts, device sensors—it’s overwhelming just to think about! Where do you start to describe it clearly? And how do you synthesize the information and make it easy for stakeholders in the company to form their own clear picture? Analytics dashboards can make this job much easier.
- Wizards to build widgets that summarize your data.
- Widget interactivity to answer different types of questions without leaving the dashboard.
- Layouts to optimize the dashboard for different devices.
Sounds like a lot of work, right? It’s actually not so bad because the designer guides you as you build. With the help of wizards and the layout builder, you can quickly and accurately create the right dashboards for different device types, like desktop and mobile.
Before you start building, watch this video to learn about the different widget types that you can add to a dashboard.
Ready to build? Let’s go.
Build a Dashboard to Reward Sales Performance
You’re the Salesforce admin at DTC Electronics, a leading provider of tablets, phones, and other hardware devices. Laura, the worldwide sales manager, is offering each sales rep a one-week, all-inclusive trip to Bora Bora if all reps hit their $22.5 million quota by the end of this year. Laura has asked you to create a dashboard that analyzes sales performance and identifies reps who have not yet reached quota. Oh, and by the way, you’re also invited to join the team on this luxurious vacation!
- Provide the total amount of open, won, and lost opportunities.
- Analyze sales performance of each rep to see how best to support them.
- Analyze opportunities by stage to help move opportunities from leads to won deals.
- Analyze sales by product family to see if any product lines are struggling.
Let’s create it now.
Sign Up for an Analytics Developer Edition Org
Before you work through this Trailhead module, sign up for a free Analytics-enabled Developer Edition org. This org is a safe environment where you can practice the skills you’re learning. Unlike the regular Developer Edition org, the Analytics-enabled one comes with a limited Analytics platform license and contains sample data required for this module.
Create the Dashboard
When you create a dashboard, you can start from scratch or use a template. Templates do the heavy lifting for you—they come with an industry-proven design and suggested widgets. To learn the basics about dashboard templates, check out the following video.
To give you the complete experience of building a dashboard from scratch, you’ll start with a blank dashboard. Based on Laura’s requirements, here’s your plan for the dashboard.
It contains number widgets that you can use to track key performance metrics. It contains selectors that let you change the filters while viewing the dashboard—you don’t need edit access. It also has a chart that you can use to compare the performance of each sales rep and show a quota line to determine who’s currently meeting quota. Not only can this dashboard do everything Laura wants it to do, it can also help reps evaluate their own performance.
Let’s create this dashboard now.
- If you haven’t already done so, sign up for a new Analytics Developer Edition org—even if you’ve already signed up for one while completing another module.
- Log in to your Analytics Developer Edition org.
- Open Analytics. In Lightning Experience, from the App Launcher ( ), find and select Analytics Studio.
- Select Create | Dashboard.
- Under Blank Dashboard, click Create Blank Dashboard. Select Create Dashboard from Template to create a dashboard based on a template. You can apply a template only while creating a dashboard—it can’t be applied to an existing dashboard.
- To add a title to the dashboard, drag a text widget from the widget toolbar to the top left corner of the dashboard canvas.
- To change the default text, enter “Sales Performance” in the Text widget property. To display a widget’s properties, select the widget while editing the dashboard.
- Drag the right handle of the text widget to increase the width to 12 cells. The text widget now spans 12 cells wide by 1 cell tall. Center the text in widget.
- Drag a container widget to the top right corner, below the text widget, and then drag the bottom handle to make it 6 cells tall.
- Drag a new text widget inside the top left corner of the container widget and change the text to “Key Metrics".
- Add three number widgets under the Key Metrics text widget.
- Drag the right handle of each number widget to make it 3 cells wide, fitting perfectly in the container widget.
- Click the Save button, name the dashboard “Sales Performance,” and then select My Private App. We save this dashboard in My Private App to hide it while you work on it. After it’s ready for prime time, you can place it in a shared app for others, like Laura, to access.