Erfolgreiche Unternehmen bauen ihre

SharePoint-Dashboards mit Visio Sehen heißt verstehen!

Claus Quast SSP Visio – Microsoft Deutschland GmbH

2

Inhalt

3

Was sind Dashboards?

Die Bausteine

Visio Services, der “Sehen heißt verstehen”-Baustein

o Demo

Web Part to Web Part Connection, der “Das kann jeder”-Baustein

o Demo

Mash-up API, der “Hier geht mehr”-Baustein

o Demo

Was sind Dashboards?

Dashboard: dash·board\dash-ˌbord\Ein Kennzahlen-Cockpit [auch IT-Dashboard, Scorecard oder Cockpit-Chart] ist eine Visualisierungsform großer Mengen von meist verteilten Informationen in verdichteter Form

Wichtige Faktoren für Dashboards

o Entstehungs- und Herstellungszeit

o Lebenszeit

o Kosten

o Zielgruppenorientierung

o Standards

4

Excel Services

Performance Services

Visio Services

Listen

…

5

Die Dashboard-Bausteine

Data Source

• LOB apps via ODBC/OLEDB

• SQL Server

• SharePoint Service List

• Excel Services

Publishing Diagram Visio 2010 Pro

Viewing Diagram ECAL

• Zero Software Deployment

• Manual/Auto refresh

• Pan & Zoom

• Page Tab

• Hyperlink

• Search with Meta Data

ECAL User

Visio 2010 Pro

Link Data to Diagram

Publish

Diagram to

SP

View Diagram with

Silverlight or .png

Re-importing Data

1

3

2

4

5 Update Data

Graphics

Visio Services provides a Webpage or SP Web Part

Visio 2010 – SharePoint 2010-ECAL – Visio Services

6

Visio Services provides web-based user

experience and navigation features

7

• Panning

• Zooming

• Shape

Data

Window

• Open diagram in Visio 2010

• Manually refresh by clicking

refresh button or automatically

refresh by setting interval time

Note: Administrator sets

interval time for auto refresh

Legend for Data

Graphics conditions

• Pre-defined Data Graphics: Text, Icon Set, Data Bar, Color by Value

• Data Graphics updated by importing latest data

Visio Web Access Web Part in SharePoint 2010

Demo

o Erstellen mit Visio 2010

o Veröffentlichen in SharePoint 2010

o Präsentieren in SharePoint

8

Visio Services Web Part to Web Part Connections

9

Visio layout

ready to use

connections to

the second web

part

Excel Services

ready to be

connected to

Visio Services

web part

Connection

sends or receives

data

Visio Services enables users to manipulate the Visio web drawing by using the pre-defined connections to

send or receive data

Web Part to Web Part Connection

Demo

o Einbinden von Web Parts in SharePoint 2010

o Konfiguration von Interaktionen

10

Visio Services Mash-up API

Floor layout of

supermarket

shows sales

trends and

stock levels

based on KPIs

Detailed view of

a specific shelf

with KPI

Excel chart for

detailed sales

information

Hyperlink to

open relevant

documents

• Visio Services JavaScript Mash-up API enables developers to access and manipulate the Visio web

drawing, its pages and shapes

• All 4 web parts are connected to each other and retrieve business data from LOB applications

11

Visio Services Mash-up API

Demo

o Einbinden der Bausteine

o Das JavaScript- und Objektmodell

o Die Lösung

12

Integration of Visio diagram in SharePoint Anwendungen

Visio Services embed both static and dynamic Visio Web Drawings into SharePoint applications

Integration method Scenario enabled Skill set required

Visio Web Access web part Embed Visio diagrams into SharePoint pages. How to create a web part page in

SharePoint.

Web Part to Web Part Connections

Enable limited interactivity between the Visio Web

Access web part and another Web Part on the page,

without code. For example, clicking a shape in a

Visio web part to trigger another web part to show

additional relevant information about that shape.

How to create a web part page in

SharePoint and how to set-up Web Part

Connections.

Visio Services Mash-up API

Enable rich interactivity on web part page by

programmatically manipulating the different Visio

web diagram objects, for example, to show custom

visual overlays when the user hovers the pointer

over a shape.

How to code simple JavaScript and/or ASPX

pages.

13

Workflow-Visualisierung

SharePoint 2010 enthält ein vordefiniertes Webpart zur Überwachung von SharePoint- Workflows

Workflow Settings in

SharePoint Designer 2010

zum Aktivieren der

Workflow- Visualisierung

in der SharePoint-Site

14

Vielen Dank für Ihre Aufmerksamkeit!

Quast

Claus

SSP Visio

Microsoft Deutschland GmbH

Gasstraße 6a

22761 Hamburg

Tel. 040 897 22-6500

E-Mail: Claus.Quast@Microsoft.com

URL: http://office.microsoft.com/de-

de/visio/

15

© 2011 Microsoft Corporation. All rights reserved. The names of actual companies and products mentioned herein may be the trademarks of their respective owners. The information herein is for informational purposes

only and represents the current view of Microsoft Corporation as of the date of this presentations. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the

part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE

INFORMATION IN THIS PRESENTATION.