MegaPivot is a web-based big data analytics application. Simply import csv files from your Dropbox folder into our Google BigQuery platform, easily describe tables relationships, create and share pivot tables.

September 15, 2013

MegaPivot is not a data warehouse

Data warehouse projects are massive IT and business intelligence endeavours that take months and millions of dollars from design to roll-out. Anyone who has been through any, even small scale, data warehouse implementation will remember the struggles behind ETL design, data mismatch and failed data quality audits, aborted import jobs, out-of-sync data, ...
September 14, 2013

Easily access your Google Analytics Premium data from BigQuery

Google is testing out with a select group of beta testers a new feature of Google Analytics Premium that allows exporting of unsampled data into Google BigQuery. You will soon be able to mix and match your unsampled google analytics data with your other datasets (orders tables, CRM tables, profitability analyes) right from your MegaPivot account. MegaPivot ...
September 14, 2013

Most cost effective alternatives to a data warehouse

Data warehouse implementations have historically required a large investment of resources and money. Cloud-based systems now offer cost-effective alternatives. Two of the most powerful and scalable platforms were released by two cloud-computing giants, Amazon and Google. Amazon released RedShift, a columnar database platform built on Postgres by ParAccel, ...
September 12, 2013

Building pivot tables on big data sources

Pivot tables are a powerful paradigm for data analysis. Microsoft Excel can only be reliably used on sheets containing few tens of thousands of rows. PowerPivot can get you a bit farther than that, although at the cost of maintaining data sources and increased complexity. Once you have to deal with hundreds of thousands of lines, Excel-based tools quickly ...
September 08, 2013

Amazon Redshift vs Google BigQuery vs Hadoop

Many people associate big data applications with open source project Hadoop. Hadoop was built on the map reduce distributed programming paradigm, first introduced by Google in a cornerstone paper published in 2004. Over the past decade, numerous companies have successfully adopted Hadoop for their big data needs and many IT consultants and service providers ...
September 07, 2013

How to import CSV files into Google BigQuery

Building your own Google BigQuery datasets has never been so easy. Open your free MegaPivot account Create a new dataset and click on "Add table" Select any CSV file from your Dropbox folder Let MegaPivot infer your table schema from your data and make adjustments as needed Choose if you want to create a new table or append to an existing table in your ...
September 01, 2013

PowerPivot used as datawarehouse

Many organizations face the need of dealing and making sense of an exploding amount of data. Large companies have the resources to invest in expensive datawarehouse projects, but integrating new data sources or even making small adjustments to data schemas require the involvement of IT resources, which often results in long lead times and prioritization ...

MegaPivot is a web-based big data analytics application built on Google BigQuery infrastructure.

Build pivot tables on billions of rows in seconds.
Easily import CSV files of any size directly from your Dropbox folder.
Share your reports with your colleagues.

Sign Up with Google