n cmptng, dt wrhs (DW r DWH), ls knwn s n ntrprs dt wrhs (DW), s systm sd fr rprtng nd dt nlyss nd s cr cmpnnt f bsnss ntllgnc. Dt wrhss r cntrl rpstrs f dt ntgrtd frm dsprt srcs. Thy str crrnt nd hstrcl dt rgnzd n wy tht s ptmzd fr dt nlyss, gnrtn f rprts, nd dvlpng nsghts crss th ntgrtd dt. Thy r ntndd t b sd by nlysts nd mngrs t hlp mk rgnztnl dcsns.
Th dt strd n th wrhs s pldd frm prtnl systms (sch s mrktng r sls). Th dt my pss thrgh n prtnl dt str nd my rqr dt clnsng fr ddtnl prtns t nsr dt qlty bfr t s sd n th dt wrhs fr rprtng.
Th tw mn wrkflws fr bldng dt wrhs systm r xtrct, trnsfrm, ld (TL) nd xtrct, ld, trnsfrm (LT).