Data Visualization is a popular requirement for Office 365 computing built on Business Intelligence components

Microsoft’s TechEd Europe 2014 event, which was held in October, 2014, included a presentation on the Business Intelligence (BI) opportunities presented by Microsoft Office and Office 365 products. The title of this presentation, which is now available for public viewing as a webcast on Microsoft’s MSDN Channel 9 web site, is Overview of Business Intelligence in Office and Office 365. The presentation is led by Peter Myers, an expert on Microsoft databases who is based in Australia. Myers is affiliated with Bitwise, a Microsoft partner. Microsoft is not the only ISV looking to capitalize on the increasing appetite of enterprise…
Read more →

Some limitations on building dynamic diagrams with Visio Services for SharePoint 2013 on-premises and SharePoint Online, Office 365 should be kept in mind

This a second and final post on a webcast published on Microsoft’s Channel 9 web site titled Interactive Visual Dashboard Solutions with Visio Services. There are some important caveats about using Visio Services to produce data visualizations like the “interactive dashboards” Ian White presents in this presentation. Data sources are limited. Visio Service currently provides no support as of yet for OData, so linking to external data from sources like MySQL, or other non SQL Server databases otherwise accessible via the OData protocol unfortunately won’t work. As well, Data linking is only available with Visio Professional, (available online as Visio…
Read more →

A Practical, Hands On Demonstration of How to Visualize Excel 2013 Data with Power View and Store It with SharePoint Server 2013

In a short, six minute and 39 second video tutorial titled Visualize your Excel data in SharePoint using Power View, Asif Rehmani, SharePoint MVP, MCT, and CEO of SharePoint-Videos demonstrates how to transform numbers on an Excel 2013 spreadsheet into a useful visual presentation — in chart form –via the Power View feature of Excel. Once the visualization has been created, Asif demonstrates how to add it to SharePoint server. While all of this may seem trivial, especially given the very short length of the video tutorial, it is, unfortunately, not. This writer attempted to transform the data reposed in…
Read more →