If we do have an analysis that we think is interesting and we want to hold onto it to come back to later, we can save it to a Deck.
- In the upper right corner, click the + (next to Save)
When we do that, the Deck panel on the right-side slides open.
A Deck is a place where you can hold on to any analysis that you find interesting and you want to either:
- look at later yourself,
- share or perhaps,
- use for export. You can export to PowerPoint, Excel, or, a dashboard.
You can see we have a couple saved analysis in this deck here, called Main Deck.
- Click the first item in Main Deck and note it appears in the Main Area.
- Select another question from the Accordion (to change the analysis)
- Click Save in the Deck panel on the top-right, noting it the analysis is saved by
The items in the Decks have different icons corresponding to whether the item is a table or a particular type of chart.
(optional) Charting time-based analysis
Let’s look at an example of an analysis over time.
- Find Internet Usage at Home in the Accordion
- Make it into a cross-tab using Wave(Date)
- Change the analysis into a Line Chart (using the Display Controller)
You have the option here to turn the table into a line chart because the data is being cross-tabulated against a date/time variable
Having a time-based variable lets you do some cool things. For example, we can roll-up time to different bands (eg; quarters, months, days, etc).
- Click on Table View icon in the Display Controller to turn it back into a table
- Hover the mouse over the Wave(Date) column header and use the little down arrow to go to Rollup in the menu that appears.
- Change the banding of time to quarterly (from monthly)
Let's save the analysis to the deck by pushing Save in the top right-corner.
- Click Save in the top-right corner. Note the analysis appears in the Deck at the bottom.
Make the deck go away just by clicking the X in the Deck panel.
- Click the X in the Deck panel to close the Deck.
(optional) Geographic mapping
Another interesting analysis is geographic mapping.
Let’s look at Internet Usage, at Home by regions.
- Click on Internet Usage, at Home in the Accordion
- Find US State in the Accordion and drag it onto the columns to make a crosstab.
You’ll now notice in the Display Controller, we have the option of the Globe icon as a chart. This is only available because we are using a geographic variable.
- Click the Globe icon.
And now we have a Google Map style interface.
- Pan around
- Zoom in and out
- Click on a particular region to notice underlying values
- Save analysis to the deck
Exporting to PowerPoint
We can export Decks we save as mentioned before. For now, we’ll just step through exporting some analysis to PowerPoint. We will look at Excel in Part 3 (Multi-tables), and then Dashboards in Part 4.
This icon down, square with a downer, allows me to export a deck, so if I click that it will offer me either Excel or PowerPoint export.
If you exported these slides into an existing presentation or template, you would immediately adopt all your logos, colors, net template or existing presentation.
- (Optional) Open a PowerPoint template
- Click on the Export button (bottom left of DecK) and select Export to PowerPoint
- Look at the PowerPoint export
When you export to PowerPoint it will produce editable PowerPoint objects. Each analysis is saved to its own slide. That is, they are not images.
- In PowerPoint, right-click on the chart and go to Edit Data
The other thing that we can do with the deck besides exporting it to Excel or PowerPoint is a dashboard, but we’ll cover that in Part 4.