Now Use Machine Learning Powered Explore & BigQuery to Analyze Data in Google Sheets

Quickly analyzed business data using Explore in Sheets, as well as sync Sheets with BigQuery for deeper insights.

Share online:

A new way to analyze data in Google Sheets using machine learning instead of relying on lengthy formulas to crunch numbers, can now achive with Explore in Google Sheets to ask questions and quickly gather insights.

With this launch, just click the "Explore" button on the bottom right corner in Sheets, then type in a question about your data in the search box and Explore will respond to your query. "You might now use Explore in Sheets to analyze profit from last year, or look for trends in how customers sign up for your company's services."

Now, taking data analysis one step further, users are now allowed to sync Sheets with BigQuery—Google Cloud's low cost data warehouse for analytics. This ability enables to compare publicly-available datasets in BigQuery, like U.S. Census Data or World Bank: Global Health, Nutrition, and Population data, to your company's data in Sheets and gather information.

This GIF shows an example of using Explore in Sheets, and BigQuery:

Use Explore and BigQuery in Google Sheets

For more information on using this ability, watch this video:

G Suite Business and Enterprise admins gains more granular control over mobile app management, as they can now assign different settings for different organizational units (OUs) and groups.

"This means that an admin can, among other things, whitelist certain apps for their executive team and others for their marketing org, or prohibit their sales team from disabling specific apps," the team writes. Previously, admins could only do these things for an entire domain.

Check out the Help Center for more information.

Whitelisted apps
Whitelisted apps