View of Analiza danych produkcyjnych na podstawie transakcji w systemie ERP z wykorzystaniem technologii Business Intelligence

RUJDQL]DFMDL]DU]ĈG]DQLH

62

7–8

Wojciech Danilczuk

Analiza danych produkcyjnych na podstawie transakcji w systemie ERP z wykorzystaniem technologii Business Intelligence

JEL: C81. DOI: 10.24136/atest.2019.192.

DDWD]JâRV]HQLD: 08.05.2019. DDWDDNFHSWDFML: 08.06.2019.

W artykule przedstawiono sposób analizy danych produkcyjnych rejestrowanych przez pracowników produkcyjnych w systemie (53=DSUH]HQWRZDQRSRZLĉ]DQLDORJLF]QHZ\VWĘSXMĉFHZV\VWH- PLH(53SR]ZDODMĉFHQDSRâĉF]HQLH]HVREĉLQIRUPDFML]REV]D- UyZNDGU\²F]DVSUDF\²SURGXNFMD1DSRGVWDZLHW\FKSRZLĉ]DĽ

DXWRUSU]HGVWDZLPHWRGĘSUH]HQWDFMLDJUHJRZDQLDLDQDOL]\GD- Q\FKSURGXNF\MQ\FK]Z\NRU]\VWDQLHPQDU]ĘG]L2/$3LWHFKQROR- JLL%XVVLQHV,QWHOOLJHQFH

6âRZDNOXF]RZH: Business IntelligenceDQDOL]DGDQ\FK]DU]ĉG]D- QLHSU]HGVLĘELRUVWZHP

:VWĘS

6\VWHP\NODV\(53DQJEnterprise Resource PlanningVĉMHG- Q\PL]NOXF]RZ\FKHOHPHQWyZZVSRPDJDMĉF\FK]DU]ĉG]DQLH

SU]HGVLĘELRUVWZHP3RGVWDZRZ\P]DGDQLHPW\FKV\VWHPyZ

MHVWHZLGHQFMD]GDU]HĽJRVSRGDUF]\FKPDMĉF\FKPLHMVFHZÀU- PLH:V]\VWNLH]GDU]HQLD²WUDQVDNFMH²Vĉ]DSLV\ZDQHZED]LH

GDQ\FKDGRVWĘSGRQLFKMHVWPRŮOLZ\SU]H]DSOLNDFMĘ6\VWHP\

NODV\(53]GHÀQLFMLPRJĉREHMPRZDýZV]\VWNLHREV]DU\IXQNFMR- QDOQHSU]HGVLĘELRUVWZDPLQNDGU\ÀQDQVHNRV]W\NVLĘJRZRŒý

JRVSRGDUNĘPDJD]\QRZĉ]DU]ĉG]DQLHUHODFMDPL]NOLHQWHP]D- PyZLHQLDG\VWU\EXFMD]DU]ĉG]DQLHSURGXNFMĉ>@

3U]\NâDGHPV\VWHPXNODV\(53MHVWSURJUDP,038/6(92SRO- VNLHMSURGXNFMLÀUP\%LXUR3URMHNWRZDQLD6\VWHPyZ&\IURZ\FK

6$2EHFQLHQDU\QNXGRVWĘSQDMHVWZHUVMDDSOLNDFML,038/6

(92D]RSURJUDPRZDQLDNRU]\VWDSRQDGÀUP6\VWHPRSLH- UDVLĘRED]ĘGDQ\FK2UDFOH*'RVWĘSGRV\VWHPXPRŮOLZ\

MHVWSU]H]DSOLNDFMĘGHVNWRSRZĉRUD]SRSU]H]WHUPLQDOHGRW\NR- ZHW]ZNLRVNL&]ĘŒýIXQNFMRQDOQRŒFLGRVWĘSQ\FKMDNUyZQLHŮ

SU]H]SU]HJOĉGDUNĘLQWHUQHWRZĉQS]DU]ĉG]DQLHRELHJLHPGR- NXPHQWyZ>@

-HGQ\P]JâyZQ\FK]DOHWV\VWHPyZ(53MHVWSRâĉF]HQLH]H

VREĉUyŮQ\FKREV]DUyZG]LDâDOQRŒFLSU]HGVLĘELRUVWZD]JRGQLH

]SURFHVDPL]DFKRG]ĉF\PLZSU]HGVLĘELRUVWZLHRUD]ZRSDUFLX

RPRGHOHPORJLF]Q\PLEL]QHVRZ\PGDQHMÀUP\>@&]ĘVWR

MHGQDNWHSRâĉF]HQLDQLHVĉZLGRF]QH]SXQNWXZLG]HQLDSRMH- G\QF]HJRXŮ\WNRZQLNDV\VWHPXOHF]Vĉ]DV]\WHZZDUVWZLHGD- Q\FKJURPDG]RQ\FKQDVHUZHUDFKED]GDQ\FK0RŮHVWDQRZLý

WRRJUDQLF]HQLHZSRGHMPRZDQLXGHF\]ML]DU]ĉGF]\FKSU]H]

PDQDJHUyZLGHF\GHQWyZ1LHZLG]ĉFFDâRŒFLSRZLĉ]DĽPLĘG]\

SURFHVDPL]DFKRG]ĉF\PLZUyŮQ\FKREV]DUDFKG]LDâDOQRŒFLÀUP\

SRGHMPRZDQLHGHF\]MLPRŮHE\ýREDUF]RQHGXŮ\PU\]\NLHPOXE

QLHSHZQRŒFLĉ'ODWHJR]SXQNWXZLG]HQLDNDGU\]DU]ĉG]DMĉFHM

QLH]EĘGQHMHVWSRVLDGDQLHRGSRZLHGQLFKQDU]ĘG]LUDSRUWXMĉF\FK

RUD]ZVSLHUDMĉF\FKDQDOL]ĘGDQ\FK1LHVWHW\F]ĘVWRV\VWHP\NODV\

(53VĉSR]EDZLRQHRGSRZLHGQLFKPRGXâyZUDSRUWXMĉF\FKOXE

VĉRQH]E\WXERJLHZVWRVXQNXGR]PLHQLDMĉF\FKVLĘSRWU]HE

PDQDJHUyZ-HGQ\P]SRGVWDZRZ\FK]DGDĽV\VWHPX(53MHVW

ZVSRPQLDQHZ\ŮHMJURPDG]HQLHGDQ\FKWUDQVDNF\MQ\FKQLH]DŒ

DQDOL]DW\FKGDQ\FKLUDSRUWRZDQLH1LHPQLHMGDQH]JRUPDG]R- QHZV\VWHPDFK(53VWDQRZLĉSRGVWDZRZHLQIRUPDFMHMDNLPL

PRŮHP\VLĘSRVâXŮ\ýGREXGRZDQLDV]F]HJyâRZ\FK]HVWDZLHĽ

LDQDOL]:W\PFHOXPRŮHP\Z\NRU]\VWDýQDU]ĘG]LDNODV\%XV- VLQHV,QWHOOLJHQFHRUD]WHFKQRORJLĘ2/$3ED]XMĉFĉQDGDQ\FK

]JURPDG]RQ\FKSU]H]V\VWHPWUDQVDNF\MQ\>@

6\VWHP\%XVLQHVV,QWHOOLJHQFH

=JRGQLH]NODV\F]QĉGHILQLFMĉÅBusiness Intelligence%,MHVW

WR]RULHQWRZDQ\QDXŮ\WNRZQLNDSURFHV]ELHUDQLDHNVSORUDFML

LQWHUSUHWDFMLLDQDOL]\GDQ\FKNWyU\SURZDG]LGRXVSUDZQLHQLD

L]UDFMRQDOL]RZDQLDSURFHVXSRGHMPRZDQLDGHF\]ML6\VWHP\WH

ZVSLHUDMĉNDGUĘPHQDGŮHUVNĉZSRGHMPRZDQLXGHF\]MLEL]QHVR- Z\FKZFHOXNUHRZDQLDZ]URVWXZDUWRŒFLSU]HGVLĘELRUVWZDµ>

@,QQDGHÀQLFMDSRGDMHŮH%,MHVW]ELRUHPSUDNW\NG]LDâDĽRUD]

WHFKQRORJLLNWyUHSU]HNV]WDâFDMĉGDQHZXŮ\WHF]QHLQIRUPDFMH

EL]QHVRZH>@

1LHZĉWSOLZ\PŬUyGâHPGDQ\FKRSURFHVDFK]DFKRG]ĉF\FK

ZHZQĉWU]SU]HGVLĘELRUVWZDVĉGDQH]JRUPDG]RQHZV\VWHPDFK

(351DWXUDOQHMHVWZLĘFZ\NRU]\VWDQLHW\FKGDQ\FKMDNRGDQ\FK

ZHMŒFLRZ\FKGODV\VWHPX%,ZFHOXWUDQVIRUPDFMLLFKZXŮ\WHF]QH

EL]QHVRZRLQIRUPDFMHXâDWZLDMĉFHNDGU]H]DU]ĉG]DMĉFHMDQDOL]Ę

V\WXDFMLRUD]SRGHMPRZDQLHGHF\]ML

7HFKQRORJLD2/$3

-HGQĉ]SRZV]HFKQLHMVWRVRZDQ\FKWHFKQRORJLLZUDPDFKV\V- WHPyZ%,MHVWWHFKQRORJLD2/$3DQJ2Q/LQH$QDO\WLFDO3URFHV- VLQJ2SLHUDVLĘRQDQD]DVDGDFKZLHORZ\PLDURZ\FKED]DFK

GDQ\FKDQJMultidimensional data base0'%>@%D]ĘZLHOR- Z\PLDURZĉPRŮQDRNUHŒOLýMDNRNRVWNĘDQJcube:SRV]F]H- JyOQ\FKZ\PLDUDFKNRVWNLDQJdimensionsSU]HFKRZ\ZDQH

Vĉ]DJUHJRZDQHGDQHZHGâXJZVND]DQ\FKNU\WHULyZQSF]DV

UHJLRQSURGXNWU\V:\PLDU\WHPRJĉWZRU]\ýKLHUDUFKLH

5\V3U]\NâDGNRVWNL2/$3>@

RUJDQL]DFMDL]DU]ĈG]DQLH

AUTOBUSY

7–8

63

²PRJĉZ\VWĘSRZDýUyŮQHSR]LRP\QSZ\PLDUF]DVXPRŮH

G]LHOLýVLĘQDODWDPLHVLĉFHGQL.RVWNL2/3$Vĉ]DVLODQHGD- Q\PLSRFKRG]ĉF\PL]V\VWHPyZWUDQVDNF\MQ\FK:UR]ZDŮDQ\P

SU]\SDGNXVĉWRGDQH]JURPDG]RQHZUDPDFKIXQNFMRQRZDQLD

V\VWHPX(53

:UDPDFKDQDOL]\ZLHORZ\PLDURZHMQDNRVWNDFK2/3$PRJĉ

]RVWDýZ\NRQDQHQDVWĘSXMĉFHRSHUDFMH>@

¡

GUĉŮHQLHGDQ\FKDQJdrill downLDJUHJRZDQLHDQJdrill up),

¡

REUDFDQLHDQJrotation),

¡

VHOHNFMLDQJslicing),

¡

UDQNLQJRZDQLHDQJrating),

¡

ÀOWURZDQLDDQJÀOWUDWLRQ),

¡

VRUWRZDQLHDQJsorting),

3U]\NâDG]DVWRVRZDQLHWHFKQRORJLL%,L2/$3]DVLODQ\PLGDQ\PL

]V\VWHPX(53

-DNRSU]\NâDG]DVWRVRZDQLDWHFKQRORJLL%,RUD]2/$3]DVLODQ\FK

GDQ\PL]V\VWHPX(53PRŮQDSRGDýVWZRU]HQLHUDSRUWXGRDQD- OL]\F]DVXSUDF\]DUHMHVWURZDQHJRSU]H]SUDFRZQLNyZUyŮQ\FK

Z\G]LDâyZQDSRV]F]HJyOQH]OHFHQLDSURGXNF\MQH

5R]ZDŮP\SU]HGVLĘELRUVWZRNWyUH]DMPXMHVLĘSURGXNFMĉ

MHGQRVWNRZĉVSHFMDOLVW\F]Q\FKPDV]\QSURMHNWRZDQ\FKSRG]D- PyZLHQLHNOLHQWDDQJengineering to order(723URFHVSUR- GXNF\MQHRSLHUDVLĘR]OHFHQLDSURGXNF\MQHGRW\F]ĉFHSRV]F]H- JyOQ\FKXU]ĉG]HĽ=OHFHQLDPRJĉQDOHŮHýGRUyŮQ\FKNDWHJRULL

SURMHNWRZDQLHSURGXNFMDF]ĘŒFLPRQWDŮLXUXFKRPLHQLHVHUZLV

JZDUDQF\MQ\HFW(ZLGHQFMDF]DVXSUDF\SU]H]SUDFRZQLNyZSUR- GXNF\MQ\FKRGE\ZDVLĘQDSRV]F]HJyOQH]OHFHQLDSURGXNF\MQH

:LHG]DRLORŒFL]DUHMHVWURZDQ\FKJRG]LQQDSRV]F]HJyOQH

SURMHNW\MHVWSRWU]HEQDPDQDJHURPGRPRQLWRURZDQLDZ\GDMQR- ŒFLSUDFRZQLNyZZSRV]F]HJyOQ\FKREV]DUDFKSURGXNF\MQ\FK

RNUHŒOHQLHZ\NRU]\VWDQLDEXGŮHWyZJRG]LQRZ\FKQDSRV]F]H- JyOQHSURMHNW\DQDOL]\UR]NâDGXF]DVXSUDF\QDSRV]F]HJyOQH

URG]DMH]OHFHĽRGSRZLDGDMĉFHUyŮQ\PDNW\ZQRŒFLRPL]GDU]H- QLRPQDSURGXNFMLRUD]XG]LDâXJRG]LQRZHJRSRV]F]HJyOQ\FK

JQLD]GSURGXNF\MQ\FKZGDQ\P]OHFHQLXSU]\SURGXNFMLGDQHJR

XU]ĉG]HQLD

:V\VWHPLH,038/6(92GDQHGRW\F]ĉFHUHMHVWUDFMLF]DVX

SUDF\VĉGRVWĘSQHZPRGXOH.DUW\3UDF.LHURZQLF\REV]DUyZ

SURGXNF\MQ\FKQLHPDMĉGRVWĘSXGRWHJRPRGXâX=NROHLLQIRU- PDFMHR]OHFHQLDFKSURGXNF\MQ\FKVĉGRVWĘSQH]SR]LRPX.DUWR- WHNL=OHFHĽ3URGXNF\MQ\FK=NROHLZIRUPDWFH2VRE\]QDMGXMĉVLĘ

LQIRUPDFMĘRVWDQRZLVNDFKQDMDNLFKVĉ]DWUXGQLHQLSRV]F]HJyOQL

SUDFRZQLF\DZLĘFLFKSU]\SLVDQLHGRSRV]F]HJyOQ\FKREV]DUyZ

SURGXNF\MQ\FK

3U]\XŮ\FLXDSOLNDFMLPRŮOLZHMHVWMHG\QLHREOLF]HQLHVXP\

JRG]LQ]DUHMHVWURZDQ\FKâĉF]QLHQDGDQH]OHFHQLHSURGXNF\MQH

U\V1LHPDPRŮOLZRŒFLSU]HSURZDG]HQLDLQQ\FKEDUG]LHM

]DZDQVRZDQ\FKDQDOL]$E\PRŮOLZHE\âRRSUDFRZDQLHWDNLHJR

UDSRUWXQDOHŮ\VWZRU]\ýZLHORZ\PLDURZDNRVWNĘ2/$3NWyUDSR- ZLĉŮHLQIRUPDFMĘ]REV]DUyZNDGURUD]SURGXNFML

%XGRZDQLHNRVWNL2/$3

3LHUZV]\PHWDSHPEXGRZ\WDNLHMNRVWNLMHVWRNUHŒOHQLHORJLF]Q\FK

SRZLĉ]DĽSRPLĘG]\GDQ\PL:V]\VWNLHLQIRUPDFMHSRWU]HEQHGR

MHMSU]\JRWRZDQLD]DZDUWHVĉZWDEHODFKGDQ\FK]JURPDG]RQ\FK

ZED]LHWUDQVDNF\MQHMV\VWHPX(53:FHOX]EXGRZDQLPRGHOX

ORJLF]QHJRQDOHŮ\SU]\JRWRZDýZLGRNSU]\XŮ\FLXMĘ]\ND64/DQJ

6WUXFWXUHG4XHU\/DQJXDJHREVâXJXMĉFHJRED]ĘGDQ\FK

'DQHMDNLHFKFHP\DQDOL]RZDýQDOHŮ\SRâĉF]\ý]HVREĉSU]\

XŮ\FLXNOXF]\JâyZQ\FKDQJprimery keyRNUHŒODMĉF\FKORJLNĘ 5\V=DS\WDQLHWZRU]ĉFHNRVWNĘ2/$3 ūUyGâRRSUDFZâDVQH

5\V Fragment formatki Karty Pracy ūUyGâRRSUDFZâDVQH

5\V6FKHPDWSRZLĉ]DĽ

ūUyGâRRSUDFZâDVQH

RUJDQL]DFMDL]DU]ĈG]DQLH

64

7–8

SRZLĉ]DĽPLHG]\WDEHODPLED]\GDQ\FK-HVW

WR MHGQRF]HŒQLH RGZ]RURZDQLH ORJLF]- Q\FKSRâĉF]HĽEL]QHVRZ\FKZ\VWĘSXMĉF\FK

ZSU]HGVLĘELRUVWZLH

:UR]ZDŮDQ\PSU]\SDGNXPXVLP\SRâĉ- F]\ý]HVREĉLQIRUPDFMH]DZDUWHZWDEHOL

RVRE\LPLĘQD]ZLVNRVWDQRZLVNRLWG]WD- EHOĉNDUW\SUDF\GDWDUHMHVWUDFMLF]DVXSUDF\

LORŒýJRG]LQ]OHFHQLQDNWyUH]DUHMHVWURZDQR

F]DVSUDF\LWG.OXF]HPJâyZQ\PâĉF]ĉF\P

WHWDEHOHMHVW,'RVRE\1DVWĘSQLHNDUW\SUDF\

âĉF]\P\]WDEHOĉ]OHFHQLDSURGXNF\MQH]DZLH- UDMĉFĉLQIRUPDFMĘRQXPHU]H]OHFHQLDLORŒFL

]OHFRQ\FKV]WXNSODQRZDQ\FKGDWDFK]DNRĽ- F]HQLD]OHFHQLD]OHFHQLDFKSRZLĉ]DQ\FKLWG

.OXF]HPJâyZQ\PEĘG]LHZW\PSU]\SDGNXQX- PHU]OHFHQLDZ\VWĘSXMĉF\ZREXWDEHODFK1D

NRQLHFSRâĉF]\P\LVWQLHMĉF\PRGHO]HVâRZQL- NLHPURG]DMyZ]OHFHĽZ\VWĘSXMĉF\FKZWDEHOL

VâRZQLNL]OHFHĽ:W\PSU]\SDGNXORJLF]Q\P

SRâĉF]HQLHPEĘGĉSLHUZV]H]QDNL]QXPH- UX]OHFHQLDRNUHŒODMĉFHURG]DMDNW\ZQRŒFLQD

SURGXNFML6FKHPDWSRZLĉ]DĽSU]HGVWDZLRQ\

MHVWQDU\VXQNX5\VXQHNSU]HGVWDZLD]D- S\WDQLHWZRU]ĉFHNRVWNĘ

3RRNUHŒOHQLXNOXF]\JâyZQ\FKRUD]SRâĉ- F]HĽ]GDQ\PLVâRZQLNRZ\PLPRŮHP\SU]\JR- WRZDý]DS\WDQLHNWyUH]JURPDG]LGDQH]UyŮ- Q\FKREV]DUyZIXQNFMRQDOQ\FKV\VWHPX(53

ZMHGQĉZLHORZ\PLDURZĉNRVWNĘGDQ\FK

:LHORZ\PLDURZDDQDOL]DGDQ\FK

:FHOXSU]HSURZDG]HQLDZLHORZ\PLDURZHM

DQDOL]\GDQ\FKSRVâXŮ\P\VLĘQDU]ĘG]LHP

([FHO-HVWWRSRZV]HFKQLHZ\NRU]\VW\ZDQH

ZSU]HGVLĘELRUVWZDFKRSURJUDPRZDQLHGR

SU]HSURZDG]DQLDNDONXODFMLUDSRUWRZDQLD

LDQDOL]'RZL]XDOL]DFMLGDQ\FK]JURPDG]R- Q\FKZNRVWFH2/$3SRVâXŮ\P\VLĘ7DEHODPL

3U]HVWDZQ\PLDQJpivot table3URJUDP

([FHOZUDPDFKVWDQGDUGRZHMIXQNFMRQDO- QRŒFLSR]ZDODXŮ\WNRZQLNRPQDSRâĉF]HQLH

DUNXV]DNDONXODF\MQHJR]ED]ĉGDQ\FK>@

:RPDZLDQ\PSU]\SDGNXDUNXV]]RVWDâSR- âĉF]RQ\]Z\QLNLHP]DS\WDQLD64/WZRU]ĉFH- JRNRVWNĘ2/$3U\V$UNXV]NDONXODF\MQ\

SR]ZDODQDPRGŒZLHŮDýGDQH]DZDUWHZWDEHOL:SU]\SDG- NXSRMDZLHQLDVLĘQRZ\FKUHNRUGyZZED]LHGDQ\FK]RVWDQĉ

RQH]DLPSRUWRZDQHGRVNRURV]\WX

3RâĉF]HQLHGDQ\FKŬUyGâRZ\FKGRDUNXV]DNDONXODF\M- QHJRSR]ZDODQDPQDGDOV]ĉPRŮOLZRŒýREUyENLGDQ\FK

=DâyŮP\ŮHFKFLHOLE\ŒP\]GDW\UHMHVWUDFML]GDU]HQLDZ\- FLĉJQĉýQXPHUW\JRGQLD0RJOLE\ŒP\]URELýWRQDSR]LRPLH

]DS\WDQLD64/OHF]ZSU]\SDGNXEUDNX]QDMRPRŒFLRGSR- ZLHGQLFKSROHFHĽZMĘ]\NX64/OXEEUDNXEH]SRŒUHGQLHJR

GRVWĘSXGRED]\GDQ\FKQLHPLHOLE\ŒP\WDNLHMPRŮOLZRŒFL

3RQLHZDŮGDQH]JURPDG]RQHVĉZ([FHOXPRŮHP\WRREOL- F]HQLHZ\NRQDýSU]\XŮ\FLXVWDQGDUGRZ\FKIRUPXâDUNXV]D

NDONXODF\MQHJR

5\V8G]LDâURG]DMyZ]OHFHĽZGDQ\PPLHVLĉFX ūUyGâRRSUDFZâDVQH

5\V'DQHUHSUH]HQWRZDQHVĉMDNRWDEHODGDQ\FKZSURJUDPLH([FHO ūUyGâRRSUDFZâDVQH

5\V,ORŒýF]DVX]DUHMHVWURZDQDQD]OHFHQLH

ūUyGâRRSUDFZâDVQH

RUJDQL]DFMDL]DU]ĈG]DQLH

AUTOBUSY

7–8

65

3UH]HQWDFMDGDQ\FKZWDEHOLSU]HVWDZQHMXPRŮOLZLDQDPSU]H- SURZDG]DQLHDQDOL]ZLHORZ\PLDURZ\FK1DU]ĘG]LHWDEHOSU]H- VWDZQ\FKSR]ZDODQDPZGRZROQ\VSRVyEÅREUDFDýµNRVWNĉ

1DNROHMQ\FKU\VXQNDFKSU]HGVWDZLRQRDQDOL]\ED]XMĉFHQD

MHGQHMNRVWFH2/$33R]ZDODMĉRQHRGSRZLHG]LHýPDQDJHURP

QDS\WDQLD

¡

MDNDMHVWLORŒýF]DVX]DUHMHVWURZDQDQDGDQH]OHFHQLHU\V

¡

MDNLMHVWXG]LDâURG]DMyZ]OHFHĽZGDQ\PPLHVLĉFXZGDQ\P

G]LDOHU\V

¡

MDNZ\JOĉGDW\JRGQLRZ\UR]NâDGSUDF\ZMHGQ\PG]LDOHQDSR- V]F]HJyOQ\FKSUDFRZQLNyZU\V

:UDPDFKIXQNFMRQDOQRŒFLWDEHOSU]HVWDZQ\FKPRŮHP\GRâĉF]Dý

Z\NUHV\RUD]IRUPXâ\REOLF]HQLRZHED]XMĉFHQDGDQ\FKSUH]HQWRZD- Q\FKZWDEHODFK7DEHOHSU]HVWDZQHGDMĉQDPPRŮOLZRŒýZ\NRQ\- ZDQLDZV]\VWNLFKRSHUDFMLW\SRZ\FKGODDQDOL]\ZLHORZ\PLDURZ\FK

WDNLFKMDNGUĉŮHQLHVHOHNFMRQRZDQLHVRUWRZDQLHÀOWURZDQLHLWG

3RGVXPRZDQLH

6\VWHPX(53MDNRV\VWHP\WUDQVDNF\MQHVĉQLH]EĘGQHZSU]HG- VLĘELRUVWZDFKGRHZLGHQFML]GDU]HĽJRVSRGDUF]\FK-HGQDNLFK

SRWHQFMDâMDNRV\VWHP\ZVSLHUDQLDGHF\]MLMHVWRJUDQLF]RQ\'R

UDSRUWRZDQLDLGRVWDUF]DQLDLQIRUPDFMLQLH]EĘGQ\FKZGHF\]MDFK

]DU]ĉGF]\FK]RVWDâ\VWZRU]RQHV\VWHP\NODV\Business Intelligen- ce>@3UH]HQWRZDQ\ZDUW\NXOHSU]\NâDGSRND]XMHZMDNL

VSRVyEV\VWHP\NODV\%,PRJĉZVSRPDJDýLQIRUPDFMDPLPDQD- JHUyZZSRGHMPRZDQLXGHF\]ML]DU]ĉGF]\FK6\VWHP\(53QLH

SRVLDGDMĉWDNLHMHODVW\F]QRŒFLLZLHONRZ\PLDURZRŒFLZDQDOL]D

GDQ\FKFRWHFKQRORJLD2/$3SRQLHZDŮ]]DâRŮHQLDQLHVĉV\VWH- PDPLSU]H]QDF]RQ\PLGRFHOyZDQDOLW\F]Q\FK

2GVHSDURZDQLHZVSRVyEORJLF]Q\RUD]SURJUDPRZ\ZDUVWZ\

HZLGHQF\MQHMRGZDUVWZ\DQDOLW\F]QHMQLHVLH]HVREĉV]HUHJNR- U]\ŒFL0DQDJHURZLHZÀUPDFKF]ĘVWRQLHVĉRVREDPLHZLGHQ- FMXMĉF\PL]GDU]HQLDJRVSRGDUF]HZV\VWHPDFK(53LQLH]QDMĉ

W\FKV\VWHPyZ1DWRPLDVWDUNXV]HNDONXODF\MQHVĉGODQLFK]QD- Q\PŒURGRZLVNLHP]NWyU\PSRWUDÀĉZVSyâSUDFRZDý'RVWĘSGR

DQDOL]QLHREFLĉŮDIXQNFMRQRZDQLDV\VWHPX(53LQLHZ\PDJD

GRGDWNRZ\FKOLFHQFML$JUHJDFMDGDQ\FKZWDEHODFKSU]HVWDZQ\FK

SR]ZDODZâDWZ\VSRVyESU]HSURZDG]LýDQDOL]ĘLZUD]LHSRWU]HE\

]PLHQLýSUH]HQWRZDQHZ\PLDU\NRVWNLFRQLH]DZV]HMHVWPRŮOLZH

ZV\VWHPDFK(53

7HQGHQFMHQDU\QNXZVND]XMĉŮHV\VWHP\ZVSLHUDMĉFHGHF\]MH

DQJsupport decision systemVĉFRUD]EDUG]LHMSRZV]HFKQH

LSRŮĉGDQHQDU\QNX>@3UH]HQWRZDQHSU]\NâDGSU]HGVWDZLD

PRŮOLZRŒýZ\NRU]\VWDQLWDNLFKV\VWHPyZZRSDUFLXRWHFKQRORJLH

Business Intelligence]DVLODQĉGDQ\PL]V\VWHPyZ(53

%LEOLRJUDÀD

 *DUWQHU5HVHDUFK%XVLQHVV,QWHOOLJHQFH7RROV3HUVSHFWLYH

,'*

 -DQXV]HZVNL$)XQNFMRQDOQRŒýLQIRUPDW\F]Q\FKV\VWHPyZ

]DU]ĉG]DQLDWZintegrowane systemy transakcyjne:\- GDZQLFWZR1DXNRZH3:1:DUV]DZD

 -DQXV]HZVNL$)XQNFMRQDOQRŒýLQIRUPDW\F]Q\FKV\VWHPyZ

]DU]ĉG]DQLDWSystemy Business Intelligence:\GDZQLF- WZR1DXNRZH3:1:DUV]DZD

 -ĘGUD,6\VWHP\ZVSRPDJDMĉFH]DU]ĉG]DQLHSU]HGVLĘELRU- stwem –impuls evo –wprowadzanie danych osobowych do systemu, „$XWREXV\²7HFKQLND(NVSORDWDFMD6\VWHP\7UDQV- SRUWRZHµQU

 3RUWDOÀUP\%36&SURGXFHQWDV\VWHPX,038/6(92ZZZ

ESVFFRPSO

 3WDV]QLN$+XUWRZQLHGDQ\FK²F]\OLMDN]DSHZQLýGRVWĘS

GRZLHG]\WNZLĉFHMZGDQ\FK:DUV]DZVND:\ŮV]D6]NRâD

,QIRUPDW\NL:DUV]DZD

 5XG2%XVLQHVV,QWHOOLJHQFH6XFFHVV)DFWRUV7RROVIRU$OL- gning Your Business in the Global Economy:LOH\ 6RQV

+RERNHQ

 6XUPD-Business Intelligence. Systemy wspomagania de- cyzji biznesowych:\GDZQLFWZR1DXNRZH3:1:DUV]DZD



 :DONHQEDFK-([FHO3/%LEOLD+HOLRQ

$QDO\VLVRI3URGXFWLRQ'DWDRQWKH%DVLVRI7UDQVDFWLRQVL

WKH(536\VWHP8VLQJ%XVLQHVV,QWHOOLJHQFH7HFKQRORJ\

The paper presents a method of analyzing production data reg- istered by production employees in the ERP system. The logical connections appearing in the ERP system allowing to connect in- formation from the areas of staff – work time – production are presented. Based on these connections, the author will present a method for presenting, aggregating and analyzing production GDWDXVLQJ2/$3WRROVDQG%XVVLQHV,QWHOLJHQFHWHFKQRORJ\

.HZRUGV%XVLQHVV,QWHOOLJHQFHGDWDDQDO\VLVPDQDJHPHQW

$XWRU

PJULQŮWojciech Danilczuk²3ROLWHFKQLND/XEHOVND:\G]LDâ0H- FKDQLF]Q\.DWHGUD$XWRPDW\]DFML

5\V7\JRGQLRZ\UR]NâDGSUDF\ZGDQ\PG]LDOH

ūUyGâRRSUDFZâDVQH