数据混搭，数百万行Excel 2010中使用的PowerPivot

Excel 2010中引入了切片机，迷你，聚合函数，公式编辑器和更平滑的方式粘贴，但截至目前为止，在Excel 2010中最好的功能并非来自Excel的团队。安装Excel 2010中后，下载免费的PowerPivot插件从www.PowerPivot.com。通过微软的SQL Server分析服务组撰写，PowerPivot的增加严重的商业智能工具，Excel 2010中这里有四个神奇的东西，使PowerPivot的：1.在Excel工作簿存储数亿行的。您将不再拥有月产100万项为您的Excel用户的行子集。让他们访问整个数据集，即使该数据集为200万行。显然，承重200万行到内存中，你必须有一个相当严重的64位机与一吨的RAM。2.从任何地方导入数据。PowerPivot的消耗可以从SQL Server，Access，Excel中，文本文件，甲骨文，Teradata的，ODBC时，SharePoint报告，Atom提要数据。你可以导入SQL服务器到Sheet1中，文本文件到Sheet2和原子饲料到工作表Sheet 3。3.混搭数据，而无需掌握VLOOKUP：说你有工作表Sheet1上200万行与项目ID字段。 Sheet2 contains the product master database, mapping ItemID to a variety of descriptive fields. PowerPivot can create a single Pivot Table offering fields from both worksheets. Traditionally, your power Excel users would have created 10 million slow VLOOKUP formulas to solve this problem. Your non-power users would have been stopped in their tracks. PowerPivot analyzes the data, figures out how to join the tables, and builds a star schema, all behind the scenes. 4. New time-intelligence functions. PowerPivot offers 80 functions that are similar to Excel functions and then adds 60 new functions that should have been in Excel. When building a pivot table, you could calculate Month to Date sales from a parallel period that is 1 year ago. PowerPivot also adds date functions that work even if your fiscal year doesn't end on December 31. While the client version of PowerPivot is free, you may want to invest in the SharePoint version of PowerPivot. This tool allows your Excel users to post their reports to a SharePoint library. From their, you can use the PowerPivot dashboard to see which reports are being used frequently and by whom. The Excel client version of PowerPivot requires Excel 2010. It is a painless install and doesn't interfere with the normal operation of Excel. Offer a version to a few of your star Excel data analysts and they will fall in love with the new reporting opportunities. Additional Resources: If you opt to buy PowerPivot for Sharepoint, you will want to read Denny Lee's专业微软的PowerPivot为Excel和SharePoint谁正在使用的PowerPivot的Excel的客户端版本的数据分析将要阅读我的对于PowerPivot的数据分析：Excel 2010中