Exporting Tableau Dashboards to PowerPoint

Data

Exporting Tableau Dashboards to PowerPoint

As Tableau Developers, we hate to see our work flattened and shoved into a PowerPoint file. We love to see our work displayed in it’s fullest, greatest ways – full of filters, parameters and tooltips for our users to play around with.

Occasionally, though, we have a few stubborn users who want to see the data in a familar format: PowerPoint. Your users likely have semi-valid excuses like: 

  • “I need to take the dashboards on the road.” 
  • “I don’t have a Tableau Server login.” 
  • “What’s Tab-blue?” 

Or, perhaps they just are simply afraid of new technology. Regardless of the reason, you may find yourself in need of exporting a set of dashboards to PowerPoint.

How It’s Done

Using a combination of PowerShell, Tabcmd and Microsoft’s Interop Libraries (installed with PowerPoint), it is fairly simple to export your dashboards. I’ve attached a ZIP file containing the script I use to complete this process. It contains two important pieces:

  1. GenPPT.ps1 – This is the main script. It runs the PowerShell processes to compile the PowerPoint. You will need to modify this to point to your dashboards and server.
  2. AnalyticsPPTBase.pptx – This is the template for generating your PowerPoint file. Modify it to your look/feel. The second slide is a base for additional slides.

In GenPPT.ps1, you will see several variables you need to modify:

  1. Line 8: Location of the PowerPoint folder
  2. Line 11: Location of the server
  3. Lines 17-19: List of dashboards to export. Add lines as needed. (Note: These need to be the sharable version of the URL, not the version with the # sign)
  4. Lines 29-31: Credentials for logging onto the server
  5. Lines 76-77: Optional title for pages

Upon modifying this information, you should be well on your way to exporting your dashboards as PowerPoint files!

More About the Author

Derrick Austin

Solutions Architect | Integration Practice Lead
A Quick Overview of Embedded Analytics in Portals for Tableau At InterWorks, we live and breathe Tableau. It is an awesome product that helps us to analyse data, draw insights and share them across ...
Portals for Tableau: The Year’s Biggest Features 2017 was without a doubt the year of embedded analytics. So, we wanted to emphasize the year’s biggest wins for our version of embedded ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072