#Visio Automation for IT Design & Operations – London, 25th April 2018

I am pleased to announce that I will be co-hosting a free event at the new Microsoft Reactor in Shoreditch on 25th April, aimed at showcasing Visio automation for IT design & operations. You can find more details and sign up here.

Using #Visio and #PowerBI with #GraphDatabase in #SQLServer

I went to a very interesting inaugural meeting of the South East UK Power BI Group last week. Whilst the presentation by Dr. Subramani Paramasivam was impressive for its ambition, it was the presentation by Andrew Fryer of Microsoft that particularly intrigued me. He introduced us to the world of Graph Databases, such as Neo4J and CosmosDB, but also demonstrated SQL Server 2017’s new Graph table types, called Node and Edge.  He used the latter because solution because he could use example in Power BI using the Force-Directed visual. Well, this SQL Server feature was new to me, and so I was inspired to see if I could use my favourite tool, Visio, to input data into a graph database, and to selectively display parts.

This slideshow requires JavaScript.

Read the rest of this entry »

#PowerApps in #PowerBI with #Visio!!!

I am very excited to see that the preview for PowerApps in PowerBI has been released ( see Announcing availability of PowerApps custom visual for Power BI (preview) ). I saw this demonstrated months ago, and have been waiting impatiently ever since. Every time I have embedded a Visio diagram into PowerBI, I have wanted to display the selected shape data in a detail view … and now I can!

I cannot yet create a PowerBI report with the embedded PowerApps visual for consumption by the whole internet, but it should still solve many scenarios for organisations. I quickly added the new PowerApps visual to my example synchronised Org Chart and Desk Layout from my previous article ( #Visio in #PowerBI for viewing personnel hierarchies and locations ) , and recorded a simple selection in the following gif:

Selecting a Person.gif

Read the rest of this entry »

#Visio in #PowerBI for viewing personnel hierarchies and locations

My last article, Aliasing Data Columns for #Visio Organization Chart Wizard , mentioned the slight anomalies in the default Shape Data rows for the Organization Chart shapes and the Resources / Person shape. This prompted me to create an alternative view of the same data that can be linked to the Person shapes on a floor plan, and then to use the preview Visio Custom Visual in Power BI to display both views of personnel synchronised by the same data. This demonstrates how easy it is to create an effective dashboard for locating personnel locations and their position within an organisational hierarchy at the same time!

This slideshow requires JavaScript.

View the Power BI report online : Org Chart and Personnel Locations in PowerBI

Read the rest of this entry »

Create & edit #Visio diagrams in browser

Visio Online is now generally available! You can read more about it here , but what does it mean? Well, if you have Visio Pro for Office 365 (like me) then you should find that it is now converted to Visio Online Plan 2, which includes Visio Online as well. Visio Online Plan 1 does not include Visio Pro for Office 365, but these users can view all Visio documents, and can also create and edit simple ones (see the FAQ for more details).

Selecting a New / Visio Drawing in my Office 365 tenant now opens a Basic Diagram in Visio Online. I can then choose to create a diagram from a different template using File / New.

This slideshow requires JavaScript.

Read the rest of this entry »

Countdown to #MSIgnite for #Visio sessions

Only a couple of days to go before Microsoft Ignite conference starts here in Orlando. Yes, I am here a week early to “acclimatize” 🙂 , but I have not been idle since I will be presenting in three sessions!

This slideshow requires JavaScript.

Read the rest of this entry »

Adding clicks to infographics with #Visio visual for #PowerBI

Office 365 is a truly remarkable success story, but it is often difficult to understand what each of the parts actually do, or what it is actually in each edition. Microsoft are always adding applications and services to the various editions, or retiring ones that have been superseded. If I can’t see it, I can’t understand it, so I was very interested to see the Periodic Table of Office 365 infographic created by Matt Wade, a SharePoint guru who keeps an eye on these changes ( see http://icsh.pt/O365Table ). It really helps in comprehending the current Office 365 applications and their purpose. Indeed, I have seen his graphic go through many iterations over the last few months, and it will continue to change. However, it was not clickable, and I am a visual data guy, so I contacted him, and offered to integrate his infographic into a Power BI now that the Visio custom visual is available. I then found out that there are several different language versions of his infographic out there on the web, translated by other SharePoint professionals in his network.

This slideshow requires JavaScript.

Read the rest of this entry »

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

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

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

Smart graphics for visual people

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...