Advanced Analysis of Manufacturing Data in Excel and Its Add-ins
2017 IEEE 15TH INTERNATIONAL SYMPOSIUM ON APPLIED MACHINE INTELLIGENCE AND INFORMATICS (SAMI)(2017)
摘要
This article focuses on the business analytics and data analysis by application of the advanced tools, technologies and methods of Business Intelligence (BI). These tools enable companies to gain competitive advantage and improve their processes. We had data from the biggest steel factory in Slovakia. In papers [1], [2] we worked with BI solutions and there was request that all reports have to be in formats supported by Microsoft Excel. In this paper, we decided to use Excel and Add-ins like Power Query, Power Pivot, Power View, Power Map, and Power BI for advanced business analysis. Sequentially with the selected Excel Add-ins and based on the available data a complete management information system has been created, capable respond to various queries.
更多查看译文
关键词
manufacturing data analysis,business analytics,business intelligence,companies,competitive advantage,steel factory,Slovakia,BI solutions,Microsoft Excel,Power Query,Power Pivot,Power View,Power Map,Power BI,Excel add-ins,management information system
AI 理解论文
溯源树
样例
![](https://originalfileserver.aminer.cn/sys/aminer/pubs/mrt_preview.jpeg)
生成溯源树,研究论文发展脉络
Chat Paper
正在生成论文摘要