If your organization has invested in creating BI dashboards in Tableau, you probably want to use them for reporting. However, many clients and executives prefer to receive reports in PowerPoint. Luckily, you can automatically integrate your Tableau content into PowerPoint using Slideform.
Slideform automation puts your reports on auto-pilot. Embed any content from Tableau into a presentation, apply filters, and set a schedule to update automatically.
Why use slide decks for reporting?
Some may wonder why we are still using
PowerPoint for client-facing reporting. Well, one reason is that Tableau Viewer licenses are expensive! But there are other good reasons to send your clients a report in slide form.
- A PPT deck can be customized to each client or exec so they see only the data that is most relevant to them.
- A slide deck does not change over time, so they can always refer back to it.
- Presentation format is easy to step through together during a meeting.
- You can add comments and recommendations that are relevant to the specific data in the slides.
- The slide deck can be styled according to the client's branding guidelines or your corporate style guide.
- You can share the presentation directly with the recipients over email.
So, how can you insert Tableau content into PowerPoint?
There are few solutions available to insert Tableau to PowerPoint.
- The best way to export Tableau charts and visuals directly to your customized PPT report is with Slideform. Slideform uses AI-powered automation to map your Tableau content to shapes and text boxes on a PowerPoint template. You can apply filters to the data automatically, crop the chart images, set an update schedule, and create multiple presentations at once. Learn more at https://slideform.co.
- Tableau does have the option to export to a PowerPoint file. However, the worksheet is exported in a non-editable format and on a blank PowerPoint template. This is useful as an archive or snapshot of your dashboard, but I wouldn't send this raw dashboard dump to a client.
- The option that I used to use is to manually copy and paste from Tableau to PowerPoint. This puts a static image of the visual into your presentation. The limitation is that you have to set the filters, then copy over every single data element and chart, and if the data changes you will have to copy them over again.
How to automatically export Tableau visuals to PowerPoint
-
Connect your Tableau workbook to Slideform
First, create a new connected app in Tableau, then, in Slideform, add the Tableau data source and provide the requested credentials. For more details on setup, see How to Connect A Data Source.
Slideform captures each visual in the worksheet, including charts, tables, maps, and metrics, and makes it available to embed into your slide template. Slideform also extracts all of the data behind each of the visuals. You can use this to fill in text boxes in the presentation and to construct editable tables in your slides.
Here is my sample Tableau dashboard. I want to filter this dashboard to a specific year and category, and then embed some of the charts and data into a PowerPoint.
- Connect a slide deck template
Next, you need a template for your presentation. With Slideform, you can use your own custom-branded slide deck. Just start with a previous version of your report and insert placeholders (enclosed in curly braces) for any elements that will change between versions of the report, like text, numbers, tables, images, charts, logos, and names. All the colors, styling, fonts, and sizing of the elements in the template will be carried through to the slide deck output.
Here is an example slide template with placeholders for metrics and charts from Tableau.
Once you have saved a template, upload the .pptx file to Slideform as a New Project. Give your project a name and associate the Tableau data source.
- Match Tableau views and metrics to the placeholders
Now, we need to match each placeholder in the slide template to the correct chart or other content that will fill it. Open the project for editing by clicking Configure Data on the project card. Select the data source, then choose the chart or table, and set the anchor position. You can filter the data with any filters that are included in your dashboard, such as date range, category, or region. Tables are embedded as editable, native PowerPoint tables.
To pull in a number, such as a KPI or metric, it is a similar process. We pull in the data behind Tableau scorecards and tables and you can filter and perform functions to select the data you want to use. The metric will be embedded as an editable text field in the presentation.
- Generate the PowerPoint presentation
Click Generate on the project card to make a new, up-to-date presentation. You can also Set a Schedule for Recurring Presentations to auto-generate and email the slides to you. Or, create several slide decks with different filter settings using Bulk Mode. Awesome, right!
Here is my report with filters for year and category applied to the Tableau data.
Advantages of Slideform automation:
- No screenshots! And no copying & pasting.
- Set recurring presentations to auto-generate on a schedule!
- Slides are viewable by all recipients; no Tableau license required.
- Data (charts, graphs, numbers) automatically update when you generate a presentation.
- Combine Tableau with other data sources and content including spreadsheets, images, and text.
- Use your own custom slide template in the format of your choice.
Can I embed Tableau in Google Slides?
Yes! Slideform fully supports Google Slides format. Slideform automation is the best choice to connect Tableau to Google Slides.
Start your free trial today!