CN111190597A

CN111190597A - Data UE visual design system

Info

Publication number: CN111190597A
Application number: CN201911372387.2A
Authority: CN
Inventors: 张卫民
Original assignee: Tianjin Langtao Technology Co Ltd
Current assignee: Tianjin Langtao Technology Co Ltd
Priority date: 2019-12-27
Filing date: 2019-12-27
Publication date: 2020-05-22

Abstract

The invention provides a data UE visual design system, which comprises: the data management module is used for acquiring source data in a local file uploading mode or a remote database extraction mode, selecting a database needing data connection configuration, generating new data connection information, and storing the acquired source data into the database; the visualization tool design module is used for designing a visualization interactive chart editing tool as a billboard for presenting data; the billboard editing module is also used for importing a billboard installation package from the outside and installing a corresponding billboard; and the visual presentation module is used for receiving an operation instruction of a user on the visual tool, dragging the corresponding interactive chart editing tool according to the operation instruction, and updating and presenting the created data in real time in a designed billboard style. The invention ensures the usability, provides powerful functions of visual analysis, visual exploration and display of data and fully meets all requirements of organizations on data processing and operation analysis.

Description

Data UE visual design system

Technical Field

The invention relates to the technical field of data visualization, in particular to a data UE visualization design system.

Background

Big data has become a national strategy, becomes another national core asset besides the land, sea and air, and big data consciousness has also entered national thinking and enterprise thinking. With the rapid development of big data basic settings, big data technologies and big data applications over the years, big data complexity, technical barriers and implementation difficulty are decreasing year by year, and data applications have many practices and face new challenges no matter from policy-oriented implementation or enterprise-level solutions:

the existing visual design system has the following defects:

(1) broad application scenarios

From the traditional internet and the mobile internet to the internet of things which is mature day by day, from the commercial intelligence field and the public service field to the government decision field, big data are applied in a hundred flowers, and correspondingly, the requirement on the iteration efficiency of data application is higher.

(2) High manpower cost

At present, most suppliers or solution providers capable of providing professional industry application have unique industry expertise, but many of the suppliers or solution providers are not good at data application, and have the problems of high cost, no accumulation, no specialization and high requirement change cost in designing and developing data application by themselves.

(3) New value point challenges

Traditional software supply is accepting the gifts of big data thinking, and such suppliers need to try to provide new value points for users in the big data era, but the problems of difficult use, high learning cost and high price exist in the current BI-scale data application, and the trial and error cycle is slowed down to some extent.

(4) Extremely cool personalized appeal

At present, data application bias analysis reports are more, and the application of emphasis display is less. At the present display stage of positive data results, the market needs a data application product capable of meeting the extremely cool personalized pursuit of users.

(5) The self-designed and developed visual application has high cost, no accumulation, no speciality and high cost of change of the demand.

(6) The existing tool is not easy to use, has high learning cost and is expensive.

(7) The partial analysis reports are more, the tools displayed with emphasis are fewer, and professional data display tools are lacked.

(8) Professional presentation tools do not support privatized deployments, such as DataV.

(9) The method lacks an industry application case where a client is located, and cannot meet the personalized requirements of industry users.

Disclosure of Invention

The object of the present invention is to solve at least one of the technical drawbacks mentioned.

Therefore, the invention aims to provide a data UE visualization design system.

In order to achieve the above object, an embodiment of the present invention provides a data UE visualization design system, including:

the data management module is used for acquiring source data in a local file uploading mode or a remote database extraction mode, selecting a database needing data connection configuration, generating new data connection information, and storing the acquired source data into the database;

the visualization tool design module is used for designing a visualization interactive chart editing tool as a signboard for presenting data, and comprises the steps of setting the attribute value of the signboard and exporting the signboard after the setting is finished; the billboard editing module is also used for importing a billboard installation package from the outside and installing a corresponding billboard;

and the visual presentation module is used for receiving an operation instruction of a user on the visual tool, dragging the corresponding interactive chart editing tool according to the operation instruction, and updating and presenting the created data in real time in a designed billboard style.

Further, the data management module acquires the source data by adopting a local file uploading mode, and the method comprises the following steps: uploading an Excel file or a CSV file, generating a data table, and automatically detecting and judging the data type according to the data content.

Further, the data management module acquires the source data by adopting a remote database extraction mode, and the method comprises the following steps: after the user inputs the host name, the port, the user name and the password, the remote database is connected for data query and extraction.

Further, the data management module is also used for providing a data center and providing a data list viewing function for a user; the data management module is also used for data editing and providing functions of modifying field names, field types and manual updating for users.

Further, the interactive chart editing tool designed by the visualization tool design module comprises: self-service chart design, atlas design, chart filtering and drilling, atlas filtering, sharing and writing and personal information management.

Further, the self-service chart design comprises: chart type, statistical setting, style setting and chart setting; the atlas design includes: chart layout design and atlas management.

Further, the kanban attribute values include: page attribute, show front cover, many screen adaptation forms, the demonstration style and the icon of billboard, wherein, set up the icon, include: information on icons, data, filter content, color, margin, background, title, axis, bar, legend, label, prompt, effect, linkage and highlight, line, mark, area, funnel, pie section, radar axis, bubble, GIS map, heat, general map, dashboard, reading, subtitle, pointer, split line, scale, KPI list, indicator item, indicator value, proportion ring, electronic watch text, word cloud, table, header, web page, video, play, style.

Further, the visual presentation module is used for displaying the prepared chart in real time by a large screen.

The data UE visual design system ensures the usability, provides powerful functions of visual data analysis, visual exploration and display, and fully meets all requirements of organizations on data processing and operation analysis. By means of an open architecture and extremely strong expansion capability, the data UE visual design system supports software and hardware environments of most servers and clients.

(1) Improved data analysis solution

The data UE visual design system provides a complete data analysis solution which is mapped from semantics to data display for a user, assists the user in reasonably planning services, clearly displays data and accurately analyzes trends.

The advanced interactive chart, the exclamatory design mode, the abundant graphic components, the flexible interactive analysis mode and the perfect display mode lead the new direction of the visual analysis, and will conquer each user.

(2) Perfect balance of functionality and ease of use

The data UE visual design system has applicability throughout the whole product design, effectively balances the contradictions between usability and complexity and analysis depth and query breadth, and provides various flexible data analysis modes for different users in an organization.

The decision layer directly reviews the interactive chart by means of a powerful display tool to obtain the service progress condition, analyzes the organization development trend and makes a correct decision by taking data as a basis;

meanwhile, IT personnel get rid of complicated repeated development, finish high-difficulty visual contents by utilizing SQL language and improve the technical and service level.

(3) Cross-platform extensible architecture

The system architecture and the development tool language which are well designed by the data UE visual design system enable the data UE visual design system to be free from depending on the software and hardware environment of the system and to be seamlessly connected with the mainstream database in the industry. By means of efficient background services, the data model can be converted into a uniform data model no matter OLAP (analytical database), ODS (operational data store), OLTP (on-linear processing transactional database) or even Excel, so that a uniform data analysis aperture is provided for a client, and reliable support is provided for rich front-end applications due to the provision of GIS and other extension applications;

the interactive chart is flexible and easy to use, so that non-IT personnel can freely edit visual contents and capture business changes in time; the ubiquitous visual presenter enables the visual content to be displayed perfectly on a computer and also can be displayed in daily offices such as mobile intelligent equipment, and the like, so that data is really carried about and is visualized everywhere.

(4) Comprehensive system and data security protection

The data UE visual design system provides real-time system operation monitoring and effective data access management, so that the data leakage risk is obviously reduced, and the healthy operation of the system is constantly ensured.

(5) Agility to continuous changes in business

The design concept of agile visualization of the data UE visualization design system emphasizes rapid effect and agile response to the change of customer requirements, and provides high cost performance in the whole life cycle for customers compared with customized development or other visualization products.

The effect is earlier achieved, by means of a data UE visual design system, only the quick deployment of a plurality of working days and the allocation and demand of a user are needed, the user can design personalized visual contents by himself, and the investment return is realized more quickly;

the response is faster, and by means of a data UE visual design system, a client can correct a chart in real time according to service development, quickly respond to the service change of the client and accurately reflect the operation condition of organization;

the data UE visualization design system has the advantages that the cost performance is higher, the data UE visualization design system is easy to deploy and use, the user can be assisted to quickly pass through high investment stages such as demand analysis, system development and customer trial, the system maintenance pressure is relieved due to the characteristics of easiness in correction and convenience in maintenance, and low cost and high value of the whole life cycle are provided for the customer.

(6) Lifting the user system to a new height

In recent times, the organization information construction has been effective, and in the face of increasing mass data, the data analysis capability of the original system is obvious day by day, and the ever-increasing data analysis requirements of the organization are difficult to meet.

And through the integrated data UE visual design system, the defects of the original system of a client in 'heterogeneous/multi-data source support, data analysis capability, operation flexibility and data visual analysis and display' can be effectively overcome, the design concept of 'loose coupling and high cohesion' is realized, and the user integration cost is greatly saved.

Additional aspects and advantages of the invention will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the invention.

Drawings

The above and/or additional aspects and advantages of the present invention will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:

fig. 1 is a block diagram of a data UE visualization design system according to an embodiment of the present invention;

FIG. 2 is an architecture diagram of a data UE visualization design system according to an embodiment of the present invention;

FIG. 3 is an interface diagram for inputting SQL statements for query according to an embodiment of the invention;

FIG. 4 is an interface diagram of fields that need to be queried and generating a complete query SQL according to an embodiment of the invention;

FIG. 5 is an interface diagram of information attribute setting according to an embodiment of the present invention;

FIG. 6 is an interface diagram of data attribute setup according to an embodiment of the present invention;

FIG. 7 is an interface diagram of a filter attribute set according to an embodiment of the present invention;

FIG. 8 is an interface diagram of a legend attribute set in accordance with an embodiment of the present invention;

FIG. 9 is an interface diagram of effect attribute setting according to an embodiment of the present invention;

FIG. 10 is a schematic diagram of a pie section setup according to an embodiment of the invention;

FIG. 11 is a schematic view of a radar chart axis arrangement according to an embodiment of the present invention;

FIG. 12 is a schematic diagram of a generic map setup according to an embodiment of the invention;

FIG. 13 is a schematic diagram of KPI settings according to an embodiment of the present invention;

FIG. 14 is a diagram illustrating setting of an index value according to an embodiment of the present invention;

FIG. 15 is a schematic diagram of a word cloud setting according to an embodiment of the invention;

FIG. 16 is a schematic diagram of a table arrangement according to an embodiment of the invention;

FIG. 17 is a schematic view of a billboard lead-in interface according to an embodiment of the invention;

FIG. 18 is a schematic diagram of billboard release in accordance with an embodiment of the invention.

Detailed Description

Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are illustrative and intended to be illustrative of the invention and are not to be construed as limiting the invention.

The invention provides a data UE visual design system, provides a complete set of solution, can effectively integrate the existing data in an enterprise, quickly and accurately provides a report form and provides a decision basis, and helps the enterprise to make an intelligent business operation decision. The invention discloses a data UE visual design system which is a set of business intelligent systems oriented to analysis type application and used as a visual tool set for analysis and display. The product is realized by adopting a B/S framework based on Java + Javascript technology, data is analyzed in a brand-new mode, results are displayed by gorgeous charts, and the relation, the trend and the KPI (Key performance indicator) of the data are revealed by a comprehensive visual angle. The data UE visual design system provides a data analysis function (such as GIS space analysis) with precedence through simple interactive operation without programming, and the whole process of service, data and data value application is realized.

As shown in fig. 1 and fig. 2, a data UE visualization design system according to an embodiment of the present invention includes: the system comprises a data management module, a visualization tool design module and a visualization presentation module.

Specifically, the data management module is configured to acquire source data in a local file uploading manner or a remote database extraction manner, select a database to be configured with data connection, generate new data connection information, and store the acquired source data in the database. The data management module may provide functions for managing data connections, creating data, searching data, and the like.

(1) Managing data connections

The databases supported by the invention include databases such as MySQL, SQLSever, Oracle, PostgreSQL, GreenPlum, Hive2 and the like.

Taking the MySQL database as an example for configuration, the new data connection information is generated after the MySQL database is selected, specifically including the following information, and whether the connection configuration is correct is tested.

Data connection name: the name is customized, and the search can be carried out through the upper search bar.

jdbcUrl: the program links the address information of the database, and the format of the jdbcUrl is different according to the used database.

User name: a database username.

Password: a database password.

Filtering the table: the tables entered in the table filtering are database tables that can be used when creating data, and all tables can be used without filling out defaults.

After the data connection is created, updating information and deleting the data connection may be performed as needed.

The data management module acquires the source data through a local file uploading mode or a remote database extraction mode.

The data management module acquires source data in a local file uploading mode, and the method comprises the following steps: uploading an Excel file or a CSV file, generating a data table, and automatically detecting and judging the data type according to the data content.

The following describes the data table: the data table is generated after connection by using the data account (or directly uploading file data). In the data UE visualization design system, these data tables can be directly used in subsequent visualization authoring, and can also be used as input data of ETL for data post-processing and generating new data tables. In the management list of the data table, the user can: creating a data table (created using a data account or parsing data directly from a file); viewing data table data; editing the connection configuration of the data table (if sql build statement, column name, etc.); and deleting the data table.

Table 1 shows the function and detailed description of local file upload:

TABLE 1

1) Data creation with Excel file as data source

Uploading an excel file required to be used as a data source, entering a data confirmation interface, previewing the file content, and setting a header and a starting column. The name of this data set is set and saved. The saved data set can be subjected to name modification, editing and deletion operations through buttons.

2) Creating data with CSV files as data sources

Uploading a CSV file required to be used as a data source, entering a data confirmation interface, previewing the content of the file, and setting a file code, a header, a separation symbol, a comment symbol and a reference symbol. The name of this data set is set and saved. The saved data set can be subjected to name modification, editing and deletion operations through buttons.

(2) The data management module acquires source data by adopting a remote database extraction mode, and the method comprises the following steps: after the user inputs the host name, the port, the user name and the password, the remote database is connected for data query and extraction.

Table 2 shows the data function descriptions created in SQL direct using remote database extraction.

TABLE 2

The following describes creating data in SQL direct.

Specifically, the data connection to be used is selected, a new connection is created at this point, or the data connection is modified by clicking on the gear icon. The input SQL interface can set query statements and preview query results, and after the preview result set is executed without errors, the set query statements can set the result set in two ways:

the first method is to input SQL statements in an input box for query, and the method is suitable for multi-table association query, such as FIG. 3. The second method is to select the field to be queried in the right list and generate the complete query SQL, and this method is suitable for single-table queries, as shown in fig. 4.

Setting data and name and saving, and the saved data set can be subjected to name modification, editing and deletion operations through buttons.

In addition, the data management module is also used for providing a data center and providing a data list viewing function for a user; the data management module is also used for data editing and provides functions of modifying field names, field types and manual updating for users.

Table 3 gives a list of functions and a detailed functional description of the data center and data boundaries.

TABLE 3

The visualization tool design module is used for designing a visualization interactive chart editing tool as a signboard for presenting data, and comprises the steps of setting the attribute value of the signboard and exporting the signboard after the setting is finished; the billboard editing module is also used for importing a billboard installation package from the outside and installing a corresponding billboard.

The following explains the signboard:

in the data UE visualization design system of the present invention, there are various forms of signboards, interactive reports, interactive PPTs, data applications or data widgets, collectively referred to as "signboards". The billboard in the invention can be presented as various forms of visual and interactive reports, from simple dashboards to interactive subject reports to cool and dazzling large screen displays.

The method supports the adjustment of the layout position and size of the visual elements in the canvas space through mouse dragging or keyboard control, and can also input numerical values in the setting area for accurate positioning, even can perform 3D rotation on the elements; supporting adjustment of hierarchy, replacement, duplication, and deletion.

In the billboard of the data UE visual design system, charts, characters, picture media and the like are collectively called as visual elements and are used for supporting the theme of a data story or beautifying visual display. According to the invention, data needs to be provided for the visual elements, and for the chart needing to be provided, a data UE visual design system provides a data configuration panel to assist a user in completing configuration quickly.

The visual element style feature of the present invention provides rich style settings, all of which are developed in the form of small panels, allowing the user to set more details, including: the drawing edge is marked with labels from the background title axis and is specified as "bar", "line", "mark", etc. The high-level effect setting is provided for the billboard pursuing visual display: mixing and filtering. The mixing can complete the superposition processing of different elements; the filter may further enhance the visual appearance of the element layer. The mixing comprises the following steps: color filtering, overlaying, saturation, soft light, bright light, positive lamination, color deepening, and the like; the filter includes: shadow, blur, brightness, contrast, saturation, color, etc.

In addition, the chart of the system is data-driven, so that the system naturally has the linkage capability, and a viewer of the billboard can view data details, pay attention to key elements and search data problems in a deeper level by matching drilling and highlighting.

The following describes the process of creating a billboard:

and (3) newly building a billboard application, wherein the name of the billboard can be modified by editing the modification buttons below, the four buttons in the middle of the billboard application are respectively 'preview', 'release', 'copy' and 'delete', and the billboard application is clicked to enter the editing mode to start to manufacture the billboard. The method comprises the steps of setting page attributes after entering a billboard editing page, setting a display cover, whether the billboard is manufactured in a multi-screen adaptive mode, a display style page mode or a screen resolution mode of the billboard, pictures, colors and nine-grid grids of a background, and providing convenience for manufacturing the billboard through an auxiliary function, setting rows and columns of the billboard grids to divide the billboard into rows and columns, zooming and moving the size of the chart along the square lines in the process of manufacturing the chart, switching a click chart by icons of a pointer and a palm and dragging the whole page, wherein the page can be zoomed according to the proportion by the zooming proportion.

The types of charts supported by the kanban of the present invention include: the method comprises the steps of column diagrams, funnel diagrams, line diagrams, pie charts, polar seat diagrams, scatter diagrams, GIS maps, common maps, KPI texts, common texts, word segmentation texts, conventional tables, webpage embedded in media, pictures embedded in media, videos embedded in media and filtering.

In an embodiment of the invention, the kanban attribute values include: page attribute, show front cover, many screen adaptation forms, the demonstration style and the icon of billboard, wherein, set up the icon, include: information on icons, data, filter content, color, margin, background, title, axis, bar, legend, label, prompt, effect, linkage and highlight, line, mark, area, funnel, pie section, radar axis, bubble, GIS map, heat, general map, dashboard, reading, subtitle, pointer, split line, scale, KPI list, indicator item, indicator value, proportion ring, electronic watch text, word cloud, table, header, web page, video, play, style.

(1) Information: basic information of the components, titles of the components and the positions of the components in the billboard can be set, the components can be moved to appropriate positions in a manual dragging mode, and a 3D effect can be achieved by setting a rotation angle, as shown in FIG. 5.

(2) Data: the data source used for making the bar graph can be set, the value is taken, the upper limit of the display data such as a chart for making TOP10 can be set to 10 after the fields are sorted in the reverse order, the query frequency of the data can enable the chart to realize that the functional unit for refreshing the data at fixed time is second, and 0 is not refreshed, as shown in FIG. 6.

(3) And (3) filtering: the result set used can be filtered to filter out what is not needed to be displayed in the graph, and the display efficiency of the icons can also be increased, as shown in fig. 7.

(4) Color: the main colors for the chart are selected, and the use sequence of the colors is from left to right and from top to bottom. Clicking the color may enter the palette to adjust the current color.

(5) Edge distance: and adjusting the distance between the chart content and the chart outer frame.

(6) Background: the picture, color and grid of the nine palaces can be arranged as the page background. The background picture can set transparency, zooming mode, filling strategy and picture position. The background color may be entered into the palette to adjust the background color and transparency. The nine-grid is used for being arranged as a frame, and the icon is stretched to be used as the frame through the coordinates of the upper left corner and the lower right corner of the arrangement assembly.

(7) Title: the display, position, and text attribute of the title are set, and the text content of the title may be set in the above-mentioned "information".

(8) Shaft: and setting the attributes of a horizontal axis, a vertical axis and an auxiliary axis. The value range of the chart can be correspondingly zoomed by setting the adaptive value range attribute, and the fluctuation of the value across the large chart display can be clearer. The arrangement of the grids can prolong the scale marks, and the comparison is convenient under the condition that the lengths of the column diagram type diagrams are not large. The shaft label can be set to display, and the rotating angle and other style settings. Text may set text attributes.

(9) Column bar: the bar width, minimum height, and filling color of the bar graph can be set.

(10) Legend: whether a legend is displayed, the location of the display, the legend text attributes, and the legend type may be set, as shown in FIG. 8.

(11) Labeling: setting whether to display a value, a display position, and a character attribute in a graph

(12) And (4) prompting: and setting whether to display the content of the position of the mouse pointer when browsing the billboard or not, and displaying the position, the frame style and the character attribute.

(13) The effect is as follows: setting event penetration, mixing effect, filter effect, and mask property of the chart. The event penetration attribute may be that after being turned on, the visual element will not respond to any mouse/touch event, but these interaction events may penetrate itself to reach the underlying elements, and the blending effect, filter effect, etc. may beautify the diagram in visual effect, as shown in fig. 9.

(14) Linkage and highlight: whether the chart participates in linkage activities among the charts or not and whether highlight display is carried out during data linkage or not are set.

(15) Line: the line type, line color, line width, transparency, and shading effect of the line graph are set.

(16) Marking: the shape, size and angle of the line graph nodes are set.

(17) Area: the color, transparency and shading effect of the pattern formed between the lines and the coordinate axes are set.

(18) A funnel: and setting data sequencing, graph spacing, alignment mode and maximum and minimum sizes of graphs of a funnel graph main body funnel.

(19) A cake sector area: the arrangement order, the start angle, the minimum fan angle, etc. of the pie chart are set as shown in fig. 10.

(20) Radar axis: radar chart shapes, styles, axis labels, and text attributes are set as shown in fig. 11.

(21) Air bubbles: the bubble size and pattern of the bubble map are set.

(22) And (3) GIS map: and setting attributes of a map provider used by the GIS map, WMTS service, whether to start mouse zooming, translation roaming and the like.

(23) Heating power: and setting the thermal size, fuzzy distance, transparency, visual coding and other attributes in the thermal map.

(24) A common map: the map level used, whether to turn on mouse pinch and pan, text properties of tags, region style, etc. are set as shown in fig. 12.

(25) Instrument panel: and setting the attributes of the instrument panel such as the primary color, the thickness, the number of the segmentation sections, the center coordinates, the starting and stopping angles, the growth mode and the like.

(26) Reading: and setting the attributes such as arrangement, format and character attribute of the display reading.

(27) Subtitle: and setting attributes such as subtitle content, position, character attributes and the like displayed in the chart.

(28) Pointer: and setting the length, width, style and other attributes of the pointer.

(29) Dividing the lines: whether the attributes such as the dividing line and the style of the dividing line are displayed or not is set, and meanwhile, the dividing number of the dividing line is set in a 'instrument panel'.

(30) Scale mark: whether a scale mark is displayed in each divided region is set, and attributes such as segment number and style are set.

(31) And (3) calibration: whether to display the scale and the character attribute and other attributes are set.

(32) KPI, setting character attribute, margin, position, and whether to reduce prefix and suffix of KPI value, as shown in FIG. 13.

(33) KPI list: and setting the list layout, the item layout background and other attributes of the KPI list.

(34) Index items: and setting character attributes, margins, positions, whether to narrow down prefixes and suffixes and other attributes of the index items.

(35) Index value: the character attribute, margin, position, whether or not to narrow down the suffix, and the like of the index value are set as shown in fig. 14.

(36) Ratio ring: the arrangement sequence of the ratio rings, the main color and the ground color of the ring, the initial angle, the minimum angle, the center coordinate, the inner radius and the outer radius and other attributes are set.

(37) Electronic watch text: and setting the time format, character attribute, margin, position and other attributes of the electronic watch display.

(38) Text: and setting the character attributes, margins, positions and other attributes of the text control.

(39) Word cloud: attributes such as style size of the word cloud are set as shown in fig. 15.

(40) Table (b): attributes such as table attribute, text attribute, and the like of the conventional table are set as shown in fig. 16.

(41) A meter head: the header attribute of the conventional table is set.

(42) Web page: and setting the attributes such as the website of the embedded webpage.

(43) Video: and setting attributes such as video addresses, playing modes and the like of the embedded videos.

(44) And (3) playing: and setting the playing mode of the data playback device.

(45) The style is as follows: setting the display style of the data player.

In an embodiment of the present invention, an interactive chart editing tool designed by a visualization tool design module comprises: self-service chart design, atlas design, chart filtering and drilling, atlas filtering, sharing and writing and personal information management.

Wherein, self-service chart design includes: chart type, statistical setting, style setting, chart setting.

Table 4 type of chart and corresponding functional description.

TABLE 4

Table 5 shows the function and details of the statistical setting.

TABLE 5

Table 6 shows the function and details of the style setting.

TABLE 6

Table 7 shows the function and details of the chart setup.

TABLE 7

The design of the atlas includes: chart layout design and atlas management, as shown in Table 8.

TABLE 8

Filtering and drilling of graphs, filtering of atlas, as shown in table 9, each function description.

TABLE 9

Table 10 is a detailed functional description of sharing and composition.

Watch 10

The personal information management displays all information, name, head portrait, contact information, authority details, etc. of the user, and provides the user with functions of modifying a nickname, changing a binding Email, inviting a new member, and viewing a status, as shown in table 11.

TABLE 11

Specifically, the visual presentation module is used for displaying the prepared chart in real time by updating data on a large screen. Table 12 is an illustration of large screen presentation, large screen setup, and supporting chart types.

TABLE 12

In the present invention, a leading-in/out function of the signboard may be further provided. That is, the arranged kanban is led out, or the arranged kanban is led out from the outside.

(1) Sign leading-out

And selecting the signboard to be exported on a display interface, entering an export preview interface, checking the exported signboard application, the data used by the signboard and the data connection, and then finishing export, wherein the exported file is a zip compressed packet.

(2) Introduction of billboard

Selecting (installing from the outside) button and loading the kanban package (zip export file), and finishing the importing of the kanban by viewing kanban application to be imported, the used data and the used connection in a kanban installation interface, as shown in fig. 17.

According to the user's idea, the bulletin board can be selected to be published in a public manner in the data UE visualization design system of the present invention, as shown in fig. 18. This will result in a connection URL that allows public access, by which anyone can view the billboard contents. The third party application can be integrated into the owned system by means of simple IFrame embedding. The data UE visualization design system can develop an OAUTH 2.0-based open authorization standard according to the user needs, and can be connected with a third-party application system, so that the access of a downstream user group can be controlled on the premise of higher safety.

The invention can also realize case release, namely the data UE visual design system of the invention has the user account with specific role, it has authority to release the own kanban as the data UE visual design system case, the users in the system can check the cases at any time, meanwhile, through simple data mapping operation, any user in the system can connect the case as the own kanban.

In conclusion, the data UE visual design system adopts innovative design, provides a humanized design mode and interface, and gives consideration to the usability and the use flexibility of the system. The method realizes the binding of graphic component selection, data dimension and measurement through full dragging, provides hundreds of graphic components and hundreds of graphic attribute settings, and assists a user to quickly create the most accurate and applicable chart.

The invention can be widely connected with various databases, and mainstream relational databases such as Oracle, MySQL, SQLServer and the like can be used as data sources for analysis. A plurality of data source data can be connected in a chart at the same time, so that cross-system and cross-database comprehensive analysis is realized, and data integration analysis and application are effectively realized. The design and preview of the data UE visual design system are realized based on a web browser, and a user does not need to install any additional plug-in or program. The design and development work of the visual interactive chart can be realized by adopting a mouse dragging mode. The chart making work can be completed only by dragging the graphic assembly to the stage area and dragging the corresponding dimensionality and measurement in the model to the attribute area of the graphic assembly. The drilling and the linkage of the corresponding graph can be completed only by clicking one mouse. And (3) data filtering, namely only dragging the filtering component or directly setting one or more filtering conditions in the attribute area of the graphic component. The whole development does not need any programming work, and is quick and efficient without complex training.

The user can quickly achieve proficiency and proficiency, and the development and use cost is greatly reduced. The data UE visual design system designer has rich graphic components, each type of the graphic components has rich chart styles, effects and attribute settings, the graphic components can be expanded into hundreds of graphic components through style setting, and users are supported to create chart styles which accord with application habits and original system styles of the users. Aiming at different display targets, a user can select an optimal graphic component to correctly display data, and the data is highlighted with information, so that the user can quickly understand the data value and make a correct decision. The data UE visual design system supports multi-type graphic data linkage and clearly shows data relation; the various graphic assemblies can select and set the linkage conditions, so that the main assembly clicks/selects the corresponding graphic data area, and the associated assemblies are subjected to linkage change. By means of graph linkage, association analysis of graph data is achieved in multiple directions, a user is assisted in analyzing data relations, and data values are fully mined. The data UE visual design system fully fuses geographic position data and service data through a GIS component, takes geographic information as a bluebook, displays multidimensional service data on a map, facilitates users to sense the data from a spatial angle, analyzes the relation between layer information and the service data, compares service development conditions of different areas, comprehensively controls organization development states, and excavates internal association of the data. Meanwhile, as one of graphic components of a data UE visual design system, bidirectional linkage with other graphic components is supported. The complete function of the GIS map information and data UE visual design system is combined, so that the data relation and the internal meaning can be read and understood more clearly. The data UE visual design system provides page layout components, filtering components and other extension components. The method is convenient for users to reasonably display the page, filter irrelevant data and clearly reflect the change of key data.

The data UE visual design system of the embodiment of the invention integrally adopts a B/S framework, has safe, stable and efficient platform, realizes high cohesion and low coupling among modules and has good cross-platform performance. The platform design takes a user as a leading factor, adopts a B/S framework and a Web2.0 technology, and ensures smooth and rich user experience. The data UE visualization design system can realize higher performance and support main stream databases such as Mysql, Oracle and SqlServer. Rich chart styles and chart functions. The column diagram, the pie diagram, the stack diagram, the area diagram, the instrument panel, the thermometer diagram and other graphic types support the linkage of the graphics, and the data display and analysis are more flexible and clear. The chart designer is completely realized based on the Js technology, the effect is more gorgeous, the dragging is smoother, and the function is stronger. The platform supports various mainstream operating system platforms such as Windows series and Linux series in an all-round manner, and has good cross-platform capability. The invention can connect data from various sources, convert the data into an interactive billboard which is easy to read and extremely has visual expressive force, and integrate the interactive billboard into a complete data workflow. The data may be Excel spreadsheets, various relational databases such as Mysql, Oracle, SqlServer, PostgreSQL, etc., or data warehouse products such as greenplus, etc., or even from existing web services and data api within an enterprise. With the help of data UE visualization design systems can easily connect to them, visualize and discover important data knowledge, and share and collaborate with others as needed.

The data UE visualization design system provided by the embodiment of the invention can be used for more intelligently, intuitively and simply meeting the requirements of omnibearing data display analysis by applying an advanced data visualization technology, and is widely applied to commercial intelligent systems in various fields. The data UE visual design system provides a driving force for processing data through the whole process of realizing business, data and data value application, so that an enterprise can better use the data and display a statistical analysis result, the enterprise is helped to fully utilize the data to improve decision quality, and an ideal target is achieved.

(1) Improved data analysis solution

(2) Perfect balance of functionality and ease of use

(3) Cross-platform extensible architecture

(4) Comprehensive system and data security protection

(5) Agility to continuous changes in business

(6) Lifting the user system to a new height

The data UE visual design system provided by the embodiment of the invention has the following product technical indexes:

(1) performance and extensibility

And a multi-thread working mode is adopted, and multi-CPU resources of hardware equipment are fully utilized. And multi-user concurrent operation is supported, and the concurrent number is determined by the maximum connection number of the application server. The system can run on virtualization software supporting cloud computing technology; supporting mainstream databases such as Oracle, SQLServer, MySql and the like; support for mainstream browsers such as Chrome, IE (IE10 and above), FireFox, Netscape, Opera.

(2) Integration and expansion capability

Easy integration, easy to use, and high openness.

(3) Deployment and management tool

The front-end application does not need to install additional product plug-ins.

(4) Data presentation function

Supporting data filtering;

a plurality of high-level functions with rich functions supporting various aspects of mathematics, text processing, date processing and logic functions.

(5) Data visualization functionality

Visual dragging is supported, drilling of a non-programming graph is supported, linkage of the non-programming graph is supported, and mouse hovering information prompt is supported;

support data filtering (global/local);

an embeddable portal or application system supporting personalized changes (changing metrics or types);

the method can support various rich graphic components such as multi-coordinate shaft support, three-dimensional graphs, column/bar/broken line/pie conventional graphs, stacking/area/bubble/hot spot graphs, radar maps/tree graphs, instrument panels, line point/column line combination graphs, population pyramids and the like.

(6) Mobile application functionality

The graph has exquisite and smooth display effect and supports visual reading.

The data UE visual design system is an output terminal of a data workflow, and helps an enterprise to continuously extract data value based on data by performing visual code conversion on the data.

1. Interconnection of multiple data

The data UE visual design system can be connected easily no matter the data is file data, a relational database or a larger data warehouse.

2. Self-service with full participation

The product is designed for the enterprise members, a modeling process is not needed, complex BI concepts are removed, and anyone can use the product quickly. The kanban results can be used not only to drive business decisions, but also to enable individuals to act as performance-enhancing aids.

3. Visual interactive billboard

The visual design system billboard for the data UE assists in insights of data in an optimal mode, namely, the data can be quickly created and analyzed, and can also pursue to achieve the ultimate visual display.

4. Flexible system integration and deployment

Plugging and unplugging as required, and the system can be applied to an OEM complete platform and can also be integrated in a module form. And public/private cloud deployment and private deployment are supported at the same time.

5. Expansibility: the high expansion capability is provided so as to adapt to various application scenes and individual requirements of users; the extensible visual component meets the data display of a specific scene;

6. interactivity: ensuring data interaction feedback, assisting data exploration, data early warning and equipment scheduling;

7. self-service: the user designs by self and deposits the service template;

8. the method has complete large-screen design and display capability and rich visual effect setting;

9. the system has the capability of visual interactive linkage, and is suitable for more use scenes;

10. data connection and modeling from agile BI technology

11. Data, design and display are separated, and the system module is pluggable and expandable.

In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.

Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present invention, and that variations, modifications, substitutions and alterations can be made in the above embodiments by those of ordinary skill in the art without departing from the principle and spirit of the present invention. The scope of the invention is defined by the appended claims and equivalents thereof.

Claims

1. A data UE visualization design system, comprising:

2. The UE visualization design system of claim 1, wherein the data management module obtains the source data by uploading a local file, and the method comprises: uploading an Excel file or a CSV file, generating a data table, and automatically detecting and judging the data type according to the data content.

3. The UE visualization design system of claim 1, wherein the data management module obtains the source data in a remote database extraction manner, comprising: after the user inputs the host name, the port, the user name and the password, the remote database is connected for data query and extraction.

4. The UE visualization design system of claim 1, wherein the data management module is further configured to provide a data center providing a data list viewing function to a user; the data management module is also used for data editing and providing functions of modifying field names, field types and manual updating for users.

5. The UE visualization design system of data of claim 1, wherein the interactive chart editing tool designed by the visualization tool design module comprises: self-service chart design, atlas design, chart filtering and drilling, atlas filtering, sharing and writing and personal information management.

6. The data UE visualization design system of claim 1, wherein the self-service chart design comprises: chart type, statistical setting, style setting and chart setting; the atlas design includes: chart layout design and atlas management.

7. The data UE visualization design system of claim 1 wherein the kanban attribute values comprise: page attribute, show front cover, many screen adaptation forms, the demonstration style and the icon of billboard, wherein, set up the icon, include: information on icons, data, filter content, color, margin, background, title, axis, bar, legend, label, prompt, effect, linkage and highlight, line, mark, area, funnel, pie section, radar axis, bubble, GIS map, heat, general map, dashboard, reading, subtitle, pointer, split line, scale, KPI list, indicator item, indicator value, proportion ring, electronic watch text, word cloud, table, header, web page, video, play, style.

8. The UE visualization design system of claim 1, wherein the visualization presentation module is configured to present the created chart with a large screen in real-time updated data.