{"id":578947,"date":"2019-04-15T15:23:36","date_gmt":"2019-04-15T22:23:36","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/research\/?post_type=msr-project&#038;p=578947"},"modified":"2022-03-22T02:54:11","modified_gmt":"2022-03-22T09:54:11","slug":"conversational-data-analytics","status":"publish","type":"msr-project","link":"https:\/\/www.microsoft.com\/en-us\/research\/project\/conversational-data-analytics\/","title":{"rendered":"Natural Language Interface for Data Analytics"},"content":{"rendered":"<p>In this project, we try to research and develop a conversation technology for data analytics scenarios. By using <span style=\"float: none;background-color: #ffffff;color: #333333;cursor: text;font-family: Georgia,'Times New Roman','Bitstream Charter',Times,serif;font-size: 16px;font-style: normal;font-variant: normal;font-weight: 400;letter-spacing: normal;text-align: left;text-decoration: none;text-indent: 0px;text-transform: none\">our technology, g<\/span>iven a relational database or a data table, a user can explore the data table and insights from the dataset through natural language conversation. Our system can understand user\u2019s natural language questions and convert the questions into some analysis programs. The programs can be executed on the relational database (or the data table) to obtain their results. The results are then returned to users in a form of visualization and a natural language description. With conversational analytics, we can significantly lower the bar for general users to conduct data analysis. It helps organizations analyze structural data (e.g., tabular datasets, relational databases, knowledgebase, etc.) and deliver personalized reporting and intelligence.<\/p>\n<p>In this project, we research and develop AI&NLP technologies and experience designs to support conversational analytics.\u00a0This is a cross-discipline research project that includes the following research topics:<\/p>\n<ul>\n<li>Semantic parsing (also called NL2Code) is a technology of converting a natural language utterance to a logical form (or program) that is a machine-understandable meaning representation of the utterance. Different applications may need different mean representations. Here, a domain specific mean representation (i.e., DSL) can be SQL, a kind of Formula, regular expression, or Lambda calculus, or other logic form. In this project, we proposed a unified framework on semantic parsing to support different DSLs for different scenarios. Many problems in natural language understanding domain are also important to a practical semantic parsing system, such as conversation context modeling, ambiguity handling, and so on.<\/li>\n<li>Knowledge computing. In practice, common knowledge or domain specific knowledge are often essential to understand a natural language utterance in an application scenario. Therefore, research on technologies of knowledge representation, knowledge mining\/enhancement, and knowledge integration is also very important.<\/li>\n<li>Advanced machine learning approaches. Machine learning algorithms play a critical role in our semantic parsing and knowledge computing technologies. To develop advanced NLU technologies, we often need advanced machine learning algorithms. Recently, deep learning algorithms have aided conversational analytics to support multi-step complex queries by continually learning through experience from large natural language datasets.<\/li>\n<li>Experience design. User interaction design is a very important factor to the success of a conversational data analysis system. As we know, NL is often ambiguous, and SOTA NL technologies are often not 100% accurate, a good interaction design can mitigate these problems. In addition, traditional visual interface is also very convenient and efficient in some scenarios. We need a good interaction design to seamlessly integrate the NL interface with the traditional visual interface together for better user experience.<\/li>\n<\/ul>\n<p>Project News:<\/p>\n<ol>\n<li class=\"x-hidden-focus\">Our NL technology on Excel was announced at\u00a0<a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/Excel-Blog\/Excel-Announcements-Ignite-2019\/ba-p\/964482\">Ignite 2019<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>.\u00a0<a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" href=\"https:\/\/sfmagazine.com\/post-entry\/december-2019-excel-ask-excel-a-question-about-your-data\/\">Here<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>\u00a0is a review article from Mr. Excel (a MVP user of Excel).<\/li>\n<li class=\"x-hidden-focus\">Our NL technology on Excel has been\u00a0<a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" href=\"https:\/\/support.office.com\/en-gb\/article\/ideas-in-excel\">released<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this project, we try to research and develop a conversation technology for data analytics scenarios. By using our technology, given a relational database or a data table, a user can explore the data table and insights from the dataset through natural language conversation. Our system can understand user\u2019s natural language questions and convert the [&hellip;]<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"footnotes":""},"research-area":[13556],"msr-locale":[268875],"msr-impact-theme":[],"msr-pillar":[],"class_list":["post-578947","msr-project","type-msr-project","status-publish","hentry","msr-research-area-artificial-intelligence","msr-locale-en_us","msr-archive-status-active"],"msr_project_start":"","related-publications":[603384,702754,616995,712789,627885,712804,627894,758014,627903,758029,670179,758533,670185,777154,702724,800368,702730,813565,702739,702748],"related-downloads":[],"related-videos":[],"related-groups":[],"related-events":[],"related-opportunities":[],"related-posts":[],"related-articles":[],"tab-content":[],"slides":[],"related-researchers":[{"type":"user_nicename","display_name":"Jian-Guang Lou","user_id":32337,"people_section":"Section name 1","alias":"jlou"},{"type":"user_nicename","display_name":"Zhitao Hou","user_id":35124,"people_section":"Section name 1","alias":"zhith"},{"type":"user_nicename","display_name":"Haidong Zhang","user_id":31953,"people_section":"Section name 1","alias":"haizhang"},{"type":"user_nicename","display_name":"Yan Gao","user_id":38730,"people_section":"Section name 1","alias":"gaoya"},{"type":"user_nicename","display_name":"Zeqi Lin","user_id":39751,"people_section":"Section name 1","alias":"zelin"},{"type":"guest","display_name":"Yan XIAO","user_id":734611,"people_section":"Section name 1","alias":""},{"type":"user_nicename","display_name":"Dongmei Zhang","user_id":31665,"people_section":"Section name 1","alias":"dongmeiz"}],"msr_research_lab":[199560],"msr_impact_theme":[],"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/578947"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/types\/msr-project"}],"version-history":[{"count":10,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/578947\/revisions"}],"predecessor-version":[{"id":735196,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/578947\/revisions\/735196"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=578947"}],"wp:term":[{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=578947"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=578947"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=578947"},{"taxonomy":"msr-pillar","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-pillar?post=578947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}