主办：陕西省汽车工程学会
ISSN 1671-7988  CN 61-1394/TH
创刊：1976年
汽车实用技术

汽车实用技术 ›› 2021, Vol. 46 ›› Issue (24): 68-72.DOI: 10.16638/j.cnki.1671-7988.2021.024.015

• 设计研究 • 上一篇    

基于 Power BI 的汽车外表面色差数据展示系统

蒋佳伟   

  • 发布日期:2022-01-21
  • 通讯作者: 蒋佳伟
  • 作者简介:蒋佳伟，工程师。

An Automobile External Surface Colour Matching Data Display System Based on Power BI

JIANG Jiawei   

  • Published:2022-01-21
  • Contact: JIANG Jiawei

PDF

摘要： 一个测量部位的色差数据通常包括多个元素，而整台车的外表面又包含多个测量部位，即 多组数据，且各组数据间又有匹配和相合关系。色差数据如果用纯文字展示，不但不便于阅读， 还不便于展示各元素间的关系。为了解决这一问题，利用 Power BI 强大的信息分拣与可视化功能， 开发了一种展示工具。该工具用简洁、清晰的方法展示诸如色差数据这类包含多个元素且有匹配 关系的信息，并展示其变化趋势。有助于指导质量优化，并促进该项工作的跨单位、跨部门协作。

关键词: Power BI；信息可视化；色差

Abstract: One measuring area of colour matching usually includes multiple elements. The exterior surface of the whole car also includes multiple measuring areas, or multiple sets of data. Matching relationships also exist between the data sets. Colour matching data shown in text only are hard to read and display the relationship between elements. For solving this problem, the powerful information sorting and visualization function of Power BI is applied to develop a sort of display tool. This tool shows the data, for instance, the colour matching, which contain multiple elements and their matching relationship, besides, the trend, in a lucid form. That guides the quality optimization and promotes cross-unit and cross-departmental collaboration in this project.

Key words: Power BI; Information visualization; Colour matching