In addition, workbook on disk was 36MB whereas the raw CSV was 75MB, a 50% reduction in size. PowerPivot made a nice fast pivot table over it, no problem.
:max_bytes(150000):strip_icc()/001-Power-Pivot-for-excel-14121ecff83140c7bee1a84e41a3580b.jpg "excel for mac 2011 powerpivot")
Our preliminary test was a 1 million row table, imported from a CSV. We didn’t buy the hype on the scalability, so we tried it for ourselves.
#Excel for mac 2011 powerpivot free
Well there IS such a beast, and the surprise is, it’s Excel itself! Excel 2010 has a free add-on called PowerPivot that addresses many of our longstanding issues with it as a business intelligence tool. Wouldn’t it be great to have something like Excel, but it serves more like the front end to multiple databases and DOESN’T cost a bajillion dollars like Tableau? Introducing PowerPivot isn’t good at stitching multiple tables together.isn’t great at selecting subsets of data.Excel’s fine for simple, small data sets but it: It’d be great to have something like Excel, but without the limitations. Plus, a lot of people just aren’t comfortable with SQL and we often need to hand off our work to more businessy types that have more starch in their shirts than comp sci classes under their belts. While raw SQL and a database remain a top weapon of choice for getting a sense of a new data set, it leaves a bit to be desired in the presentation department. We do a lot of ad-hoc data investigation and analysis around here, and are always on the lookout for tools that make our lives easier.
0 kommentar(er)
