Understanding how Power Pivot and Power Query contribute to a successful Business Intelligence project built with Power BI

For readers familiar with Microsoft’s Power BI suite of tools for Excel, but not clear as to how Power Pivot, and Power Query interact within a Power BI project, a webcast from TechEd Europe 2014, titled Overview of Business Intelligence in Office and Office 265 may be worth watching. The webcast is led by Peter Myers, a subject matter expert on the topic, and runs about 1.25 hours. Myers identifies the target user for the Power BI suite: a business analyst from a Line of Business (LoB) unit within an organization. He explains how research has shown analysts are the…
Read more →

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 →

The agenda at TechEd Europe 2014 included a presentation on dynamic diagrams and SharePoint on-premises or online

Visio is usually seen as the successor to SharePoint Designer. The common understanding is Visio represents the “next generation” of workflow design tools. But it’s very important not to forget Visio is, if nothing else, a diagram tool. During Microsoft’s TechEd Europe 2014 event, last month, Ian White, EPM and Visio Technical Lead at Microsoft in the UK, led an hour presentation titled Interactive Visual Dashboard Solutions with Visio Services. It’s worth noting the venue for displaying these “visual dashboard solutions”, and providing dynamic data for them, is SharePoint on-premises, or SharePoint Online, Office 365. White points out how some…
Read more →

Just how does Power BI bolt together with Office 365?

In a webcast titled Power BI for Office 365 Overview, Michael Tejedor, a Senior Product Marketing Manager at Microsoft provided his audience with some information about this data analytics tool, including: design features for business analysts a demonstration of likely benefits for organizations implementing Power BI today and a preview of new features to be added, along with a debut of Microsoft’s new web site:

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 →

Using Power BI with SharePoint Online, Office 365

Organizations looking to maximize the impact of the data visualization features of MS Excel 2013 should think about leveraging team sites in SharePoint Online, Office 365, to provide users with a unique method of consuming this information. An Office 365 enterprise subscription is required. The Power BI Sites app can be added to any Office 365, Enterprise subscription registered for Power BI. With the Power BI Sites app, Any Excel Report (up to a maximum size of 250 MBs) can be viewed in any browser supported by SharePoint Online, without an Excel client. The first step is to use the…
Read more →

Is Power BI the ‘Must Have’ Feature Organizations need to Hasten their Pace of Signing Up for SharePoint Online, Office 365 Computing?

Microsoft’s promotional materials for Office 365 include the phrase ‘self service business intelligence’. This phrase was actually coined by Forrester Research, for The Forrester Wave™: Self-Service Business Intelligence Platforms, Q2 2012. To provide a summary of this concept, one result of the consumerization of IT and the Bring Your Own Device (BYOD) phenomena of the last few years, for business computing, is a burning need for business intelligence solutions within the technical reach of Line of Business (LoB) groups. The rationale for these solutions is simple. Enterprise IT can no longer be looked to provide all of the business intelligence…
Read more →

Transform On Premises SharePoint Into a Business Critical Solution with Curated Sets of Video Training Content

Microsoft’s Business Critical SharePoint web site presents a series of high value solutions presented along with supporting success stories. SharePoint stakeholders may benefit from reviewing some of the information on this web site before commencing work on an implementation plan for SharePoint. Many of the examples presented illustrate how valuable features of SharePoint, for example, workflows, can be used to expose data from LoB applications to: reduce duplication of efforts and to minimize the risk of overlapping applications streamline procedures and ensure personnel involvement is as efficient as possible. This method lowers operating costs while, at the same time, the…
Read more →

1 2 3