470 likes | 689 Views
Fabrice Romelard Intranet-Extranet CTO SGS. Visio Professional 2007 & BI Data. Presentation. MVP since 2003 ASP.NET 2003-2006 SQL Server Since 2006 French communities member ASP-PHP Codes Sources GUSS .NET developer, SQL Server DBA and SharePoint Expert
E N D
Fabrice Romelard Intranet-Extranet CTO SGS Visio Professional 2007 & BI Data
Presentation • MVP since 2003 • ASP.NET 2003-2006 • SQL Server Since 2006 • French communities member • ASP-PHP • Codes Sources • GUSS • .NET developer, SQL Server DBA and SharePoint Expert • Coworkers SGS at Geneva (Suisse)
Survey • Office 2007 ? • Visio ? • Visio 2007 ?
Business Intelligence ? • Decisionhelper • Business strategicchoices • For business users
The Data Explosion GameChangers FormFactors Hard Drive Prices StorageInnovation DataTypes IT & Regulatory Compliance
Planning • VISIO 2007 show information • From Excel • From Access • From SharePoint (List or KPI) • FromDatabases (relational, analytic) • From Network (SCOM, SCCM connectors) • Visio and Overlays • Visio integration in Office • Share Visio documents
Visio and Excel data demo Football World Cup 2006
Visio and Access Datas demo Network Components
Visio and SharePoint demo
Visio - SharePoint Workflow Reports • Create Visio reports from Microsoft SharePoint workflow tasks • Ready-made graphical reports on status and progress of workflow tasks stored in SharePoint lists • Visio reports linked to SharePoint list data for automatic refreshing of diagram
Visio and SharePoint KPI demo Performance KPI
Vision and SQL Server • Connection possible for • DataBaseEngine • Analysis Services (SSAS)
SQL Assement - Symbols Used This denotes an Active Node Server in a clustered environment.
Visio and SCOM - SCCM • Connectors for System Center : • Operation Manager • Configuration Manager
Visio and SCCM - SCOM SCCM – System Info SCOM
Visio and Data Overlays • Add data in layer • Simplify usage • Perfect for end user
Data Visualisation with Data Overlays Data Overlay is the technique to visualize corporate information using Data Layer and Data Graphics on top of background image. Data Source 3 Import background Data Source 2 Create data layer Data Source 1 Shape 3 Data Layer 2 Shape 2 Data Layer 1 Link data to shape Shape 1 Background Image Apply Data Graphic CAD, Photo, Map, Diagram, etc.
Visio and Data Overlays demo USA Call Center – Ski Station
Information in context - Click Through Rate Icon Set Color by Value with transparency effect Data Bar Easy to understand relationships between data, location, contents and user trend Visual effects as data layer Web site as background image
Visio - Automating Data Visualization Visio API extended to allow programming against Data Link and Data Graphics Data features accessible from Visio ActiveX control Add Layer from the Winform on the Visio Schema
Visio - Project reports • Create Visio reports from within Microsoft Project • Ready-made graphical reports on projects and resources
Ressources • Visio Online • http://office.microsoft.com/en-us/visio/ • Visio ToolBox • http://www.visiotoolbox.com/ • Office Online • http://office.microsoft.com/ • My Technical Blog • http://blogs.developpeur.org/fabrice69/
© 2007 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. 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.