{"title":"先进的分析制造数据在Excel和它的插件","authors":"E. Kajati, M. Miskuf, P. Papcun","doi":"10.1109/SAMI.2017.7880359","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":105599,"journal":{"name":"2017 IEEE 15th International Symposium on Applied Machine Intelligence and Informatics (SAMI)","volume":"124 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"5","resultStr":"{\"title\":\"Advanced analysis of manufacturing data in Excel and its Add-ins\",\"authors\":\"E. Kajati, M. Miskuf, P. Papcun\",\"doi\":\"10.1109/SAMI.2017.7880359\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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.\",\"PeriodicalId\":105599,\"journal\":{\"name\":\"2017 IEEE 15th International Symposium on Applied Machine Intelligence and Informatics (SAMI)\",\"volume\":\"124 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"1900-01-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"5\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2017 IEEE 15th International Symposium on Applied Machine Intelligence and Informatics (SAMI)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/SAMI.2017.7880359\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2017 IEEE 15th International Symposium on Applied Machine Intelligence and Informatics (SAMI)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/SAMI.2017.7880359","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 5
摘要
本文重点介绍了应用商业智能(BI)的先进工具、技术和方法进行业务分析和数据分析。这些工具使公司能够获得竞争优势并改进其流程。我们有斯洛伐克最大的钢铁厂的数据。在[1]和[2]论文中，我们使用了BI解决方案，并要求所有报告都必须使用Microsoft Excel支持的格式。在本文中，我们决定使用Excel和插件，如Power Query, Power Pivot, Power View, Power Map和Power BI进行高级业务分析。依次使用选定的Excel Add-ins并根据可用数据创建了一个完整的管理信息系统，能够响应各种查询。
Advanced analysis of manufacturing data in Excel and its Add-ins
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.
求助内容：
应助结果提醒方式：
京公网安备 11010802042870号
