CN111722895B - SPC chart rendering method in Power BI component - Google Patents
SPC chart rendering method in Power BI component Download PDFInfo
- Publication number
- CN111722895B CN111722895B CN201910218545.2A CN201910218545A CN111722895B CN 111722895 B CN111722895 B CN 111722895B CN 201910218545 A CN201910218545 A CN 201910218545A CN 111722895 B CN111722895 B CN 111722895B
- Authority
- CN
- China
- Prior art keywords
- spc chart
- spc
- power
- desktop application
- chart
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000009877 rendering Methods 0.000 title claims abstract description 20
- 230000000007 visual effect Effects 0.000 claims abstract description 24
- 230000008676 import Effects 0.000 claims abstract description 4
- 238000004519 manufacturing process Methods 0.000 claims description 24
- 239000000463 material Substances 0.000 claims description 5
- 238000004806 packaging method and process Methods 0.000 claims description 3
- 239000003086 colorant Substances 0.000 claims description 2
- 238000012800 visualization Methods 0.000 claims description 2
- 230000002159 abnormal effect Effects 0.000 abstract description 7
- 230000008859 change Effects 0.000 abstract description 2
- 238000003070 Statistical process control Methods 0.000 description 75
- 238000012544 monitoring process Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 7
- 230000008901 benefit Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 238000012512 characterization method Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013079 data visualisation Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000009666 routine test Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Theoretical Computer Science (AREA)
- Human Computer Interaction (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- General Factory Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a rendering method of SPC charts in a Power BI component, which relates to the field of SPC chart rendering, and comprises the following steps of: installing a Power BI Desktop application program, and opening the Power BI Desktop application program; step 2: acquiring SPC chart data and importing the SPC chart data into a Power BI Desktop application; step 3: acquire SPC chart components and import SPC chart components into the Power BI Desktop application; step 4: opening the SPC chart component, making adjustments to the data based on the SPC chart data, loading a visual image that creates the SPC chart; step 5: the visual image anomaly fluctuation judgment rules of the SPC chart are manually configured, and the line color and line thickness of the SPC chart. The invention generates the SPC chart component based on the Power BI Desktop application program, realizes the visual display of the SPC chart through the SPC chart component, realizes the SPC chart high configuration, can change the rule for judging abnormal fluctuation according to the requirement of a customer, and defines the alarm content.
Description
Technical Field
The present invention relates to the field of SPC chart rendering, and more particularly, to a method for rendering SPC charts in Power BI components.
Background
SPC (Statistical Process Control ), SPC mainly uses statistical analysis technique to make real-time monitoring on production process, and scientifically distinguish random fluctuation and abnormal fluctuation of product quality in the production process so as to provide early warning for abnormal fluctuation of production process, and can make measures and eliminate abnormality in time for production manager and recover temperature of production process so as to attain the goal of raising and controlling production quality.
Currently, the rendering methods of SPC charts (quality management charts) are all browser-based, so SPC charts can only be presented through a browser; loading SPC charts through a browser, failing to highly configure the SPC charts and failing to customize the rules for determining abnormal fluctuations; in the Microsoft Power BI (Power Business Intelligence) data visualization component, the visual graphical presentation of SPC charts is also a blank, and there is no component that can present SPC charts.
Disclosure of Invention
In view of the above-described drawbacks of the prior art, an object of the present invention is to provide a method for rendering an SPC chart in a Power BI component, generating an SPC chart component based on a Power BI Desktop application, implementing visual presentation of the SPC chart through the SPC chart component, implementing high configuration of the SPC chart, and capable of changing rules for judging abnormal fluctuation according to customer requirements and defining alarm contents.
The present invention provides a method for rendering SPC charts in Power BI components, said method comprising the steps of:
step 1: installing a Power BI Desktop application program, and opening the Power BI Desktop application program;
step 2: acquiring SPC chart data and importing the SPC chart data into a Power BI Desktop application;
step 3: acquire SPC chart components and import SPC chart components into the Power BI Desktop application;
step 4: opening the SPC chart component, making adjustments to the data based on the SPC chart data, loading a visual image that creates the SPC chart;
step 5: the visual image anomaly fluctuation judgment rules of the SPC chart are manually configured, and the line color and line thickness of the SPC chart.
Further, SPC chart data includes materials, equipment, environments, personnel, and production parameters required for production.
Further, the SPC chart component is obtained as follows:
step 3.1: creating an engineering file in the Power BI Desktop application and installing tools required for developing SPC chart components in the engineering file;
step 3.2: introducing a third party tool required for rendering the SPC chart visual image rendering into the engineering file;
step 3.3: generating configuration items based on the data provided by the Power BI Desktop application, the configuration items, and the configuration files of the SPC chart visualization image features;
step 3.4: based on the generated configuration items, the tools installed in the Power BI Desktop application program and the introduced third party tools are adopted to render SPC charts and carry out file packaging, so that SPC chart components are generated.
As described above, a method for rendering SPC charts in Power BI component of the present invention has the following benefits:
1. according to the invention, the SPC chart component is generated through the Power BI Desktop application program, the SPC chart component is imported into the Power BI Desktop application program, the SPC chart visual image can be generated through data adjustment of SPC chart data, and the abnormal fluctuation judgment rule can be defined, so that the SPC chart visual image is convenient for enterprises to use.
2. The invention can reliably evaluate the production process of the product through the visual display of the SPC chart, define the alarm content based on the visual image of the SPC chart, and timely monitor the production condition to prevent waste products.
3. The present invention can reduce the dependency on routine tests by visual presentation of SPC charts, and the timed observation method replaces a large amount of monitoring and verification work.
Drawings
FIG. 1 is a flow chart of a rendering method disclosed in an embodiment of the invention;
FIG. 2 shows a flowchart of the SPC chart work disclosed in an embodiment of the present invention.
Detailed Description
Other advantages and effects of the present invention will become apparent to those skilled in the art from the following disclosure, which describes the embodiments of the present invention with reference to specific examples. The invention may be practiced or carried out in other embodiments that depart from the specific details, and the details of the present description may be modified or varied from the spirit and scope of the present invention. It should be noted that the following embodiments and features in the embodiments may be combined with each other without conflict.
It should be noted that the illustrations provided in the following embodiments merely illustrate the basic concept of the present invention by way of illustration, and only the components related to the present invention are shown in the illustrations, not according to the number, shape and size of the components in actual implementation, and the form, number and proportion of each component in actual implementation may be arbitrarily changed, and the layout of the components may be more complex.
As shown in FIG. 1, the present invention provides a method for rendering SPC charts in a Power BI component, the method comprising the steps of:
step 1: installing a Power BI Desktop application (a business data analysis tool proposed by Microsoft corporation) and opening the Power BI Desktop application;
step 2: acquiring SPC chart data and importing the SPC chart data into a Power BI Desktop application;
step 3: acquire SPC chart components and import SPC chart components into the Power BI Desktop application;
step 4: opening the SPC chart component, performing data adjustment based on the SPC chart data (dragging corresponding data according to the visualized requirement of the SPC chart), and loading a visualized image for generating the SPC chart;
step 5: visual image anomaly fluctuation determination rules for SPC charts, line colors, line thicknesses, etc. for SPC charts are manually configured (i.e., configuration items in the SPC chart component are manually set).
Wherein the SPC chart data file includes materials, equipment, environments, personnel, production parameters, etc. required for production;
the SPC chart component is obtained as follows:
step 3.1: creating an engineering file in the Power BI Desktop application and installing tools required for developing SPC chart components in the engineering file;
step 3.2: introducing a third party tool required for rendering the SPC chart visual image rendering into the engineering file;
step 3.3: generating configuration items based on the data provided by the Power BI Desktop application, the configuration items, and the configuration files of the SPC chart visual image characteristics (such as the settings of the visual image anomaly fluctuation judgment rules, etc.);
step 3.4: based on the generated configuration items, the tools installed in the Power BI Desktop application program and the introduced third party tools are adopted to render SPC charts and carry out file packaging, so that SPC chart components are generated.
As shown in FIG. 2, the present invention can render visual images of SPC charts by inputting data (e.g., materials, equipment, environment, personnel, production parameters, etc.) during the production process into SPC chart components, define alarm content based on the visual images of SPC charts, and timely monitor production to prevent the generation of waste; the output visual image data is utilized to react with the input data so as to obtain continuous improvement of input factors (such as materials, production parameters and the like), the input data is converted into output data through a production process, the implementation process is that SPC charts are required to be monitored, the SPC charts are only applied to the monitoring process of part of key characteristics, and the selection of the key characteristics is also determined according to the production capacity and the requirements of enterprises, so that when the statistical process control is carried out, firstly, a controlled object is required to be defined, then, the effect of each major factor in the implementation process of the monitoring production on the controlled object is detected, the fluctuation of special reasons of the process is detected, so that unqualified products are prevented in advance, and other parameters beyond the key characteristics can be recorded and stored in a form of a record check table so as to provide reference of historical basis for the process improvement;
the control items of the SPC chart are generally set up for the necessity of product characterization and process monitoring by the following aspects;
(1) Judging whether the product is a key characteristic of the product according to the product characteristic requirement;
(2) In the production and manufacturing process of the product, the monitoring of key process parameters plays an important role in determining the quality and yield of the product, and the monitoring of the process parameters is performed by using a real-time SPC chart method, so that special reasons existing in the production process can be found out in time, and the special reasons can be blocked and eliminated in time, thereby playing a role in timely correcting and preventing;
(3) The customer's specific requirements may be directed to the inherent characteristics of the product, such as package form factor requirements, etc.
In summary, the present invention creates SPC chart components based on the Power BI Desktop application, realizes the visual presentation of SPC charts through the SPC chart components, realizes SPC chart high configuration, and can change rules for judging abnormal fluctuation according to customer requirements and define alarm content. Therefore, the invention effectively overcomes various defects in the prior art and has high industrial utilization value.
The above embodiments are merely illustrative of the principles of the present invention and its effectiveness, and are not intended to limit the invention. Modifications and variations may be made to the above-described embodiments by those skilled in the art without departing from the spirit and scope of the invention. Accordingly, it is intended that all equivalent modifications and variations of the invention be covered by the claims, which are within the ordinary skill of the art, be within the spirit and scope of the present disclosure.
Claims (2)
1. A method for rendering SPC charts in a Power BI component, the method comprising the steps of:
step 1: installing a Power BI Desktop application program, and opening the Power BI Desktop application program;
step 2: acquiring SPC chart data and importing the SPC chart data into a Power BI Desktop application;
step 3: acquire SPC chart components and import SPC chart components into the Power BI Desktop application;
step 4: opening the SPC chart component, making adjustments to the data based on the SPC chart data, loading a visual image that creates the SPC chart;
step 5: manually configuring visual image anomaly fluctuation judgment rules of the SPC chart and line colors and line thicknesses of the SPC chart;
the SPC chart component is obtained as follows:
step 3.1: creating an engineering file in the Power BI Desktop application and installing tools required for developing SPC chart components in the engineering file;
step 3.2: introducing a third party tool required for rendering the SPC chart visual image rendering into the engineering file;
step 3.3: generating configuration items based on the data provided by the Power BI Desktop application, the configuration items, and the configuration files of the SPC chart visualization image features;
step 3.4: based on the generated configuration items, the tools installed in the Power BI Desktop application program and the introduced third party tools are adopted to render SPC charts and carry out file packaging, so that SPC chart components are generated.
2. The method of SPC chart rendering in the Power BI component as recited in claim 1, wherein: the SPC chart data includes materials, equipment, environments, personnel, and production parameters required for the production.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910218545.2A CN111722895B (en) | 2019-03-21 | 2019-03-21 | SPC chart rendering method in Power BI component |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910218545.2A CN111722895B (en) | 2019-03-21 | 2019-03-21 | SPC chart rendering method in Power BI component |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111722895A CN111722895A (en) | 2020-09-29 |
| CN111722895B true CN111722895B (en) | 2024-01-12 |
Family
ID=72563514
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910218545.2A Active CN111722895B (en) | 2019-03-21 | 2019-03-21 | SPC chart rendering method in Power BI component |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111722895B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105512139A (en) * | 2014-09-26 | 2016-04-20 | 阿里巴巴集团控股有限公司 | Method and device for implementing data visualization |
| CN108062339A (en) * | 2016-11-09 | 2018-05-22 | 北京国双科技有限公司 | The processing method and processing device of Visual Chart |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090278848A1 (en) * | 2008-05-12 | 2009-11-12 | Microsoft Corporation | Drawing familiar graphs while system determines suitable form |
-
2019
- 2019-03-21 CN CN201910218545.2A patent/CN111722895B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105512139A (en) * | 2014-09-26 | 2016-04-20 | 阿里巴巴集团控股有限公司 | Method and device for implementing data visualization |
| CN108062339A (en) * | 2016-11-09 | 2018-05-22 | 北京国双科技有限公司 | The processing method and processing device of Visual Chart |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111722895A (en) | 2020-09-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11726447B2 (en) | Quality review management system with configurable exception rules | |
| Unver | An ISA-95-based manufacturing intelligence system in support of lean initiatives | |
| US7006878B2 (en) | Computer-implemented method for analyzing a problem statement based on an integration of Six Sigma, Lean Manufacturing, and Kaizen analysis techniques | |
| CN105487458B (en) | Method and apparatus to filter process control system alarms based on alarm source type and/or alarm purpose | |
| EP3125172A1 (en) | Data reliability analysis | |
| CN105717810A (en) | Methods And Apparatus To Provide A Role-Based User Interface | |
| US10234855B2 (en) | Apparatus and method for rationalizing and resolving alarms in industrial process control and automation systems | |
| WO2018142678A1 (en) | Method for visualizing manufacturing results, image processing device, and program | |
| US11262743B2 (en) | Predicting leading indicators of an event | |
| CN111722895B (en) | SPC chart rendering method in Power BI component | |
| Parkash et al. | Statistical process control | |
| US10295997B2 (en) | Diagnostic tool and diagnostic method for determining an interruption in a plant | |
| US8839124B2 (en) | Apparatus for configuring a diagnostics module for an industrial plant | |
| US20200372433A1 (en) | Quality Assurance Systems and Methods Associated Therewith | |
| US20190236508A1 (en) | Kpi spotlight for manufacturing process | |
| EP3805881B1 (en) | Unified control system and method for machining of parts | |
| García et al. | Methodology for Oil Production-Loss Control in a Digital Oilfield Implementation | |
| JP2957561B1 (en) | Production line management method | |
| Schippers | Structure and applicability of Quality tools: Decision support for the application of process control and improvement techniques | |
| EP4332699A1 (en) | Operator-supporting control system for a technical installation and operating method | |
| JP2024512504A (en) | Improving production processes guided by shared data | |
| Liebowitz et al. | PROCESS ROBUSTNESS | |
| Van Hop et al. | Modifying Integrated Model for Manufacturing Process Improvement | |
| CN111459123A (en) | Method for generating machine heartbeat | |
| Smith et al. | Critical Decision Making and the Salesforce Analytics Cloud |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |