Step 7: Build a story to present
You want to share your findings with the larger team. Together, you might reevaluate selling machines in North Carolina.
Instead of having to guess which key insights your team is interested in, and including them in a PowerPoint presentation, you decide to create a story in Tableau. That way, you can walk viewers through your data discovery process, and you have the option to interactively explore your data to answer any questions that come up during your presentation.
Create your first story point
For the presentation, you'll start with an overview.
Click the New story button.
From the Story pane on the left, drag the Sales in the South worksheet onto your view.
Add a caption – maybe "Sales and profit by year” – by editing the text in the grey box above the worksheet.
You're presented with a blank workspace that reads, "Drag a sheet here." This is where you'll create your first story point.
If you’re thinking that blank stories look a lot like blank dashboards, that's because they do. And like a dashboard, you can drag worksheets over to present them. You can also drag dashboards over to present them in your story.
This story point will be a useful way to acquaint viewers with your data.
But you want to tell a story about selling machines in North Carolina, so it's time to take a step in that direction.
Highlight machine sales
To bring machines into the picture, you can leverage the Sub-Category filter included in your Sales in the South bar chart.
In the Story pane, click Duplicate to duplicate the first caption.
Continue working where you left off, but know that your first story point will be exactly as you left it.
Since you know you’re telling a story about machines, on the Sub-Category filter, clear the selection for (All), then select Machines.
Now your viewers can quickly identify the sales and profit of machines by year.
Add a caption to underscore what your viewers see, for example, "Machine sales and profit by year."
You've successfully shifted the focus to machines, but you realise that something seems odd: In this view, you can't single out which state is contributing to the loss.
You'll address this in your next story point by introducing your map.
In the Story pane, select Blank.Learn more: What's this mini toolbar under your story point caption?
The Story toolbar shows under, or on top of, the story point caption once you drag your first story point onto the canvas and mouse-over the navigator area. Use it to revert changes, apply updates to a story point, delete a story point or create a new story point out of the current, customised one. All of the options are available once you make a change to the story point. Otherwise only the delete option is available.
Check your work! Watch "Create your first story point" and "Highlight machine sales" in action.
Click the image to replay it
Make your point
The bottom line is that machines in NC lose your company money. You discovered that in the dashboard you created. Looking at overall sales and profit by year doesn't demonstrate this point alone, but regional profit can.
Drag your dashboard Regional Sales and Profit onto the canvas.
This gives viewers a new perspective on your data: Negative profit catches the eye.
Add a caption like, "Underperforming items in the South."
To narrow your results to just North Carolina, start with a duplicate story point.
Select Duplicate to create another story point with your Regional Profit dashboard.
Select North Carolina on the map and notice that the bar chart automatically updates.
Select All on the Year of Order Date filter card.
Add a caption, for example, "Profit in NC, 2014-2017."
Now you can walk viewers through profit changes by year in North Carolina. To do this, you will create four story points:
Select Duplicate to begin with your Regional Profit dashboard focused on North Carolina.
On the Year of Order Date filter, click the right arrow button so that 2014 appears.
Add a caption, for example, "Profit in NC, 2014," and then click Duplicate.
Repeat steps 2 and 3 for years 2015, 2016, and 2017.
Now viewers will have an idea of which products were introduced to the North Carolina market when, and how poorly they performed.
Check your work! Watch "Make your point" in action.
Click the image to replay it
On this story point, which focuses on data from 2017, you want to describe your findings. A caption simply won't do.
In the left-hand pane, select Drag to add text and drag it onto your view.
Enter a description for your dashboard that emphasises the poor performance of machines in North Carolina, for example, "Introducing machines to the NC market in 2017 resulted in losing a significant amount of money."
For dramatic effect, you'll probably hover over Machines on the Sales in the South bar chart while presenting to show a useful tooltip: the loss of nearly $4,000.
In the Story pane, click Blank.
From the Story pane, drag Negative Profit Bar Chart to the view.
In the Year of Order Date filter card, narrow the view down to 2017 only.
You can now easily see that the loss of machine profits was solely from Burlington, NC.
In the view, right-click the Burlington mark (the bar) and select Annotate > Mark.
- In the Edit Annotation dialog box that appears, delete the filler text and type: "Machines in Burlington lost nearly $4,000 in 2017."
In the view, click the annotation and drag it to adjust where if appears.
Give this story point the caption: "Where are we losing machine profits in NC?"
Double-click the Story 1tab and rename your story to "Improve Profits in the South".
Review your story by selecting Window > Presentation mode.
And now, for the final slide, you drill down into the details.
What are those scroll bars doing on the right side or the bottom of your dashboard story point while you're in presentation mode?
It seems like your dashboard is too big for the presentation. That's irritating. Press the Esc key to exit your presentation, and then select the Regional Profit sheet at the bottom of your workbook.
In the left-hand pane under Dashboard, change the Size drop-down selection from Desktop to Fit to Improve Profits in the South. This will automatically size your dashboard for optimal story viewing.
Select Fit to Improve Profits in the South and then enter Presentation mode again. Your dashboard fits nicely.
Check your work! Watch "Finishing touches" in action.
Click the image to replay it
After you present
Your presentation went very well. The team is convinced there is work to be done to increase profit in Burlington, NC. Plus, they're curious to know why machines did so poorly in the first place. Your boss is thrilled: Not only have you identified a way to address negative profit, you've got the team asking questions about their data.
To keep the lessons fresh in their minds, your boss asks you to email your team a Word doc with your findings. Good thing you know about sharing your visualisations with Tableau Server and Tableau Public.
Continue to Step 8: Share your findings.