Business Intelligence Features in Excel 2010

    Business Intelligence Features in Excel 2010


    Posted: 28 Jan 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

    Table and PivotTable Improvements

    PowerPivot

    Also, read about improvements in other areas of Excel:

    More...
    z3r010's Avatar Posted By: z3r010
    28 Jan 2010



 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 10:28.
Find Us