Acta Mechanica Slovaca 2026, 30(1):16-19 | DOI: 10.21496/ams.2026.009

Using Power BI to Analyse Withdrawals from Company Dispensing Machines

Andrea Šimerová1, *, Pavel Raška1, Michal Šimon1
Department of Industrial Engineering and Management, University of West Bohemia in Pilsen, Univerzitní 2762/22, 301 00 Plzeň 3, Czech Republic

This paper describes the design, development and deployment of an interactive Power BI report intended for the finance department of a manufacturing company. The report analyses material withdrawals from in‑plant dispensing machines and relates them to monthly production hours at the cost centre level. A complete workflow is presented, including data acquisition from multiple Microsoft Excel sources, data cleaning and transformation, construction of a relational data model, and the definition of key metrics using Data Analysis Expressions (DAX). The resulting solution comprises a set of report pages for (i) comparing total withdrawals with production hours over time and (ii) analysing withdrawals by valuation class and withdrawal frequency, including identification of the most frequently withdrawn items. To address confidentiality and compliance with the General Data Protection Regulation (GDPR), cost centre names were anonymised, and financial values were intentionally blurred in the presented screenshots. The case study demonstrates how a self‑service BI tool can reduce manual processing, improve transparency of key indicators and support timely decision‑making in financial controlling.

Keywords: business intelligence; Power BI; DAX; ETL; cost centre; production hours; industrial vending machine; financial controlling

Received: February 2, 2026; Revised: February 2, 2026; Accepted: March 5, 2026; Published: April 1, 2026  Show citation

ACS AIP APA ASA Harvard Chicago Chicago Notes IEEE ISO690 MLA NLM Turabian Vancouver
Šimerová, A., Raška, P., & Šimon, M. (2026). Using Power BI to Analyse Withdrawals from Company Dispensing Machines. Acta Mechanica Slovaca, 30(1), 16-19. doi: 10.21496/ams.2026.009
Share...
Download citation
  • BibTeX (.bib)
  • Bookends (.ris)
  • EasyBib (.ris)
  • EndNote (.enw)
  • EndNote 8 (.xml)
  • ISI WoS (.isi)
  • Medlars (.medlars)
  • Mendeley (.ris)
  • MODS (.xml)
  • Papers (.ris)
  • RefWorks (.txt)
  • RefManager (.ris)
  • RIS (.ris)
  • MS Word (.xml)
  • Zotero (.ris)
    • Open full article

    References

    1. Novotný, O.; Pour, J.; Slánský, D. (2005). Business Intelligence: jak využít bohatství ve vašich datech. Grada, Prague. ISBN 80-247-1094-3.
    2. Microsoft. Data visualisation | Microsoft Power BI (online). Available at: https://powerbi.microsoft.com/cs-cz/ (accessed 27 July 2025).
    3. Lago, C. 150 years of Business Intelligence: a brief history. CIO (online). Available at: https://www.cio.com/article/221963/history-of-business-intelligence.html (accessed 27 July 2025).
    4. Pour, J.; Maryčka, M.; Novotný, O. (2012). Business Intelligence v podnikové praxi. Professional Publishing, Prague. ISBN 978-80-7431-065-2.
    5. Kovanicová, D. (2004). Jak porozumět světovým, evropským, českým účetním výkazům: cesta k účinnému controllingu. Polygon, Prague. ISBN 80-727-3095-9.
    6. Deckler, G. (2022). Learn Power BI: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence. 2nd ed. Packt Publishing. ISBN 978-1801811958.
    7. Microsoft. Power BI documentation (online). Available at: https://learn.microsoft.com/cs-cz/power-bi/ (accessed 27 July 2025).
    8. Chmelár, M. (2018). Reporting v Power BI, PowerPivot a jazyk DAX. Smart People, Pezinok. ISBN 978-80-9773078-0-6.
    9. Microsoft. Power BI (online). Available at: https://app.powerbi.com/home?experience=power-bi (accessed 27 July 2025).
    10. Šimerová, A.; Kubičková, H.; Rubášová, A. (2025). Návodka pro Power BI Desktop Daimler Buses. Internal document.

    This is an open access article distributed under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits use, distribution, and reproduction in any medium, provided the original publication is properly cited. No use, distribution or reproduction is permitted which does not comply with these terms.


    Return to the content