Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Business Intelligence Features in Excel 2010

28 Jan 2010   #1
z3r010

 
Business Intelligence Features in Excel 2010

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


My System SpecsSystem Spec
.
Reply

 Business Intelligence Features in Excel 2010




Thread Tools




Similar help and support threads
Thread Forum
New Document Inspector features for Excel, PowerPoint and Word
Source...
News
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
features in Excel
What features have you found in Excel that would be useful to the management team? how would you use them?:(
Microsoft Office
Office 2010 Home and Business
I bought Home and Business, I installed it once but I need it again for another computer. I know Microsoft cut down the amount of installs you can do on Office 2010, so how many installs does Home and Business allow?
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Data Visualization Features in Excel 2010
More...
Microsoft Office


Our Sites

Site Links

About Us

Find 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 22:18.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App