{"id":513502,"date":"2018-10-08T12:58:00","date_gmt":"2018-10-08T10:58:00","guid":{"rendered":"https:\/\/www.devoteam.com\/expert-view\/alteryx-powerpoint\/"},"modified":"2018-10-08T12:58:00","modified_gmt":"2018-10-08T10:58:00","slug":"alteryx-powerpoint","status":"publish","type":"expert-view","link":"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/","title":{"rendered":"Alteryx &amp; PowerPoint"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">###<strong>Automated PowerPoint Generation using Alteryx<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this post I\u2019ll show you how to change content of PowerPoint presentations by using Alteryx. You can change text, graphs, pictures in your own template. Automate your standard presentations to eliminate potential errors and save time on time repetetive tasks.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 1.<\/strong><br><br>In order to identify what elements to change in your PowerPoint using Alteryx, you have to add some unique variables you want to replace using new data from Alteryx. It could be a header like Company_Name (see below example with template and output). Or other data like numbers, pictures, graphs etc.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/xM3WhNk.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Spep 2.<\/strong><br><br>Save the template PowerPoint as XML. (File, Save As, Browse, Save as type: (*.xml))<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Spep 3.<\/strong><br><br>Load the .xml PowerPoint into Alteryx as a csv file with the following change of settings:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Delimiters: \u0000<\/li>\n\n\n\n<li>First Row Contains Field Names: &#8220;uncheck&#8221;<\/li>\n\n\n\n<li>Field Length: 14500000<\/li>\n\n\n\n<li>Code Page: Unicode UTF-8<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/PROncUK.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">**Spep 4.**<br>Now concatenate the XML into one field using the Summarize-tool.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Spep 5.<\/strong><br><br>Having the PowerPoint presentation loaded into Alteryx, you can start replacing your unique variables using the tool &#8220;Find Replace&#8221;-Tool<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Spep 6.<\/strong><br><br>When the manipulation of the XML data is completed, the data is outputted as a text file with the .xml extension, as below example. Remember to set:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Delimiters to \u0000<\/li>\n\n\n\n<li>First Row Contains Field Names: &#8220;uncheck&#8221;<\/li>\n\n\n\n<li>Code Page: Unicode UTF-8<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/RmoHBK8.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">At this stage your Workflow is fairly static, but by changing the replace element of your &#8220;Find Replace&#8221;-tool to reflect what the user selects in e.g. a dropdown you can start building PowerPoints with content based on the users input.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Use case:<\/strong><br><br>Based on inputs from the user e.g. like &#8220;company name&#8221; you would be able to build a report using relevant pictures, downloading information from company-specific pages like CVR, query data from databases and changing numbers in prebuild graphs in PowerPoint, and more.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The power of the Alteryx Server would at this point be to enable an organization to build automatically created PowerPoints using a shared app freeing up time from building PowerPoint to actually create value for the company.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Credit<\/strong>&nbsp;to Helle from Danica Pension for sharing the idea of using Alteryx to edit PowerPoint XML.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>###Automated PowerPoint Generation using Alteryx In this post I\u2019ll show you how to change content of PowerPoint presentations by using Alteryx. You can change text, graphs, pictures in your own template. Automate your standard presentations to eliminate potential errors and save time on time repetetive tasks. Step 1. In order to identify what elements to [&hellip;]<\/p>\n","protected":false},"featured_media":164612,"template":"","categories":[],"tags":[3506,2297,3499],"industry":[],"class_list":["post-513502","expert-view","type-expert-view","status-publish","has-post-thumbnail","hentry","tag-alteryx-en-nl","tag-data-en-nl","tag-denmark-en-nl"],"acf":[],"cards":"\n\t<div class=\"single-post-card\">\n\n\t\t<figure class=\"wp-block-post-featured-image\"><a href=\"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/\" target=\"_self\" ><img width=\"2560\" height=\"1031\" src=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2.jpg\" class=\"attachment-post-thumbnail size-post-thumbnail wp-post-image\" alt=\"Alteryx &amp; PowerPoint\" style=\"aspect-ratio:4\/3;width:100%;object-fit:cover;\" decoding=\"async\" loading=\"lazy\" srcset=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2.jpg 2560w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-300x121.jpg 300w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-1024x412.jpg 1024w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-768x309.jpg 768w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-1536x619.jpg 1536w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-2048x825.jpg 2048w\" sizes=\"auto, (max-width: 2560px) 100vw, 2560px\" \/><\/a><\/figure>\n\n\t\t\n\t\t<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-43282307 wp-block-group-is-layout-flex\">\n\t<p style=\"font-style:normal;font-weight:700\" class=\"has-link-color wp-elements-1 wp-block-lp-post-type has-text-color has-primary-color has-small-font-size\">Expert View<\/p>\n\n\t\t\n\t\t<h3 style=\"font-style:normal;font-weight:400\" class=\"wp-block-post-title has-base-font-size\"><a href=\"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/\" target=\"_self\" >Alteryx &amp; PowerPoint<\/a><\/h3><\/div>\n\t\t\n\t<\/div>\n\n","yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Alteryx &amp; PowerPoint | Devoteam<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Alteryx &amp; PowerPoint\" \/>\n<meta property=\"og:description\" content=\"###Automated PowerPoint Generation using Alteryx In this post I\u2019ll show you how to change content of PowerPoint presentations by using Alteryx. You can change text, graphs, pictures in your own template. Automate your standard presentations to eliminate potential errors and save time on time repetetive tasks. Step 1. In order to identify what elements to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/\" \/>\n<meta property=\"og:site_name\" content=\"Devoteam\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/xM3WhNk.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/expert-view\\\/alteryx-powerpoint\\\/\",\"url\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/expert-view\\\/alteryx-powerpoint\\\/\",\"name\":\"Alteryx &amp; PowerPoint | Devoteam\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/expert-view\\\/alteryx-powerpoint\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/expert-view\\\/alteryx-powerpoint\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/GettyImages-928121104_Edited-scaled-2.jpg\",\"datePublished\":\"2018-10-08T10:58:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/expert-view\\\/alteryx-powerpoint\\\/#breadcrumb\"},\"inLanguage\":\"en-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/expert-view\\\/alteryx-powerpoint\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-NL\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/expert-view\\\/alteryx-powerpoint\\\/#primaryimage\",\"url\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/GettyImages-928121104_Edited-scaled-2.jpg\",\"contentUrl\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/GettyImages-928121104_Edited-scaled-2.jpg\",\"width\":2560,\"height\":1031},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/expert-view\\\/alteryx-powerpoint\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expert View\",\"item\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/expert-view\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Alteryx &amp; PowerPoint\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/#website\",\"url\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/\",\"name\":\"Devoteam\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/devoteam.info\\\/en-nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-NL\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Alteryx &amp; PowerPoint | Devoteam","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/","og_locale":"en_US","og_type":"article","og_title":"Alteryx &amp; PowerPoint","og_description":"###Automated PowerPoint Generation using Alteryx In this post I\u2019ll show you how to change content of PowerPoint presentations by using Alteryx. You can change text, graphs, pictures in your own template. Automate your standard presentations to eliminate potential errors and save time on time repetetive tasks. Step 1. In order to identify what elements to [&hellip;]","og_url":"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/","og_site_name":"Devoteam","og_image":[{"url":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/xM3WhNk.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/","url":"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/","name":"Alteryx &amp; PowerPoint | Devoteam","isPartOf":{"@id":"https:\/\/devoteam.info\/en-nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/#primaryimage"},"image":{"@id":"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/#primaryimage"},"thumbnailUrl":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2.jpg","datePublished":"2018-10-08T10:58:00+00:00","breadcrumb":{"@id":"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/#breadcrumb"},"inLanguage":"en-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/"]}]},{"@type":"ImageObject","inLanguage":"en-NL","@id":"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/#primaryimage","url":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2.jpg","contentUrl":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2.jpg","width":2560,"height":1031},{"@type":"BreadcrumbList","@id":"https:\/\/devoteam.info\/en-nl\/expert-view\/alteryx-powerpoint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devoteam.info\/en-nl\/"},{"@type":"ListItem","position":2,"name":"Expert View","item":"https:\/\/devoteam.info\/en-nl\/expert-view\/"},{"@type":"ListItem","position":3,"name":"Alteryx &amp; PowerPoint"}]},{"@type":"WebSite","@id":"https:\/\/devoteam.info\/en-nl\/#website","url":"https:\/\/devoteam.info\/en-nl\/","name":"Devoteam","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devoteam.info\/en-nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-NL"}]}},"uagb_featured_image_src":{"full":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2.jpg",2560,1031,false],"thumbnail":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-150x150.jpg",150,150,true],"medium":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-300x121.jpg",300,121,true],"medium_large":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-768x309.jpg",768,309,true],"large":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-1024x412.jpg",1024,412,true],"1536x1536":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-1536x619.jpg",1536,619,true],"2048x2048":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/GettyImages-928121104_Edited-scaled-2-2048x825.jpg",2048,825,true]},"uagb_author_info":{"display_name":"Julien Pawlowski","author_link":"https:\/\/devoteam.info\/en-nl\/author\/"},"uagb_comment_info":0,"uagb_excerpt":"###Automated PowerPoint Generation using Alteryx In this post I\u2019ll show you how to change content of PowerPoint presentations by using Alteryx. You can change text, graphs, pictures in your own template. Automate your standard presentations to eliminate potential errors and save time on time repetetive tasks. Step 1. In order to identify what elements to&hellip;","_links":{"self":[{"href":"https:\/\/devoteam.info\/en-nl\/wp-json\/wp\/v2\/expert-view\/513502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devoteam.info\/en-nl\/wp-json\/wp\/v2\/expert-view"}],"about":[{"href":"https:\/\/devoteam.info\/en-nl\/wp-json\/wp\/v2\/types\/expert-view"}],"version-history":[{"count":0,"href":"https:\/\/devoteam.info\/en-nl\/wp-json\/wp\/v2\/expert-view\/513502\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devoteam.info\/en-nl\/wp-json\/wp\/v2\/media\/164612"}],"wp:attachment":[{"href":"https:\/\/devoteam.info\/en-nl\/wp-json\/wp\/v2\/media?parent=513502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devoteam.info\/en-nl\/wp-json\/wp\/v2\/categories?post=513502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devoteam.info\/en-nl\/wp-json\/wp\/v2\/tags?post=513502"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/devoteam.info\/en-nl\/wp-json\/wp\/v2\/industry?post=513502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}