business intelligence tools microsoft
What kind of reporting tools does Microsoft offer for business intelligence activities?
With regards processing the data, you will need SQL Server 2000 or 2005.
The following are available for analysis of the data.
For a very high level view of data KPI(key product indicators) you can get balanced scorecard (aka business scorecard). This gives a very simple ‘Fisher Price’ view of the data. e.g. a traffic light showing red to indicate a low share price.
To give more detail use Reporting Services, this allows users to create reports in a variety of formats (PDF, Excel, HTML, XML, CSV and also graphical) by simple parameter selection (drop downs or text entry) they can also subscribe to reports by email.
For a higher level of anaylsis you will need to use Pivot Tables (either in Excel or as part of the Office Web Components in Sharepoint) this allows you to slice and dice the data in cubes on the OLAP server. (You create cubes using Analysis Services – part of SQL Server, these have lots of precalculations of what you might want to know, precalculated to give better performance speedwise)
Finally you can also use Data Mining tools (in Analysis Services, much improved in SQL Server 2005) to spot trends and perform incredibly detailed statistical analysis of the data.
Most people tend to use something like ProClarity or MicroStrategy products in conjunction with the above Microsoft products, they allow easier and more powerful control of reporting functions for the users.
PushBI Desktop for Microsoft Windows – Personalized Business Intelligence Solution
|
|
Delivering Business Intelligence with Microsoft SQL Server 2008 (Paperback) $28.86 Maximize the Business Intelligence Tools in Microsoft SQL Server 2008Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 |
|
|
Professional Business Intelligence With Powerpivot for Microsoft Office 2010 (Paperback) $26.47 SQL Server “Gemini” brings the power of Microsoft`s business intelligence tools to the desktop Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you`re a busi… |
|
|
Business Intelligence With Microsoft Office Performancepoint Server 2007 $33.2 Deliver BI Solutions with Microsoft Office PerformancePoint Server 2007Maximize the powerful BI tools available in PerformancePoint 2007 with help from this practical guide. You will learn how to collect and store data, monit… |
|
|
Delivering Business Intelligence With Microsoft SQL Server Xxxx (Paperback) $28.91 Master the business intelligence tools in the latest release of Microsoft SQL ServerFully updated for the new version of SQL Server, Delivering Business Intelligence with Microsoft SQL Server XXXX, Third Edition is a complete BI cour… |
|
|
Knight`s Microsoft Business Intelligence 24-hour Trainer (Paperback) $24.06 Provides information on using the Microsoft business information tools to perform analysis and reporting using Excel and SharePoint. |
|
|
Microsoft SQL Server 2008 Reporting Services (Paperback) $28.25 The bestselling guide to Microsoft's number-one Business Intelligence tool–updated for the latest releaseThis hands-on guide explains how to create, manage, and deliver traditional and interacti… |
|
|
Microsoft SQL Server 2008 Analysis Services Unleashed (Paperback) $34.98 As the foundation of the Microsoft Business Intelligence Strategy, Microsoft SQL Server 2008 Analysis Services provides users with faster access to data and even more tools for managing and analyzing data across multidimensional … |
