Information Visualisation What can I do with Excel and Visio Services?

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