sql saturday and share point saturday cambridge 2015 - david parker - visio
TRANSCRIPT
SQLSaturday 323 – Paris 2014
Visualising SQL and SharePoint data with Microsoft Visio Pro.
David ParkerMicrosoft MVP (Visio)[email protected]
@VisioRules
https://doc.co/Q43c2mhttp://bit.ly/1KhFyCR
This deck :Blog :
SQLSaturday 323 – Paris 2014
Thanks to our Main Sponsors:
SQLSaturday 323 – Paris 2014
bVisual profile
Visio consultant trainerauthor
David Parker 11 years MVP
UK based global reachbVisual ltd
Visio consultancy training
proof of concepts
bVisual ltd founded in 1998 by David Parker
Microsoft Partner 15 years
SQLSaturday 323 – Paris 2014
bVisual typical client solutions
Network Equipment Design
Nexans Building Cabling Solutions
National Physical
Laboratory
Project Planning Roadmaps
Rail Accident Investigation Board
Rail Accident Fault Analysis
Trees
Perenco
Personnel Locations + Asset
Tracking
SQLSaturday 323 – Paris 2014
bVisual consultancy and training
SQLSaturday 323 – Paris 2014
Microsoft Visio 2013 editionsVisio Standard 2013
Easily create versatile diagrams using a rich set of new and updated shapes and stencils.
Visio Professional 2013
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 Pro for Office 365
SQLSaturday 323 – Paris 2014
Visio for everyone
Built on
IT Management
Software Development
IT
Facility Management
Quality Management
Operations
Work Flow Design
Process Modeling
Business
Mockup
Planning
Mind mapping
Dashboard
Everyone
Organizational Management
HR
Layout Design
SQLSaturday 323 – Paris 2014
sql-sales-01
IP Address 10.0.1.104
Memory 32 GB
CPU 1.60 Ghz
Windows Server 2008 R2
L
S
XL
Text CalloutsLabel Value Label Value
Value Label Value
Icon Sets
Data Bars
32
15
32
57
50 30 20
Color By Value
Key visualisation features
Surface Shape Data values• Optionally from External Data
via Link
Refreshable shape geometry• Icon Sets• Text Callouts• Data Bars• Color by Value
Data Graphics
All Visio shapes are evaluated for rendering
Build shapes that respond to data changes• Drive geometry, formatting,
text, etc via the ShapeSheet
Shape Behavior
SQLSaturday 323 – Paris 2014
Supported refreshable data sourcesSupports Kerberos, SSS & Unattended Authentication
Native SQL Azure support
Native External Lists support via BCS – WCF, .NET, OData
SharePoint 2013
On-Premises
Office 365 is a multi-tenant environment
Native External Lists support via BCS
Office 365
Custom
ODBC
OLEDB
SP Lists
ExcelServices
BCS
SQLODC
SP Lists
ExcelServices
BCS
SQLSaturday 323 – Paris 2014
Linking Data to Shapes
SQL
SQLSaturday 323 – Paris 2014
How text or graphics are updated by data
Change Value in Data Source
Refresh DataRecordse
t
Linked Shape Data value
updatesRelated cell
value updates
Displayed text or graphic updates
SQLSaturday 323 – Paris 2014
Shape Data types•Up to 32k characters0 - String•Users can select only one item from the list**1 - Fixed list•Number. Includes date, time, duration, and currency values as well as scalars, dimensions, and angles*2 - Number•Displays FALSE and TRUE as items users can select from a drop-down list box3 - Boolean•Users can select a list item or enter a new item that is added to the current list**4 - Variable list•Displays days, months, and years, or seconds, minutes, and hours, or a combined date and time value*5 - Date time•Displays elapsed time*6 - Duration•Uses the system's current Regional Settings*7 - Currency
*Specify a format picture in the Format cell**Specify the list items in the Format cell
SQLSaturday 323 – Paris 2014
Displaying Data on Visio Shapes
Link Data to Shapes
Shape Data
Data Graphics
Refreshable
Pivot Diagram
Creates structure
Hidden DataRecordsets
Non-refreshable
Custom Code
VBA
Add-ins
Add-ons
SQLSaturday 323 – Paris 2014
Structured Diagrams
Connectivity
Connected To
Glued To
Containment
Containers
Categories
Order
Lists
Directional
Associations
Callouts
Zero to many
SQLSaturday 323 – Paris 2014
Pivot Diagram overlaid with …
SQLSaturday 323 – Paris 2014
… Link Data to Shapes and Data Graphics
Data bars
Text
Icon sets
Color by Value
SQLSaturday 323 – Paris 2014
Run in Developer Mode
• FILE \ Options \ Advanced \ General \ Run in developer mode• Extra right mouse menu option• Extra ribbon group
Developer mode SDK Extras
SQLSaturday 323 – Paris 2014
Add smartness with the ShapeSheet
SQLSaturday 323 – Paris 2014
Common ShapeSheet Sections
Shape Data
Can be auto-generated
Some data types
Data graphics
Hyperlinks
Zero to many
Can be auto-generated
Most url protocols
User-defined Cells
Hidden data
Cell value changed triggers
Reserved row names
Actions
Right-mouse menu
Can change data values
Call formulas or code
SQLSaturday 323 – Paris 2014
Visio Client Programming Stack
Visio
Vie
wer
Visio
Draw
ings
Data
Dia
gram
min
gM
L
SaveAs
Web
Visio Engine
Visio
SDK
Tool
s & W
izard
sSa
mpl
e co
de
ShapeSheet, Smart Shapes
.NET Primary Interoperability Assemblies (PIAs)
Visio Object Model (COM)
Visio DrawingControl (ActiveX)
Full Visio
Client App
Extensibility Support
VSTO Add-in
COM Add-in
Add-ons
VBA
SQLSaturday 323 – Paris 2014
Writing Validation Rules
Target• Document, Page
or Shape
Filter• Refine targets by
evaluating to True
Test• Create issue by
evaluating to False
SQLSaturday 323 – Paris 2014
Web
Fro
nt
End
App.
Serv er
Back
en dVisio Services Architecture
Visio Web Access
Custom Data Providers
Visio JSOM Mash-Up API
Web Part Connections
Visio Proxy
Visio Graphics Service
vsdx/vsdm/vdwSharePoint Content
DatabaseExternal Data Sources
SQL OLEDB/ODBCXLSX SP Lists
SQLSaturday 323 – Paris 2014
Data Linked Diagrams Example• SQL Server• SharePoint• BCS• Visio
Process DiagramsBCS
Shar
ePoin
t
Process MapVisio
XML
PCF Master
SQL S
erve
r
SQLSaturday 323 – Paris 2014
Visio, SharePoint and SQL Server
Custom template & shapesLinked data
Semi-automatic diagramming & manual enhancements
Validate, control version & publish
Search & discover from anywhere
SQLSaturday 323 – Paris 2014
Schema Explorer from bVisualComing
soon
Visio add-in to provide External Data schema diagramming
SQLSaturday 323 – Paris 2014
DataView from bVisualComing
soon
Visio add-in to provide enhanced viewing of External Data
SQLSaturday 323 – Paris 2014
visViewer from bVisualAlready
available
Enable Office desktop users to view, search and export graphics and data from Visio
files WITHOUT Visio
Office Mix of visViewer
SQLSaturday 323 – Paris 2014
Demo
SQLSaturday 323 – Paris 2014
bVisual Publications
bit.ly/VRMrVS
blog.bvisual.net
bit.ly/1g8ZDY5visualizinginformation.com
visiorules.combit.ly/1kv3nqo
visiorules.com/2010
bit.ly/Vy3ITB
SQLSaturday 323 – Paris 2014
bVisual Visio Add-Ins, Apps and Shapes
visit bvisual.net for all products
Document Imager
RulesTools
multiSelect
Metro Icons
pdSelect
visViewer
Multi-Language Text
Free
Free
Free
SQLSaturday 323 – Paris 2014
bVisual Windows + Windows Phone Apps
Windows Store
bit.ly/1kv3nqo
Windows Store
bit.ly/1n0NEPL
eXplore Visioreview the templates, stencils, masters and add-ons
Windows Phone
bit.ly/1lDenY0
The Visio 2010 MVP Sessions 24 educational videos
Windows Phone
bit.ly/1qEmjch
SQLSaturday 323 – Paris 2014
Microsoft Visio ResourcesMicrosoft Visio Product Web•bit.ly/1STdjxG
Microsoft Visio Blog•bit.ly/1JmHb0R
For Microsoft Visio Developers•bit.ly/1GVDhMc
Search for Visio MVPs•bit.ly/1FSbnhY
SQLSaturday 323 – Paris 2014
http://1drv.ms/1FDAZgI
David ParkerMicrosoft MVP (Visio)[email protected]
@VisioRules
https://doc.co/Q43c2mhttp://bit.ly/1KhFyCR
This deck :Blog :