Microsoft Business Intelligence is a complete and integrated offering that supports the entire organization. It is a full-featured suite of server, client, and developer products that thoroughly integrates with Microsoft Office. This thereby provides easy to use information directly where individuals work, collaborate, and make decisions.
With SQL Server 2005 and the release of the 2007 Microsoft Office system, along with the capabilities found in PerformancePoint Server 2007, we cover the spectrum of performance management applications, end user tools, and the BI platform. This provides a complete BI stack. Thus we are not dependent upon BI partners.
However, we provide open standards so that through partnering, we are also able to offer a wider selection of premiere solutions, thus making us a leader in the BI space. Other vendors such as IBM must partner with ISVs such as Hyperion to deliver a solution that is not equivalent to Microsoft’s offering. Overall, our offering is designed to support a leading solution and the lowest total cost of ownership.
Microsoft has a great story on Analytics with SQL Server Analysis services. Microsoft SQL Server 2005 Analysis Services (SSAS) delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting you design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases. For data mining applications, Analysis Services lets you design, create, and visualize data mining models that are constructed from other data sources by using a wide variety of industry-standard data mining algorithms.
Analysis Services provides a user-friendly model where you can provide understandable business names, specify relationships between fields (Product Category – Product Subcategory – Product) so that it is possible for business users to design their own reports without help from IT.
Analysis Services offers tools for personalizing individual users’ reporting experience by only showing them the data that they care about and have permissions to see; in addition, Analysis Services can translate data into users’ preferred languages.
Analysis Services allows you to consolidate data from different business systems into a single analytical model. In this scenario the data in SAP and other repository but for analysis that you would like to see in the same report. With an Analysis Services model, you can do just that without needing to change the source system at all.
Leveraging Office Client (Excel 2007)
Excel 2007 provides great Analysis features and integrates with SSAS. With Pivot tables and visualization feature set, Excel 2007 is a great tool for Analysis.
Key Performance Indicators, calculations, conditional formatting, and actions are just a few examples of business logic that you can define once in Analysis Services and then expose automatically in Excel PivotTables. Part of the beauty of this is that all users see the same thing in their PivotTables because the formatting, for example, is calculated in one place – on the server.
When analyzing data in Analysis Services, all the business logic is centrally managed in one analytical model so that every user will see the same numbers, calculated using the same business logic. Any changes made to the model will immediately be available to all Excel PivotTable users when they update their report.
Performance / Dashboard:
Business score card manager or BSM along with Office 2007, MOSS 2007, SSAS, SSIS and SSRS provides a complete, robust end to end BI development environment on Microsoft stack.
Deep Insight and Good Context
ü Scorecards, reports and charts can be rapidly assembled and connected on web pages
ü Provides immediate access to analysis functionality for drilldown, filtering, sorting, and ranking
ü Insight in transactional data by drilling down through KPIs
ü Web Parts connections drive all-on-one-page interaction; Report View filters work together with Scorecard filters
Collaborative Business Management and Action
ü BSM works with MOSS 2007 for enhanced team collaboration
ü Annotations for contextual communication
ü Integration with MS Collaboration platform.
ü Personalized scorecards and views of relevant reports, tasks, project plans and notifications
ü Data-driven alerts available on Scorecard and KPIs
ü Distribution is made easy with export capabilities to Excel, PDF, HTML and TIFF formats
End User Empowerment
ü Provides business analysts the ability to build, manage and consume KPI’s and scorecards
ü Enables building comprehensive views that include charting, reports and pivot for detailed analysis
ü Provides end users the ability to add / change personal scorecard views.
ü Ability to extend BSM with advanced analysis solutions
ü Easy integration with LOB Applications
ü Partners can extend BSM using its Web Services APIs and SharePoint platform
ü BPM ISVs can extend Microsoft Office Business Scorecard Manager 2005 using it’s SharePoint platform and web services APIs to provide an end to end BPM offering
SQL Server Reporting Services is natively integrated with .NET report services and is part of whole Microsoft BI solutions. It is designed to provide one of the most comprehensive BI and reporting solutions on the market today.
Reporting Services in SQL Server 2005 provides enterprise reporting capabilities and addresses a new audience—business users who want to interact with data in an ad hoc fashion as well as create their own reports from scratch and to share them with others.
SQL Server 20005 Reporting Services has many improvements in the areas of report design, processing, and interactivity. There are also improvements to performance and scalability.
SSRS provides enhanced integration with other components within SQL Server 2005 including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Management Studio. Reporting Services also has tighter integration with Microsoft SharePoint Products and Technologies, enabling reports to easily participate in corporate portal scenarios.
Reporting Services provides unparalleled reporting integration into the Visual Studio development environment. In addition, freely redistributable Microsoft Windows and ASP.NET controls make it easy to embed reporting in both server-based and client-based applications.
SQL Server 2005 Reporting Services includes Report Builder, a new ad hoc reporting tool that enables business users to create their own reports and explore corporate data. Report Builder incorporates a user-friendly business query model that enables users to build reports without deep technical understanding of the underlying data sources.
SQL 2005 is an integrated platform to create Data Warehousing applications, data mining tools are consolidated into two working environments in SQL 2005, Business Intelligence Development Studio and SQL Server Management Studio.
SQL Server Integration Services (SSIS) goes beyond being an ETL tool not only in terms of enabling nontraditional scenarios, but also in being a true platform for data integration. SSIS is part of the SQL Server Business Intelligence (BI) platform which enables the development of end-to-end BI applications.
Microsoft Office SharePoint Server 2007
SharePoint server deliver centralized access to information. SharePoint portal server makes it easy to create live, interactive business intelligence (BI) portals that assemble and display business-critical information from disparate sources, using integrated BI capabilities such as dashboards, Web Parts, scorecards, key performance indicators (KPIs), and business data connectivity technologies. Centralized Report Center sites give users a single place for locating the latest reports, spreadsheets, or KPIs.
ü Excel Services and Reporting Services in the portal
ü Report Center: out-of-the-box BI portal experience
ü Dashboards, KPIs, and Report Libraries
ü Integrated with Portal, Collaboration, Enterprise Content Management and Workflow functionality
Excel Services runs spreadsheets and performs calculations on a Web server, delivering results to users through a browser and to other applications through a Web services API.
Performance Point Server: