20.500.12556/RUL-185168 Optimizacija proizvodnih procesov z analizo podatkov v okolju Power BI Optimization of manufacturing processes with data analysis in the Power BI environment Zaključna naloga obravnava optimizacijo proizvodnje s poudarkom na neučinkovitosti delovnih mest in nastajanju ozkih grl. Cilj naloge je vzpostaviti analitični pristop za podporo odločanju na podlagi podatkov iz proizvodnih sistemov. Podatki se najprej pridobijo iz delovnih mest ter analizirajo z namenom razumevanja podatkovne strukture. Sledi priprava podatkov z uporabo SQL poizvedb in oblikovanje pogledov, optimiziranih za okolje Power BI. V Power BI se izdelajo poročila in analize, ki omogočajo vpogled v učinkovitost proizvodnje, zastoje in KPI. Na podlagi rezultatov se identificirajo ključne pomanjkljivosti ter predlagajo ukrepi za izboljšanje proizvodnih procesov. Ugotovitve kažejo na potrebo po vzpostavitvi norm in izboljšanju planiranja proizvodnje ter optimizaciji manj učinkovitih delovnih mest. This bachelor’s thesis addresses production optimization with a focus on workplace inefficiencies and bottlenecks in the manufacturing process. The aim is to establish a data-driven analytical approach to support decision-making. Data is collected from production systems and analyzed to understand the database structure. SQL queries are then used to prepare and transform the data into views optimized for the Power BI environment. In Power BI, reports and analyses are developed to provide insights into production efficiency, downtime, and key performance indicators (KPIs). Based on the results, main inefficiencies are identified and measures for improving production processes are proposed. The findings highlight the need for production standards, improved production planning, and optimization of low-efficiency workstations. optimizacija proizvodnje Power BI poročila analiza podatkov Microsoft SQL Server proizvodni procesi podatkovno modeliranje production optimization Power BI reports data analysis Microsoft SQL Server manufacturing processes data modeling true false false Slovenski jezik Angleški jezik Diplomsko delo/naloga 2026-07-25 08:31:02 2026-07-25 08:31:11 2026-07-26 04:01:03 0000-00-00 00:00:00 2026 0 0 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 1970-01-01 287409 47173.pdf 47173.pdf 1 0AD4BD9E2EE924F98297CAFB9FC12DC8 7d20976b7feb1babf721af1b9c733985418d96164a787fb9762128cbeb629049 2d116713-87f2-11f1-9b0d-0050569b8976 https://repozitorij.uni-lj.si/Dokument.php?lang=slv&id=243398 Fakulteta za strojništvo 0 0 0