Features

• 

  BigQuery BI Engine

  • 
    

    BigQuery BI Engine is a blazing-fast, in-memory analysis service for BigQuery that allows users to analyze large and complex datasets interactively with sub-second query response time and with high concurrency. BigQuery BI Engine seamlessly integrates with familiar tools like Data Studio, Looker,* and Sheets* to accelerate data exploration and analysis.

    
    

    - Enable real-time dashboarding over streaming or static data with sub-second query response and with high concurrency

    - Simplify BI architecture and accelerate time to insight by reducing additional ETL or BI server management

    - Optimize visual analytics over big datasets with automatic performance tuning and capacity flexibility

    
    
• 

  Data Studio

  • 
    

    Google Data Studio is a fully managed visual analytics service that can help anyone in your organization unlock insights from data through easy-to-create and interactive dashboards that inspire smarter business decision-making. When Data Studio is combined with BigQuery BI Engine, an in-memory analysis service, data exploration and visual interactivity reach sub-second speeds, over massive datasets.

    
    

    - Build effective dashboards and analyses with drag-and-ease using a flexible reporting canvas and hundreds of pre-built or custom data connectors and visualizations

    - Inspire and engage users with fast visual interactivity, real-time dashboard collaboration and deep integrations across the Google ecosystem

    - Scale both self-serve or centralized BI workloads across the org on Google’s serverless and secure platform without unnecessary IT provisioning or administration

    
    
    
• 

  Sheets with BigQuery: connected sheets

  • 
    

    The connected sheet is a new feature of Sheets that activates only when using the Sheets data connector for BigQuery, allowing you to access, analyze, visualize, and collaborate on up to 10 billion rows of BigQuery data — no SQL scripts needed. Sheets end users can surface insights without needing the help of BigQuery experts or analysts fluent in SQL, saving time for everyone. Sheets users can then make sense of that data with spreadsheet formulas or perform deeper analysis with features like Explore, pivot tables, and charts. It’s that easy.

    
    

    - Unlock insights by empowering anyone in the organization to easily connect to, view, and understand big data, without requiring SQL

    - Use the familiarity and speed of a spreadsheet interface for self-serve exploration, pivoting, filtering, charting, and formula-based analysis of big data

    - Boost data-driven decision-making and collaboration across the organization while controlling permissions to limit who can view, edit, or share data