Create Sales Analytics Using the Wizard

Learning Objectives

By completing this unit, you’ll learn the following:
  • How to use the configuration wizard to create Sales Analytics.
  • How changing answers to wizard questions impacts dashboards.
  • How to use a lightweight, iterative approach to creating the app so it meets your business needs.

KPIs at a Glance

It’s time to jump in and create the app. In the Analytics Apps Basics Trailhead module, you did that using the fast Basic creation option. This time, you do it again with the Custom option, which means you get to try out the built-in configuration wizard.

As you work, keep in mind the rules of using the wizard you read in the Analytics Apps Basics module. Your goal: To get Laura a working version of Sales Analytics so she has quick access to KPIs showing her team’s quarterly results.

Start by taking a sec to look at what you created in the Analytics Apps Basics module.

Log in to the org you set up in Analytics Apps Basics and click the App Launcher (App Launcher icon). Then click the Analytics Studio tile.



STOP! If you haven’t completed the Analytics Apps Basics module, go there first. In that unit, you sign up for a special Analytics Developer Edition org, which you must have to complete the rest of the Sales Analytics Trailhead module. You also create your first version of Sales Analytics in that module, which you’ll need here. If you’ve previously set up a Developer Edition org for another trail, it won’t work with Sales Analytics.

Open My First Analytics App. If you don’t see it right away, click the Browse tab at the top of the screen to get to your app. Get the app’s dashboards in a single view by clicking the Dashboards tab at the top of the app window. You now have all the dashboards in a scrollable window—a handy way to look at them, right?



Do not use the options to upgrade or reset your app if they’re available. Doing so changes Sales Analytics dashboards and the examples in the trail won’t match the app in Developer Edition.

Remember one of the rules of using the wizard: “Use it to fine-tune your analytics experience.” Put another way, that means there are many aspects of dashboards you can’t change. For example, open the Executive Overview – Pipeline Performance dashboard. You can be sure that will catch the CEO’s attention, right?

Sales Wave app executive overview dashboard

Don't worry if your dashboards look a bit different from the examples here and elsewhere in the Sales Analytics trail. The basic elements of the dashboards should be the same even though the data may differ.

The wizard doesn’t let you change the top part of this dashboard. In fact, many Sales Analytics elements can’t be changed by the wizard selections. Remember: We’ve prebuilt Sales Analytics and all the other Analytics apps to make analytics easy, right out of the box, with little effort on your part.

That said, some things are under your control through the wizard. Let’s have a look at an example.

What You Can Change With the Wizard: An Example

Have a look the Sales Performance dashboard, one of the dashboards for the sales ops team. Laura can use it to help her and the team understand which customers might be good candidates for upsell or cross-sell to help make quota. Here’s what the top of it looks like:Sales Performance dashboard

Now have a look at the wizard.

  1. In Analytics Studio, click Create in the upper right and select App.
  2. Select Sales Analytics and click Continue.
  3. Select My First Analytics App, click Continue. That opens a screen that lets you add objects to your app. We’ll come back to that in a minute; for now click Looks good, next.

Have a look at the first two questions, which ask how you want to segment customers. The Sales Performance dashboard uses those answers to determine what goes in some of the filters across the top. Here are the wizard questions (on the left) and the dashboard filters (on the right).



The questions in the wizard you see in your Developer Edition, and their order, may differ slightly from the ones shown here. We periodically update wizard functionality and the phrasing of questions and explanations, as well as their order. As long as you follow the instructions here, Sales Analytics should create your app successfully.

How wizard answers impact dashboards

See how Account Type and Industry in the wizard end up as filters in the dashboard? The other filters across the top can also be changed by the wizard, as can some filters in other dashboards. To see details about how to control dashboards with wizard selections, see the Sales Analytics Dashboard guide listed in the resources section at the end of this unit.

Close the wizard by clicking the X in the upper right corner.

Create Sales Analytics: Get the Wizard Answers Just Right

With that in mind, it’s time to create the app. In Analytics Apps Basics, you created the app using the Basic option. That created the app using the standard settings. It’s as if you had run through the wizard and accepted all the defaults, only it did that with just a click or two.

This time, you use the Custom option to vary the default settings and use the wizard. To keep it simple, we’re only going to change a couple of settings. You’ll get a feel for how the wizard works and how to use it in your own org. And you’ll see that your answers to the wizard questions really do matter!



Do not use the options to upgrade or reset your app if they’re available. Using these options changes Sales Analytics dashboards and the examples in this module may no longer match the app in Developer Edition.

  1. Go to your Developer Edition org and open Analytics Studio.
  2. Click Create and select App.
  3. In the “Choose an app template” window, select Sales Analytics and click Continue.
  4. Select Create a brand new app. Click Continue. This starts a compatibility check to see if your org meets minimum requirements for creating the app and to look at the data in your org. It should pass with flying colors, since we’ve prepopulated your the special Developer Edition org with the right data. After this runs, click Looks good, next.
  5. Select Custom and click Looks good, next.Choose how you would like to create Sales Wave screen
  6. This brings you to a page that lets you add objects to your app with Products and Cases preselected. When Service Analytics runs the compatibility check, it looks for the objects you see on this page. We’ve included Products and Cases in your special Developer Edition org, but not the other objects (which are greyed back here). You can deselect them by clicking the object, but let’s leave them—you know that DTC uses data about products to measure results. And it sounds great to see customer service data with your sales data. So leave them as is and click Looks good, next. In your own org, you can add other objects to your app here, but we only want Products and Cases for our example app.Sales Wave add objects page
  7. You see the first page of the wizard. Go to the first question, about the first field to use to segment customers. It has Account Type—but you’re going to try something a little different: You know that Laura usually likes grouping customers according to the segment. So look for Segment in the answers to the first question and select that. Leave Industry in the second question, like this.Sales Wave wizard first two questions
  8. Click Looks good, next, and move on to questions about the Opportunities object. Open the list of answers to each question one at a time and scroll through them. You should be able to tell that very few of the choices would work. For example, the first question asks about total amount of the opportunity, and the default selection is Amount. The other possibilities—Expected Amount, Probability, and Quantity—clearly aren’t right. That’s an important wizard rule in action: that only some answers make sense.
  9. On that page, go to the question about the field that indicates an opportunity is new business. Right now, the answer is Opportunity Type. But you’re feeling confident and want to try something different, so select Opportunity Source.
  10. Click Looks good, next a few more times to move through the rest of the wizard. As you do that, keep your eye out for one question you should know about: “How would you like to control data visibility in Sales Analytics?” Your answer controls data security in your app. Choosing the default lets Laura and other users view the data they own as well as the data owned by the people who work for them. In other words, it uses the standard Salesforce Role Hierarchy for data security. Leave that as is for now, but if you ever need to change data security for a particular app, this is the place to start. You can learn more about Salesforce Role Hierarchy in the document listed in the Resources section at the end of this unit.Configuration wizard security question
  11. When you get to the Name your app dialog, type in Analytics for Sales Managers and click Create.
This takes a few minutes, so grab that cup of coffee, watch cat videos, or whatever you like to do to pass time. You could also have a look at more details about the wizard in Salesforce Help. Soon, you’ll receive an email stating that the dataflow ran successfully, and you can move on to the next section.

Sync Analytics Data with Trailhead Data Manager

You just created your Sales Analytics app. Congrats! Now it's time to run the Trailhead Data Manager, which we introduced in the Analytics Apps Basics module. This step brings the right data into your app so you see meaningful data in dashboards. In the “real world,” you never have to do this when you create Sales Analytics with your own license. So we invite you to blast through without thinking about it too much.


Be sure you can see the dashboards for your app before running the Trailhead Data Manager. Also, you only need to run the data manager in Trailhead. You won’t have to use it to set up Sales Analytics in your own org.

  1. From Analytics Studio, go to the app picker at upper right and select Trailhead Data Manager. You may have to scroll down to find it.Trailhead Data Manager in app picker
  2. Select the Trailhead Data Manager link below Items. Then select Trailhead Data Manager on the next page.
  3. On the Trailhead Data Manager home page, click Refresh DTC Data.
  4. If your data is up-to-date, click the Download Trailhead Dataflow circle.Trailhead Data Manager Download Trailhead Dataflow
  5. From the dropdown menu, select Analytics_for_Sales_Managers. If you don’t see your app in the menu, you need to wait until the app creation process has finished.
  6. Click the Download Dataflow for Analytics_for_Sales_Managers_for_Trailhead button. The file is saved in your Downloads directory. It should be called Analytics_for_Sales_Managers_for_Trailhead.json.
  7. Go back to Analytics Studio by selecting it from the app picker.
  8. Click the gear icon in the upper right, and select Data Manager. (This is the Analytics Data Manager, not to be confused with the Trailhead Data Manager.) From the menu in the upper left, select Dataflow View.
  9. Scroll to Analytics for Sales Managers. Open the menu on the far right opposite the app name and select Upload.
  10. Click Select a file, navigate to the file you just saved in Downloads (Analytics for Sales Managers_forTrailhead.Json), and select it.
  11. Click Open, click the Upload button, and then click Done.
  12. Finally, open the menu on the far right next to the app name again, and select Start.
  13. From the menu in the upper left, select Dataflow View. You can see the status of the dataflow to the right of your app name at the top of the list of jobs. Click the refresh button a few times until the status changes from Running to Successful.

What a Difference a Few Answers Make

Wait a few minutes for the dataflow to run again. To be sure it’s finished, refresh your browser, select Dataflow View in the menu at the upper left and click the plus sign next to Analytics for Sales Managers. If you see Running at the top of the Status field, it’s not done yet. Once that changes to Successful, you’re ready to move on.

Go back to Analytics by clicking the gear icon at upper right and selecting Analytics Studio. Click Browse All, and open Analytics for Sales Managers. Now go to the Sales Performance dashboard to see what you did. Sales Wave Performance by Customer dashboard after changing wizard answers

The first version had Account Type and Industry filters at the far left. The second has Segment and Industry filters instead.

Just to see how the dashboard works, open the Segment filter to look at a list of DTC’s various market segments. Choose SMB and click Update. Now you can look at just accounts in the small-medium business segment. To go back to the dashboard in its original state, click the reset button wave reset button iconabove the dashboard.

Now go to the My First Analytics app and open the Sales Performance dashboard. Open the Account Type filter, which lets you select only from between Customer and Partner.

It’s a subtle, but important change. Laura can now filter all the performance dashboards exactly the way she wants—looking at all the data according to segments.

Previously, filters gave Laura a choice between looking at customers or partners, that is customer types, and she wanted to see a breakdown of customers. The new Segment filter shows sources of business broken down according to DTC’s market segments—exactly what she wants. Nice!

Now, let’s look for the results of the other change you made: Selecting Opportunity Source instead of Opportunity Type. Look at the filters along the left side of the dashboard, below the filters you just looked at. The second filter is called Opportunity Source.The opportunity source filter in performance by customers dashboard from Wave for Sales ManagersGo back to My First Analytics App and open the Sales Performance dashboard. The filter in the same location is called Opportunity Type. You can see the same change to all the other performance dashboards (by geography, by source, and so on), and other dashboards, too. One small change made a difference, right?

We deliberately made this simple, to help you get Laura what she wants fast. Likely, when you use the wizard to create your own app, it will take a little more thought and effort. But you get the idea: the wizard guides you through the process and tries to eliminate as much complexity as possible.

Clean Up: Delete Other Apps

Since you’re happy with this second version, you can delete any other apps you’ve created along the way.
  1. In Analytics Studio, click the Apps tab to see all your apps.
  2. Open My First Analytics App.
  3. Select the arrow in the upper right, and click Delete Delete Analytics apps
  4. Confirm that you want to delete the app.
  5. Repeat this for all other apps you might have created, except Analytics for Sales Managers. You want to have a clean org with only one app before you move to the next unit.
Great work—you’ve created a pretty useful app. Your filters are working like a charm and you have products showing in other dashboards. Of course those are just some of the dashboards—you can go through the others on your own to get ideas about what you’d change if you were to keep going with this process.

But for now, you’re happy, and Laura and the CEO should be ecstatic! It’s time to switch from coffee to champagne!

One More Thing: No Quotas

But wait! Just as you pop the cork on your champagne, your bubble bursts. You decide to check dashboards that show how the sales team is doing against its quota. You go to the apps tab in Analytics Studio, find your app, and open the Company Overview dashboard. But...

Company overview dashboard without quotas

You can see the forecast, but you can’t see how your team’s doing against its quota! Oh no! You forgot that you store and track data about the sales team’s quotas in a tool outside Salesforce. Never fear: You’ll learn how to import the data into Sales Analytics in the next unit.

Wrap Up

Thinking back to not so long ago, you remember how long it used to take to get all this data, and the form it used to take—a boring-looking set of reports. But now that you have Sales Analytics, Laura and the CEO can quickly get all DTC’s KPIs in one place and look at everything in snappy, interactive dashboards. And you got there with just a few quick runs through the wizard.

Of course, you’ve only done that with a few dashboards. But you can see just how fast and how intuitive the process can be, as long as you take a step-by-step approach and remember a few key rules when using the configuration wizard.