Skip to main content

Take Analytics Dashboards to the Next Level

Learning Objectives

In this project, you’ll:
  • Learn new ways to improve the readability and engagement of a dashboard.
  • Apply conditional formatting to highlight values in widgets.
  • Break up the dashboard content into separate, animated pages.
  • Add a binding to dynamically set a reference line based on a calculated average.
Note

Be sure that you have completed the Analytics Dashboard Building Basics module before beginning this project. Also, to complete the steps outlined here, use an Analytics-supported browser: Firefox, Chrome, Edge, or Internet Explorer 11.

Where to Next?

You've mastered the basics of building CRM Analytics dashboards. You built dashboards with key metrics, charts, tables, and filters. You designed different layouts for mobile and desktop.

Now it's time to up your game! Let’s learn about some advanced features that can make your dashboard more dynamic and easier to read.

Ready? Let’s do this!

Your Next Project at ABC Seeds

ABC Seeds is a nonprofit organization that provides funding to build schools in poverty-stricken areas around the world. They hired you as their Salesforce admin to help build a system to track fundraising.

A few months ago, the program director came to you asking if she can see metrics about donations, donors, and account owners in a single place. So, after getting everyone going with Salesforce’s Nonprofit Success Pack, you quickly threw together the Worldwide Fundraising dashboard. The director took one look at it and was impressed. She then asked you to share it with the fundraising team, which you did.The Worldwide Fundraising - Starter dashboard offers key metrics, goal attainment, top account owners, and more in one place.

But the director came into your office this morning and said, "We love your dashboard, but there's so much on it that we're having trouble reading it. I'm afraid a few account owners overlooked some huge potential donors. Maybe as much as a few million dollars we could have raised just last month.” Yikes!

After brainstorming some ideas, you and your program director agreed to make the following enhancements.

Clarify the data. Make large potential donations jump off the page by automatically highlighting opportunities worth more than $1 million. Make data actionable. Show high (and lower) performing members of the team by grouping them into high, medium, and low performer buckets. That way, the director can quickly see whose achievements to call out, and who needs coaching. Make data contextual. Help business users quickly zero in on key metrics and trends that impact donations by reorganizing the dashboard into smaller, more focused chunks. We don’t want to miss any more large donations, right? Set benchmarks. Quickly identify how the team’s doing by showing how each account owner’s performance compares to the average. Account owners are responsible for managing all donor accounts, including both individual and corporate donors.

Sign Up for an Analytics Developer Edition Org

Before you work through this Trailhead project, 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 project. Sign up here: trailhead.salesforce.com/promo/orgs/analytics-de.

Even if you already have an Analytics-enabled Developer Edition org, sign up for a new one. The older orgs don’t get recently released features—signing up for a new one ensures that you get the latest and greatest. In some cases, you can’t complete the challenges without the new features.

  • Fill out the form using an active email address. 
    • Your username must also look like an email address and be unique, but it doesn’t need to be a valid email account. For example, your username can be yourname@crmrocks.de, or you can put in your company name.
  • Click Sign me up. A confirmation message appears.Confirmation message appears, asking you to check your email.
  • Open and click the link in the activation email waiting in your inbox.
  • Complete your registration, and set your password and challenge question.
  • Write down or remember your credentials. To log in and play, just go to login.salesforce.com.

Signed up? Great! Now, it’s time to connect your new org to Trailhead. If you’ve already done this, feel free to skip to the next section in this step.

Connect your new org to Trailhead:

  • Log in to your Trailhead account.
  • Click the playground name and then click Connect Org located in the Challenge section at the bottom of this page.
  • Enter the username and password for the Developer Edition you just set up on the login screen.
  • Click Allow at the Allow Access? screen.
  • Click Yes! Save it. on the Want to connect this org for hands-on challenges? screen. You are redirected back to the challenge page and ready to use your new Developer Edition to earn this badge.

Create a Safe Work Area

To start, let’s clone the existing Worldwide Fundraising - Starter dashboard. It’s always best to work on a copy just in case you want to revert to the original.
  1. Log into your new Analytics-enabled Developer Edition org.
  2. From the App Launcher ( App Launcher icon), find and select Analytics Studio.
  3. Locate the ABC Seed app and open the Worldwide Fundraising - Starter dashboard.  NOTE: If the dashboard displays an error that says “Can’t display this widget,” wait a minute or two, and then refresh this page. This error happens if the underlying dataset for the widget hasn’t been created yet. When you sign up for an Analytics DE org, this dataset is created for you.
  4. Select the Edit button.
  5. Select the more options More options buttonbutton and select Clone in New Tab.
  6. Save the dashboard.
  7. Name the cloned dashboard Worldwide Fundraising In Progress and save it in My Private App.
  8. Close the Worldwide Fundraising - Starter dashboard so you don’t accidentally update it.

Great! Now you have a copy of the dashboard in your private work area. You can update the copy and make tweaks until it’s ready—and you don’t have to worry about affecting the day-to-day business since your original is still available to users. In the next project step, you edit the dashboard to draw users’ attention to specific results by dynamically highlighting table cells and chart segments.

Continue a aprender de graça!
Inscreva-se em uma conta para continuar.
O que você ganha com isso?
  • Receba recomendações personalizadas para suas metas de carreira
  • Pratique suas habilidades com desafios práticos e testes
  • Monitore e compartilhe seu progresso com os empregadores
  • Conecte-se a orientação e oportunidades de carreira