PowerQuery在渔业科研项目统计中的应用

Application of PowerQuery in the Project Statistics of Fisheries Scientific Research

科研数据统计工作是高校、研究所等科研机构的科研处日常管理的重要内容。PowerQuery拥有傻瓜式的操作界面,更拥有高阶的M函数,可用于科研项目管理的项目办理、项目统计、项目查询等多个环节中,配合Word邮件合并、Excel数据透视表等功能,实现数据的批量汇总、实时更新、一键查询,在科研管理工作中有良好的应用前景。

For the scientific research offices of universities,research institutes and other scientific research institutions,the statistical work of scientific research data is an important part in their daily management.PowerQuery,with a fool-like operation interface and a powerful functions(M function),can be applied to multiple links in scientific research project management,such as project management,project statistics,and project query.The combined use with PowerQuery and the functional module of mail merge in Word software,pivot tables in Excel software,will realize the batch summarization,real-time update,and one-key query of project data,which possesses a good application prospect in scientific research management.