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.
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.