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.[Read more…] about Adding clicks to infographics with Visio visual for PowerBI
Yesterday, I wrote about using #MSFlow with #Visio ( Updating data sources from #Visio using #MSFlow … easily! ), so it is fitting to announce that the Visio custom visual for PowerBI is now available from the Microsoft store, and that it works with PowerBI Desktop! This means that everyone can make use of my guidelines in my other recent article at Previewing the #Visio Custom Visual in #PowerBI !
[Read more…] about Visio custom visual preview for PowerBI available for all!
I used the small sample file that I created for my earlier blog, but it does demonsrate how powerful these new capabilities are. The possibilities are really exciting!
By the way, the text in my Visio shapes above were not Data Graphic Text callouts, because, if they were, they would have been supressed automatically.
The support of the Visio custom visual in PowerBI desktop enables data modelling whilst testing with Visio diagrams. This is so useful!
Check out the Microsoft announcements at Office Blog post and on Facebook and Twitter.
It is time to talk about the new Visio custom visual for PowerBI. You may have read about it at Visio Power BI example and Add Visio visualizations to Power BI reports, but I wanted to add my findings. First, it is great to see this feature, but it is not yet the finished article. However, I hope I can show that it can be an extremely useful addition to the business intelligence toolset from Microsoft. I think that the existing Link Data to Shapes and Data Graphics features in Visio desktop are considered to be Operational Intelligence capabilities, whereas this new custom visual for PowerBI is definitely Business Intelligence. This is a different discipline, and I have been developing some guidelines for good practice when using Visio with PowerBI. In this article, I will demonstrate how I created a PowerBI dashboard using graphics and data from last years Microsoft Ignite conference.
Let me set the expectations because I am working with a preview of the Visio custom visual.[Read more…] about Previewing the Visio Custom Visual in PowerBI
Microsoft are about to announce sweeping changes to their worldwide software sales channels as they continue to emphasise that the future is in the cloud. We expect that this will mean a restructuring away from traditional desktop application sales. Visio has been one of these desktop applications for many years, and has a large, and mostly loyal, following. We Visio developers have been excited by the large number of advances in Visio features released over the past year or so, but has it moved quickly enough towards the cloud to save it from the deep cuts that are threatened? I hope so.
I recently created a short survey about learning Visio (A short survey about learning #Visio ) and these are the results that I have had so far:
Well, MS Ignite is over for another year. I planned to visit loads of sessions, but the reality was that I spent many hours on the Visio booth. Fortunately, many of them were recorded, including ours, but I don’t have time to watch over 700 videos! So, I looked through them all and picked out 50-odd, and used Get & Transform in Excel again to create suitable queries to link to Visio.
The more I use PowerQuery, the more I like it. I was able to extract the unique values in the Personas, Tags, and Products columns which each contained comma separated lists. I data-linked these values to large circles on different pages, and data-linked the Sessions to Watch to hexagonal shapes. I then wrote a little VBA code to link the circles to the hexagons with data-linked connectors. Data Graphics was applied to all shapes, including the connectors, and a legend added. Each of the Session hexagons have an automatically created hyperlink to the On-Demand Video. I used a standard radial page layout so that I had minimal manual movement shapes.
The end result is a visual dashboard by Persona, Tag and Product to open the videos for the sessions I want to watch.
I watched a presentation today about some of the new features of Power Map. I was impressed, and the surprising thing is that the data does not have to be location data to get a 3D visualisation. All that is needed is to establish a co-ordinate system and any data can be transformed … and it can even have a time dimension!
It can do some visualisations that are just not possible with Visio, but I could see that Visio could be used to feed custom maps to Power Map with base layers and a co-ordinate system.
Cool custom maps : https://blogs.office.com/2014/10/08/6-cool-ways-use-custom-maps/
I will play some more with this soon….