Microsoft has a large number of business intelligence (BI) applications with BI features included in it. All of them are important to understand so that one can easily choose the best one in terms of working. The business intelligence tools are usually based on the problems and difficulties that one is trying to overcome.
The routine business activities are related to the information in three regions of business intelligence: personal, team, and organizational. There is sometimes overlapping between these areas. Let us take an example: an employee of a firm may use Microsoft Excel 2010 in Microsoft SharePoint Server 2010. This gives employee the authority to make business decisions. PerformancePoint Services uses Excel and Excel Services and hence it integrates its BI tools to generate and forward a dashboard, which should show the elements of team business intelligence. According to the default design, all Microsoft business intelligence products are interoperating. This allows people inside the firm to move across the continuum team and organization and all the products are gathered to work together.
The following image is showing tools from SQL Server and SharePoint Server to elaborate the corresponding categories in which the tool is actually used.
Note: The above image is showing the products from the Microsoft Office, SharePoint 2010 products, and SQL Server.
SQL Server gives you data infrastructure for secure and trusted form of data. SharePoint Server is also used with SQL Server reporting and is capable of showing the business intelligence data in different new ways. To get more knowledge about how SQL Server is compatible with BI in SharePoint 2010, you can refer to the keywords SQL Server in a SharePoint environment and SQL Server (SharePoint Foundation 2010).
Comments