[Translate to English:] Microsoft Business Intelligence Architektur
The memory blocks in the diagram represent the now well-established in-memory technology. Its two most prominent features are:
- The enormous speed at which data can be not only read but also calculated, analyzed and written.
- The extremely high compression of the data in memory. The compression factor between the "relational" data base and the "in-memory" data at an average of 1:10. That is 10 terabytes of data in the relational in-memory database consume just one terabyte.
Today, the in-memory technology is an integral part of the Microsoft SQL Server, and the system architect can choose the best technology for each of the planned system.
From many did not notice, Microsoft Excel has the "guerrilla solution for the department" has become one of the most powerful front-ends in the BI environment at all. Today, Excel 2010, addressed both in a position to access relational and multidimensional databases, as well as the in-memory technology. So to sum it the perfect "self-service store" for the department, as expressed in the new slogan "self-service BI."
The term "self-service BI" very aptly summarizes what matters:
- Easy access to all necessary information with SQL Server 2012, and in-memory technology.
- Use tools for rapid compilation of data with Microsoft Excel and PowerPivot, and for the creation of dashboards on the Web, the new Microsoft PowerView.
- Rapid publication and distribution with advanced Excel functionality, and Microsoft SharePoint.
In the graphic PowerPivot is seen as so-called Excel add-in. An Excel add-in integrates after installing completely in Microsoft Excel. It is in the menu bar has its own tab, in the now, all additional functions. Put simply - - PowerPivot, the freely downloadable from the Web Excel add-in opens for the "in-memory analysis" with an empty data container in which compiles the users from virtually any data source "his" data base, which are then analyze Excel board tools to build attractive reports from it, and even to publish in Microsoft SharePoint.
The interface from the "self-service BI" to "BI-Team" is also enshrined in Excel 2010. The completed report is not stored locally, but "sent" on the appropriate menu item to Microsoft SharePoint, it is published with a few clicks and is available to any user who has the necessary access rights available - regardless of whether it has a suitable Excel version has on his computer or not, because SharePoint has its own "Excel Services", on the report can be downloaded in the browser and operated. A key advantage must, nevertheless the IT manager so not have to worry about the local infrastructure and the release version of Microsoft Office for "its users".
By posting on SharePoint and the data sources and their connections from the local users are automatically world "moved" in the team area of ??SharePoint. If necessary, the reports from the web can also re-open the local Excel. The data source is still SharePoint with SQL Server.