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.