Exploring Excel 2010
The first significant enhancement Microsoft has made in Excel is a concerted effort to improve the end user client SSAS experience by improving the pivot table interface. The primary focus is to make pivot tables and charts more intuitive to set up and use, so that more of your end users will be able to quickly become productive using pivot tables.
The Excel Ribbon
Let's begin by taking a look at the new menu system. This menu redesign is called the ribbon. Figure 11–1 shows the first half of the Excel ribbon for the Data tab. You'll notice that this tab contains a group that allows you to manage connections to any data source to which you are making a connection. These connections include connecting from Excel to SSAS.
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
