Web to PowerPoint Conversion

If you've ever been asked to periodically produce a report in Microsoft PowerPoint, you know that this can be very time consuming and error-prone. The solution is to automate the data extraction and create the PowerPoint presentation "on the fly", saving you hours of work for each presentation, and increasing the accuracy of the final report.

How it Works

In this example, we have a web-application that contains data that needs to be used to populate a PowerPoint presentation. This data consists of text as well as data to be graphed.

1. Our first step is to ensure that the data can be reliably extracted. While access to the underlying database or through a web-service (or XML call) is preferable, we can "screen scrape" web-pages to extract the needed information.

2. The next step is to design the PowerPoint template. The best way to start is to have the customer provide an existing presentation to base the new template off of, but we can also perform custom design if needed.

3. The third step is to create the tool to insert the extracted data into the presentation. This takes the form of a "VBA Macro" that loads and inserts the data, properly formatted, into the template.

4. The final step is to perform rigorous testing and to obtain customer sign-off. The final tool is then delivered, complete with documentation and all source code.

To learn more or to request a quote, please use the comment form or e-mail me directly.