My SQL and SharePoint Saturday additional content

I am presenting my view of using Visio to Visualize data with SQL Server and SharePoint today. The slideshow is available for viewing at https://doc.co/Q43c2m but, whilst I wait for my turn to talk, I have created a smart prism shape to demonstrate many of the smartness of shapes and the data linking features of Visio. The file can be downloaded from http://1drv.ms/1FDAZgI .

image

 

The Visio shape has a few interesting (I hope) features:

1. Drag the control handle on the left edge of the shape to alter the position of the light source origin. The ray of light will then bend according to its wavelength and the type of materials in the enclosure and prism.

image

2. The DataBar data graphics on the right lower edge will automatically display the angles of incidence, refraction and emission.

image

3. Edit the prism vertices A and B angles (the lower left and right) using the Shape Data panel. The angle at C (the top) is calculated, the graphics changes, as does the DataBar data graphics.

 

image

4. Select the enclosure and prism materials from the Shape Data panel, and the light beam angles will change, and the Text Callout data graphics will display the materials.

image

5. Select a light source and colour from the Shape Data panel, and the wavelength will be updated, along with the colour and angle of the beam through the prism.

image

6. If you select a non-visible light colour source, such as infra-red or ultra-violet, then the IconSet data graphic displays a red\white cross rather than a green\white tick.

image

7. There are three External Data recordsets, and a row can be cragged and dropped from each to change the light source and colour, prism and enclosure materials.

image

This file can be downloaded from http://1drv.ms/1FDAZgI

Enjoy!

PS I am not a physicist, so don’t shoot me if I have got the maths wrong!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

davecra.wordpress.com/

Microsoft Office 365 Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...

%d bloggers like this: