Browsed by
Tag: PowerPivot

SQL Server 2012 SP1 is here & it’s huge for SharePoint 2013 BI

SQL Server 2012 SP1 is here & it’s huge for SharePoint 2013 BI

This is a massive deal for SharePoint 2013 BI.  Here is an excerpt from What’s New in SQL Server 2012: “Business Intelligence highlights (with SQL Server 2012 SP1, Office and SharePoint Server 2013 ) Business Intelligence highlights (with SQL Server SP1, Office and SharePoint Server 2013 Preview) are: Enable self-service BI as a natural part of users day-to-day activities in Excel 2013: Access and mash-up data from any source (PowerPivot). Documentation related to PowerPivot in Excel 2013 (http://go.microsoft.com/fwlink/p/?LinkID=255958). Stunning visualizations…

Read More Read More

Hooray, it’s a book!: “Developing Business Intelligence Apps for SharePoint”

Hooray, it’s a book!: “Developing Business Intelligence Apps for SharePoint”

Over the past year I have been spending my night’s & weekends working on a book with my co-author, Dave Feldman, and I am proud to say that we have completed our draft of “Developing Business Intelligence Apps for SharePoint”.  Through the book you will learn to create dynamic Business Intelligence solutions for SharePoint, using Microsoft Visual Studio LightSwitch, SQL Server 2012, and other tools and technologies. This hands-on book shows you how to create data-rich BI applications with SharePoint…

Read More Read More

Getting PowerPivot & Power View working in Office 2013

Getting PowerPivot & Power View working in Office 2013

One of the many exciting features of Office 2013 is that PowerPivot now comes as a part of the installation & Power View is now available in the client for Excel 2013 , rather than being an post installation add-in for PowerPivot and web resident only for PowerView.  PowerPivot is still a COM add-in, but is not more tightly integrated with the product & Power View is now a COM Add-in. I upgraded to Office 2013, removing the 2010 version,…

Read More Read More

PowerPivot & Claims Based Authentication–Is there hope in SQL 2012?

PowerPivot & Claims Based Authentication–Is there hope in SQL 2012?

I promised an update on this in my previous article and it is time to share what I have learned. The issue: As many of us have painfully found, PowerPivot v1 on a Claims Based Authentication web application is not supported in SharePoint 2010.  I had a case open with Microsoft last year that had the aspirations of rectifying that situation.  We had hoped that working with the PowerPivot team (a part of the SQL Server Product team) and the…

Read More Read More

Putting a bow on an amazing year of SharePoint

Putting a bow on an amazing year of SharePoint

Last week I had the honor of presenting “Heavy Metal PowerPivot Redux” to the San Antonio SharePoint Users Group.  My slide deck from that session can be found here: http://www.slideshare.net/SentriInc/sentris-saspug-deck-heavy-metal-power-pivot-redux The SASUGers were a great group of folks to present to and the location was tremendous.  We were hosted by Jeff Deverter at the RackSpace facility in Eastern San Antonio.  They purchased the Windsor Park Mall and have converted it into their offices.  It was completely wild experience touring a…

Read More Read More

SQL Server 2012 Release Candidate is here!

SQL Server 2012 Release Candidate is here!

We are creeping slowly toward the release of SQL Server 2012 and all of its new, fun features for SharePoint 2010!  The first Release Candidate of SQL Server 2012, known as RC0, dropped today and is publicly available for download.   Here are a some links worth checking out: Download SQL 2012 RC0 – Get the software here! SQL Server 2012 Release Candidate is now Available! – SQL Server Reporting Services Team Blog Announcing Microsoft SQL Server 2012 Release Candidate 0…

Read More Read More

SharePoint Connections Las Vegas 2011 Wrap up

SharePoint Connections Las Vegas 2011 Wrap up

I just completed my 5 sessions, 3 of which I presented with my great friend Cornelius J. van Dyk, here at SharePoint Connections Las Vegas.  While here we received several pieces of great news: 1.) O’Reilly has green lit our book “SharePoint for Business Intelligence” which will be coming out in 2012 and will revolve around how you can solve business problems using SharePoint 2010, SQL Server 2012, & Visual Studio LightSwitch technologies for Business Intelligence. 2.) We will be…

Read More Read More

SharePoint Road Trips!

SharePoint Road Trips!

With the devastating storm that has hit New Hampshire over the weekend, there is no better time for a SharePoint Road Trip to start than today!  It was so bad up here that our city postponed Halloween Trick-or-treating until next Sunday.  Here are a couple of pictures of the devastation, just from our driveway:   Here is a quick list of where you can find me over the next 2 months. I fly out to Las Vegas this evening to…

Read More Read More

SQL Server 2012 Announcements & a new Blogger

SQL Server 2012 Announcements & a new Blogger

The big news of the day in the technology world… no, not the Blackberry outage… no, not iOS 5 being released…  the big news about SQL Server Code Name: “Denali” becoming official SQL Server 2012!  Product release is slated for the first half of 2012 (not specifically Q1 as many of us had hoped) Project Crescent has been rebranded as Power View and announced that there will be a browser based version that will work on iOS & Android devices,…

Read More Read More