BigQuery-Native Pivot for Massive SaaS Analytics

A powerful new version of the ChartFactor Pivot Table is here, currently supported for Google BigQuery.

If you build visual analytics into a SaaS product, this will change how you deliver insights—fast, scalable, and deeply interactive.

This is what you are missing if you are using Looker Studio’s pivot instead of ChartFactor’s pivot table:

• Massive data support 

• Drag-filter interactions 

• Custom handling for missing cells 

• Easy include/exclude nulls 

• One-click full-screen 

• Themes + fine-grained color control 

• Fully embeddable & code-transparent 

• Included in ChartFactor Studio Community (free) 

In the demo: we query the Chicago Taxi Trips public dataset (211M+ rows) directly in BigQuery, no ETL, no data movement. We configure rows/columns, paginate huge pivots, keep context with sticky headers, select individual cells like a spreadsheet, pin/unpin dimensions, and even color by heatmap. Prefer 2019 only? We add an interactive trend and select the year in seconds. Need help? The AI Assistant understands your data context and guides configuration.

Built on BigQuery’s security model—your data stays protected and in place. 

Watch the video to see it in action.

Start building today with ChartFactor Studio Community, it’s free and ready for your SaaS analytics stack. Go to https://chartfactor.com to get started.