You’ve got questions about your business, and the answers are in your data. So you need to become an explorer—a data explorer, that is—using Analytics. As you work toward your badge for this module, you’ll start with a concrete goal that guides all your explorations. The basic concepts that you’ll learn will not only help you through this module but can be applied at your actual company. So, no time to waste—let’s go through the first use case!
Here’s your goal for this unit: The new quarter is starting and you want to run a bonus contest for the best seller in the company to drive sales in one of your product families. You don’t know which family to choose, but the answer is in your business data. You need to understand how your sales are spread among your products in order to choose the focus for your contest. Analytics data exploration allows you to go from one answer to another naturally, and even answer new questions as they arise.
STOP! If you haven't completed the Analytics Basics module, please go there first. You'll need to sign up for a special Developer Edition org before you can do this module.
You should see a single dataset called DTC Opportunity. Click to open it.
Now you’re in a tab called “New Lens.” You’ll see the initial state of your data exploration with a count of rows in your dataset. Hover your mouse over the bar to view a box with the exact number.
Throughout the exploration, you’ll ask questions about the data. Asking a question is what we call “running a query.” You’ll be changing the query one step at a time to get closer to your exploration goal, and you’ll see this simple bar transform into a sophisticated chart.
- Aggregating—Summarize the data by some measure. For example, the measure could be a count of the rows of data, as in the initial exploration state. Another common measure is a sum of the amounts.
- Grouping—Group the data by a certain dimension (more on dimensions in a bit). For example, group by product name or account.
- Filtering—Filter the data to narrow your results. For example, show only opportunities within the fiscal year.
It’s not grouping or filtering, but it’s aggregating the count of rows, which is the default. Note that groups and filters are optional, whereas aggregation is required. Regardless of the query you use, there must be at least one measure to have a visualization.
Time to add a grouping by product family. Clicking the plus sign (+) under Vertical Axis opens a drop-down menu where you select the dimension to group by.
Don’t know what a dimension is? A dimension is a qualitative value, like region, product name, or model number. So it’s something you can group by.
Here, you want to group by Product Family. You can access the dimension faster by typing the name, then selecting it from the list.
You can see that the aggregation, Count of Rows, is now calculated for every group. But you want to see the revenue brought in by each product family, so you need to change the aggregation. Aggregations are typically made on measures.
- Under Horizontal axis, click Count of Rows to
change the aggregation.
The dropdown menu that opens shows you the calculations you can make using a measure, such as Sum or Average.
- You want to see the total revenue brought in by each product family, so click
The list on the right shows the available measures.
- Select Amount.
The chart has been updated, and you can see that the value on each bar is different now!
- Click the menu control (v) next to Sum of Amount.
- Select Sort Descending.
Now you have an interesting view of your sales by product family. You can see that laptops have made a strong showing and have moved into the second place over digital media. DTC has also made a big push behind the light laptop family product—boosting inventory and marketing activities—to go after the home and education markets. Can laptops catch accessories? Can you boost light laptop sales? That’s it! You need to run your sales contest on laptops to motivate your sales reps to sell this product family—especially DTC light laptops!
Just by clicking the blue Laptops bar, you can drill into laptops sales data. Click once to select the bar, and then right-click to open the drop-down menu. Select Opportunity Owner, and let the magic happen!
- Under Vertical Axis, the grouping has changed from Product Family to Opportunity Owner.
- You’re filtering the product family by laptops only.
You now have an answer to the leaderboard question! But wait! Is it the real answer?
- Click the plus sign (+) under Filter by.
- Search for Won, and then click it.
- Select the value true.
- Click Add.
Did you notice the animation when you added the filter? It’s a great visual way to understand how the results change. Your top sales reps are different when you’re focusing only on the won deals. Some reps went down, others went up, and it’s important to know how they moved when you focus on won opportunities.
- There are now two dimensions on the left of the bar chart: Opportunity Owner and Product Name.
- The chart now highlights the second grouping (product name) by color. The right
side of the chart includes a legend showing the color-product
This visualization tells you what products are bringing in the most revenue. As you hoped, light laptops are doing great. Let’s bring this information together with information in the sales rep leaderboard by changing the visualization.
You want to identify the rep who’s best at selling laptops, so you want to see one bar per owner name, but keep the product name grouping. So what if you could “stack” the values for each sales rep?
Let’s click the chart gallery icon () to see the options for charts. Locate Stacked Bar and click it to see what happens.
Each visualization has a different way to handle multiple groupings or measures. Try clicking the chart gallery icon () again, and then select Donut. In this case, it’s creating a donut for each first grouping (Opportunity Owner) and displaying the second grouping on it (Product Name).
As you did at the beginning, you can hover over any segment to get more information about the values. Multiple grouping charts give you even more valuable information than single groupings, for example you can see the percentage of each second dimension value.
Donut charts are a good way to quickly see the composition of your data. Here’s a summary of the best chart to use based on the insight you’re seeking:
- Under Trellis, delete Opportunity Owner.
- Change Segment By to Opportunity Owner.
- Under Trellis, click + to add Product Name.
The visualization now has donuts for each product. On each donut, the second grouping is now by opportunity owner.
- A dimension is a descriptive value, whereas a measure is a value you can do math on.
- Each visualization is efficient in specific use cases. Choose visualizations based on the major insights you want to derive from them.
- Don't be afraid to go exploring. You can see every step of the journey in the history and navigate between the steps easily.
- You can save an exploration in a lens.
- When you’re exploring data, you’re just mixing and matching four basic actions: aggregating, grouping, filtering, and creating a meaningful visualization.