CN110059132A - A kind of data analysis display systems of intelligence water affairs management platform - Google Patents

A kind of data analysis display systems of intelligence water affairs management platform Download PDF

Info

Publication number
CN110059132A
CN110059132A CN201910298709.7A CN201910298709A CN110059132A CN 110059132 A CN110059132 A CN 110059132A CN 201910298709 A CN201910298709 A CN 201910298709A CN 110059132 A CN110059132 A CN 110059132A
Authority
CN
China
Prior art keywords
data
analysis
display systems
theme
show
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201910298709.7A
Other languages
Chinese (zh)
Inventor
牛豫海
张自力
张强
张增烁
田志民
李存昌
李玉宝
张鹏程
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
HECIC WATER INVESTMENT CO Ltd
Chengdu Jiuding Credit Suisse Polytron Technologies Inc
Original Assignee
HECIC WATER INVESTMENT CO Ltd
Chengdu Jiuding Credit Suisse Polytron Technologies Inc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by HECIC WATER INVESTMENT CO Ltd, Chengdu Jiuding Credit Suisse Polytron Technologies Inc filed Critical HECIC WATER INVESTMENT CO Ltd
Priority to CN201910298709.7A priority Critical patent/CN110059132A/en
Publication of CN110059132A publication Critical patent/CN110059132A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/26Visual data mining; Browsing structured data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/06Electricity, gas or water supply

Abstract

The invention discloses a kind of data of intelligent water affairs management platform to analyze display systems, which at least shows the analysis data of a water utilities analysis theme;Theme is analyzed for each, the workflow of the display systems includes: A. data preparation stage: by choosing source data, and the source data of selection being pre-processed, to determine data required under corresponding analysis theme;B. premise testing stage: the data prepared data preparation stage are tested, and after upchecking, execute C;C. task submits the stage to: Xiang Houtai submits analysis task to, with the analysis for the data that the complete paired data preparation stage is prepared;D. data show the stage: showing analysis result.This system can provide the convenient and fast water utilities data display systems of operation, and shown result has customization, and data understand.This system is set with premise test stage, can test to analysis environment, to save overhead in the case where guaranteeing system stability.

Description

A kind of data analysis display systems of intelligence water affairs management platform
Technical field
The present invention relates to water utilities field of information management, especially a kind of data analysis of intelligent water affairs management platform shows system System.
Background technique
Centralized management for water utilities data often relates to big data treatment process, and for the tune of data after processing With being dependent on the bandwagon effect of data.Intuitively, clear, convenient and fast display systems can play the application to data good Support effect;Conversely, display systems complicated for operation, that displaying is chaotic, data are unclear, then not only influence user experience, can also Prevent data from being utilized well.
Summary of the invention
Goal of the invention of the invention is: in view of the above problems, providing a kind of water utilities data exhibition of tool property Show system, to achieve the effect that customize ground data mining, analysis and displaying, provides good displaying circle for the calling to data Face.To provide bandwagon effect that is clear, convenient, customizing for the calling to water utilities data.
The technical solution adopted by the invention is as follows:
A kind of data analysis display systems of intelligence water affairs management platform, the display systems at least show a water utilities analysis theme Analysis data;Theme is analyzed for each, the workflow of the display systems includes:
A. data preparation stage: by choosing source data, and the source data of selection is pre-processed, to determine corresponding analysis Data needed under theme;
B. premise testing stage: the data prepared data preparation stage are tested, and after upchecking, execute C;
C. task submits the stage to: Xiang Houtai submits analysis task to, with the analysis for the data that the complete paired data preparation stage is prepared;
D. data show the stage: showing analysis result.
By the selection to source data, the object of analysis can be determined, then correspond to analysis theme and filter out accordingly Data can determine the element of analysis, realize the customization of data.It is examined by premise, can verify whether have analysis Condition, to avoid subsequent unnecessary system operations.By submitting to task execution data to analyze and showing, i.e., display systems belong to Passive triggering type system, the display systems of " application system " the only operation when submitting application to, rather than to totally according to analyzing can be with Reduce overhead, it is ensured that the efficiency of system operation, while reducing system operating load.If being set with dry analysis master in this system Topic further improves the customization of data analysis, convenient for the algorithm customization for various analysis themes and shows framework customization.
Further, above-mentioned analysis theme includes total industrial output value theme and/or cost analysis theme.
The displaying of total industrial output value theme and cost analysis theme is isolated, it can be to the analytic process of two main bodys It is customized with displaying interface, to meet different analysis requirements.Simultaneously as boundary can be shown for different themes The differentiation in face, it can be ensured that the interface shown is more matched with analyzed theme.So that bandwagon effect is clearer, operation It is more convenient.
Further, the above-mentioned source data to selection pre-processes are as follows: data search is carried out to source data, it will be required Data are extracted in designated memory cell from source data.
By pretreatment, the data needed for analysis can be extracted from source data, and then in the data source of analysis On achieve the effect that customization.And required data are written in designated memory cell, it on the one hand may insure executing analytic operation When, to the convenience and high efficiency of data call, on the other hand, it is also convenient for the retrospect and release to analysis data.
Further, the above-mentioned data prepared data preparation stage are tested are as follows: the verifying specified storage is single Member whether there is, and if it exists, then upcheck.
For being built with corresponding storage unit in the processing of source data, the premise inspection herein for displaying is set in front Be set to verify the storage unit whether there is, process is convenient, fast, have high accuracy;And test effect height, required operand It is small.
Further, above-mentioned data show that the stage includes the displaying option analyzed log and/or analyze result, pass through choosing Different options is selected, corresponding data are shown.
It, can be in order to be traced to analytic process for setting analysis log in the data displaying stage, and then reach several According to the purpose of verifying and process optimization.Log and result setting are triggered by the mode of option, can effectively save interface money Source to show most valid data (user's data of concern) in the same time for client, while can ensure that log again Relevance between result is convenient for two item data of user's quick calling.
Further, the analysis result of above-mentioned total industrial output value theme is divided into the first show area and the second show area, described First show area shows several representative items, and second show area corresponds to several items that represent in the first show area Value shows the value of analysis result.
The data that second show area is shown play chess respectively to represent in show area the value of item, in this way, just by two The value of show area is associated with, meanwhile, and be isolated in showing interface, distinguish the factor and function.In this way, can be with So that showing the factor that is more intuitive, while recognizing impact analysis result convenient for user again for analysis result.
Further, in above-mentioned first show area it is described it is several represent in item at least one of represent the value of item can be by It adjusts.
The program can intuitively reflect that each influence for representing item to analysis result is worth.
Further, above-mentioned second show area includes the first pane, the second pane and third pane;The first pane exhibition Show that total industrial output value corresponds to the actual value of source data and corresponding to each predicted value represented under item;Second pane shows monthly structure At the gain term in the representative item of the total industrial output value of prediction and are dependent in the first pane in declining profit item, corresponding month Selected month;Third pane shows the selected history value for representing item in the first show area.
Actual value and predicted value are showed in the same pane, can be compared to user and show total industrial output value, so as to In discovery actual production value and predicted value between discrepancy and bigger difference point, not only convenient for improve prediction algorithm, but also convenient for examine and Improve production technology.The gain term represented in item and declining profit item are shown respectively individually, can protrude and be wanted input by each month The variable quantity of element, corresponds to the gross output value (prediction) in each month, can protrude each influence value height for representing item to the gross output value. Third pane shows each history value for representing item, corresponding with the gross output value, can intuitively reflect that each item that represents is total for industry The influence degree of the output value, in order to which supplier carries out production improvement.
Further, the analysis result of above-mentioned cost analysis theme includes production analysis, cost analysis, gain and loss analysis, life One or more in production five options of simulator and multidimensional analysis, any one of selection then shows the number corresponding to selected item According to.
Cost is analyzed and shown from multiple dimensions respectively, the needle analyzed from each dimension cost can be protruded To property, while to carry out comprehensive analysis to cost, it is ensured that the high-precision of each dimensional analysis result and the good result of displaying.
Further, the selection production analysis under cost analysis theme, then show the relational graph of operation capital and yield, with And the capital data corresponding to selected point in the relational graph;In the capital data, correspond to selected in relational graph Yield corresponding to point can be adjusted.
Chart (relational graph) and data (capital data) are associated displaying, so that the displaying for data is more straight It sees, while being conveniently adjusted the point of displaying again.Corresponding to the yield of point, when showing corresponding capital data, setting is certain Floating space, can quickly update corresponding to other capitals data needed for updated yield.
In conclusion by adopting the above-described technical solution, the beneficial effects of the present invention are:
1, display systems through the invention, can the targetedly excavation to being customized of source data, analysis and displaying, So that understanding for the bandwagon effect of water utilities data, being convenient, convenient for operation.This system is set with premise test stage, can be right Analysis environment is tested, and unnecessary process is avoided, to save overhead in the case where guaranteeing system stability.
2, in the present invention, turn-on data shows process in such a way that active is applied, actively executes the process compared with system The load of system operating can be effectively reduced in mode.
3, all data that the present invention is shown has preferable body in independence, relevance and the convenience of adjustment It tests.
4, display systems of the invention, the data shown have corresponding analysis log, convenient for retrospect.
5, the predicted value that uses of the present invention shown with actual value same district, represent item with actual value corresponding displaying, represent item The scheme that gain term and declining profit item are shown respectively can protrude the intensity of each influence to total industrial output value that represents item, with And respectively represent the value height that item influences total industrial output value.
Detailed description of the invention
Examples of the present invention will be described by way of reference to the accompanying drawings, in which:
Fig. 1 is display systems work flow diagram.
Fig. 2 is that total industrial output value subject analysis result shows interface.
Fig. 3 is under cost analysis theme, and production analysis result shows interface.
Fig. 4 is under cost analysis theme, and cost analysis results show interface.
Fig. 5 is under cost analysis theme, and gain and loss analysis result shows interface.
Fig. 6 is under cost analysis theme, and production simulator shows interface.
Fig. 7 is under cost analysis theme, and multidimensional analysis result shows interface.
In figure, 101 be the first show area, 102 be the second show area, 1021 be the second show area the first pane, 1022 It is the third pane of the second show area for the second pane of the second show area, 1023,201 be the relationship of operation capital and yield Figure, 202 be the capital data corresponding to point on 201,203 for yield can constituency, 204 for supplier can constituency, 205 have been The constituency of whole yield scaling figure, 501 select area for simulator, and 502 be production main body'choice area, and 503 be third show area, and 504 It is Production adjustment area for the 4th show area, 505,506 select area for type, and 507 be the 5th show area, and 601 select area for dimension, 602 be the 6th show area, and 603 be the scaling figure of time shaft, and 604 be the constituency to time shaft, and 605 be the 7th show area.
Specific embodiment
All features disclosed in this specification or disclosed all methods or in the process the step of, in addition to mutually exclusive Feature and/or step other than, can combine in any way.
Any feature disclosed in this specification (including any accessory claim, abstract), unless specifically stated, It is replaced by other equivalent or with similar purpose alternative features.That is, unless specifically stated, each feature is a series of An example in equivalent or similar characteristics.
As shown in Figure 1, present embodiment discloses a kind of data of intelligent water affairs management platform to analyze display systems, the displaying System at least shows the analysis data of a water utilities analysis theme, and in one embodiment, analysis theme includes total industrial output value Theme and cost analysis theme;The display systems workflow are as follows:
Data preparation stage.The stage is to analyze theme to customize the data that need to be excavated, by choosing source data, and to the source of selection Data are pre-processed, and determine required data under corresponding analysis theme.Common, source data is to count all water utilities numbers According to data warehouse, be with the library HIVE it is preferred, HIVE is a Tool for Data Warehouse based on Hadoop, can be by structuring Data file is mapped as a database table, and provides simple sql query function, sql sentence can be converted to MapReduce task is run.Pretreatment for source data is looked into one embodiment to carry out data to source data Look for-as by building filtering sentence, by the data of needs, from finding out and copied in the list newly constructed in source data.Example Such as the analysis of some waterworks, the water of the water factory can be found out by enterprise's number (company_no) of the water factory Business data, remainder data similarly, pass through the extraction of data needed for nested query is realized.
In intelligent water affairs management platform, data analyze display systems and need to start corresponding analysis theme, can just open Analysis and subsequent displaying of the corresponding analysis theme to data.For analyzing the unlatching of theme, is realized, that is, existed by premise inspection After data preparation stage, testing stage premised on the workflow of display systems.The stage is for judging whether display systems have The condition of back-up analysis corresponding analysis theme then opens corresponding analysis theme after upchecking.In one embodiment, lead to It crosses and judges whether the pretreatment to source data is completed to carry out implementing precondition inspection.Specifically, in above-mentioned data preparation stage, for source In the pretreatment of data, there is the step of building new table, then whether there is the list in the library HIVE by examining, before completing The step of proposing inspection, if whether there is corresponding list in the library HIVE, premise is upchecked.It should be noted that for list Inspection, be not relevant in the list with the presence or absence of data;No matter whether there is data in the list, as long as list exists, Then premise is upchecked.
After premise testing stage, display systems have had the condition for executing correlation analysis theme.Pass through automatic or touching The mode of hair, Xiang Houtai submit the analysis task under corresponding analysis theme to, i.e., the excavation and analysis of complete paired data are (if submitted to Analysis task run succeeded).The stage belongs to task and submits the stage to.
After the completion of task submits the stage to, the workflow of display systems enters data and shows the stage.Under at this stage, User shows corresponding analysis result by clicking corresponding button.In general, analysis result is with the shape of text and/or chart Formula is showed.
The present embodiment specifically discloses the execution process that data show the stage.Data show that the stage includes at least analysis log Corresponding data are shown by selecting different options with the displaying option of analysis result.For analyzing log, After selection, show that the log of at least one analysis task, each record include the task ID of corresponding analysis task, start Time, task time-consuming, task execution mode (automatic or manual), executes state (success or failure) and log at the end time Record.Log recording is selected, then shows the specific daily record data under the log recording, including execution date (in analysis task, The execution date of each concrete analysis step, be accurate to the second), (title of i.e. each analytical procedure such as initializes source number to each step title According to, obtain item attribute, extract valid data, understand invalid data, screening represent item, interpolation null value etc.), each step execute shape The data strip mesh number that state (such as running succeeded or execute failure), each step are related to.
By selection analysis as a result, showing the analysis result of corresponding analysis theme.
As shown in Fig. 2, analysis result is divided into the first show area 101 and the second show area for total industrial output value theme 102, two show areas are at tiled configuration;First show area 101 shows several representative items, and each parameter for representing item is adjustable, Preferably adjust (being such as adjusted to 0,1 or 2 times) at double;Second show area 102 shows that corresponding to the first show area 101 respectively represents The value of analysis result of the item under certain state.Above-mentioned representative item in one embodiment, including water user sum, tap water sell water Amount, always sell water cost, business tax and add, selling charges, sewage load, tap water sell in water cost etc. at least one ?.For the second show area 102, it is divided into the first pane 1021, the second pane 1022 and third pane 1023, three Pane from top to bottom sequentially arranges.First pane 1021 shows that total industrial output value corresponds to the actual value of source data and corresponds to each Represent the predicted value under item;Second pane 1022 show monthly constitute prediction total industrial output value representative item in gain term and Declining profit item, corresponding month are dependent on selected in the first pane 1021 month (as clicked);Third pane 1023 is opened up Show the selected history value for representing item in the first show area 101, by the first show area 101 click may be selected it is different Represent item.
For cost analysis theme, analyzing result includes production analysis, cost analysis, gain and loss analysis, production simulator With it is one or more in five options of multidimensional analysis, any one of selection then shows data corresponding to this.Production point It analyses and shows in the case where obtaining yield or capital position, the production factors amount that need to be put into;The relationship of cost analysis displaying cost and yield; Gain and loss analysis shows profit and loss situation of the supplier under different output;In the case of producing simulator simulated production change in factor, To the influence situation of resources of production and cost;Multidimensional analysis shows under identical items from the dimension of Item Detail or supplier, The accounting of each supplier or projects.
As shown in figure 3, selection production analysis, shows the relational graph 201 of operation capital and yield, and correspond to the relationship The capital data 202 of selected point on figure.Wherein, yield, which is divided into, water supply yield and sells aquatic products amount, by can constituency in yield It is selected in 203, it may be determined that go out the relational graph or operation capital that shown relational graph is operation capital and water supply yield With the relational graph for selling aquatic products amount.Capital data 202 include supplier (water factory), personnel directly engaged in production's amount, the production capital and throwing Produce four item data of capital.Relational graph and the capital data 202 are at tiled configuration.In relational graph, pass through color or line Shape distinguishes different suppliers.Each supplier can be selected or be cancelled in constituency 204 in supplier and chosen.
It should be noted that in capital data 202, it, can corresponding to yield corresponding to point selected in relational graph It is adjusted.Regulative mode is by the units of production basis corresponding to selected point, setting certain floating range, such as in institute On units of production basis corresponding to reconnaissance position, the range of setting left and right floating 5%, to achieve the effect that adjust yield.Corresponding to the tune Section operation, the result that capital data 202 are shown can also execute corresponding adjusting automatically.For production corresponding to selected point Amount can be default value (generally empty) by click " resetting " button, recovery yield.Corresponding to relational graph, it is contemplated that yield Under the same coordinate system, data continuity is very long, and the curve of all data can not be disposably shown under a viewport, therefore, Around relational graph (preferably lower section), also shows that the scaling figure of complete yield, in the scaling figure, is built with and selects constituency, By adjusting the constituency, to show the section of complete yield in choice relation figure.I.e. in the abscissa of relational graph, only show Selected section is as maximum range.The initial position in selected section is fixed as origin.
As shown in figure 4, selecting cost analysis in cost analysis results, then specific yield and operation capital are shown respectively It relational graph, unit cost and sells water relational graph and always sells and water cost and sell water relational graph.It selects any in three relational graphs Point in relational graph shows the data for corresponding to selected middle point in other two relational graph.Such as choose specific yield with Point a in operation capital ties figure (relation curve), then unit cost with sell water relational graph and always sell water cost and sell The unit cost corresponding to point a is then shown in water relational graph and is sold water relation curve and is always sold water cost and sell water relationship Curve.Three relational graphs are at left, center, right structural arrangement.In each relational graph, by color or linear, different production masters is distinguished Body (water factory).For in specific yield and operation capital ties figure, specific yield includes average product and two kinds of marginal product;It is right It in unit cost and sells in water relational graph, unit cost includes average unit cost and two kinds of marginal cost.Each supplier, unit The classification of yield and the classification of unit cost can be selected or be cancelled and choose.When selected, in corresponding relational graph It can then show the data, be cancelled when choosing, then in corresponding relational graph, do not show the data.
As shown in figure 5, selecting gain and loss analysis in cost analysis results, then cost/benefit/profit is shown and for aquatic products The relational graph of amount, and the corresponding capital data with selected point in the relational graph.By color or linear, it is distinguished into Originally, income and profit.Capital data include supplier, totle drilling cost, total revenue, gross profit and absolute profit five kinds of data. Relational graph and the capital data are at tiled configuration.By color or linear, different suppliers is distinguished.Each supplier And cost curve, yield curve or yield curve, it can be selected or be cancelled and choose.Such as in cost, income and profit, Cancel selection yield curve, then in relational graph, only displaying cost is with the relation curve and income of water supply yield and for aquatic products The relation curve of amount, the relation curve without showing profit and water supply yield.For each supplier similarly.Corresponding to pass System's figure, it is contemplated that for yield under the same coordinate system, data continuity is very long, and all numbers can not be disposably shown under a viewport According to curve therefore around relational graph (preferably lower section), also show that the scaling figure of complete yield, in the scaling figure, It is built with constituency, by adjusting the constituency, to show the section of complete yield in choice relation figure.I.e. in the horizontal seat of relational graph In mark, only show selected section as maximum range.The initial position in selected section is fixed as origin.
In capital data, correspond to the corresponding water supply yield of selected point in relational graph, can be adjusted and again It sets.Regulative mode is by setting certain floating range on the water supply units of production basis corresponding to selected point.With above-mentioned generation Regulative mode and reset mode in function.
The case where simulator is produced for selection, as shown in Figure 6 comprising the simulator of several simulator selects area 501, which includes that such as industrial rich and influential family's water supply simulator, tap water production simulator, resident's water supply simulator, organ use The options such as family water supply simulator.It further include supplier choosing the case where the production simulator of selection in the case where analyzing result Area 502 is selected, which includes option of several suppliers, such as * * water factory, * * water utilities company etc..It is selected from simulator The selection of area 501 production simulator-such as selection tap water production simulator is selected, and selects some from supplier selection area 502 Supplier-such as * * water utilities company-after the completion, then shows that (tap water produces mould by the production analogue data of selection supplier Quasi- data).
For the production analogue data shown, it includes third show areas 503 and the 4th show area 504;Third exhibition Show that area 503 is shown by the intrinsic creation data of selection supplier, such as the degree of fitting of the degree of association data of * * and * *, * * and * * Data (relationship of such as tap water effective water supply and time, the predicted value comprising actual value and simulator) etc.;4th show area 504 show the simulated production data, such as cost data, resources of production consumption data etc. that simulated production is carried out to supplier. Also include Production adjustment area 505 in the 4th show area 504, by operation to the Production adjustment area 505 (such as input data, Pull the modes such as progress bar), the simulated production amount of adjustable selected production simulator.Selected production simulator according to Simulated production, the simulated production that above-mentioned 4th show area 504 is shown are carried out according to the adjusted result to the Production adjustment area 505 Data are every creation data that selected production simulator carries out simulated production according to the yield adjusted.
It also may include type selection area 506 and corresponding view in the simulated production data that the 4th exhibition section is shown Window is shown by way of drop-down menu, is selected to the type if the type selection area 506 includes dry type option It selects area 506 to be operated, after choosing some type option, corresponding form then shows corresponding categorical data.Example Simulation power consumption increment option such as is had selected in type selection area 506, then then shows power consumption increment in corresponding form Data.In Selective type option, can also simultaneous selection form displaying unit.Such as above-mentioned power consumption increment option, it can Select displaying unit of ten thousand kilowatt hours as form.
Displaying interface after selection produces simulator, also includes the 5th show area 507, which includes the 4th exhibition Show all or part of project in the every simulated production data shown in area 504, is shown in the 5th show area 507 It is all or part of in project, it can be selected or can be cancelled and choose.Corresponding in the 5th show area 507 to projects It operates (choose or cancel and choose), displaying or the corresponding project data of revocation token in the 4th show area 504.Such as the 5th exhibition Show the item for corresponding to resources of production consumption data in area 507 comprising water factory's self water consumption, production power consumption, gasoline consumption etc. Mesh then shows production power consumption in the resources of production consumption data of the 4th show area 504 when choosing production power consumption The data of project, other projects are similarly.Above-mentioned simulator selects area 501, also may be included in the 5th show area 507.
It include also " resetting " button, by triggering the button, by displaying circle at the displaying interface of selection production simulator All data in face are restored to default value (usually empty).
As shown in fig. 7, under the multidimensional analysis of cost analysis results, include dimension selection area 601 and corresponding the Six show areas 602, it includes several analysis dimension options that dimension, which selects area 601, for the analysis dimension chosen, the 6th exhibition Show that area 602 then shows corresponding analysis data.In one embodiment, analysis dimension includes that supplier and/or production are bright Thin two dimensions, after select supplier dimension, the 6th show area 602, which is then shown, analyzes each supplier Chart.Wherein, the analysis for each supplier includes that economic indicator and expense pay two projects.Pass through between each supplier Color linear distinguishes.The relational graph for finally showing expense and time, wherein each time point packet on a timeline Containing two item data of economic indicator and expense expenditure target, each item data identifies the respective counts of each supplier respectively again According to.In view of that can not show complete time shaft under the coordinate system of form, around relational graph (preferably lower section), also show that There is scaling Figure 60 3 of full time axis, in the scaling figure, constituency 604 is built with, by adjusting the constituency, with choice relation The time interval shown in figure.I.e. in the abscissa of relational graph, the cost data in selected time interval is only shown.
Multidimensional analysis also includes the 7th show area 605, by click relational graph in point (such as relational graph be histogram, Each time point is corresponding with economic indicator and expense pays two columns, clicks the supplier chosen in any histogram), then exist In 7th show area 605, the detailed data under the analysis project chosen where chosen supplier is shown, such as choose pass It is the yellow area (corresponding to supplier B) in the economic indicator histogram in figure, under time point A, then in the 7th show area 605 show supplier B in the detailed economic indicator of time point A, such as total industrial output value, total profit, always sell water cost.
The invention is not limited to specific embodiments above-mentioned.The present invention, which expands to, any in the present specification to be disclosed New feature or any new combination, and disclose any new method or process the step of or any new combination.

Claims (10)

1. a kind of data of intelligence water affairs management platform analyze display systems, the display systems at least show a water utilities analysis The analysis data of theme, which is characterized in that theme is analyzed for each, the workflow of the display systems includes:
A. data preparation stage: by choosing source data, and the source data of selection is pre-processed, to determine corresponding analysis Data needed under theme;
B. premise testing stage: the data prepared data preparation stage are tested, and after upchecking, execute C;
C. task submits the stage to: Xiang Houtai submits analysis task to, with the analysis for the data that the complete paired data preparation stage is prepared;
D. data show the stage: showing analysis result.
2. display systems as described in claim 1, which is characterized in that the analysis theme include total industrial output value theme and/ Or cost analysis theme.
3. display systems as described in claim 1, which is characterized in that the source data of described pair of selection pre-processes are as follows: right Source data carries out data search, and required data are extracted in designated memory cell from source data.
4. display systems as claimed in claim 3, which is characterized in that the data prepared data preparation stage carry out It examines are as follows: verifying the designated memory cell whether there is, and if it exists, then upcheck.
5. display systems as claimed in claim 2, which is characterized in that the data show the stage include analysis log and/or The displaying option for analyzing result shows corresponding data by selecting different options.
6. display systems as claimed in claim 5, which is characterized in that the analysis result of the total industrial output value theme is divided into One show area and the second show area, first show area show several representative items, and second show area corresponds to first Several values for representing item in show area show the value of analysis result.
7. display systems as claimed in claim 6, which is characterized in that described in first show area several represents in item At least one of represent value of item and can be adjusted.
8. display systems as claimed in claims 6 or 7, which is characterized in that second show area includes the first pane, second Pane and third pane;First pane shows that total industrial output value corresponds to the actual value of source data and corresponds to each representative item Under predicted value;Second pane shows gain term and declining profit item in the representative item for the total industrial output value for monthly constituting prediction, institute It is dependent on the month selected in the first pane in corresponding month;Third pane shows the selected representative in the first show area The history value of item.
9. display systems as claimed in claim 5, which is characterized in that the analysis result of the cost analysis theme includes production Analysis, cost analysis, gain and loss analysis, production five options of simulator and multidimensional analysis in it is one or more, select it is any Xiang Ze shows the data corresponding to selected item.
10. display systems as claimed in claim 9, which is characterized in that selection production analysis then shows operation capital and yield Relational graph, and capital data corresponding to selected point in the relational graph;In the capital data, corresponding to closing It is yield corresponding to selected point in figure, can be adjusted.
CN201910298709.7A 2019-04-15 2019-04-15 A kind of data analysis display systems of intelligence water affairs management platform Pending CN110059132A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910298709.7A CN110059132A (en) 2019-04-15 2019-04-15 A kind of data analysis display systems of intelligence water affairs management platform

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910298709.7A CN110059132A (en) 2019-04-15 2019-04-15 A kind of data analysis display systems of intelligence water affairs management platform

Publications (1)

Publication Number Publication Date
CN110059132A true CN110059132A (en) 2019-07-26

Family

ID=67318905

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910298709.7A Pending CN110059132A (en) 2019-04-15 2019-04-15 A kind of data analysis display systems of intelligence water affairs management platform

Country Status (1)

Country Link
CN (1) CN110059132A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110443503A (en) * 2019-08-07 2019-11-12 成都九鼎瑞信科技股份有限公司 The training method and related system of water utilities system industrial gross output value analysis model
CN110458442A (en) * 2019-08-07 2019-11-15 成都九鼎瑞信科技股份有限公司 Water utilities system cost analysis method
CN110827172A (en) * 2019-11-12 2020-02-21 河北建投水务投资有限公司 Wisdom water affairs cloud service platform

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2001325417A (en) * 2000-05-15 2001-11-22 Mit:Kk Method and system for analyzing financial affairs and recording medium
US20020087540A1 (en) * 2000-12-20 2002-07-04 Hitoshi Ashida Method and system for database management for data mining
CN103399926A (en) * 2013-08-05 2013-11-20 河海大学 Water conservancy general survey data multidimensional analysis and service system and encapsulation and achieving method thereof
CN104408170A (en) * 2014-12-09 2015-03-11 广州大乘信息科技有限公司 Business data analysis system
CN105955178A (en) * 2016-05-05 2016-09-21 中科智水(北京)科技有限公司 TCP series water data acquisition control intelligent terminal and water concentrated monitoring system
CN109376188A (en) * 2018-09-13 2019-02-22 智恒科技股份有限公司 A kind of wisdom water utilities big data fusion method and system based on subject area

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2001325417A (en) * 2000-05-15 2001-11-22 Mit:Kk Method and system for analyzing financial affairs and recording medium
US20020087540A1 (en) * 2000-12-20 2002-07-04 Hitoshi Ashida Method and system for database management for data mining
CN103399926A (en) * 2013-08-05 2013-11-20 河海大学 Water conservancy general survey data multidimensional analysis and service system and encapsulation and achieving method thereof
CN104408170A (en) * 2014-12-09 2015-03-11 广州大乘信息科技有限公司 Business data analysis system
CN105955178A (en) * 2016-05-05 2016-09-21 中科智水(北京)科技有限公司 TCP series water data acquisition control intelligent terminal and water concentrated monitoring system
CN109376188A (en) * 2018-09-13 2019-02-22 智恒科技股份有限公司 A kind of wisdom water utilities big data fusion method and system based on subject area

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
刘立超等: "跨业务主题分析的研究与应用", 《电力信息化》 *
纪菁: "智慧水务一体化平台软件设计", 《水电厂自动化》 *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110443503A (en) * 2019-08-07 2019-11-12 成都九鼎瑞信科技股份有限公司 The training method and related system of water utilities system industrial gross output value analysis model
CN110458442A (en) * 2019-08-07 2019-11-15 成都九鼎瑞信科技股份有限公司 Water utilities system cost analysis method
CN110827172A (en) * 2019-11-12 2020-02-21 河北建投水务投资有限公司 Wisdom water affairs cloud service platform

Similar Documents

Publication Publication Date Title
US10902045B2 (en) Natural language interface for building data visualizations, including cascading edits to filter expressions
US7822795B2 (en) Apparatus and methods for displaying and determining dependency relationships among subsystems in a computer software system
US9727981B2 (en) Visualizing data model sensitivity to variations in parameter values
US20200089760A1 (en) Analyzing Natural Language Expressions in a Data Visualization User Interface
Thalhammer et al. Active data warehouses: complementing OLAP with analysis rules
US6775674B1 (en) Auto completion of relationships between objects in a data model
CN109389143A (en) A kind of Data Analysis Services system and method for automatic modeling
Ungerer et al. Integrating spatial data analysis and GIS: a new implementation using the Component Object Model (COM)
US8666999B2 (en) Search utility program for software developers
CN110059132A (en) A kind of data analysis display systems of intelligence water affairs management platform
US20040122699A1 (en) Method and system for integrating workflow management with business intelligence
US20030182303A1 (en) System and method for automated database report definition
CN110442620A (en) A kind of big data is explored and cognitive approach, device, equipment and computer storage medium
US20080059437A1 (en) Data mining system
CA3111511C (en) Analyzing natural language expressions in a data visualization user interface
Kotsyuba et al. Automating MySQL database complexity estimation based on quantitative metrics
CN101479726B (en) Configurable multi-lingual advisory system and method thereof
Harmon Enterprise architectures
US11960500B1 (en) Natural language data analysis, visualization and editing system
Hmelnov et al. An approach to information export from database for complex master-detail table hierarchies into a single flat table form.
CN118012963A (en) Low-code data exploration method and device
AU2007216642A1 (en) Data Mining System
WO2013049906A1 (en) Dynamically generated ui for a relational database and method thereof
Eberius Configuration And Modeling Of Mapping Processes in Schema Matching
Yeung et al. Database Models and Data Modelling

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
AD01 Patent right deemed abandoned
AD01 Patent right deemed abandoned

Effective date of abandoning: 20231110