Microsoft announces free business intelligence tool

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
 

You may like these other stories...

The following list highlights 10 apps that that may be of interest to you, your clients, or your clients' clients. They were featured during a session of AWEBLive!, the 12-hour CPE marathon, and presented by Gregory L....
I am a recent MS Accounting degree graduate and I am looking into a programming/IT related career. Anyone here have experience or know any accountants that diverted their careers into IT/Programming/System design, etc?...
Event Date: May 29, 2014 In this presentation Excel expert David Ringstrom, CPA brings you up to speed on the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both...

Upcoming CPE Webinars

Apr 24
In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel.
Apr 25
This material focuses on the principles of accounting for non-profit organizations' revenues. It will include discussions of revenue recognition for cash and non-cash contributions as well as other revenues commonly received by non-profit organizations.
Apr 30
During the second session of a four-part series on Individual Leadership, the focus will be on time management- a critical success factor for effective leadership. Each person has 24 hours of time to spend each day; the key is making wise investments and knowing what investments yield the greatest return.
May 1
This material focuses on the principles of accounting for non-profit organizations’ expenses. It will include discussions of functional expense categories, accounting for functional expenses and allocations of joint costs.