The much anticipated and eagerly awaited Analysis Services 2005 Performance Guide has been released and is available on the Microsoft download site.

Reporting in Team System is handled by SQL Server 2005 Reporting Services. As such, team members get to enjoy (and are restricted-by) the built-in report rendering extensions (CSV, Excel, HTML, Image, MHTML, PDF, and XML). What's missing from this list is the Microsoft Word DOC format and a richer Microsoft Excel XLS format.

This is where a product called OfficeWriter comes in. It enables you to use Excel or Word to create templates utilizing data markers and merge fields for databinding sections of the document to the various Team Foundation Server data items. After a quick configuration of Reporting Services, your reports can generate documents/spreadsheets based on these templates without the need for Microsoft Office on the server. There's also an integration with Reporting Services that will let you create these documents without any coding at all. Users will design their RDL reports using Excel or Word, without the need for Visual Studio or SQL Report Builder.

Check out their latest version of OfficeWrite (v3.6) at http://officewriter.softartisans.com

Microsoft recently announced Microsoft Office PerformancePoint Server 2007. I believe this product was a result of the acquisition of Proclarity (Boise, ID) and a combination SQL Server 2005 BI, and Microsoft Excel.

Read the announcement from InfoWorld (Yahoo).

Check out our article on Data Mining in the October issue of Business IQ Magazine. You'll need to download the October issue and read it for yourself! It's about 5mb.