Share Centrally Managed, Powerful Spreadsheets | MSBI Tutorial pdf

Share Centrally Managed, Powerful Spreadsheets

Microsoft Office Excel has long been a favorite tool for analyzing multi-dimensional data and gaining business insight to make more informed decisions. Office Excel 2007 brings new, more intuitive visualization features and tighter integration with the portal and database, resulting in employees being able to more securely access, analyze, and share information from data warehouses and enterprise applications.

Manage Data More Effectively
In Office Excel 2007, you can more easily discern trends from complex data, view metadata stored in SQL Server 2005 Analysis Services from within the Excel report itself, quickly add and move dimensions presented in business terms, and report from multiple data sources within a single Excel report. As a result, you can now present your analysis with greater clarity and confidence.
=> A new results-oriented user interface presents the right tools when you need them most, exposing all the rich features of Office Excel 2007.
=> Increased spreadsheet row and column capacity enables you to import and work with up to 1 million rows and 16,000 columns of data.
=> Multi-threaded chipsets provide faster calculations by running formulas on multiple processors simultaneously.
=> Formulae authoring experience, including a resizable formulae bar and context-based Formulae AutoComplete that exposes column headings (as business terms) as a drop-down menu while you write the formulae, helps you write the proper formulae syntax the first time, every time.
=> Sorting and filtering helps you quickly find the information you need. Office Excel 2007 supports up to 64 levels to sort data, including the ability to sort by color.
=> Enhanced PivotTable® views and PivotChart views use data fields to quickly explore and analyze your data.
=> Simplified conditional formatting such as heat maps, colored icons, and arrows help you discover trends, exceptions, and patterns in your information.
=> Full support for SQL Server Analysis Services enables you to easily connect to a central metadata repository in SQL Server Analysis Services, quickly extract information from your OLAP cube, and expose it within Office Excel 2007, providing context for the data being analyzed.
=> Improved charting tools help you easily summarize your analysis results in professional-looking charts.