Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Excel VBA-based death cause monitoring data analysis method

A technology for monitoring data and analysis methods, which is applied in the field of big data processing, and can solve problems such as time-consuming, limited utilization of monitoring data, and uneven levels of data management, analysis, and utilization.

Pending Publication Date: 2020-04-24
无锡市疾病预防控制中心
View PDF1 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Due to the uneven level of data management, analysis and utilization of technicians in grassroots monitoring units, the utilization of monitoring data is limited
In addition, due to the real-time update of the cause of death monitoring data, and there are many key information items and a large amount of data, the processing and analysis of the data is heavy and time-consuming, prone to errors and omissions, and cannot meet the work requirements
Although there are currently many statistical software, such as SAS, R language, SPSS, Stata, etc., for the personnel of the majority of grassroots monitoring units, their high price and professional use methods are the biggest obstacles to the use of these statistical software, and some software It is very inconvenient to use, requires programming, and the visualization and interaction are not strong

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Excel VBA-based death cause monitoring data analysis method
  • Excel VBA-based death cause monitoring data analysis method
  • Excel VBA-based death cause monitoring data analysis method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0024] Embodiment: a kind of death monitoring data analysis method based on Excel VBA comprises the steps:

[0025] (1) Build a data quality assessment model

[0026] Formulate data quality definition rules, and screen and filter all collected data according to the source of data and the established data quality definition rules, so as to build a standardized and systematic data quality evaluation model; the scope of data management and evaluation mainly includes:

[0027] a. Death cause monitoring data access: use the electronic information system to collect data, collect death cause monitoring data of the whole region, the whole population, and the whole life cycle, and the death population information data can be traced throughout the whole process; embed the underreporting investigation module to fully grasp special death cases At the same time, realize the multi-department joint data sharing mechanism to ensure the comprehensiveness and reliability of the cause of death d...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses an Excel VBA-based death cause monitoring data analysis method, which comprises the steps of constructing a data quality evaluation model; constructing a data analysis execution engine, converting all variables by adopting a unified coding rule and format based on Excel VBA, uniformly arranging and importing all data into Excel, and embedding ICD codes of different diseasetypes into the background; carrying out data analysis and arrangement by taking the data imported into Excel as an execution object in a transverse analysis or longitudinal analysis mode, wherein transverse analysis reflects the crowd death condition and the key index condition of a specific year, and longitudinal analysis reflects the change trend of the crowd death level or the key index betweenspans of different years. According to the Excel VBA-based death cause monitoring data analysis method, management and quality control are performed on death cause monitoring data, and full-crowd, full-process and integrated death cause data analysis and key index calculation are realized.

Description

technical field [0001] The invention belongs to the field of big data processing, and in particular relates to an analysis method of death cause monitoring data. Background technique [0002] Death cause monitoring is an important public health monitoring activity. It is of great significance to understand the level and order of death of residents, grasp the factors affecting residents' health, and provide a reliable basis for government decision-making. As a highly technical work, death monitoring involves many links, and the amount of data is huge every year. From the perspective of monitoring data management, it involves many aspects such as data collection, reporting, sorting, cleaning, analysis and reporting. link. With the application of the direct network reporting system for cause of death registration, the quality of data collection and reporting has been greatly improved. How to do a good job in subsequent data management, analysis and utilization has become an ur...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G16H50/70G06F16/2458G06F16/215
CPCG16H50/70G06F16/215G06F16/2465G06F16/2462
Inventor 陈海董昀球钱云王璐郭亮亮刘佳杨志杰申倩
Owner 无锡市疾病预防控制中心
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products