Big Data Visualization of E-invoices on Alcohol Expenditure

• Main Authors: Li-An Chien, 簡苙安
• Other Authors: Chien-wen Shen
• Format: Others
• Language: en_US
• Published: 2016
• Online Access: http://ndltd.ncl.edu.tw/handle/52352013909538172299

碩士 === 國立中央大學 === 企業管理學系 === 104 === The global alcoholic beverage industry is an estimated USD 900 billion business in 2015. Previous researches on the topic of alcohol expenditure generally use data from surveys and market research to analyze the relationships between influencing factors and alcohol expenditure. However, since Taiwan is among leading countries adopting nationwide e-invoice usage toward reducing transaction cost in corporate and public sector, it’s worth utilizing e-invoice transaction data to learn about alcohol spending behavior. Accordingly, this study aims to explore the information of alcohol expenditure from e-invoice data. Data cleansing and classification were conducted in this study and the results were presented by the methods of data visualization. From the perspective of hourly pattern, 11 am, 3 pm and 8 pm were the peak hours of alcohol spending in Taiwan. In addition, by using dual chart to visualize the analysis, it is concluded that there was a significantly moderate correlation between alcohol expenditure and CPI. On the other hand, monitoring indicator and alcohol expenditure were not closely related. Furthermore, the evident difference of alcohol expenditure was shown between the northern and the southern region by visualized methods such as filled maps with pie charts, bubble charts, treemaps and box plots. Hence, this study provides the visualized insights to the related industries such as tobacco and alcohol to explore business opportunities by region.