Integrate BigQuery & Mosaic
BigQuery
Overview
Automatically sync operational data directly from BigQuery and use it to build custom metrics, analyze performance drivers, and create detailed operational plans.
Tap into an extensive library of operational data
Access vast networks of business data in a one-stop-shop fashion, rather than connecting to dozens of systems individually.
Combine financial and ops data to see the bigger picture
Go beyond your core financial systems to build a complete, connected view of all the business activities that drive financial results.
Turn tables of raw data into deep financial context
Use Mosaic to transform BigQuery’s vast operational datasets into the financial structure and logic that unlock insights important to finance.
Plan for growth by connecting every piece of the puzzle
Leverage datasets from BigQuery to power more expansive financial models, metrics, and analyses across the Mosaic platform.
Key Features
Mosaic has all the tools you need to transform your raw BigQuery data into contextualized financial and operational insights that drive financial success.
DETAILS
1-click data connection to BigQuery
Intelligent data mapping
150+ prebuilt financial and business metrics
35+ report and dashboard templates
Out-of-the-box financial and business metric dashboards
Metric Builder to build custom metrics
Custom report builder
Automated BigQuery actuals in reports, dashboards, and models
Automated forecast vs. actual reporting
BigQuery transaction-level drilldown
Role-based user access
Key Metrics
Mosaic makes it easy to report, forecast, and share key business metrics that drive your financial and operational success — from pipeline and bookings, to revenue and collection schedules, product usage, and customer health. Combine BigQuery data with the rest of your financials for a complete view of business performance.
How It Works
Data integration shouldn’t be hard. At Mosaic, we make it easy. Get connected and start analyzing your data in minutes with these four simple steps.
STEPS
Enter your BigQuery account credentials directly within Mosaic
Sync your source data in Mosaic in just a few clicks
Map BigQuery data to Mosaic with intelligent mapping tools
Start building metrics, analyzing, and modeling
Shared Data
More Resources
Videos
Build a Customer LTV:CAC Metric
Sales Pipeline to Cash Scenario Planning
Build a Rolling Forecast
Vendor Forecasting and BVA Reporting
FAQs
What kind of data can I bring in from BigQuery?
Any data table or view that exists in BigQuery can be brought into Mosaic. If you have over 1 million data records, please let your account executive know so we can help set up your connection for optimal performance.
What is BigQuery best used for?
What is Mosaic best used for?
Are there any best-practices once I connect my data to Mosaic?
Explore more integrations
Own the of your business.
![](/_next/static/media/footer-cta.4e24ebfb.png)