Visualising and Generating SQL data with Microsoft Visio
- Slides: 35
Visualising and Generating SQL data with Microsoft Visio 2013 David Parker Microsoft MVP (Visio) davidp@bvisual. net @Visio. Rules
Thanks to our Main Sponsors:
b. Visual profile b. Visual ltd Visio consultancy training proof of concepts Microsoft Partner 15 years David Parker 11 years MVP b. Visual ltd founded in 1998 by David Parker Visio consultant trainer author � UK based global reach
b. Visual typical client solutions Nexans Building Cabling Solutions National Physical Laboratory Rail Accident Investigation Board Perenco Network Equipment Design National Planning Roadmaps Rail Accident Fault Analysis Trees Personnel Locations + Asset Tracking
b. Visual consultancy and training
Microsoft Visio 2013 editions Visio Standard 2013 Visio Professional 2013 Visio Pro for Office 365 Easily create versatile diagrams using a rich set of new and updated shapes and stencils. Work as a team to easily create and share professional diagrams that simplify complex information. Take advantage of all features in Visio Professional 2013 as an always-up-to-date subscription from Office 365.
Visio for everyone IT Management Organizational Management Facility Management Process Modeling Mind mapping Mockup Software Development Layout Design Quality Management Work Flow Design Planning Dashboard
Key visualisation features Data Graphics Surface Shape Data values • Optionally from External Data via Link Icon Sets Text Callouts Refreshable shape geometry Data Bars • • Color By Value Icon Sets Text Callouts Data Bars Color by Value Shape Behavior All Visio shapes are evaluated for rendering Build shapes that respond to data changes • Drive geometry, formatting, text, etc via the Shape. Sheet
Supported refreshable data sources Share. Point 2013 On. Premises Supports Kerberos, SSS & Unattended Authentication Office 365 is a multi-tenant environment ODC Native External Lists support via BCS Native SQL Azure support BCS Native External Lists support via BCS – WCF, . NET, OData BCS
Linking Data to Shapes SQL
How text or graphics are updated by data Change Value in Data Source Refresh Data. Recordset Linked Shape Data value updates Related cell value updates Displayed text or graphic updates
Shape Data types 0 - String 1 - Fixed list • Up to 32 k characters • Users can select only one item from the list** 2 - Number • Number. Includes date, time, duration, and currency values as well as scalars, dimensions, and angles* 3 - Boolean • Displays FALSE and TRUE as items users can select from a drop-down list box 4 - Variable list 5 - Date time 6 - Duration 7 - Currency • Users can select a list item or enter a new item that is added to the current list** • Displays days, months, and years, or seconds, minutes, and hours, or a combined date and time value* • Displays elapsed time* • Uses the system's current Regional Settings* *Specify a format picture in the Format cell **Specify the list items in the Format cell
Displaying Data on Visio Shapes Link Data to Shapes Pivot Diagram Custom Code Shape Data Creates structure VBA Data Graphics Hidden Data. Recordsets Add-ins Refreshable Non-refreshable Add-ons
Structured Diagrams Connectivity Containment Order Associations Connected To Containers Lists Callouts Glued To Categories Directional Zero to many
Importing Linked Data. Connection and Data. Recordsets • Visio 15. 0 Type Lib • Add, Add. From. Connection. File, Add. From. XML UI and code links to: • Microsoft Office Excel & Access • Share. Point Services Lists (including BCS lists) • SQL Server Tables and Views (including SQL Azure) • OLEDB & ODBC Can also create link in code to : • SQL Server stored procedures • XML files
Importing Linked Data Drop. Linked. U • Objects. To. Instance() • XYs() • Data. Recordset. ID • Data. Row. IDs() • Apply. Data. Graphic. After. Link Drop. Many. Linked. U • Objects. To. Instance() • XYs() • Data. Recordset. ID • Data. Row. IDs() • Apply. Data. Graphic. After. Link. Shape. IDs() • Shape. IDs()
Refreshing Linked Data UI and code refreshing of Data. Recordset • • . Refresh. Get. All. Refresh. Conflicts. Get. Matching. Rows. For. Refresh. Conflict. Remove. Refresh. Conflict XML files can only be refreshed in code • . Refresh. Using. XML • Automation requires assigned name and file
Pivot Diagram overlaid with …
… Link Data to Shapes and Data Graphics Text Icon sets Color by Value Data bars
Run in Developer Mode § FILE Options Advanced General Run in developer mode § Extra right mouse menu option § Extra ribbon group Developer mode SDK Extras
Add smartness with the Shape. Sheet
Common Shape Sections Shape Data Hyperlinks Userdefined Cells Can be autogenerated Zero to many Hidden data Right-mouse menu Some data types Can be autogenerated Cell value changed triggers Can change data values Data graphics Most url protocols Reserved row names Call formulas or code Actions
Visio Client Programming Stack Add-ons VBA Visio Drawing Control (Active. X) Shape. Sheet, Smart Shapes Visio Engine Visio Viewer COM Add-in Full Visio Client App Data Diagramming ML VSTO Add-in Save As Web Visio Drawings Visio Object Model (COM) Extensibility Support Tools & Wizards Visio SDK Sample code . NET Primary Interoperability Assemblies (PIAs)
Writing Validation Rules Target Filter Test • Document, Page or Shape • Refine targets by evaluating to True • Create issue by evaluating to False
Visio Services Architecture Visio Web Access Custom Data Providers Web Part Connections Visio JSOM Mash-Up API Visio Proxy Visio Graphics Service External Data Sources SQL XLSX SP Lists Share. Point Content Database OLEDB/ODBC vsdx/vsdm/vdw
Data Linked Diagrams Example § § SQL Server Share. Point BCS Visio XML
Visio, Share. Point and SQL Server
Schema Explorer from b. Visual Coming soon
DEMO
b. Visual Publications visiorules. com bit. ly/1 kv 3 nqo visiorules. com/2010 bit. ly/Vy 3 ITB visualizinginformation. c om bit. ly/1 g 8 ZDY 5 blog. bvisual. net bit. ly/VRMr. VS
b. Visual Visio Add-Ins, Apps and Shapes ee r F multi. Select ee r F pd. Select Multi-Language Text Document Imager Metro Icons vis. Viewer visit bvisual. net for all products ee r F Rules. Tools
b. Visual Windows + Windows Phone Apps The Visio 2010 MVP Sessions e. Xplore Visio review the templates, stencils, masters and add-ons Windows Store bit. ly/1 kv 3 nqo Windows Phone bit. ly/1 l. Den. Y 0 24 educational videos Windows Store bit. ly/1 n 0 NEPL Windows Phone bit. ly/1 q. Emjch
Microsoft Visio Resources Microsoft Visio Product Web Microsoft Visio Blog • bit. ly/1 STdjx. G • bit. ly/1 Jm. Hb 0 R For Microsoft Visio Developers Search for Visio MVPs • bit. ly/1 GVDh. Mc • bit. ly/1 FSbnh. Y
Thanks to our Main Sponsors:
Thank You!
- Visio sql server
- Visio 2010 updates
- Ms visio 2007
- Microsoft sql server data virtualization
- Parallel data warehouse sql server 2012
- Difference between sql and pl/sql
- Sql developer unit test
- Microsoft sql server 2005 analysis services
- Sql server ml services
- Microsoft sql server introduction
- Microsoft sql server security best practices
- Microsoft sql server 2005 management studio express
- Exam 70-464 training kit
- Sql server migration assistant for sybase
- Microsoft kerberos configuration manager for sql server
- Raspberry pi mssql server
- Microsoft sql fundamentals
- Microsoft sql compact
- Microsoft sql server security best practices
- Sqlceer
- New entry exploitation
- Trends and opportunities examples
- Recognizing opportunities and generating ideas
- Recognizing opportunities
- Marzano's high yield instructional strategies
- Recognizing opportunities and generating ideas
- Visio size and position window
- Azure sql data warehouse smp
- Microsoft official academic course microsoft word 2016
- Microsoft official academic course microsoft excel 2016
- Microsoft windows startwarren theverge
- Microsoft excel merupakan program aplikasi…
- Microsoft official academic course microsoft word 2016
- Mgf of normal distribution
- Standard generating body
- Sistem pariwisata