Lately, I have been talking to few business folks who do their own data analysis in excel (2010) and sometimes they run into the excel 2010 limit of 1 million rows. And so when I hear that, I talk about Power Pivot and I talk about what It can do and what it cannot and they are just amazed that there’s a FREE add-in that will help them crunch more than 1 million rows!
You can explore more about this amazing add-in here: http://www.microsoft.com/en-us/bi/powerpivot.aspx
And Read more about pros/benefits of PowerPivot:
- The State of Microsoft Self-Service Reporting (sqlserverbiblog.wordpress.com)