1 / 13

Unlocking the Power of Information Visualization with Excel and Visio Services

Discover how to harness the capabilities of Excel and Visio Services for effective information visualization. In this insightful session led by Dave Paylor, you'll explore various options available through Excel Services, Excel REST, and Visio Services APIs. Learn to integrate data visualization techniques, create interactive charts and reports, and utilize advanced features like PowerPivot and PerformancePoint. Get practical demos showcasing how to link data to Visio objects and enhance your BI applications. Enhance your analysis with stunning visual representations.

cachez
Télécharger la présentation

Unlocking the Power of Information Visualization with Excel and Visio Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Information VisualisationWhat can I do with Excel and Visio Services? • Dave Paylor • @DaveAtOBS

  2. What am I talking about? • Information Visualisation options • Excel Services • Excel REST • Parameters • Demo • Visio Services • Visio Services API • Demo

  3. Information Visualisation • BI • Data warehouse • Cubes • Fact tables • Dimensions • Charts • Reports • Analysis

  4. Information Visualisation Options Excel Services Visio Services jQuery plugins XSLT Excel - PowerPivot Power View Reporting Services PerformancePoint SQL Server 2012 / SharePoint

  5. Excel Services • Display named Excel elements in web part • Select from named items • Navigate worksheets • Data is protected • Excel REST

  6. Excel REST Get charts and content from Excel with a URL • http://<ServerName> • /_vti_bin/ExcelRest.aspx • /Docs/MyWorkbook.xlsx • /model/Charts(‘MyChart') • Charts • Ranges • Tables • PivotTables

  7. Parameters • /model/Charts(‘MyChart') • /model/Charts(‘MyChart')?Ranges('Sheet1!A1')=5.5 • /model/Ranges('Sheet1!A1|G5') • /model/Ranges('Sheet1!A1|G5')?Ranges('Sheet1!C3')=demo • Max 2,000 characters

  8. Demo

  9. Visio Services • URLs in Visio objects • Link data to Visio objects • Save as VDW • Dynamic Silverlight web part • Visio Services API

  10. Visio Services API • Javascript interface • Mouse over an object • Click an object • Get data from an object • Zoom to an object • Highlight an object

  11. Demo

  12. Dave Paylor http://paylord.wordpress.com @DaveAtOBS dave.paylor@obs.com.au Any Questions

More Related