Google Sheets Reporting
Google Sheets offers classic spreadsheet functionalities, mixed with cloud features. This makes it the ideal candidate for building reports that enable the end-user to dive in right away without the need to download data.
​​
In this project, we created a comprehensive report that contains sales data, web behavior analytics, and marketing spend information in a single, easy-to-use report. With our solution, the team can now start their day with a cup of coffee instead of copy/pasting.
Core Components

Google Sheets
This tool offers the flexibility of spreadsheets with the automation of reporting solutions. Pivot tables load automatically and graphs are refreshed at the same time.

OWOX BI
OWOX BI allows its users to store SQL scripts in Google Sheets and set a timer to load the data into the spreadsheet. It also fires an email in case a data load fails to notify the admin.

Google BigQuery
All data that feeds into the report was first centralized and stored in Google BigQuery. From there we can easily query it by using SQL.