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 →
sql server
A Hands On Example Using SharePoint Designer, SQL Server and the Secure Store for SharePoint 2013 to Work with External Data
In a video tutorial titled Using SQL Server to interact with BCS External Data, Fabian Williams, a SharePoint Server MVP demonstrates each of the steps required to create an external content type in SharePoint 2013. The steps are taken with SharePoint Designer 2013, SQL Server, and the Secure Store. This video tutorial is included in a set of video training content titled Working with External Data in SharePoint 2013 using BCS and Workflows. The set is available for purchase for local, on premises unlimited viewing by organizations of any size. The set is also included as a course for SharePoint…
Read more →
Carefully Consider the Ramifications of Publishing an Access 2013 Database as an App to SharePoint Online Before Proceeding
As Darvish Shadravan makes clear in a video tutorial on the Access 2013 App Model, titled Access 2013 App Model, the Data Layer of the App will be converted to SQL Server. Further, the SQL Server back end will be hosted on Azure. Organizations should carefully consider the ramifications of deciding to publish an Access 2013 App to SharePoint Online, meaning the above points, before proceeding. Shadravan’s video tutorial is available to anyone with a subscription to SharePoint-Videos. This video tutorial is also included in our SP 13-307 SharePoint 2013: Enterprise Forms set of video tutorials, which can be purchased…
Read more →
Comments on Implementing SharePoint for Enterprise Business Analytics
In its most recent quarterly earnings report, for Q2 2014, Microsoft® reported a 25% year over year increase in sales of SQL Server. I take this jump in sales as an indicator of the substantial interest enterprise business, and comparably sized organizations in the public and not-for-profit sectors have in gathering highly useful Business Intelligence (BI) from their data. SharePoint 2013 includes a lot of features these organizations can implement to successfully attain their BI objectives. In a video tutorial series titled SharePoint 2013: Business Intelligence, Jason Himmelstein, a SharePoint MVP, ITPro Solution Architect, and an author of “Developing Business…
Read more →