Office Zealot

“You know what would be really cool?  We could add scorecards and dashboards to our SharePoint environment so executives can get direct access to reporting and analytics.”  Oh, if I only had a dollar for every time I have heard that! Business Intelligence is a core component of MOSS.  SharePoint is a very good medium for ...

One of the cool things about having Excel Services in your toolbox is that you are able to deliver some very powerful ad hoc reporting against Analysis Services data.  Do this in a single server virtual environment and all is pretty simple and straightforward.  Try it in actual (production) distributed environment and you are bound ...

Welcome back to part 2 of my blog on Database-Driven Excel Charting in SharePoint. If you followed the steps from the first part of this blog, you should have an Excel 2007 workbook with a pivot table calling a stored procedure in SQL Server. In this blog, we'll publish this workbook to Excel and configure SharePoint to allow the workbook to ...

Hello everyone. I'm Gus Collazo, a member of the speakTECH Data Services team. Welcome to my first blog entry for speakTECH. In the future I'll focus my blog entries primarily on SQL Server 2008, PerformancePoint Server, and SharePoint. For my first entry though, since I'm working on a project focused on Excel Services, I'll focus on creating ...

Take one cup Google Docs, one cup Microsoft Excel and add a dash of programming. Observe.

I was more than a little bummed yesterday (annoyed is more like it) when I found out why I was missing the Excel Services option on the Publish menu in Excel. Excel 2007 Enterprise Publish Menu Little did I realize that all of the work I’ve been doing to date inside a Virtual PC image used Office Enterprise edition. I didn’t even think twice ...

Excel Services Options - parameters

Excel Services Options

A workbook viewed using Excel Services

A workbook viewed using Excel Services.