O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required