Market analysis visualization method for import commodity supervision

Abstract

The invention provides an imported commodity supervision-oriented market analysis visualization method, and relates to the technical field of market analysis. The method comprises the following steps: acquiring an import commodity detail table, an import commodity warehousing table and an import commodity ex-warehouse table, and performing data conversion to obtain converted data; carrying out visual mapping and view design based on the three tables; and performing layout and implementation of a visual view based on the visual mapping and view design results. According to the method, time sequence analysis can be performed on data based on a market scale evolution view, and multi-angle data analysis from commodities, enterprises to the market is realized in combination with a market overall feature distribution view, a supplier enterprise feature view and an import commodity detail view. The visuality of data viewing is improved through visual interaction response, data for market scale evolution rules and influence factor analysis can be enriched, the actual conditions and potential risks of the market are accurately reflected, and the accuracy of market data analysis is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of market analysis, and in particular to a market analysis visualization method for import commodity supervision. Background Art

[0002] In the context of globalization and cross-border trade, with the expansion of trade scale and the increase in commodity types, the flow of imported goods faced by regulators has become more complex and diverse.

[0003] In traditional import commodity supervision, regulatory agencies usually rely on inspections, sampling and reporting to ensure the compliance and safety of imported goods. However, with the increasing variety and quantity of imported goods, the traditional methods have shortcomings such as complex operations and poor analysis results, making them unable to meet the needs of large-scale data analysis and processing. At the same time, as the main place for the circulation of imported goods, the market is greatly affected by the quality and compliance of imported goods. The single-dimensional data provided by traditional regulatory methods is often difficult to fully evaluate the market situation and cannot accurately reflect the actual situation and potential risks of the market.

[0004] At present, most of the market analysis visualization methods for import commodity supervision are still at the stage of simple data display and statistical analysis, with a single view design and lack of interactive visualization tools. It is difficult for regulators to complete the import commodity market analysis from multiple angles, discover the law of market size evolution, and effectively associate commodities with markets and enterprises. In addition, the existing methods lack the mining and exploration of the temporal laws of the import market, and it is difficult to meet the data needs for the analysis of the law of market size evolution and influencing factors. Summary of the invention

[0005] In view of the above technical problems existing in the prior art, the present invention provides a market analysis visualization method for import commodity supervision. The specific technical solution includes the following steps:

[0006] Step S1: Obtain an imported goods details table, an imported goods entry table, and an imported goods exit table, and convert the data to obtain converted data;

[0007] Step S2: Perform visual mapping and view design based on the imported goods details table, the imported goods inbound table, the imported goods outbound table and the conversion data table;

[0008] Step S3: Based on the results of visualization mapping and view design, layout and implementation of visualization views are performed.

[0009] Preferably, the imported commodity details table includes commodity code, commodity category, commodity country of origin, commodity entry port, commodity weight and entry date;

[0010] The import commodity entry table includes the entry code, commodity code, warehouse name, warehouse location, entry time, supplier company name and the province and city where the supplier is located;

[0011] The outbound list of imported goods includes the outbound code, commodity code, inbound code, warehouse name, warehouse location, outbound time, consignee company name and the consignee's province and city.

[0012] Preferably, the transformed data obtained through data transformation includes:

[0013] Establish field mapping rules and complete the missing values ​​of corresponding fields according to the mapping rules and field values;

[0014] Delete the commodity records that violate the logical order of entry and exit;

[0015] Calculate the total number of commodity batches and the total weight of imported commodities on a single day based on the imported commodity details table;

[0016] Calculate the respective percentages of commodity categories, commodity countries of origin, and the province or city where the consignee is located;

[0017] Calculate the entry residence time of each commodity batch record based on the entry time and storage time;

[0018] The storage time is calculated based on the storage time and the outbound time.

[0019] Preferably, the view design is specifically a market scale evolution view design, including:

[0020] (1) Overview of Stacked River Chart

[0021] Map the dates that increase by week from left to right in segments, and draw a timeline with corresponding dates marked; set two time period selectors, the outer and inner ones, which divide the time periods in the form of left closed and right open; use dotted lines to connect adjacent time periods to indicate the correspondence between the outer time period selector, the inner time period selector, and the display area and zoom area in the scalable stacked river chart; the left bracket and right bracket of each time period selector indicate the starting point and end point of the selected time period respectively;

[0022] The width of the overview stacked river chart encodes the total number of commodity batches or total commodity weight for the corresponding week;

[0023] By color-coding feature classification, the feature classification includes product category, province or city, source province or city, and country of origin; switching feature classification through feature classification attributes of the control panel; using preset colors to indicate the time period selected by the inner time period selector;

[0024] (2) Scalable stacked river map

[0025] Map the dates in increments of weeks from left to right, with each week divided by a week tick mark, and draw labels at the corresponding week positions above the scalable stacked river chart; for each time period of the time period selector, the leftmost coordinate represents the start date, and the rightmost coordinate represents the end date;

[0026] The total batch quantity or total weight of the goods in the corresponding week by width coding;

[0027] For the zoom area, set a background dotted line parallel to the week scale lines;

[0028] Scalable width, color coding and overview of stacked rivers Figure 1 To;

[0029] (3) Severe Fluctuation Tags

[0030] The trend of change is encoded by label color and shape; a red upward arrow indicates an upward trend, and a green downward arrow indicates a downward trend;

[0031] The change range is encoded by the label radius, and the maximum label radius represents the maximum value of all current change ranges;

[0032] The horizontal coordinate of the label indicates the week when the violent fluctuation occurs, and the vertical coordinate of the label indicates the feature classification corresponding to the violent fluctuation.

[0033] Furthermore, it also includes the interactive design of the market size evolution view, specifically:

[0034] Drag the left and right brackets of any time period selector to display a scalable stacked river view;

[0035] Switch the Classify feature classification property in the control panel to display the overview stacked river view and the scalable stacked river view under the corresponding classification method;

[0036] Switch the Encode attribute on the control panel to switch between the overview stacked river view and the scalable stacked river view with different vertical axis values. The encoding attributes include: product batch quantity and product total weight.

[0037] Modify the display conditions of the violent fluctuation label by switching the Label properties of the control panel;

[0038] Step S3 is specifically as follows:

[0039] Calculate time interval: In the overview stacked river chart, the outer time period selector is used to control the time display range of the scalable river chart, and the inner time period selector is used to control the zoom area and global time range of the scalable river chart; the outer start time startWeek is obtained from left to right through the above two time period selectorsouter 、Inside start time startWeek inner 、Inner end time endWeek inner and the outer endWeek outer ,

[0040]

[0041] In the formula, weekLen outer 、weekLen inner They are outer time length and inner time length respectively;

[0042] Calculate the width of a single cycle unit:

[0043]

[0044] Where noZoomWidth and zoomWidth are the unit width of the non-zoom area and the unit width of the zoom area respectively; viewWidth is the overall width of the scalable stacked river map; largeScale is the zoom ratio of the scalable stacked river map;

[0045] Calculate the X-axis mapping scale riverScale x (week),

[0046]

[0047] range1 = [startWeek outer ,startWeek outer );

[0048] range2 = [startWeek inner , endWeek inner ];

[0049] range3=(endWeek inner , endWeek outer ];

[0050] In the formula, view left is the leftmost coordinate of the scalable stacked river chart, week is the week number, offest1 is the start coordinate of the zoom area, offest2 is the end coordinate of the zoom area, range1, range2, range3 are the intermediate representations;

[0051] week∈[startWeek outer ,endWeek outer ];

[0052] Draw a scalable river map: determine the Y-axis mapping scale according to the Encode attribute value of the control panel; calculate and draw the path data of each river in the overview stacked river map based on the X-axis mapping scale and the Y-axis mapping scale;

[0053] Add drag events on the time period selector to achieve zooming of the zoom area;

[0054] Calculate the radius labelRadius of the violent fluctuation label,

[0055]

[0056] In the formula, volatility is the fluctuation range, volatility max is the maximum fluctuation range, labelBase is the Label attribute of the control panel, labelRadius min The minimum radius of the violent fluctuation label.

[0057] Furthermore, the view design also includes the overall market feature distribution view design, specifically:

[0058] (1) Feature Distribution Connection Sankey Diagram

[0059] The four horizontally distributed characteristic rectangles represent the four classification characteristics of commodity category, commodity country of origin, consignee's province and city, and supplier's province and city respectively;

[0060] The flow between adjacent row feature rectangles indicates that two corresponding classification features appear simultaneously;

[0061] Inside each feature rectangle, the upper and lower parts are provided with time feature line area graphs, which respectively represent the entry residence time distribution and storage residence time distribution of the commodity batches under the classification feature encoded by the feature rectangle;

[0062] The length of the feature rectangle is used to encode the number of product batches corresponding to the classification feature; the width of the stream is used to encode the number of product batches corresponding to the values ​​of the two classification features;

[0063] (2) Time characteristic line area chart

[0064] The time feature line area chart is the same length as the feature rectangle, and the rectangle length is evenly divided from left to right based on the product batches;

[0065] On the right edge of the time characteristic line area chart, the positions of two small rectangles encode the average entry residence time and average storage residence time of the corresponding commodity batch under this value;

[0066] By color-coding the inbound and outbound dwell times of commodity lots;

[0067] Arrange the line points of the time characteristic line area chart according to their values ​​and then draw it.

[0068] Preferably, the interactive design of the overall market feature distribution view is also included, specifically:

[0069] Click a feature rectangle, and the clicked feature rectangle and the connected flow will be highlighted; click again, and the highlight will disappear;

[0070] For each feature classification, add the option to control the number of values ​​taken before classification statistics;

[0071] If the feature classification is modified, the feature distribution and Sankey diagram will be redrawn;

[0072] Step S3 is specifically as follows:

[0073] The feature distribution and Sankey views are set in the middle area, and the control panel is set in the top area; the middle area includes four rows of feature distribution and Sankey views; wherein each feature rectangular node displays the time feature line area view under the feature value.

[0074] Furthermore, the view design also includes the design of characteristic views of suppliers and buyers, specifically:

[0075] (1) Column view of supply and receiving enterprises

[0076] In the supply enterprise column view, different enterprises are coded from left to right;

[0077] The number of batches of goods supplied through highly coded enterprises;

[0078] The receiving company column view is set up in the same way;

[0079] Connect the bar charts representing the same enterprise in the bar chart of the supplying enterprise and the bar chart of the receiving enterprise with lines, and set a dotted frame for the bar chart representing the enterprises in other provinces;

[0080] The supplying companies and the receiving companies are coded separately by different colors.

[0081] (2) Enterprise Distribution Sunrise View

[0082] In the rising sun view of the supply enterprise distribution, the innermost circle is used to indicate the proportion of enterprises in the province and those in other provinces, the middle circle is used to indicate the proportion of enterprises in each city and prefecture in the province, and the outermost circle is used to display the preset number of enterprises at the top of the total batch of goods;

[0083] Encode the quantity of the batch of goods supplied by angle ratio;

[0084] By color coding enterprises from other provinces, enterprises in the province, and enterprises in cities and states in the province;

[0085] The receiving enterprise distribution sunburst view is set up in the same way;

[0086] Between the sunrise view of the supplying enterprise distribution and the sunrise view of the receiving enterprise distribution, there is a rectangular block that encodes the proportion of suppliers and consignees for the same enterprise through height, and borders representing 100% are set at both ends of the rectangular block.

[0087] Preferably, it also includes the interactive design of the characteristic view of the supplier and the receiver, specifically:

[0088] Click any column block in the supply enterprise column view or the receiving enterprise column view, and the clicked column block will be highlighted; click again, and the highlight will disappear;

[0089] If at least one enterprise is selected, the imported product details view corresponding to the selected enterprise will be redrawn;

[0090] Step S3 also includes:

[0091] Connect the bar charts representing the same enterprise in the supply enterprise bar chart and the receiving enterprise bar chart by using a Bezier curve;

[0092] The supply enterprise column view and the receiving enterprise column view are set on the upper part of the supplier and receiving enterprise characteristic view, distributed up and down;

[0093] The supply enterprise distribution sunrise view and the receiving enterprise distribution sunrise view are set at the bottom of the supplier and receiving enterprise characteristic view, distributed left and right.

[0094] Furthermore, the view design also includes the design of the imported product details view, specifically:

[0095] Build a table view that adds color coding;

[0096] The entry and storage dwell times of commodity batches are coded by the background gradient color of the columns;

[0097] The table view has multiple rows and columns, and the display range is the middle of the imported product details view. You can view the overflowed feature classification and data regulations by dragging;

[0098] The table header is located in the first row.

[0099] Preferably, the interactive design of the imported product details view is also included, specifically:

[0100] Set sorting interactions for each column in the table view, including ascending, descending, and unordered sorting;

[0101] Set the first N columns of the table view as fixed columns and drag left and right to view the table overflow information;

[0102] For each column, you can drag the table header to the first N rows to fix it, and drag it up and down to view the table overflow information, N = 1, 2, 3, ...

[0103] The technical solution provided by the present invention can perform time series analysis on data based on the market size evolution view, and combine the overall market characteristic distribution view, the supplier and buyer enterprise characteristic view, and the imported commodity detail view to realize multi-angle data analysis from commodities, enterprises to markets. By improving the intuitiveness of data viewing through visual interactive response, it can enrich the data for analyzing the evolution law of market size and influencing factors, accurately reflect the actual situation and potential risks of the market, and improve the accuracy of market data analysis. BRIEF DESCRIPTION OF THE DRAWINGS

[0104] Figure 1 It is a schematic diagram of the overall process of the market analysis visualization method for import commodity supervision in the present invention.

[0105] Figure 2 Schematic diagram of the visual encoding and visualization layout of the market size evolution view in the present invention.

[0106] Figure 3 It is a schematic diagram of the visual coding and visualization layout of the overall characteristic distribution view of the market in the present invention.

[0107] Figure 4 It is a schematic diagram of the visual coding and visualization layout of the characteristic view of the supplier and collector enterprise in the present invention.

[0108] Figure 5 It is a schematic diagram of the visual coding and visualization layout of the imported product details view in the present invention.

[0109] Figure 6 It is a schematic diagram of the implementation effect and overall layout of the present invention.

[0110] Figure 7 This is a schematic diagram of the interactive design of the market size evolution view in the present invention. DETAILED DESCRIPTION

[0111] The technical solution provided by the present invention will be further elaborated below in conjunction with the accompanying drawings.

[0112] The present invention realizes multi-angle market analysis for import commodity supervision through effective information visualization methods, combined with multi-view linkage strategies and flexible interactive means, helping commodity supervisors to discover the cyclical evolution of market size, analyze the overall characteristics and distribution of the market and their connections, learn the corporate characteristics of related suppliers and buyers in the market, and view the details of imported commodities under specified conditions. The technical solution includes: data acquisition and processing, visualization mapping, visualization layout and implementation, and interactive design.

[0113] like Figure 1As shown, the specific steps are as follows:

[0114] Step 1: Data acquisition and processing

[0115] According to the import commodity supervision data provided by the warehousing and logistics platform, effective information is screened and data is stored.

[0116] 1. Data acquisition: Three related import commodity supervision data are obtained from the warehousing and logistics platform, namely, the import commodity details table, the import commodity entry table, and the import commodity exit table. Among them, the import commodity details table contains: commodity code, commodity category, commodity country of origin, commodity entry port, commodity weight, and entry date; the import commodity entry table contains fields: entry code, commodity code, warehouse name, warehouse location, entry time, supplier company name, and supplier's province and city; the import commodity exit table contains fields: exit code, commodity code, entry code, warehouse name, warehouse location, exit time, consignee company name, and consignee's province and city.

[0117] 2. Data processing: This method uses the relational database MySQL database to store data. Three database tables corresponding to the data set content are constructed and stored in the database, namely the imported goods details table, the imported goods entry table and the imported goods exit table. A series of data cleaning, integration and other preprocessing are performed according to actual needs.

[0118] (1) Data completion: In the above three data tables, some fields are wrong or missing, such as the missing "warehouse entry time" field in some records, which will affect the subsequent calculation of the "entry stay time" and "warehouse entry stay time" fields. This method uses the creation time of the warehouse entry record as a substitute, which is automatically generated by the warehousing and logistics platform. For those fields with a one-to-one mapping relationship, such as "commodity country of origin" and "commodity country of origin code", "commodity entry port" and "commodity entry port code", "warehouse name" and "warehouse code", etc., this method establishes a mapping relationship table for each group of fields with a one-to-one mapping relationship based on the existing data content. For records that are missing one of the fields in the mapping field group, the corresponding mapping relationship table and the value of the other field are used for one-to-one mapping completion.

[0119] (2) Data cleaning: This method deletes and cleans some erroneous inventory records. For example, the inventory entry time of some commodity batches is later than the inventory exit time. These records violate the actual execution order and will have a negative impact on subsequent analysis, so they need to be cleaned.

[0120] (3) Data transformation: This method transforms and integrates some fields in the original data table. In order to better analyze the evolution characteristics of the time series market size, this method calculates the daily "total number of commodity batches" and "total weight of imported commodities" fields based on the imported commodity details table, records the "commodity batch list" field of the day, and the classification and proportion information for fields such as "commodity origin country", "commodity category", and "entry province and city". This method also integrates the fields in the three data tables based on the "commodity code" field, and uses the "entry time" and "warehouse entry time" fields to calculate the "entry residence time" field of each commodity batch record, and uses the "warehouse entry time" and "exit time" to calculate its "warehouse entry residence time" field.

[0121] Step 2: Visual Mapping

[0122] After data acquisition and processing, the market size evolution diagram in the present invention is as follows: Figure 2 As shown, the overall market characteristics distribution view is as follows Figure 3 As shown in the following figure, the characteristics view of the supplier and receiver is as follows Figure 4 As shown in the imported product details view Figure 5 A visual mapping scheme is designed as shown.

[0123] 1. Market size evolution view

[0124] The market size evolution view consists of an overview stacked river chart, a zoomable stacked river chart, a sharp fluctuation tab, and a dashboard.

[0125] (1) Overview of Stacked River Chart

[0126] Position: From left to right, they represent the dates increasing by week. At the same time, a timeline with corresponding dates is drawn below the river chart. The position of the left bracket of each time period selector represents the starting point of the selected time period, and the position of the right bracket represents the end point of the selected time period, while the position of the time period connection line corresponds to the time period selector one by one.

[0127] Width: The width of the river chart above the corresponding position of each date encodes the total number of batches or total weight of goods in that week. The greater the quantity, the greater the width. Whether the total number of batches or total weight of goods is encoded is determined by the Encode property in the control panel.

[0128] Color: The colors of the river map encode different feature classifications of the import goods market. The specific feature classification code is determined by the Classify feature classification attribute in the control panel. The river map encodes up to six colors, so it can only present six feature distributions. In addition, the colors of the two time period selectors and the lines connecting the two time periods correspond one to one. In particular, gray is used to represent the time period interval selected by the inner time period selector.

[0129] Shape: The left side of the time period selector uses square brackets to indicate that the selected time period is greater than or equal to the start point of the time period, and the right side uses small brackets to indicate that the selected time period is less than the end point of the time period (i.e., closed on the left and open on the right). The time period connection uses a dotted line to indicate the corresponding relationship between the two time period selectors and the display area and zoom area of ​​the scalable stacked river chart.

[0130] (2) Scalable stacked river map

[0131] Position: From left to right, they represent the dates that increase by week in the segmented mapping. At the same time, labels corresponding to the weeks are drawn above the river chart. The leftmost position corresponds to the time period start date of the outer time period selector, and the rightmost position corresponds to the time period end date of the outer time period selector. The leftmost position of the middle zoom area corresponds to the time period start date of the inner time period selector, and the rightmost position corresponds to the time period end date of the inner time period selector.

[0132] Width: Stacked rivers with overview Figure 1 The width of the river map encodes the total number of batches or total weight of goods in that week. The specific encoding of the total number of batches or total weight of goods is determined by the Encode property in the control panel.

[0133] Color: Stacked Rivers with Overview Figure 1 The colors of the river map encode the different feature classifications of the import goods market. The specific feature classification code is determined by the Classify feature classification attribute in the control panel.

[0134] Shape: To enable import commodity regulators to quickly find the zoom interval in the zoomable stacked river view, this view adds a background dotted line parallel to the weekly scale line, so that the spacing between the background dotted lines can be used to determine whether it is a zoom interval.

[0135] (3) Severe Fluctuation Tags

[0136] Color: The labels are color-coded for uptrends and downtrends, with red indicating uptrends and green indicating downtrends.

[0137] Shape: The shape of the label also encodes rising and falling trends, with an upward arrow indicating an increase and a downward arrow indicating a decrease.

[0138] Radius: The radius of the label encodes the amplitude of the rise or fall, the larger the amplitude, the larger the radius. The maximum radius of the rising or falling label represents the maximum amplitude of all current rise or fall fluctuations. In particular, the label has a minimum radius to represent the label attribute value in the control panel.

[0139] Position: The horizontal position of the label indicates the week in which the violent fluctuation occurred, and the vertical position of the label indicates which feature category the violent fluctuation belongs to.

[0140] 2. Overall market characteristics distribution view

[0141] This view consists of a feature distribution Sankey diagram, a time feature line area chart, and a control panel, which visualizes the relationship between attribute connections.

[0142] Position: Feature distribution connection The Sankey diagram encodes the main classification features of the four fields (commodity category, city, province and country of origin) with four rows of light gray feature rectangles arranged horizontally. The flow between different rows of feature rectangles indicates the simultaneous occurrence of these two classification features. In particular, all flows from bottom to top also metaphorically represent the transportation flow process of commodity batches from the country of origin to the province and city of entry and then to the commodity warehouse. Inside the feature rectangle, the line area chart in the upper part represents the entry residence time distribution of the commodity batch under this value, and the line area chart in the lower part represents the storage residence time distribution of the commodity batch under this value. In each line area chart, different batches are represented from left to right, and the unit width occupied by each batch is the same, and the stacking is exactly equal to the width of the feature rectangle. On the right edge of the line area chart, the position of the two small rectangles encodes the size of the average entry residence time and the average storage residence time of the batch under this value. The farther the rectangle is from the zero point line in the middle, the longer the time.

[0143] Width: The width of the classification feature rectangle of the feature distribution connection Sankey diagram encodes the number of batches under this value. Between different rectangles, the width of the stream encodes the number of batches of both values. The larger the width of the feature rectangle or stream, the greater the number.

[0144] Color: The time characteristic line area chart uses sky blue to represent the entry residence time, and grass green to represent the storage residence time.

[0145] Height: The height of the line points in the time feature line area chart encodes the length of entry or storage stay time through a logarithmic scale. The higher the height, the longer the time. Because there may be a large number of batches that meet a certain classification feature, resulting in dense line points and affecting the visual effect, this method arranges the line points in the line area chart from high to low according to their values ​​before drawing.

[0146] 3. Supplier and Recipient Enterprise Characteristics View

[0147] This view consists of a supply and collection enterprise column view and an enterprise distribution sunburst view to display the visualization of related enterprises.

[0148] Position: In the supply and consignee enterprise column chart, different enterprises are coded by position from left to right. In the rising sun chart, the innermost circle shows the proportion of enterprises in Sichuan Province and enterprises in other provinces. For the middle circle, if it belongs to Sichuan Province, it shows the proportion of enterprises belonging to different cities and prefectures in Sichuan Province; if it belongs to other provinces, it shows the proportion of enterprises belonging to different provinces, cities and autonomous regions. For the outermost circle, only the top 20 supplier enterprises or consignee enterprises appearing in the column chart are displayed.

[0149] Color: In the supplier and consignee column view, blue and green represent the supplier column view and the consignee column view respectively. In the supplier column view, dark blue encodes the batch quantity of the enterprise as both a supplier and a consignee, and light blue encodes the batch quantity of the enterprise as only a supplier. In the consignee column view, dark green encodes the batch quantity of the enterprise as both a consignee and a supplier, and light green encodes the batch quantity of the enterprise as only a consignee. In the enterprise distribution sunburst view, different provinces, cities or enterprises are color-coded, and the color of the outermost sector is consistent with the color of the adjacent inner sector to avoid too much color clutter.

[0150] Height: In the supply and receipt company column view, the height of the column encodes how many batches the company supplied or received. The larger the height, the more batches there are. For the rectangle between the two sunbursts, the height of the middle area encodes the proportion of batches whose supplier and consignee are the same company. The height of the blue borders on the left and right ends represents 100%.

[0151] Shape: In the two column views, a line is added between two columns belonging to the same enterprise to help regulators more accurately determine which enterprises are truly high-frequency supply and collection enterprises. In addition, if an enterprise is an out-of-province enterprise, a dotted border will be added to the edge of its column.

[0152] Angle: The angle of each sector in the enterprise distribution sunburst view encodes the number of batches of suppliers or consignees belonging to a certain province, city, enterprise or other situations. The larger the angle, the greater the number.

[0153] 4. Imported product details view

[0154] This view is a color-coded table view used to view the batch details (BatchDetail) of imported goods.

[0155] Color: The background gradient color of the "entry_day" and "stay" columns encodes the entry stay time and storage stay time of the batch. The color scales of the two are white gradient sky blue and white gradient grass green respectively. The color corresponding to the maximum value is consistent with the color coding of the feature distribution connection Sankey diagram in the overall market feature distribution view. The "batch" column will be mapped to the color of the corresponding classification with the result of the Classify feature classification attribute of the control panel in the market size evolution view, and its color scale is consistent with the river map.

[0156] Step 3: Visualization layout and implementation

[0157] In the market size evolution view, the layout and implementation of the scalable stacked river chart and the violent fluctuation label are completed; in the overall market feature distribution view, the layout and implementation of the feature distribution connection Sankey diagram and the time feature line area chart are completed; in the supplier and receiver enterprise feature view, the layout and implementation of the supply and collection enterprise column view and the enterprise distribution sunburst chart are completed; in the imported product details view, the layout and implementation of the color-coded table view are completed. The details are as follows:

[0158] 1. Visualization layout of market size evolution view

[0159] This view mainly consists of five parts: an overview stacked river view for overviewing the import commodity market size of the entire period and selecting a time period of interest, a zoomable stacked river view for displaying detailed information on the evolution of the import commodity market size and characteristic distribution, a dramatic fluctuation label that will only be displayed in the zoom area of ​​the zoomable stacked river view to display the characteristic classification and time of dramatic fluctuations in the import commodity market, and a control panel for controlling the display content and presentation form of the above views.

[0160] (1) Implementation of scalable river map

[0161] Time interval calculation: The outer time period selector on the overview stacked river view controls the time display range of the scalable river chart, and the inner time period selector controls the zoom area of ​​the scalable river chart and the global time range. Through these two selectors, you can get four weeks of time information, from left to right are the outer start time startWeek outer 、Inside start time startWeek inner 、Inner end time endWeek inner and the outer endWeek outer Next, use the following formula to calculate the outer time length weekLen outer and the medial time length weekLen inner .

[0162]

[0163] Calculation of weekly sub-unit width: Combined with the Scale property value of the control panel, largeScale, use the formula to calculate the weekly sub-unit width of the non-zoom area and the zoom area.

[0164]

[0165] Where noZoomWidth and zoomWidth are the unit width of the non-zoom area and the unit width of the zoom area respectively; viewWidth is the overall width of the scalable stacked river map; largeScale is the zoom ratio of the scalable stacked river map.

[0166] Define the X-axis mapping scale:

[0167] range1 = [startWeek outer ,startWeek outer );

[0168] range2 = [startWeek inner , endWeek inner ];

[0169] range3=(endWeek inner , endWeek outer ];

[0170] After the above calculation, we get the X-axis mapping scale riverScale of the scalable river map x (week), the formula is as follows:

[0171]

[0172] Where: view left Represents the leftmost starting coordinate of the view; week represents the week number, which can be set in startWeek outer with endWeek outer Any value between them; offest1 represents the starting coordinate of the scaling area, i.e. riverScale x (startWeek inner ); offest2 represents the end coordinate of the scaling area, i.e. riverScale x (endWeek inner ).

[0173] Scalable river map drawing: After confirming the X-axis scale, the linear scale on the Y-axis is determined according to the Encode property value of the control panel. Based on these two scales, the path data of each river in the stacked river map is calculated and drawn using the stack and area methods of d3. In addition, a drag event is added to the time period selector to implement zoom interaction.

[0174] (2) Implementation of violent fluctuation labels

[0175] Label radius calculation: The label radius labelRadius encodes the volatility of the rise and fall. Combined with the Label attribute of the control panel, labelBase is taken. The specific calculation formula is:

[0176]

[0177] Where: volatility max Represents the maximum value of all increases or decreases; labelRadius min The minimum radius of the label representing a sharp fluctuation.

[0178] 2. Visual layout of the overall market characteristics distribution view

[0179] The overall market feature distribution view mainly consists of three parts: the feature distribution connection Sankey view used to display the distribution and connection of commodity batch classification features, the time feature line area view used to obtain the relationship between classification features and entry or storage residence time, and the control panel used to control the number of categories for each field. The layout is mainly divided into two areas, the top area and the middle area. The top area is the control panel. The middle area is covered by the feature distribution connection Sankey view that can be divided into four rows, in which the time feature line area view of the feature is displayed inside each feature node.

[0180] 3. Visual layout of supplier and recipient enterprise feature view

[0181] This view uses two bar charts of supplier and consignee companies to represent the top 20 supplier companies and the top 20 consignee companies respectively, and connects the columns representing the same company in the two bar charts using Bezier curves. In addition, a corporate distribution sunburst view is drawn to represent the provincial and municipal distribution of all supplier companies and consignee companies.

[0182] The supplier and consignee enterprise characteristic view mainly consists of two parts: the supply and consignee enterprise column view for displaying the top 20 suppliers and consignees, and the enterprise distribution sunburst view for displaying the province and city distribution of the enterprises. The layout is mainly divided into two areas, the upper area and the lower area. The upper area is laid out with the supply and consignee enterprise column view representing suppliers and consignees respectively, and the lower area is laid out with the enterprise distribution sunburst view representing suppliers and consignees respectively. Between the two sunburst views, a rectangle is laid out to represent the self-supply and self-consignee ratio of the enterprise.

[0183] Among them, the number of selected enterprises can be adaptively adjusted.

[0184] 4. Visual layout of imported product details view

[0185] The imported product details view consists of a table view with color coding added.

[0186] This view mainly consists of a table with multiple rows and columns, with the table header located in the first row. The display range of the table is limited to the middle of the layout, and the overflowing field information and data rules can be viewed by dragging left and right and up and down.

[0187] After completing the visualization layout and implementation of the above four views, the implementation effect and overall layout of the present invention are as follows: Figure 6 shown.

[0188] Step 4: Interaction Design

[0189] 1. Market size evolution view

[0190] Tip: Tip interaction can display the raw data details of visual elements. Figure 7 As shown, hover the mouse over a flow or a violent fluctuation label to view data details for accurate comparison and analysis. The color of each numerical feature text or part of the category feature text in the prompt box is the same as the color of the visual element corresponding to the numerical feature or the category feature. In addition, the adjustment of the parameters in the control panel will also be reflected in the text content in the prompt bubble.

[0191] Drag in multi-view linkage: Drag interaction can help regulators select the time period of interest for further analysis. When dragging the left bracket of the inner time period selector, the zoom area of ​​the scalable stacked river view changes accordingly. Similarly, when dragging other time period selectors, the scalable stacked river view will also be redrawn synchronously. Both the outer time period selector and the inner time period selector have achieved conflict avoidance, that is, the inner time period selector will not appear outside the outer time period selector and the left bracket will not appear on the right side of the right bracket to ensure the rationality of the analysis. In particular, the gray area between the inner time selectors can be directly dragged, which will ensure that the total length of time selected by the inner time period selector remains unchanged, but the starting point and end point will change accordingly, which can assist regulators in longitudinally comparing the differences in the distribution of market characteristics and time series evolution of imported goods in different time intervals under the same time length.

[0192] Control panel interaction: When you switch the Classify feature classification attribute, the classification method of the stream in the scalable stacked river view and the overview stacked river view will switch. The Classify feature classification attribute has four values, among which: "Type" means classification by "product category", with a total of 6 categories; "City" means classification by "province and city", which will filter out the top 5 "province and city" values ​​and classify other values ​​as "others"; "SourceProvince" means classification by "source province and city", which will filter out the top 5 "source province and city" values ​​and classify other values ​​as "others"; "OriginCountry" means classification by "country of origin", which will filter out the top 5 "country of origin" values ​​and classify other values ​​as "others". When you switch the Encode encoding attribute, the Y axis in the scalable stacked river view and the overview stacked river view will switch the encoding method. The Encode encoding attribute has two values, among which: "Batch" means statistics are calculated according to the number of product batches and mapped to the Y axis; "Weight" means statistics are calculated according to the weight of the product and mapped to the Y axis. When you switch the Scale property through the slider or input box in the control panel (Scale is greater than 1), the scale ratio of the stream in the zoom area of ​​the zoomable stacked river view will be adjusted accordingly. For example, when the Scale is increased, the spacing between the weekly timelines in the zoom area will become larger, and the zoom effect will be more obvious. When the Label property is switched, the display conditions of the violent fluctuation label will change, which may cause the label to decrease or increase. The Label values ​​of "+20%" and "-20%" mean that the violent fluctuation label will be displayed only when the increase is greater than 20% or the decrease is greater than 20%.

[0193] 2. Overall market characteristics distribution view

[0194] Tip: In order to avoid the difficulty in observing the internal line area chart due to the small width of the classification feature rectangle, this method adds a prompt interaction to each classification feature rectangle. If you want to know the specific numerical distribution of the batch quantity, proportion, entry residence time and storage residence time under a certain value, you can hover the mouse over the classification feature rectangle to view the data details for accurate comparison and analysis. Similar to the above prompt interaction, the color of each numerical feature text in the prompt box is the same as the color of the visual element corresponding to the numerical feature.

[0195] Selection of multi-view linkage: The selection interaction can select the classification features of interest for further analysis. When you click on a feature rectangle, the border of the rectangle will turn dark blue. That is, the highlighted state indicates that it is selected, and the stream connected to it will also be highlighted. Click the selected feature rectangle again to cancel the selection. When a feature rectangle is selected, the market size evolution view, imported product details view, and supplier and purchaser enterprise feature view in the present invention will be redrawn according to the product batch data under the value of this field. In addition, the selection interaction allows multiple selections at the same time, and not selecting is equivalent to selecting all.

[0196] Control panel interaction: Since some fields have many possible values, but showing too many rectangular nodes will reduce the visual effect, an option is added to each field to control its Top N values ​​for classification statistics. When the Top attribute is modified, the feature distribution Sankey diagram will be redrawn. When the Top value of a field is N, this article will encode its Top N values ​​as rectangular nodes to draw the feature distribution Sankey diagram. If the field has other values ​​at this time, the other values ​​will be counted together as "other" rectangular nodes. If the field has no other values ​​at this time, this operation will not be performed.

[0197] 3. Supplier and Recipient Enterprise Characteristics View

[0198] Tip: To avoid visual encoding being difficult to detect due to the visual elements being too small, this method adds prompt interactions for columns, sectors, and rectangles. Similar to the above prompt interactions, the color of the text of each numerical feature in the prompt box is the same as the color of the visual element corresponding to the numerical feature.

[0199] Selection of multi-view linkage: Support users to click on the rectangular block of the coded enterprise in the bar chart to select the supplier and recipient enterprise. After clicking the rectangle, the corresponding rectangular border will turn dark blue, that is, highlighted, indicating that the enterprise is selected. Click again to cancel the selection. When selecting an enterprise, the imported product details view in the present invention will be redrawn according to the product batch data of the selected enterprise. The selection interaction allows multiple selections at the same time, and no selection is equivalent to full selection.

[0200] 4. Imported product details view

[0201] Sorting: To help supervisors quickly find specific data in the table, this view adds sorting interactions for columns of fields such as entry residence time, warehousing residence time, commodity weight, entry date, warehousing time, and exit time. These can be set to ascending, descending, or unordered.

[0202] Exploration: Due to limited layout space, supervisors can view other overflowed field value information by dragging left and right, or view hidden data rules by dragging up and down. In particular, the first three columns (commodity code, entry stay time, and storage stay time) are fixed when the view is dragged left and right, and the table header is fixed when the view is dragged up and down. The number of columns or fields that can be fixed can be set specifically.

[0203] The technical solution provided by the present invention can perform time series analysis on data based on the market size evolution view, improve the intuitiveness of data viewing through visual interactive response, enrich the data for analyzing the laws of market size evolution and influencing factors, accurately reflect the actual market situation and potential risks, and improve the accuracy of market data analysis.

[0204] In addition to achieving the above-mentioned beneficial effects, the above-mentioned preferred schemes have also achieved the following beneficial effects: the overall market characteristic distribution view, the supplier and buyer enterprise characteristic view, and the imported commodity detail view can support data analysis from multiple angles and on different time scales through interactive data display, further ensuring the accuracy of the market size evolution law and influencing factor analysis.

Claims

1. A market analysis visualization method for import commodity supervision, characterized in that: The following steps are involved: Step S1: Obtain an imported goods details table, an imported goods entry table, and an imported goods exit table, and convert the data to obtain converted data; Step S2: Perform visual mapping and view design based on the imported goods details table, the imported goods inbound table, the imported goods outbound table and the conversion data table; Step S3: Based on the results of visualization mapping and view design, layout and implementation of visualization views are performed.

2. A market analysis visualization method for import commodity supervision as claimed in claim 1, characterized in that: The details of imported goods include the product code, product category, country of origin, port of entry, weight and date of entry; The import commodity entry table includes the entry code, commodity code, warehouse name, warehouse location, entry time, supplier company name and the province and city where the supplier is located; The outbound list of imported goods includes the outbound code, commodity code, inbound code, warehouse name, warehouse location, outbound time, consignee company name and the consignee's province and city.

3. A market analysis visualization method for import commodity supervision as claimed in claim 2, characterized in that: The transformed data obtained through data transformation include: Establish field mapping rules and complete the missing values ​​of corresponding fields according to the mapping rules and field values; Delete the commodity records that violate the logical order of entry and exit; Calculate the total number of commodity batches and the total weight of imported commodities on a single day based on the imported commodity details table; Calculate the respective percentages of commodity categories, commodity countries of origin, and the province or city where the consignee is located; Calculate the entry residence time of each commodity batch record based on the entry time and storage time; The storage time is calculated based on the storage time and the outbound time.

4. A market analysis visualization method for import commodity supervision as claimed in claim 3, characterized in that: The view design is specifically a market scale evolution view design, including: (1) Overview of Stacked River Chart Map the dates that increase by week from left to right in segments, and draw a timeline with corresponding dates marked; set two time period selectors, the outer and inner ones, which divide the time periods in the form of left closed and right open; use dotted lines to connect adjacent time periods to indicate the correspondence between the outer time period selector, the inner time period selector, and the display area and zoom area in the scalable stacked river chart; the left bracket and right bracket of each time period selector indicate the starting point and end point of the selected time period respectively; The width of the overview stacked river chart encodes the total number of commodity batches or total commodity weight for the corresponding week; By color-coding feature classification, the feature classification includes product category, province or city, source province or city, and country of origin; switching feature classification through feature classification attributes of the control panel; using preset colors to indicate the time period selected by the inner time period selector; (2) Scalable stacked river map Map the dates in increments of weeks from left to right, with each week divided by a week tick mark, and draw labels at the corresponding week positions above the scalable stacked river chart; for each time period of the time period selector, the leftmost coordinate represents the start date, and the rightmost coordinate represents the end date; The total batch quantity or total weight of the goods in the corresponding week by width coding; For the zoom area, set a background dotted line parallel to the week scale lines; The width and color coding of the scalable stacked river chart are consistent with the overview stacked river chart; (3) Severe Fluctuation Tags The trend of change is encoded by label color and shape; a red upward arrow indicates an upward trend, and a green downward arrow indicates a downward trend; The change range is encoded by the label radius, and the maximum label radius represents the maximum value of all current change ranges; The horizontal coordinate of the label indicates the week when the violent fluctuation occurs, and the vertical coordinate of the label indicates the feature classification corresponding to the violent fluctuation.

5. A market analysis visualization method for import commodity supervision as claimed in claim 4, characterized in that: It also includes the interactive design of the market size evolution view, specifically: Drag the left and right brackets of any time period selector to display a scalable stacked river view; Switch the Classify feature classification property in the control panel to display the overview stacked river view and the scalable stacked river view under the corresponding classification method; Switch the Encode attribute on the control panel to switch between the overview stacked river view and the scalable stacked river view with different vertical axis values. The encoding attributes include: product batch quantity and product total weight. Modify the display conditions of the violent fluctuation label by switching the Label properties of the control panel; Step S3 is specifically as follows: Calculate time interval: In the overview stacked river chart, the outer time period selector is used to control the time display range of the scalable river chart, and the inner time period selector is used to control the zoom area and global time range of the scalable river chart; the outer start time startWeek is obtained from left to right through the above two time period selectors outer 、Inside start time startWeek inner 、Inner end time endWeek inner and the outer endWeek outer , In the formula, weekLen outer 、weekLen inner They are outer time length and inner time length respectively; Calculate the width of a single cycle unit: Where noZoomWidth and zoomWidth are the unit width of the non-zoom area and the unit width of the zoom area respectively; viewWidth is the overall width of the scalable stacked river map; largeScale is the zoom ratio of the scalable stacked river map; Calculate the X-axis mapping scale riverScale x (week), range1=[startWeek outer ,startWeek outer ); range2=[startWeek inner ,endWeek inner ]; range3=(endWeek inner ,endWeek outer ]; In the formula, view left is the leftmost coordinate of the scalable stacked river chart, week is the week number, offest1 is the start coordinate of the zoom area, offest2 is the end coordinate of the zoom area, range1, range2, range3 are the intermediate representations; week∈[startWeek outer ,endWeek outer ]; Draw a scalable river map: determine the Y-axis mapping scale according to the Encode attribute value of the control panel; calculate and draw the path data of each river in the overview stacked river map based on the X-axis mapping scale and the Y-axis mapping scale; Add drag events on the time period selector to achieve zooming of the zoom area; Calculate the radius labelRadius of the violent fluctuation label, In the formula, volatility is the fluctuation range, volatility max is the maximum fluctuation range, labelBase is the Label attribute of the control panel, labelRadius min The minimum radius of the violent fluctuation label.

6. A market analysis visualization method for import commodity supervision as claimed in claim 3, characterized in that: The view design also includes the market overall characteristic distribution view design, specifically: (1) Feature Distribution Connection Sankey Diagram The four horizontally distributed characteristic rectangles represent the four classification characteristics of commodity category, commodity country of origin, consignee's province and city, and supplier's province and city respectively; The flow between adjacent row feature rectangles indicates that two corresponding classification features appear simultaneously; Inside each feature rectangle, the upper and lower parts are provided with time feature line area graphs, which respectively represent the entry residence time distribution and storage residence time distribution of the commodity batches under the classification feature encoded by the feature rectangle; The length of the feature rectangle is used to encode the number of product batches corresponding to the classification feature; the width of the stream is used to encode the number of product batches corresponding to the values ​​of the two classification features; (2) Time characteristic line area chart The time feature line area chart is the same length as the feature rectangle, and the rectangle length is evenly divided from left to right based on the product batches; On the right edge of the time characteristic line area chart, the positions of two small rectangles encode the average entry residence time and average storage residence time of the corresponding commodity batch under this value; By color-coding the inbound and outbound dwell times of commodity lots; Arrange the line points of the time characteristic line area chart according to their values ​​and then draw it.

7. A market analysis visualization method for import commodity supervision as claimed in claim 6, characterized in that: It also includes the interactive design of the overall market characteristics distribution view, specifically: Click a feature rectangle, and the clicked feature rectangle and the connected flow will be highlighted; click again, and the highlight will disappear; For each feature classification, add the option to control the number of values ​​taken before classification statistics; If the feature classification is modified, the feature distribution and Sankey diagram will be redrawn; Step S3 is specifically as follows: The feature distribution and Sankey views are set in the middle area, and the control panel is set in the top area; the middle area includes four rows of feature distribution and Sankey views; wherein each feature rectangular node displays the time feature line area view under the feature value.

8. The market analysis visualization method for import commodity supervision as claimed in claim 3, characterized in that: The view design also includes the characteristic view design of the supplier and the receiver, specifically: (1) Column view of supply and receiving enterprises In the supply enterprise column view, different enterprises are coded from left to right; The number of batches of goods supplied through highly coded enterprises; The receiving company column view is set up in the same way; Connect the bar charts representing the same enterprise in the bar chart of the supplying enterprise and the bar chart of the receiving enterprise with lines, and set a dotted frame for the bar chart representing the enterprises in other provinces; The supplying companies and the receiving companies are coded separately by different colors. (2) Enterprise Distribution Sunrise View In the rising sun view of the supply enterprise distribution, the innermost circle is used to indicate the proportion of enterprises in the province and those in other provinces, the middle circle is used to indicate the proportion of enterprises in each city and prefecture in the province, and the outermost circle is used to display the preset number of enterprises at the top of the total batch of goods; Encode the quantity of the batch of goods supplied by angle ratio; By color coding enterprises from other provinces, enterprises in the province, and enterprises in cities and states in the province; The receiving enterprise distribution sunburst view is set up in the same way; Between the sunrise view of the supplying enterprise distribution and the sunrise view of the receiving enterprise distribution, there is a rectangular block that encodes the proportion of suppliers and consignees for the same enterprise through height, and borders representing 100% are set at both ends of the rectangular block.

9. A market analysis visualization method for import commodity supervision as claimed in claim 8, characterized in that: It also includes the interactive design of the characteristic views of suppliers and buyers, specifically: Click any column block in the supply enterprise column view or the receiving enterprise column view, and the clicked column block will be highlighted; Click again and the highlight disappears; If at least one enterprise is selected, the imported product details view corresponding to the selected enterprise will be redrawn; Step S3 also includes: Connect the bar charts representing the same enterprise in the supply enterprise bar chart and the receiving enterprise bar chart by using a Bezier curve; The supply enterprise column view and the receiving enterprise column view are set on the upper part of the supplier and receiving enterprise characteristic view, distributed up and down; The supply enterprise distribution sunrise view and the receiving enterprise distribution sunrise view are set at the bottom of the supplier and receiving enterprise characteristic view, distributed left and right.

10. The market analysis visualization method for import commodity supervision according to claim 3, characterized in that: The view design also includes the imported goods details view design, specifically: Build a table view that adds color coding; The entry and storage dwell times of commodity batches are coded by the background gradient color of the columns; The table view has multiple rows and columns, and the display range is the middle of the imported product details view. You can view the overflowed feature classification and data regulations by dragging; The table header is located in the first row.

11. A market analysis visualization method for import commodity supervision as claimed in claim 10, characterized in that: It also includes the interactive design of the imported product details view, specifically: Set sorting interactions for each column in the table view, including ascending, descending, and unordered sorting; Set the first N columns of the table view as fixed columns and drag left and right to view the table overflow information; For each column, you can drag the table header to the first N rows to fix it, and drag it up and down to view the table overflow information, N = 1, 2, 3, ...

Images