Integrate BigQuery & Mosaic

Data warehouse solutions like BigQuery are designed to store very large volumes of raw, structured, and unstructured business data from a variety of departments and software tools across the organization. By centralizing all this data in one place, data warehouse tools make this information easily accessible for analysis and decision-making. However, when it comes to finance, data warehouses are not designed to apply financial logic to data, provide visual analysis tools to present data in a useful financial context, or provide forward-looking forecasting and modeling capabilities. That’s where Mosaic comes in.

Mosaic is purpose-built to handle the workflows of FP&A. From financial reporting and analysis to business performance dashboarding, financial forecasting, and what-if scenario modeling, Mosaic helps finance teams manage the financial performance of the business. While raw data from source systems like BigQuery are essential inputs, Mosaic’s magic is its ability to contextualize those raw data inputs into financial and business logic that’s instantly usable for finance.

We recommend you take advantage of the latest innovation in the Mosaic platform, Metric Builder. Metric Builder lets you build and customize metrics using any datasets in Mosaic, including BigQuery data, and then surface those metrics anywhere in the Mosaic platform.