SharePoint Business Intelligence Solutions
Microsoft’s business intelligence (BI) offering has been evolving over the past few years with several products playing a role. SQL Server 2005 contains a database engine, an analysis services engine, and a report services engine, while Excel 2007 has been enhanced to support up to 2 million rows of data. Other products such as PerformancePoint Server 2007 and recently acquired ProClarity offer scorecarding and analytics. All in all, it is an offering that often feels cobbled together out of available pieces. Worst of all, there has never been a single centralized view of BI data in the Microsoft world. Excel spreadsheets might be e-mailed to users while reports are viewed through a web site and data is accessed through custom applications.
KeywordsData Warehouse Excel Spreadsheet Business Intelligence Analysis Service Fact Table
Unable to display preview. Download preview PDF.