Google Cloud BigQuery Features

Supports a variety of scripting environments

Mines data from databases and prepares data for analysis

Applies statistical algorithms to selected data

Analyzes both structured and unstructured data

Interacts with data to prepare it for visualizations and models

Series of data points indexed in time order

Review data from past periods to reveal recurring tendencies and predict future performance

Offers modeling capabilities

Creates data visualizations or graphs

Generates reports of data performance

Unifies information on a singular platform

Alter the layout and content of reports

Helps marketers measure return on investment (ROI) by analyzing campaign effectiveness against costs

Gathers data about the effectiveness, impact, and reach of marketing campaigns

Collects and reports on data relating to customer journeys, preferences, and history

Allows multiple users access to a unified, transparent overview of analytics, dashboards, and campaign results

Includes features for budgeting, forecasting, and managing marketing investments

Offers a white labeling service for agencies or resellers to customize platform branding

Collect information from multiple sources

Tracks metrics that provide insight into how a user interacts with any interface or product

Track and monitor a specific set of keywords

Track visitors'/audience's responses across web pages and other optimized content

Track the performance of marketing campaigns across multiple channels.

Measure return on ad spend by tracking the actions people take such as sign up or download after engaging with ads

Optimize and manage the search engine optimization efforts for a website or digital content

Generate or append custom campaign parameters to URLs

Receive data and information in real time

Track and document all activities across devices, networks, and other systems

Track the amount of clicks on individual products to measure campaign results

Manage, organize, and store contact information

Handles digital content throughout its lifecycle, from creation and storage to distribution and archiving

Store information about leads or contacts and track, manage and nurture them throughout the sales process

Manage, store and organize emails within the system or via third-party apps

Create a collection of marketing actions to complete specific goals and plan and analyze campaign results

Manage various distribution channels, build relations with channel partners, and track their performance

Create, save, and re-purpose templates for emails, forms, etc.

Create, design and manage workflows for repetitive tasks

Analyzes historical and current marketing campaigns to inform future strategy

Creates reports and dashboards to analyze results of campaigns

Identifies which marketing campaigns resolved in open or closed opportunities

Collects marketing campaign performance data across multiple channels

Provides opportunities for brands and businesses to fix or modify existing or future campaigns via feedback

Uses artificial intelligence (AI) to predict campaign outcomes and suggest actions for optimization

Manage multiple campaigns in one system

Track and interpret campaign performance metrics

Track and analyze information regarding website visitors

Improving user journey to boost the percentage of visitors who take a desired action (sign-ups or purchases)

Send automated marketing emails based on user actions over a predetermined period

Interact with data visualization elements, such as charts and graphs, to drill down into data

Analyze and gain insights into data in real-time

Alter the layout and content of reports

Collects, stores, and organizes massive, unstructured data in real time

Facilitates the disseminating of collected big data throughout parallel computing clusters

Creates a repository to collect and store raw data from sensors, devices, machines, files, etc.

Aligns processing and distribution workflows on top of Apache Hadoop

Aligns processing and distribution workflows on top of Apache Hadoop

Facilitates solution to run on and scale to a large number of machines and systems

Curates collected data for big data analytics solutions to analyze, manipulate, and model

Aligns processing and distribution workflows on top of Apache Hadoop

Moves big data collection and processing to the cloud

Processes batch, real-time, and streaming data workloads in singular, multi-tenant, or cloud systems

Facilitates analysis of high-volume, real-time data.

Allows user to query data through query languages like SQL.

View and track pertinent metrics to find patterns and gain insights from data

Predict future data based on historical data sets

Interact with data visualization elements, such as charts and graphs, to drill down into data

Aligns processing and distribution workflows on top of Apache Hadoop

Aligns processing and distribution workflows on top of Apache Spark

Integrates data from multiple external databases.

Facilitates the dissemination of collected big data throughout parallel computing clusters.

Receive data and information in real time

Import, collect, and capture data from multiple sources

Review data from past periods to reveal recurring tendencies and predict future performance

Provides varying estimates based on different scenarios

Apply statistical/mathematical models to sets of data

Merge data from multiple sources to a single data set

Set up connections to third-party platforms to improve business processes

Processes data and represents interpretations in a variety of graphic formats.

Strings together specific functions and datasets to automate analytics iterations.

Isolates certain datasets and facilitates management of data access.

Allows big data tool to run and record data within external applications.

Use notebooks for tasks such as creating dashboards with predefined, scheduled queries and visualizations

Discover and connect variety of data sources to the application for analysis

View ETL process data via reports and visualizations like charts and graphs.

Record ETL historical data for auditing and potential data correction needs.

Extract data from the designated source(s) like relational databases, JSON files, and XML files.

Cleanse and re-format extracted data to the needed target format.

Load reformatted data into target database, data warehouse, or other storage location.

Arrange ETL processes to occur automatically on needed time schedule (e.g., daily, weekly, monthly).

Capable of scaling processing power up or down based on ETL volume.

Automatically retrieve and pull information from documents, websites, images, data sets, and other sources

Consolidates, Cleanses and Normalizes data from multiple disparate sources.

Helps save storage capacity and improves query performance.

Eliminates data inconsistency and duplications ensuring data integrity.

SQL based analytics functions like Time series, pattern matching, geospatial analytics etc.

Provides built in capabilities like machine learning algorithms, data preparation functions, model evaluation and management etc.

Allows data querying across data formats like parquet, ORC, JSON etc and analyze complex data types on HDFS

Process of extracting and moving data from multiple sources to a single and unified database

Import, collect, and capture data from multiple sources

Analyze and gain insights into data in real-time

View and track pertinent metrics to find patterns and gain insights from data

Integrates with data science workflows, Machine Learning and artificial intelligence (AI) capabilities.

Integrates with BI Tools to transform data into Actionable Insights.

Provides speed in data processing and capturing unstructured, semi-structured and streaming data.

Provides On-Premise deployment options.

Provides Cloud deployment options (private or public cloud, hybrid cloud).

Manages huge volumes of data, upscale or downscale as per demand.

Policies, procedures and standards to manage and access data.

Restricts data access at a cell level, mask or hide parts of cells, and encrypt data at rest and in motion

Provides predefined system roles, privileges, and user-defined roles to users.

Allows integration with external security mechanisms like Kerberos, LDAP authentication etc.

Provides an audit log to track access and operations performed on databases for regulatory compliance.

Provides encryption capability for all the data at rest using encryption keys.

Stores data tables as columns.

Supports multiple data types like lists, sets, hashes (similar to map), sorted sets etc.

Implements auto horizontal data partitioning that allows storing data on more than one node to scale out.

Restores a database to a correct (consistent) state in the event of a failure.

Copy data across multiple servers through master-slave, peer-to-peer replication architecture etc.

Stores frequently-used data in system memory quickly.

Provides support to store, index and query data in more than one format.

Available on multiple operating systems like Linux, Windows, MacOS etc.

Offers a centralize, neutral location for parties to conduct data analysis.

Offers localized computation, where data remains where it resides and is called by API in order to conduct analysis.

Allows users to generate text based on a text prompt.

Condenses long documents or text into a brief summary.

Use AI to generate content in the form of text, images, videos, etc.

Allows users to generate text based on a text prompt.

Condenses long documents or text into a brief summary.

Use AI to generate content in the form of text, images, videos, etc.

Capability to perform complex tasks without constant human input

Works across multiple software systems or databases

Anticipates needs and offers suggestions without prompting

Set up connections to third-party platforms to improve business processes

Integrate with social media platforms such as Facebook, Twitter, LinkedIn, etc.

Plan marketing campaigns for events

Market event via social media tools

Coordinate marketing efforts across channels (email, landing pages, social media, etc.)

Use AI to generate content in the form of text, images, videos, etc.

Import and export data to and from software applications

Manage the process of attracting and converting business prospects into leads

Group campaigns by project, client, or campaign for better management.

Customize contracts and forms to collect specific information

Collection, analysis, and representation of numerical data and generation of reports to understand various patterns

Observe and track the demand, usage, progress or quality of a system, product, or user

A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users

Pre-designed layouts that can be customized to match preferences and requirements

Pre-made examples and templates for emails

Web form that allows users to enter data that is sent and processed for different reasons

Automatically identify and save contact information of potential customers

Add customized logos and colors to align with company branding

Active reporting of data and metrics

Plan and strategize marketing campaigns

Test multiple versions of emails, forms, content, or other campaign elements to gauge effectiveness

Built-in customer relationship management (CRM) capabilities or integration with a third-party CRM system

Process of dividing customers into groups based on common characteristics

Set campaign schedules by selecting start, pause, and end dates

Alerts or notifications of various types such as pop-up messages, sounds, banners, or badges

Create and automatically send premade copy in response to customer messages

Assemble applications and processes by dragging over and arranging pre-built components

Predefined actions automatically performed on the occurance of specific events

Create and send email blasts/campaigns

Application programming interface that allows for integration with other systems/databases

Customize data fields to support various needs and use cases

Centralized database of stakeholders and their contact information such as names, address, phone number etc.

Graphical representation of data

Generate one-off reports that meet information requirements

A set of indicators that tracks the performance of networks, applications, systems, teams, etc.

Connect to big data sources

Search and filter data across systems to locate required information by entering keywords or certain criteria

A set of rules that assigns credit for sales and revenue to touchpoints across the customer journey

Visualize and analyze customer experience across all touchpoints and channels

Tracking the status of previously identified performance measurements

Analytics that breaks the data in a data set into related groups/categories.

Running multiple processors to handle separate parts of an overall task and manage complex tasks/computations.

Allows users to manage data from a number of sources

Application programming interface that allows for integration with other systems/databases

Blending and analysis of large data sets without moving data out of a database.

Observe and track the demand, usage, progress or quality of a system, product, or user

Active reporting of data and metrics

Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency

Active monitoring of systems, applications, or networks

Connect to big data sources

A set of indicators that tracks the performance of networks, applications, systems, teams, etc.

Generate one-off reports that meet information requirements

Alerts or notifications of various types such as pop-up messages, sounds, banners, or badges

Define levels of authorization for access to specific files or systems

Assemble applications and processes by dragging over and arranging pre-built components

Graphical representation of data

Import and export data to and from software applications

Looking at data from different sources and finding possible duplicates, or identical matches

Translate EDI formats into data suitable for use with company applications.

Securely stores data to prevent data loss or breaches

Automatically retrieve and pull information from documents, websites, images, data sets, and other sources

A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users

Alter the layout and content of reports

Dashboard to view the status of ongoing processes, identify current incidents and track past activities

Move from one database to another, or upgrade the version of database software being used

Track the management and flow of data throughout the organization

Central repositories of integrated data from various sources

Assemble applications and processes by dragging over and arranging pre-built components

Dashboard to view the status of ongoing processes, identify current incidents and track past activities

Connect to big data sources

Generate one-off reports that meet information requirements

Alter the layout and content of reports

System alerts about the need to escalate an issue or request

Sample files or documents that could be customized as needed or used as is

Form predictions based on past and present data/trends

Move from one database to another, or upgrade the version of database software being used

Translate EDI formats into data suitable for use with company applications.

Define levels of authorization for access to specific files or systems

Application programming interface that allows for integration with other systems/databases

Removes data that is incomplete, inaccurate, or irrelevant from a dataset

Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency

A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users

Creation and customization of dashboards

Automatically retrieve and pull information from documents, websites, images, data sets, and other sources

Protect sensitive data for digital privacy

Security protocol that ensures secure, encrypted communication over the internet, safeguarding sensitive data from unauthorized access

Provides a channel for team members to share media files, communicate, and work together

Drag and drop/visual interfaces that allow non-tech users to build without writing code

Process and analyze large volume of data

Supports common databases such as MySQL and Oracle

Search and filter data across systems to locate required information by entering keywords or certain criteria

Use AI to generate content in the form of text, images, videos, etc.

Forecast customer demand using historical insights and simulations

Software program that continuously adjusts its behavior based on observed data

Assemble applications and processes by dragging over and arranging pre-built components

Software designed for the healthcare industry

Form predictions based on past and present data/trends

Automatically retrieve and pull information from documents, websites, images, data sets, and other sources

Set up connections to third-party platforms to improve business processes

Tools that provide relevant information at specific times to support judgments and courses of action

Using physical, mathematical, or logical models as a basis for simulations to generate data for managerial or technical decision-making

Alerts or notifications of various types such as pop-up messages, sounds, banners, or badges

View and track pertinent metrics to find patterns and gain insights from data

Allows users to manage data from a number of sources

For Retail Stores

Used for educational purposes

Discover and connect variety of data sources to the application for analysis

Create, design and modify the flow and processes of tasks in a project

A set of indicators that tracks the performance of networks, applications, systems, teams, etc.

Define and maintain business rules that determine workflow capabilities and criteria

A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users

Process and analyze human language in text or audio form

Translate EDI formats into data suitable for use with company applications.

Clustering or grouping objects based on data similarities

Application programming interface that allows for integration with other systems/databases

Merge data from multiple sources to a single data set

Grouping log entries based on similar attributes.

Create, design and manage workflows for repetitive tasks

Streamlining repetitive tasks and activities through automated and predefined workflows

Track the management and flow of data throughout the organization

Observe and track the demand, usage, progress or quality of a system, product, or user

Manage patient documentation describing all clinical interactions, diagnoses, procedures, medications, etc.

Identify which applications need to exchange data and enable these data connections

View and track pertinent metrics to find patterns and gain insights from data

Define levels of authorization for access to specific files or systems

Application programming interface that allows for integration with other systems/databases

Looking at data from different sources and finding possible duplicates, or identical matches

Active monitoring of systems, applications, or networks

Collect and maintain structured information that describes data or content

Track the progress of long term goals, campaigns, and opportunities, for sales, projects, business ventures etc.

Planning and managing the execution of tasks or jobs within a computer system, network, or other automated environments

Creation and customization of dashboards

Manage and store data in a database

Allows users to manage data from a number of sources

Import and export data to and from software applications

Use AI to generate content in the form of text, images, videos, etc.

Establish guidelines about how much and what kind of data can be stored in the repository

Connect to big data sources

Alter the layout and content of reports

Allow users to access multiple services after entering their login credentials once

Track revisions and updates made to files and navigate between different versions

Interact with data visualization elements, such as charts and graphs, to drill down into data

Integrate with a third-party accounting system

Receive data and information in real time

Has a built-in eCommerce system or integrates with third-party systems to manage online sale of products

A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users

Built-in customer relationship management (CRM) capabilities or integration with a third-party CRM system

Graphical representation of data

Security protocol that ensures secure, encrypted communication over the internet, safeguarding sensitive data from unauthorized access

Search and filter data across systems to locate required information by entering keywords or certain criteria

Analyze and gain insights into data in real-time

Import, collect, and capture data from multiple sources

Provides a channel for team members to share media files, communicate, and work together

Organize and manage the accomplishments and development of employees or performance of applications or systems

Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency

Assemble applications and processes by dragging over and arranging pre-built components

Process of copying and storing data in more than one site or node

Dashboard to view the status of ongoing processes, identify current incidents and track past activities

Supports common databases such as MySQL and Oracle

Create, design and manage workflows for repetitive tasks

Alerts or notifications of various types such as pop-up messages, sounds, banners, or badges

Predict future data based on historical data sets

Move from one database to another, or upgrade the version of database software being used

Set up connections to third-party platforms to improve business processes

Collection, analysis, and representation of numerical data and generation of reports to understand various patterns

Analyze survey results via statistical testing or crosstabs directly within the software