Excel Adds New Data Types
Excel Adds New Data Types
Written by Kay Ewbank   
Friday, 06 July 2018

New types have been added to Excel that rely on AI to recognize rich data types such as countries. The first data types to be added are Stocks and Geography, but more will be added in the future.

The AI behind the new types comes from Microsoft Knowledge Graph, the same intelligent service that powers Bing. This allows Excel to recognize, in context, whether there's a specific meaning for a piece of text  so it can be converted to a specific type of data. The feature relies on Excel having a cloud connection, hence the introduction into Office 365, Microsoft's online Office offering.

The Geography data type includes information such as States, Countries, Zip Codes and Cities.

bingai2

The Stocks data includes ticker symbols, fund names, and company names. Most importantly, the current stock price is also included and can be fetched when required.

The Geography data type means Excel would recognize that Colombia was a country, and as such as attributes such as population size and gross domestic product. Users will be able to take those properties and use them in other cells or formulae, and if the details change, the up-to-date figures will be reflected in the cells.

 

bingai

The new feature appears in the Excel Data tab, and when a choice is ambiguous, Excel will offer different options to the user. More organizational data types are planned to be added in the future.

The facility draws not just on the Knowledge Graph, but on a new service called Skydance that sends strings to the graph. There are also new elements to the user interface to allow users to work with the Knowledge Graph’s results. 

Knowledge Graph (aka Bing Satori) is based on work by Microsoft Research. It is a graph-based repository that uses the Resource Description Framework and the SPARQL query language. It is based on Trinity, Microsoft Research's distributed, in-memory, large graph processing engine.

 excel

More Information

Microsoft Explanation Of New Data Types

Microsoft Research Trinity

Related Articles

Google Search Goes Semantic - The Knowledge Graph

Amazon Neptune Graph Database

Visualizing Graph Data

Google Cayley Graph Database

Sparql moves closer

Azure Updates Announced At MS Connect()

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin.

Banner


Python Passion For Assignment Expressions - PEP 572
11/07/2018

You would think with a language as old as Python there wouldn't be much left to get excited about, but over the past few months PEP-572, a proposal to add a new feature, has been raising the bloo [ ... ]



MapR Adds Data Tiering
09/07/2018

MapR has added data tiering to its new release, along with access via the S3 API and the ability to run Kubernetes-based apps without changing the container images.


More News

justjsquare

 



 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Friday, 06 July 2018 )
 
 

   
Banner
Banner
RSS feed of news items only
I Programmer News
Copyright © 2018 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.