|
|
Business Intelligence That Can Reach the Entire Organization
|
Microsoft offers a comprehensive, integrated and easy-to-use business intelligence solution that gives people the tools they need to make better, more informed decisions. Through tight integration between the robust, proven, and scalable Microsoft SQL Server 2005 platform, Microsoft Office SharePoint Server 2007, Microsoft Office Excel 2007, and Microsoft Office PerformancePoint Server 2007, Microsoft can provide a complete Business Intelligence (BI) solution to power performance management solutions that drive business performance.
Office PerformancePoint Server 2007 is a complete and integrated performance management application that includes business scorecarding, analytics, and planning, and that enables companies to more effectively plan and manage their business. It provides all of the functionality you need for performance management in a single, integrated application that all your employees in the business, including Finance, Operations, Marketing, Sales, and Human Resources, can use to drive better business performance. This information is available to each user through personalized scorecards and dashboards or through familiar and easy-to-use Microsoft Office products on the desktop or over the Web.
|
Office SharePoint Server 2007 comes with new and advanced collaboration features, so you can interact with spreadsheets, KPIs, scorecards, reports, as well as unstructured data such as PowerPoint decks and Word documents. Using versioning, you can easily maintain control over constantly changing documents. A fully customizable search tool helps people quickly and easily search for structured and unstructured information on Web sites, in line-of-business applications, file shares, Office Outlook, and more. You can also quickly find subject matter experts using people search which finds results based on people's areas of expertise and their relationship to the end-user.
|
Office Excel has long been a favorite tool for analyzing data and gaining business insight. Excel 2007 brings new, more intuitive visualization features and tighter integration with Microsoft SQL Server 2005 and Microsoft Office SharePoint Server 2007. Now, employees can more securely access, analyze, and share information that stays connected live to the data source, Microsoft SQL Server 2005, and can pull in information from other enterprise applications. Excel Services, part of the updated Microsoft Office SharePoint Server 2007, provides new server-based Excel functionality that your employees can use to manage, consume, calculate, and share spreadsheets through a Web browser while maintaining a live connection to the data.
|
SQL Server Reporting Services is a comprehensive, server-based solution that enables the creation, management, and delivery of both traditional, paper-oriented reports and interactive, Web-based reports. An integrated part of the Microsoft business intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server with familiar and powerful Microsoft Office system applications to deliver real-time information to support daily operations and drive decisions.
|
SQL Server 2005 Analysis Services, for the first time, provides a unified and integrated view of your business data as the foundation for your traditional reporting, OLAP analysis, KPI scorecards, and data mining. By introducing a single Unified Dimensional Model (UDM), Analysis Services combines the flexibility and richness of the traditional relational reporting model with the user-friendly, powerful analytics and the superb performance of the classic OLAP model. With Proactive Caching and advanced business intelligence capabilities, Analysis Services moves into the realm of real-time analytics, while maintaining multidimensional online analytical processing (MOLAP) class performance. Major enhancements in enterprise capabilities, including scalability, manageability, and productivity, soundly position Analysis Services as the cornerstone of your BI infrastructure. Deeply integrated with SQL Server 2005 Reporting Services and with Microsoft Office, Analysis Services 2005 will extend business intelligence to every level of your organization.
|
SQL Server 2005 empowers your company by providing a security-enhanced, reliable, scalable, and productive platform for enterprise data management and business intelligence applications. SQL Server 2005 provides many new and enhanced business intelligence (BI) features designed to give you a competitive advantage. These advantages include integrating multiple data sources with Integration Services; enriching data and building complex business analytics with Analysis Services; and writing, managing, and delivering rich reports with Reporting Services. BI enhancements within SQL Server 2005 help deliver an end-to-end solution with integrated analytics including OLAP; data mining (surfaced in Excel); extract, transformation, and load (ETL) tools; data warehousing; and reporting functionality. SQL Server 2005 also offers a security-enhanced, scalable, and highly available relational database engine with improved performance and support for structured and unstructured XML data.
|
SQL Server 2005 Integration Services (SSIS) offers a redesigned and highly scalable enterprise Extract Transform and Load (ETL) platform for building high-performance data integration solutions for data warehousing. Integration Services is an enterprise data integration platform that includes Business Intelligence Development Studio, which hosts an intuitive user interface (UI) for rapidly developing SSIS packages, visual debugging, data quality, data mining, out-of-the-box high-performance transformations, and much more. As a result, you get a more holistic understanding of your business.
|
|
|
|
|
|
|
