3r3186. 3r3-31. 3r3161. Hi, Habr! I present to you the translation Article "Tableau talks up natural language interface for creating visualizations" Peter Sayer 3r3162. . 3r3173.  3r3186. 3r3173.  3r3186. 3r3161. The BI provider seeks to simplify and automate data analysis as part of the growing trend towards the introduction of AI (artificial intelligence) capabilities into BI tools. 3r3162. 3r3173.  3r3186. 3r3173.  3r3186. 3r318. 3r3173.  3r3186. 3r3173.  3r3186. How many statisticians are needed to build a new data model? According to Tableau Software, not at all. The company claims that the next version of a widely used analytical tool will do it itself.
3r3173.  3r3186. 3r3173.  3r3186. Tableau demonstrated this last week in a new feature called Ask Data, which allows users to create visualizations, describing what they want in natural language. This was done at an event for clients in New Orleans. In addition, the company has demonstrated new automation features in its data preparation tool. 3r3173.  3r3186. 3r3173.  3r3186. This is part of a growing trend among enterprise software developers to automate and streamline tasks that once required specialized skills, allowing enterprises to more efficiently use their data and redeploy qualified staff to less time-consuming work. 3r3173.  3r3186. 3r3173.  3r3186. 3r3143. The dawn of AI technology in BI 3r3144. 3r3173.  3r3186. Achievements in the field of artificial intelligence make it easier for corporate software developers to enter data in natural language — oral or printed — and display the information the user needs, instead of forcing him to learn specific commands or operate objects on the screen to achieve his goals. AI is increasingly being used in leading BI tools in the hope of “democratizing” analytics and data science. 3r3173.  3r3186. 3r3173.  3r3186. Microsoft Power BI, a competitor to Tableau, introduced a feature called “questions and answers” ​​several years ago, but even in recent demonstrations, the sentence seems more difficult in grammar and spelling than Tableau Ask Data. However, they both are ahead in the development of the company Dundas BI and the like, which still use drag and drop to create visualizations. 3r3173.  3r3186. 3r3173.  3r3186. The Tableau implementation will allow users to query the database and allow the software to independently figure out how the database tables should be combined, which columns should be selected and which operations should be performed to get the required response. This and other new features will appear in Tableau 2019.? which is expected to be released early next year, and the beta version is released in late October. 3r3173.  3r3186. 3r3173.  3r3186. “ Such automation features are welcome and required 3r3162. - Forrester chief analyst Martha Bennett said. - 3r3161. We are getting more and more data, but people working with them do not have that amount of time ". 3r3173.  3r3186. 3r3173.  3r3186. According to her, data managers spend up to 80 percent of their time preparing data, and the less time they spend on it, the more they will be able to engage in those BI functions that directly benefit the business. 3r3173.  3r3186. 3r3173.  3r3186. One way to overcome the shortage of time among specialists is to transfer most of the workload to machines. Another way is to simplify work with data for people who previously could not work with them because of the need to possess special skills. This is the so-called "democratization" of data. 3r3173.  3r3186. 3r3173.  3r3186. 3r3143. Disadvantages of using AI 3r3144. 3r3173.  3r3186. “ But there are risks in providing data to more employees: the data cannot substitute for expert knowledge in the subject area and a sober assessment of situations 3r3162. "Said Martha Bennett. 3r3173.  3r3186. 3r3173.  3r3186. “ [i] Before making automation features widely available, CIOs should test them through their experience to determine if they fit “- she advises. 3r3173.  3r3186. 3r3173.  3r3186. Tools that offer data analysis without clear recommendations can confuse users in what actions to take. 3r3173.  3r3186. 3r3173.  3r3186. 3r3151. “ [i] If you do not give someone detailed instructions, then you should not expect that he will do everything right the first time 3r3162. ". 3r3173.  3r3186. - Martha Bennett, Principal Analyst, Forrester
 3r3186. 3r3158. 3r3173.  3r3186. However, you can’t just put all the responsibility on the software. 3r3173.  3r3186. 3r3173.  3r3186. “ [i] Automation is not the same as control. All these things still need to be monitored. At trial, it will not sound very good if you say that the computer itself did this, and we have no idea why 3r3162. “- Marta Bennett warns. This problem has long been known as the AI ​​black box problem. 3r3173.  3r3186. 3r3173.  3r3186. Additionally, you need to find out if your data is suitable for an automation tool: in particular, machine learning systems require a lot of data to work. 3r3173.  3r3186. 3r3173.  3r3186. “ [i] If you apply machine learning algorithms to data, where you have more exceptions than normal ones, this will not work 3r3162. ", - she said. 3r3173.  3r3186. 3r3173.  3r3186. 3r3143. Details of the demonstration 3r3144. 3r3173.  3r3186. At an event in New Orleans, visual analytics manager Andrew Vigno demonstrated the capabilities of Ask Data in the Kickstarter crowdfunding project database, showing that, unlike most compilers, Ask Data does not require perfect punctuation for work. 3r3173.  3r3186. 3r3173.  3r3186. The software turned his request “what was the total financing” (literally) into the “amount of financing” and returned the answer. When he typed "by year" and "by status", Ask Data converted his request to "amount of financing by term and by status". Then, having no additional data, she prepared a color line chart showing green funding for successful projects, increasing every year, while funding for unsuccessful, canceled or suspended projects (red, orange and yellow) remains unchanged. 3r3173.  3r3186. 3r3173.  3r3186. The question “which categories were successful” caused another visual answer: Ask Data added “by category, filter status - successful” to the previous request and drew a histogram of ranking Kickstarter categories by the number of successful projects in descending order. 3r3173.  3r3186. 3r3173.  3r3186. Employees have long wanted corporate software to do what they wanted, even if they didn’t manage to formulate the task accurately, and Andrew Vigno showed that Tableau was approaching this. When he scored “compare with the average funding” (literally), Ask Data showed him the variation in the number of projects along with the average funding for various subcategories of technology projects that he had previously viewed. 3r3173.  3r3186. 3r3173.  3r3186. Some things in Tableau are still faster to do with the mouse, especially if you are typing slowly: adding subcategories of "fashion" and "game" to the scatter diagram takes only four clicks. 3r3173.  3r3186. 3r3173.  3r3186. 3r3143. Create new data models 3r3144. 3r3173.  3r3186. A few clicks is all that was needed by his colleague Tyler Doyle to create a new data model that displays the fields Tableau uses to analyze data in SQL queries that the underlying database can understand. 3r3173.  3r3186. 3r3173.  3r3186. 3r3151. “ [i] It is enough for me to click the mouse on one line - “Add related objects”, and your data model is ready, without the need to determine which tables to use, how they are related, or what it is, left or right connection. New data modeling features in Tableau just do it for you. 3r3162. »3r3173.  3r3186. - Tyler Doyle
 3r3186. 3r3158. 3r3173.  3r3186. “ [i] How did the data model know the correct relationships between these tables? 3r3162. "- Doyle is interested. It turns out Tableau relies on CIOs, as well as their database administrators and data specialists. In order to help him perform this trick, you need to make sure that the necessary information is stored in the data warehouse. 3r3173.  3r3186. 3r3173.  3r3186. Data preparation is another area that Tableau is working on. Senior engineer Zahira Valani showed how Tableau Prep can automate data cleansing with “roles”. Tableau uses them to identify fields that have a specific role — things like URLs, email addresses, or geographical indications (states or postal codes). Valanee showed how, in just a couple of clicks, Tableau Prep can check the contents of a field to determine the most appropriate role, and then select invalid elements that do not match the role, and either set them to “null” or filter these lines. The same can be done with user roles, for example, enumerated types. 3r3173.  3r3186. 3r3173.  3r3186. According to Tableau’s Chief Product Officer, François Eienstat, Tableau Prep will be updated monthly, in contrast to the schedule of three releases per year for the main Tableau software. 3r3173.  3r3186. 3r3173.  3r3186. Planning is a function of another tool, which is now being tested in the company: Tableau Prep Conductor. It will allow enterprises to automate the preparation of their data sources by moving them to Tableau according to their chosen schedule. This is a separate product from Tableau and will require a separate license to use it. Start of sales is scheduled for next year. 3r3182. 3r3186. 3r3186. 3r3186. 3r3179. ! function (e) {function t (t, n) {if (! (n in e)) {for (var r, a = e.document, i = a.scripts, o = i.length; o-- ;) if (-1! == i[o].src.indexOf (t)) {r = i[o]; break} if (! r) {r = a.createElement ("script"), r.type = "text /jаvascript", r.async =! ? r.defer =! ? r.src = t, r.charset = "UTF-8"; var d = function () {var e = a.getElementsByTagName ("script")[0]; e.parentNode.insertBefore (r, e)}; "[object Opera]" == e.opera? a.addEventListener? a.addEventListener ("DOMContentLoaded", d,! 1): e.attachEvent ("onload", d ): d ()}}} t ("//mediator.mail.ru/script/2820404/"""_mediator") () (); 3r33180. 3r3186. 3r3182. 3r3186. 3r3186. 3r3186. 3r3186.