|
Product support intelligent analysis tool-ask data. Users will enter the questions in the common language and will receive an immediate response. At present, Chinese input in the Chinese system language, and English input in the non-Chinese system environment. The answers address the question presented in a visual diagram, eliminating the need to manually bind the data column or understand the nuances of the data structure. Use the ask data function to purchase a Y + Analytics license. 1.1 Application scenarios •When viewing the analysis dashboard, due to the different analysis angles or granularity, the viewer still has some data questions hoping to get the answer. At this time, you can use the data question and answer function, and the viewer can quickly get the answer to the question through the form of interactive question and answer. •Users in the process of data analysis, can directly input data problem to obtain the results, it reduces the data binding operation process, simple data processing (such as date expression conversion, four operation calculation column creation, etc.), and can quickly join the analysis results in the dashboard, greatly improving the efficiency of create analysis dashboard. 1.2Application entrance •In create the dashboard, ask data component under the component / self-service analysis. •In viewing the dashboard, the data answering component is embedded in the dashboard. 2.Ask component 2.1Functional profile Users can quickly view the data for the asked data, and quickly obtain visual answers by entering relevant data questions. 2.2 Function declaration The ask data function is used in editing dashboards and viewing dashboards. 2.2.1 Ask component entrance In the edit dashboard, the right component / self-service analysis under ask data component. 2.2.2 Ask component property setting Through the right panel of the ask data [Format], you can set the format of the component and the style of the component title and the question search box. These include font, font size, bold, italics, text color, alignment, border, icon color, transparency, and text format. Through the right panel of the ask data-set, you can set the name, title, visibility, actions, ask data chart action, advanced and position properties of the components. The ask data chart action is used to control the action configuration that the chart component can perform in the ask mode. 3.Ask function 3.1 Functional profile After entering the ask data mode, you can choose the dataset to be analyzed according to the needs, and you can quickly understand the data situation through the data preview. By entering questions in the search box to ask questions, the product will recommend a visual chart to show the answers. The user can also fix the problem to adjust the results of the visual chart. The query data quantity in the editing dashboard and viewing dashboard is defined according to the respective data mode. The default editing dashboard performs the data results with the number of sample lines, and the full data results in the viewing dashboard. 3.2 Function declaration In the editing dashboard, add the ask data component, and click the right icon to select the default data set in the drop-down box; click the icon in the input box to enter the question answering mode. In the viewing dashboard, click the data answer input box or icon to enter the answer mode. 3.2.1 Data preview •Entering the ask data page, a dataset will be loaded by default. Users can select the dataset to be analyzed in the dataset selection box. •In the data bar on the right, mouse over each field for the data details it contains. •When entering the ask data mode, the index information is automatically created based on the currently selected data source to prepare the data source before the user queries. Automatic: users automatically create the index when creating new data answers and automatically update the index information every 24 hours. Manual: if the data source is changed frequently, and the user only occasionally uses the ask data, you can manually update the index to obtain the latest data source information to ensure accurate recommendation information. Note: during the index creation process, the maximum loading time is 10s and only the first 1000 rows of different values are taken for each column to ensure the system performance at large data volumes. Maximum load time is user custom configuration (data.qa.create. index.max.time). When the limit time has not fully created the index, not created part only the data column name information. •When the content of the dataset is updated, in order to ensure that the ask in use can be answered on the latest data basis, users can click on the index icon and recreate the index immediately. •Users with ask management authority can also customize synonyms for data column names and their domain values, assist to identify the same words entered by users when asking questions, and improve the efficiency of information identification. 3.2.2Ask default questions After entering the ask data mode, the system will recommend common data questions according to the currently selected dataset. Users with ask data management authority can also add custom questions according to the selected dataset to help users provide more common problem auxiliary analysis. You can create a new question by clicking on the "+" icon. "Displayed text" is used to describe the question for which the user asks, and "Matching result" is used to define the information of the corresponding identifiable column. User-defined questions are placed above the default questions to support re-editing and deletion. 3.2.3Ask questions and recommendations In the ask input box, enter the data questions. During the input process, the product searches for data columns, functions, string values, and other information, and displays the results in the drop-down list. 3.2.4Modify the ask You can adjust the wording of the question by clicking on related options, data fields, and filters in the user interface. 3.2.5The recommended chart type The ask data function can automatically generate a chart display matching the data attributes according to the recommended relevant data information. If the default chart information does not meet your presentation requirements, click on the upper right drop-down menu to select from the supported chart types. Supported chart types: ·Bar chart ·Stacked bar chart ·Line chart ·Stacked line chart ·Area chart ·Stacked area chart ·Scatter plot chart ·Stacked scatter plot chart ·Heat map ·Pie chart ·Donut chart ·3D pie chart ·Nightingale rose chart ·Radar chart ·Color-filled radar chart ·Box-and-Whisker plot chart ·Waterfall chart ·Pareto chart ·Gantt chart ·Histogram chart ·KPI card ·Map ·GIS map ·Table 3.2.6The tical operation of the chart According to the chart results of the ask feedback, the action ability on it can be customized in the ask component setting / ask data chart action. The default action include: swap column&row, named group, export to PNG, zoom, data insight, show data, brush, drill up/down, freeze pane, sort grid column, add to dashboard. 3.2.7Identification of specific statements ·Column attribute identification: dimension column, measurement column, longitude and latitude column, map column, time column. ·Aggregate function: sum, avg, count, accurate distinct count, distinct count, max, min, median, variance, standard deviation, quartile. ·Dynamic calculation: dynamic calculation, diff, percentage, percent difference, percent of total, accumulative totals, moving calculation, rank calculation, percentile. ·Filter criteria: column domain value dimension, numerical value, date and other criteria filtering. ·Compare data: year-on-year, month-on-month, growth value, growth rate. ·Sort: ascend, descend, and in alphabetical order. ·Top n ranking: top n, bottom n. ·Chart type: type supported in the recommended chart types. ·Four operations: plus, minus, multiply, divide, +, -, *, \. ·Time list: today, yesterday, tomorrow, this month, last month, next month, this quarter, last quarter, next quarter, this year, next year, last year, day, monthly, quarterly, year. ➢Example The dataset is a wide data table recording the sales of products in various provinces in China, which includes "market size, product type, product name, province, transaction time, order ID, sales, sales volume, profit, cost, etc.". Users can view the statistics of the data column through the data preview. Users can perform this analysis by entering the following questions. ·Question 1, "Ascending order of total sales volume for each market size this year", translated into "by market size", "sum of sales volume", "sort Market Size in ascending order by sales volume_sum", " filter time to is equal to?{_ THIS _ YEAR _}", generate the bar chart after submission. · Question 2, "Sales in each province minus cost", is translated into "by province" and "sum of (Sales-Cost)", and the map is generated after submission. · Question 3: "total percent of profit of each product type", which is translated into "by product type" and "sum of profit percent of total ", and generates pie chart after submission. 3.2.8 Other ·The ask data interface supports previous and next, and creates multiple title bars for questions in ask mode. ·The results of the ask data feedback are affected by the linkage of the filtering conditions in the dashboard by default, and The ask results can be isolated through the<Setting/Advanced/not involved in data association> on the right side of the component. 4.Ask authorize 4.1Functional profile The ask data function can assign users / groups / roles through permission configuration. These include the use and management of ask data. Ask application: control the use of ask data function and pay the everyone role by default. Ask management: control the use of ask data function, Simultaneously, synonym editing can be performed on dataset column names and domain values, and customize the default question at the default template question. 4.2 Function explain 4.2.1Permission configuration The ask data permission configuration entry is, and the permission information edit / action / view dashboard action. 4.2.2Ask audit Under the audit / system function, the ask data usage statistics dashboard is added to count the information of a dataset in a certain period of time. Managers can know what data users pay more attention to and what indicators they pay more attention to in the monitoring dashboard. For details, please refer to audit> ask data usage statistics. | 
