Office Zealot

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 ...

I’ve always had a soft-spot for budgeting/forecasting applications. Show me a nice tight revenue/expense cube, a decent Excel-based client, and interactive browser-based reporting capabilities and I’ll show you a company with an efficient forecasting process. Well, I’ll show you a company with the capability to have an efficient ...