a Sift Media publication
Over 23,000 pages of accounting passion and insight!   |   Sift Media logo

Microsoft announces free business intelligence tool

Posted by AccountingWEB in Technology, IT on 10/29/2009 - 11:31
Data,Chart,Spreadsheet

The tool formerly known as "Project Gemini" has been officially dubbed Microsoft PowerPivot for Excel 2010. This data analysis tool will enable Excel 2010 users to analyze very large data sets in seconds. And they mean very large: about 4 minutes into this video you can a demonstrator filtering 20 million records in an Excel spreadsheet. A second video provides a deeper look into this functionality and shows how you can sort, filter, and analyze millions of records just about instantaneously, even on a netbook computer.

PowerPivot works its magic through a new expression language known as DAX (Data Analysis Expressions). This language is very similar to Excel's worksheet function language, and allows users to create pivot tables based on multiple tables, such as vendor data from a Vendors table and purchase data from a Purchases table. DAX also allows you to use Excel-like functions, such as this
 
=SUM(Purchases[Amount])
 
This formula would sum the Amount column from a table named Purchases. Some DAX functions are more complex, but in essence you refer to columns in a database table rather than worksheet ranges. PowerPivot links to Microsoft SQL Server 2008 and will link to other data sources as well. Users can choose to publish their work to Microsoft Sharepoint 2010. In turn, other users can use a web browser to view the data results.
 
The PowerPivot add-in has an engine that allows it to do massive number crunching not previously possible in Excel. As an added benefit, Excel 2010 users will be able to work with previously unfathomable data sets in a familiar Excel environment.
 
You'll be hearing much more about PowerPivot in the coming months. In the interim, you can keep up with the latest developments:
·         Follow PowerPivot on Twitter
·         Become a Facebook fan
 
  • 4881 reads


Tags:   
Welcome Visitor!
Sign up for the Technology newsletter to stay informed of future content in this category.
Email:
Already have an account? Sign in:
Forgotten your password?
Join us FB Connect with us LI Follow us
Voice of the Editor
Amidst a certain amount of controversy, the AICPA and the Chartered Institute of Management Accountants have launched a new designation for global management accountants, the CGMA (Chartered Global Management Accountant). The designation is available to members of both organizations.
Read more >>

Gail Perry, CPA
Editor-in-Chief, AccountingWEB
editor@accountingweb.com
Related Content
AccountingWEB Readers Find Time Management a Challenge
Free Spreadsheet-Based Form 1040 Available for 2011 Tax Year
Excel Tip: Table Feature Enables Effective Analysis
On the Horizon: A New Version of Microsoft Office
Governments and Private Companies Exploring Benefits of XBRL