Business Intelligence Features in Excel 2010

The Excel team has made a number of improvements in the Business Intelligence area for Excel 2010, which have been covered in-depth on the Excel Team Blog.

First, the team added slicers, which are visual controls that allow you to quickly and easily filter your data in an interactive way. Slicers can connect to PivotTables, PivotCharts, and CUBE functions to creative interactive dashboards:

Part of an interactive Dashboard with Slicers and PivotCharts

A number of enhancements have been made to PivotTables- including the ability to modify values in PivotTable cells (writeback), more flexibility and power through named sets, and a series of other enhancements.

A new search filter is available for tables and PivotTables, which allows you to quickly navigate through large data sets.

The New Search Filter

Finally, the Excel and SQL teams have collaborated to create a PowerPivot, a powerful data analysis tool made up of two components: an add-in for Excel 2010 and a series of new features for SharePoint 2010.

"Designed for business users, PowerPivot […] delivers unmatched computational power directly within the application users already know and love — Excel. Leveraging familiar Excel features, users can transform enormous quantities of data from virtually any source with incredible speed into meaningful information to get the answers they need in seconds."

PowerPivot add-in for Excel 2010

Here's the full list of Excel blog posts about Slicers, PivotTable Improvements, and PowerPivot.

Slicers

• Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers
• Interacting with Slicers
• Dressing up your Slicers

Table and PivotTable Improvements

• Excel 2010: New Search Filter
• PivotTable Named Sets in Excel 2010
• Excel 2010 PivotTable What-If Analysis (Writeback)
• A Few More PivotTable Improvements in Excel 2010

PowerPivot

• Introducing PowerPivot
• New PowerPivot Site
• Using PowerPivot with Excel 2010
• PowerPivot for SharePoint 2010 – The Business User’s Perspective

Also, read about improvements in other areas of Excel:

• Data Visualization Features in Excel 2010
• Functions and Solver Improvements in Excel 2010
• Excel Services 2010: Excel in the browser

Comments

• Anonymous
  January 01, 2003
  There are some noughty bugs in PowerPivot beta. When will next version of beta be ready to ship??

• Anonymous
  January 28, 2010
  Love the new sparklines feature in Excel 2010! It totally rocks! :)

• Anonymous
  January 28, 2010
  Looks good, I can hardly wait for the launch events to see the experts demo this stuff.

• Anonymous
  February 04, 2010
  Can someone tell me if Microsoft corrected their egregious mistake in Office 2007 of leaving no option for the classic menus in Office 2010?

• Anonymous
  March 16, 2010
  thank you so much

• Anonymous
  March 22, 2010
  what about data mining add-in tool in 2010??? when it will be published??

• Anonymous
  May 02, 2010
  The comment has been removed