Introduction – OWOX Help Center

Welcome to the OWOX: Reports, Charts & Pivots (Sheets, BigQuery) extension guide, which helps you set up all features and get analytics-ready data for your reports.

Screenshot 2023-12-19 at 19.45.50.png

HOW TO INSTALL The "OWOX: Reports..." extension is a part of the OWOX BI platform, and you need to install the extension from the official Google Workspace Marketplace.

Core features

This extension allows you to do the following:

create reports in Google Sheets based on your BigQuery data;
collaborate with your team using shared Data Marts for people who haven't direct access to BigQuery;
use dynamic parameters in Data Marts;
apply Filters, Limits, and Sorting to fields in the report;
schedule automatic updates of Google Sheets reports;
import Google Sheets reports to Google BigQuery;
use automated Pivots & Charts for data visualizations.

Getting started requirements

Case #1: Power Users

Case #2: No-Code Users

To perform SQL coding with direct access to BigQuery data:

You’re using the Google Cloud Platform with an active project setup (see instructions on setting up GCP).
The data you’re working with is stored in Google BigQuery.
To import data from BigQuery to Google Sheets, you need at minimum the following roles: BigQuery Job User (project level) and BigQuery Data Viewer.
To import data from Google Sheets to BigQuery, you’ll need either BigQuery Admin or BigQuery Data Owner roles.
The "OWOX: Reports..." extension is included in your subscription.

To build reports, apply filters and sorting, and create charts and pivots:

You have a Google account to install the OWOX extension;
Your colleagues have shared a Data Mart with you.

Terms of Usage and Report Runs

Read the terms of use in this article with examples.

Core features

Getting started requirements

Terms of Usage and Report Runs

0 Comments

Related articles