Learn how to use DataPoint technology to show live XML data on your slides. You will see how to connect your textboxes, tables and charts to XML data on your computer, or XML data residing on the internet. When you open your PowerPoint presentation, the content of your textboxes, tables and charts is updated automatically. You can generate a snapshot presentation out of it, or display this information in real-time on a computer screen.

XML data is typically data originating from a database, but made available to the public, without granting permission on your database. So you export your table or query information of your SQL database, to an uniform and flat data file. You can put this XML data file on a network share, your local drive, or on a webserver.

In this article here, we will use the USD/EUR exchange rates as they are made available by Yahoo. This is just an example and you can use any other XML data file for your purpose. Yahoo offers the USD/EUR exchanges rates and other currency exchange information on the site.

The URL of this is:

https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDEUR%22)&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys

and shows the following information in a browser;

xml data slides xml raw data

So from this complex readable file, you can find out that a US Dollar is worth 0.92 EUR, at this time. Yahoo will keep this information up-to-date and update this information continuously. Imagine that we need to display this exchange rate in our presentations, or display it on a television screen for information to our colleagues at the bank.

After the installation of DataPoint, we see a new DataPoint item in the PowerPoint ribbon.

datapoint menu in powerpoint ribbon

Click the DataPoint menu option. For the List of the Connections group, click here.

click to open the connections list

Select the XML node in the tree and click the Add connection button.

select xml node and add connection

Enter the URL of the remote XML data file here.

https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDEUR%22)&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys

Calling this URL returns an XML formatted file or document that DataPoint can read. Hit OK to close.

set the url of the remote xml data file

Rename the connection and hit the Add query button.

add query to connection

You get an overview of the data tables that are present in the XML file. For this purpose, select the rate table. When needed, you can change the updating interval for more often or fewer updates. Default here is 60 seconds. Hit OK to close.

select a table from the xml data file

Now we have set up a live connection to the XML data file and see a preview of the data here already at the preview pane. Hit OK to close again.

preview on the xml file data

Add a background image to your slide and select a first textbox of your slide. Click DataPoint in the menu, followed by the Textbox button.

link textbox to name column

Select Name from the list of fields and click OK.

link textbox to name column

The value of the Name column is now copied into the textbox.

Repeat the same action for the rate column. Add or select a second textbox and click the Textbox button of the DataPoint menu. And select the column Rate from the columns list. Hit OK.

Perfect. The 2 textboxes are now linked dynamically to the fields of the remote XML data file.

Finalize the layout of your slide and we are ready. Next time you open your presentation, the name and rate will be updated automatically with the latest values. And you can run the slideshow, repeating this and other slides, and the information will be updated every 60 seconds as we have set it to be.

Get Your FREE DataPoint Trial. Valid for 15 days.

Download your free data driven PowerPoint templates
Use DataPoint to link presentations to various data sources
Great Digital Signage software for playlists with images, videos and PowerPoint presentations
Download FREE PowerPoint Templates

Download FREE PowerPoint Templates

You will receive more than 10 PowerPoint templates that you can use to create your information screens and digital signage.

You will also be asked if you want to be added to our mailing list to receive the latest resources, "how-to" articles and updates from our team.

You are subscribed successfully! You will get the gift with free Microsoft PowerPoint templates in your final subscription confirmation mail.

10 Secrets to Exceptional Presentations

Instant Access: 10 Secrets to Exceptional Presentations

Join our mailing list to receive the latest presentation resources from our team.

You have Successfully Subscribed!

Pin It on Pinterest

Share This