Advanced analysis of manufacturing data in Excel and its Add-ins

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.

Cite this work

No public copy is stored for this record, so only the metadata is cited.

Stored only when both papers are in the corpus — 10 citations exist upstream.

Papers that cite the same references — the relational fallback while embeddings are still backfilling.