9 of 11Image
Google describes BigQuery as a column store database that works well for OLAP (OnLine Analytical Processing) queries. Microsoft PowerPivot, a free add-in for Excel 2010, precisely fits that description as well and can import from CSV files just fine. Here’s what the data looks like once it’s in PowerPivot. Throwing large datasets in PowerPivot will give you far better performance than storing the same data directly in a spreadsheet.
One very powerful aspect of PowerPivot is its use of data compression. The CSV file containing the six states’ baby data was over 20MB. The Excel workbook containing the PowerPivot model with that same data was less than 1MB.