maxresdefault-1080x675

Google improves Sheets analytics, visualization features

Google improves Sheets analytics, visualization features

 

Google is adding new visualization and analytical tools to its Sheets software to help business users to better understand the data on their spreadsheets. In its latest effort to bring Big Data analytics capabilities to the masses, Google has announced a new tool that allows users to preview formula results instantly, even as users are typing out the formula. Dan Gundrum, Google product manager, said in a blog post this feature was unique to Google Sheets, and that its main use will be to help users spot basic formula errors more easily than before.

Besides this, the update allows users to filter rows and columns using qualifiers like “text contains” or “greater than” to focus on the spreadsheet values that matter. Doing so, users will be able to look at only the dates, text and numbers they need for a particular task, Gundrum explained.

Other new features include being able to add a new calculated field to the pivot table that performs functions based on other data in the pivot field. There’s also a GETPIVOTDATA function that enables easier data retrieval from the pivot table.

Read Also:
How Blockchain and AI Can Defeat Fake News

Google has also updated the data visualization features in Sheets. A new feature called “data labels” allows users to display the exact value of bars or points in a spreadsheet, while another feature lets users change the shape of data points in line or scatter graphs.

“Charts can make even the largest data sets digestible, so Google made a few improvements to help you highlight what’s most important,”.

Google has long been trying to win over Microsoft Office and Excel users and the updates are clearly an attempt to make its software more appealing to enterprise users. While Microsoft’s software is generally said to have more features and better performance, Google is clearly getting closer and believes this, combined with its substantially lower costs, might be enough to temp some users to switch.



Data Science Congress 2017

5
Jun
2017
Data Science Congress 2017

20% off with code 7wdata_DSC2017

Read Also:
Don't count on data scientist being the sexiest job for much longer
Read Also:
A Visualization of Sunrise and Sunset Photos Being Snapped Around the World

AI Paris

6
Jun
2017
AI Paris

20% off with code AIP17-7WDATA-20

Read Also:
Why Google BigQuery excels at BI on big data concurrency

Chief Data Officer Summit San Francisco

7
Jun
2017
Chief Data Officer Summit San Francisco

$200 off with code DATA200

Read Also:
10 Women Influencers in Big Data Analytics

Customer Analytics Innovation Summit Chicago

7
Jun
2017
Customer Analytics Innovation Summit Chicago

$200 off with code DATA200

Read Also:
Sketching with Data Opens the Minds Eye

HR & Workforce Analytics Innovation Summit 2017 London

12
Jun
2017
HR & Workforce Analytics Innovation Summit 2017 London

$200 off with code DATA200

Read Also:
Don't count on data scientist being the sexiest job for much longer

Leave a Reply

Your email address will not be published. Required fields are marked *