Enter your email address:

Delivered by FeedBurner

February 2017

Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28        

Brian's G+ Shared Items

« Whats Going on with Brian? | Main | Dear Brian: What Do You Think About Your Sprint 4G OverDrive/MiFi Device? »

July 23, 2010


Jeff Huckaby

Brian - enjoy your blog. On PowerPivot, having used it for over 9+ months, the tool is a lot more powerful than anything you can do with Access. You can easily import many large data sets (hundreds of millions rows of data) from a wide variety of data sources: oracle, sql server, teradata, .txt files, excel spreadsheets, etc. You can easily create data "mash-ups" that would normally take IT weeks to complete, in minutes/hours. The key component of PowerPivot is its ability to store the cube "in-memory" for very fast analysis. In addition, PowerPivot can compress data at a factor of 50 to 1. Informative dashboards can be created using the existing PivotTable functionality, and calcultions (called measures) can be created using PowerPivot new "DAX" language, using built-in time intelligence, such as MTD, YTD, and period over period analysis. Sharing the analysis takes a click of the button to share to the corporate intranet via SharePoint 2010.

The comments to this entry are closed.