Mar 24, 2017

[TIP: How to query in Natural Language (NLP) within Google Spreadsheets]

Introduced in the Google Cloud Next 2017, this feature allows you to Question/Answer in natural language within Google Spreadsheet.

In general, spreadsheet novices often do not know how to use a sheet or the functions Spreadsheet provide, so even if there is useful data in the sheet, it is often misaligned because of poor analysis.

If you take advantage of the Explore function in 'Spreadsheet' as shown below, you can create a good report.



This is a sample statement that can be queried in the Explore of a sheet.

1. What were the top item on 2017
2. How many unique countries
3. What percentage of Represent is '이영희'
5. Who is the top represent?
6. Top Sold Units for Rep of '홍길동'
7. How many sold items by '홍길동



-----------
Kindle Edition-Paperback/eBook -


' 

No comments:

Post a Comment