1 / 47

Visio Professional 2007 & BI Data

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

lorenzo
Download Presentation

Visio Professional 2007 & BI Data

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. Fabrice Romelard Intranet-Extranet CTO SGS Visio Professional 2007 & BI Data

  2. 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)

  3. Survey • Office 2007 ? • Visio ? • Visio 2007 ?

  4. Business Intelligence ? • Decisionhelper • Business strategicchoices • For business users

  5. The Data Explosion GameChangers FormFactors Hard Drive Prices StorageInnovation DataTypes IT & Regulatory Compliance

  6. 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

  7. Visio and Excel data demo Football World Cup 2006

  8. DEMO – Visio and Excel data

  9. Visio and Access Datas demo Network Components

  10. DEMO – Visio and Access

  11. Visio and SharePoint demo

  12. DEMO – Visio and SharePoint

  13. 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

  14. Visio and SharePoint KPI demo Performance KPI

  15. DEMO – Visio and SharePoint KPI

  16. DEMO – Visio and SharePoint KPI

  17. DEMO – Visio and SharePoint KPI

  18. DEMO – Visio and SharePoint KPI

  19. DEMO – Visio and SharePoint KPI

  20. DEMO – Visio and SharePoint KPI

  21. DEMO – Visio and SharePoint KPI

  22. DEMO – Visio and SharePoint KPI

  23. DEMO – Visio and SharePoint KPI

  24. Vision and SQL Server • Connection possible for • DataBaseEngine • Analysis Services (SSAS)

  25. Visio – SSAS

  26. Visio and connector SQL Assement

  27. Visio and connector SQL Assement

  28. Generated Diagram in Visio

  29. SQL Assement - Symbols Used This denotes an Active Node Server in a clustered environment.

  30. Visio and SCOM - SCCM • Connectors for System Center : • Operation Manager • Configuration Manager

  31. Connector- SCOM Visio Add-in--BI

  32. Connector- SCCM Visio Add-in - BI

  33. Visio and SCCM - SCOM SCCM – System Info SCOM

  34. Visio for IT Management

  35. Visio and Data Overlays • Add data in layer • Simplify usage • Perfect for end user

  36. 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.

  37. Visio and Data Overlays demo USA Call Center – Ski Station

  38. DEMO - Visio and Layers

  39. 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

  40. Data Overlays

  41. 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

  42. Sharing Visio documents

  43. Visio - Project reports • Create Visio reports from within Microsoft Project • Ready-made graphical reports on projects and resources

  44. Visio New Areas Covered

  45. 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/

  46. Questions ?

  47. © 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.

More Related