{"id":204,"date":"2012-03-09T11:15:25","date_gmt":"2012-03-09T03:15:25","guid":{"rendered":"http:\/\/down.cdhaha.net\/?p=204"},"modified":"2012-03-09T11:23:45","modified_gmt":"2012-03-09T03:23:45","slug":"powerpivot-for-microsoft-excel","status":"publish","type":"post","link":"http:\/\/down.cdhaha.net\/?p=204","title":{"rendered":"SQL Server 2012 PowerPivot for Microsoft Excel 2010"},"content":{"rendered":"

\"PowerPivot\"<\/a>Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint 2010.<\/p>\n

Microsoft PowerPivot for Microsoft Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the software users already know and love \u2014 Microsoft Excel. You can transform mass quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others. You can:
\n
\n Process large data sets (often millions of rows) with about the same performance as processing a few hundred rows by leveraging the PowerPivot in-memory engine and its efficient compression algorithms<\/p>\n

Use PowerPivot to directly access trusted premium and public domain data from DataMarket section of Windows Azure Marketplace<\/p>\n

Integrate data from a multitude of sources, including corporate databases, spreadsheets, reports, text files, and Internet data feeds<\/p>\n

Go beyond standard Excel expressions and use PowerPivot\u2019s Data Analysis Expressions (DAX) language to perform powerful data manipulations. Follow relationships between tables as in a database and define sophisticated calculations using familiar and intuitive expressions<\/p>\n

Interactively explore, analyze, and create reports without depending on expert knowledge and specialty training by using native Excel 2010 functionality such as PivotTables, slicers, and other familiar analysis features<\/p>\n

To install and use Microsoft SQL Server 2012 PowerPivot for Microsoft Excel, complete the following steps in this order:<\/p>\n

1. Install .NET Framework 4.0 and Visual Studio 2010 Tools for Office Runtime.
\n 2. If you are running Windows Vista or Windows Server 2008, install the platform update.
\n 3. Install Microsoft\u00ae Office 2010.
\n 4. Install PowerPivot for Microsoft Excel <\/p>\n

ENG For X86<\/span><\/a>
<\/div><\/div>\n
\u7b80\u4f53\u4e2d\u6587\u7248 For X86<\/span><\/a>
<\/div><\/div>\n
ENG For X64<\/span><\/a>
<\/div><\/div>\n
\u7b80\u4f53\u4e2d\u6587\u7248 For X64<\/span><\/a>
<\/div><\/div>\n

=====================================================<\/p>\n

Microsoft PowerPivot for Microsoft Excel 2010 \u63d0\u4f9b\u591a\u79cd\u521b\u65b0\u6280\u672f\uff0c\u4f8b\u5982\u5feb\u901f\u64cd\u4f5c\u5927\u6570\u636e\u96c6\uff08\u5e38\u5e38\u662f\u51e0\u767e\u4e07\u884c\uff09\u3001\u4f18\u5316\u6570\u636e\u7684\u96c6\u6210\u4ee5\u53ca\u80fd\u591f\u901a\u8fc7 Microsoft SharePoint 2010 \u8f7b\u677e\u5171\u4eab\u60a8\u7684\u5206\u6790\u7ed3\u679c\u3002<\/p>\n

Microsoft PowerPivot for Microsoft Excel 2010 \u662f\u6570\u636e\u5206\u6790\u5de5\u5177\uff0c\u5b83\u76f4\u63a5\u5728\u8f6f\u4ef6\u7528\u6237\u6240\u719f\u6089\u548c\u559c\u7231\u7684\u8f6f\u4ef6 Microsoft Excel \u5185\u63d0\u4f9b\u975e\u5e38\u5f3a\u5927\u7684\u8ba1\u7b97\u673a\u80fd\u529b\u3002\u60a8\u53ef\u4ee5\u60ca\u4eba\u7684\u901f\u5ea6\u5c06\u5927\u91cf\u6570\u636e\u8f6c\u6362\u4e3a\u6709\u610f\u4e49\u7684\u4fe1\u606f\uff0c\u4ece\u800c\u51e0\u79d2\u949f\u5c31\u83b7\u5f97\u6240\u9700\u7684\u7b54\u6848\u3002\u60a8\u53ef\u4ee5\u8f7b\u677e\u5730\u4e0e\u4ed6\u4eba\u5206\u4eab\u60a8\u7684\u53d1\u73b0\u3002\u60a8\u53ef\u4ee5\uff1a
\n* \u901a\u8fc7\u5229\u7528 PowerPivot \u5185\u5b58\u4e2d\u5f15\u64ce\u548c\u9ad8\u6548\u7684\u538b\u7f29\u7b97\u6cd5\uff0c\u5904\u7406\u5927\u6570\u636e\u96c6\uff08\u901a\u5e38\u51e0\u767e\u4e07\u884c\uff09\u65f6\u6240\u4f53\u73b0\u7684\u6027\u80fd\u5c31\u50cf\u5904\u7406\u51e0\u767e\u884c\u4e00\u6837\u3002
\n* \u96c6\u6210\u6765\u81ea\u591a\u79cd\u6570\u636e\u6e90\uff08\u5305\u62ec\u516c\u53f8\u6570\u636e\u5e93\u3001\u7535\u5b50\u8868\u683c\u3001\u62a5\u8868\u3001\u6587\u672c\u6587\u4ef6\u548c Internet \u6570\u636e\u9988\u9001\uff09\u7684\u6570\u636e\u3002
\n* \u8d85\u51fa\u6807\u51c6 Excel \u8868\u8fbe\u5f0f\u7684\u8303\u7574\uff0c\u5e76\u4e14\u4f7f\u7528 PowerPivot \u7684\u6570\u636e\u5206\u6790\u8868\u8fbe\u5f0f (DAX) \u6267\u884c\u5f3a\u5927\u7684\u6570\u636e\u64cd\u4f5c\u3002\u50cf\u5728\u6570\u636e\u5e93\u4e2d\u4e00\u6837\u9075\u5faa\u8868\u4e4b\u95f4\u7684\u5173\u7cfb\uff0c\u5e76\u4e14\u4f7f\u7528\u5927\u5bb6\u6240\u719f\u6089\u4e14\u76f4\u89c2\u7684\u8868\u8fbe\u5f0f\u5b9a\u4e49\u590d\u6742\u7684\u8ba1\u7b97\u3002
\n* \u901a\u8fc7\u4f7f\u7528\u56fa\u6709\u7684 Excel 2010 \u529f\u80fd\uff08\u4f8b\u5982\u6570\u636e\u900f\u89c6\u8868\u3001\u5207\u7247\u5668\u548c\u5176\u4ed6\u5927\u5bb6\u6240\u719f\u6089\u7684\u5206\u6790\u529f\u80fd\uff09\uff0c\u4ee5\u4ea4\u4e92\u65b9\u5f0f\u6d4f\u89c8\u3001\u5206\u6790\u548c\u521b\u5efa\u62a5\u8868\uff0c\u800c\u65e0\u9700\u4f9d\u8d56\u4e8e\u4e13\u5bb6\u77e5\u8bc6\u548c\u4e13\u95e8\u7684\u57f9\u8bad\u3002<\/p>\n

\u7cfb\u7edf\u8981\u6c42
\n * \u652f\u6301\u7684\u64cd\u4f5c\u7cfb\u7edf\uff1a Windows 7
\n Windows Server 2008 R2\uff0864 \u4f4d\uff09\uff0c
\n Windows XP SP3\uff0832 \u4f4d\uff09\uff0c
\n Windows Vista SP2\uff0832 \u4f4d\u6216 64 \u4f4d\uff09*\uff0c
\n Windows Server 2008 SP2\uff0832 \u4f4d\u6216 64 \u4f4d\uff09*\uff0c
\n \u88c5\u6709 MSXLM 6.0 \u7684 Windows Server 2003 R2\uff0832 \u4f4d\u6216 64 \u4f4d\uff09+\uff0c
\n \u652f\u6301 Terminal Server \u548c Windows on Windows (WOW)\uff08\u5141\u8bb8\u5728 64 \u4f4d\u64cd\u4f5c\u7cfb\u7edf\u4e2d\u5b89\u88c5 Office 2010 \u7684 32 \u4f4d\u7248\u672c\uff09\u3002<\/p>\n

* \u8fd8\u8981\u6c42\u7528\u4e8e Windows Vista\/Windows Server 2008 \u7684\u5e73\u53f0\u66f4\u65b0\u3002
\n + \u5728 64 \u4f4d Windows Server 2003 R2 \u4e0a\u4ec5\u652f\u6301 32 \u4f4d Microsoft\u00aeOffice 2010\/PowerPivot for Microsoft\u00ae Excel 2010\u3002
\n * 500 MHz 32 \u4f4d\u6216 64 \u4f4d\u6216\u7ea7\u522b\u66f4\u9ad8\u7684\u5904\u7406\u5668
\n * \u6700\u4f4e 1 GB RAM\uff08\u5efa\u8bae\u4f7f\u7528 2 GB \u6216\u66f4\u5927\u7684 RAM\uff09
\n * 3.5 GB \u53ef\u7528\u786c\u76d8\u7a7a\u95f4
\n * Internet \u8bbf\u95ee <\/p>\n

\u8bf4\u660e
\n\u5728\u5b89\u88c5\u6b64\u4ea7\u54c1\u4e4b\u524d\uff0c\u5efa\u8bae\u60a8\u5148\u9605\u8bfb Microsoft SQL Server 2008 R2 \u53d1\u884c\u8bf4\u660e\u548c Microsoft SQL Server 2008 R2 \u81ea\u8ff0\u6587\u4ef6\u3002<\/p>\n

\u82e5\u8981\u5b89\u88c5\u548c\u4f7f\u7528 Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010\uff0c\u8bf7\u6309\u7167\u4e0b\u9762\u7684\u987a\u5e8f\u5b8c\u6210\u4ee5\u4e0b\u6b65\u9aa4\uff1a
\n1. \u5982\u679c\u60a8\u6240\u8fd0\u884c\u7684\u64cd\u4f5c\u7cfb\u7edf\u5e76\u975e Microsoft Windows 7 \u6216 Microsoft Windows Server 2008 R2\uff0c\u5219\u5b89\u88c5 .NET Framework 3.5 SP1\u3002
\n2. \u5982\u679c\u60a8\u5728\u8fd0\u884c Windows Vista \u6216 Windows Server 2008\uff0c\u5219\u5b89\u88c5 \u5e73\u53f0\u66f4\u65b0\u3002
\n3. \u5b89\u88c5 Microsoft Office 2010\u3002
\n \u91cd\u8981\u63d0\u793a\uff1a\u5982\u679c\u60a8\u9009\u62e9\u4ee5\u81ea\u5b9a\u4e49\u65b9\u5f0f\u5b89\u88c5 Microsoft Office 2010\uff0c\u5219 Excel 2010 \u548c Office \u5171\u4eab\u529f\u80fd\u90fd\u5fc5\u987b\u5b89\u88c5\uff0c\u8fd9\u6837\u624d\u80fd\u4f7f\u7528 PowerPivot for Excel\u3002
\n4. \u5b89\u88c5 PowerPivot for Microsoft Excel
\n \u91cd\u8981\uff1a\u5982\u679c\u60a8\u5b89\u88c5 Excel \u7684 32 \u4f4d\u7248\uff0c\u5219\u5fc5\u987b\u4f7f\u7528 PowerPivot \u7684 32 \u4f4d\u7248\u3002\u5982\u679c\u60a8\u5b89\u88c5 Excel \u7684 64 \u4f4d\u7248\uff0c\u5219\u5fc5\u987b\u4f7f\u7528 PowerPivot \u7684 64 \u4f4d\u7248\u3002<\/p>\n

English Version For X86<\/span><\/a>
<\/div><\/div>\n
\u7b80\u4f53\u4e2d\u6587\u7248 For X86<\/span><\/a>
<\/div><\/div>\n
English Version For X64<\/span><\/a>
<\/div><\/div>\n
\u7b80\u4f53\u4e2d\u6587\u7248 For X64<\/span><\/a>
<\/div><\/div>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[191],"tags":[293,29,657,137],"_links":{"self":[{"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=\/wp\/v2\/posts\/204"}],"collection":[{"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=204"}],"version-history":[{"count":0,"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=\/wp\/v2\/posts\/204\/revisions"}],"wp:attachment":[{"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=204"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/down.cdhaha.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}