Information Visualisation What can I do with Excel

Information Visualisation What can I do with Excel and Visio Services? Dave Paylor @Dave. At. OBS

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

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

Information Visualisation Options Excel Services Visio Services j. Query plugins XSLT Excel - Power. Pivot Power View Reporting Services Performance. Point SQL Server 2012 / Share. Point

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

Excel REST Get charts and content from Excel with a URL http: //<Server. Name> /_vti_bin/Excel. Rest. aspx /Docs/My. Workbook. xlsx /model/Charts(‘My. Chart') �Charts �Ranges �Tables �Pivot. Tables

Parameters /model/Charts(‘My. Chart')? Ranges('Sheet 1!A 1')=5. 5 /model/Ranges('Sheet 1!A 1|G 5')? Ranges('Sheet 1!C 3')=demo Max 2, 000 characters

Demo

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

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

Demo

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

Thank you to our sponsors