Hunhu hwe data mudura chinhu chakakosha chinodiwa kuti uwane ruzivo rwakakosha. Hunhu husina kunaka hunoita kuti pasave neketani isina kunaka mukufamba kwenguva.
Kutanga, kuvimba nemashoko anopiwa kunorasika. Vanhu vari kutanga kushandisa Bhizinesi Intelligence kunyorera zvishoma; mukana wekushandisa unoramba usina kutaurwa.
Nekuda kweizvozvo, imwezve mari muchirongwa chekuongorora inodaidzwa mubvunzo.
Basa remhando yedata
Iyo ficha ine chekuita nekuvandudza mhando yedata ndeye mega-yakakosha mumapurojekiti eBI. Nekudaro, haisi ropafadzo yehunyanzvi hwehunyanzvi chete.
Hunhu hwedata hunokanganiswawo nezvinhu zvakadai se
Corporate tsika
- Vashandi pachavo vanofarira kugadzira mhando yakanaka here?
- Kana zvisina kudaro, nei? Panogona kunge paine kupesana kwechido.
- Zvichida pane mitemo yekambani inosarudza kuti ndiani ane mhosva yehutano?
Maitiro acho
- Ndeipi data inogadzirwa pamagumo emaketani aya?
- Zvichida maitiro ekushanda anogadziriswa nenzira iyo iwe unoda "kumonyorora" kuratidza izvi kana kuti mamiriro acho chaiwo.
- Masisitimu anoshanda anoita ongororo yedata uye nekuyananisa ivo pachavo?
Wese munhu musangano ane basa remhando yedata mumasisitimu ekubika.
Tsanangudzo nerevo
Hunhu ndiko kugutsikana kwakaratidza kwezvinotarisirwa nevatengi.
Asi mhando yedata haina tsananguro. Nguva dzose inoratidza mamiriro ekushandiswa. Iyo data warehouse uye BI system inoshandisa zvinangwa zvakasiyana pane inoshanda sisitimu kunobva data.
Semuenzaniso, pane inoshanda sisitimu, iyo mutengi hunhu inogona kunge iri yekusarudza munda. Mune repository, hunhu uhu hunogona kushandiswa sechiyero uye kuzadza kwayo kunodiwa. Izvo, zvakare, zvinosuma kudiwa kwekuzadza madefault values.
Zvinodiwa zvekuchengetedza data zvinogara zvichichinja uye zvinowanzokwira pane izvo zvemashandisirwo masisitimu. Asi inogonawo kuva imwe nzira yakapoteredza, kana pasina chikonzero chekuchengetedza ruzivo rwakadzama kubva kuhurongwa hwekushanda mukuchengetedza.
Kuita kuti data yemhando ikwanise kuyerwa, zviyero zvayo zvinofanirwa kutsanangurwa. Vanhu vanoshandisa ruzivo uye manhamba ebasa ravo vanofanirwa kuve nechekuita mukutsanangura maitiro. Mhedzisiro yekubatanidzwa uku inogona kunge iri mutemo, uchitevera izvo munhu anogona kutaura nekutarisa patafura kana pane kukanganisa kana kwete. Mutemo uyu unofanirwa kuumbwa sechinyorwa/kodhi yekuzoongororwa.
Kuvandudza mhando yedata
Izvo hazvigoneke kuchenesa uye kugadzirisa ese ekufungidzira zvikanganiso panguva yekurodha data mudura. Hunhu hwakanaka hwe data hunogona kuwanikwa chete kuburikidza nekubatana kwepedyo pakati pevatori vechikamu vese. Vanhu vanoisa data mumasisitimu anoshanda vanofanirwa kudzidza kuti ndezvipi zviito zvinotungamira mukukanganisa.
Hunhu hwedata inzira. Nehurombo, masangano mazhinji haana zano rekuenderera mberi nekuvandudza. Vazhinji vanozviganhurira ivo chete kuchengetedza data uye havashandise iyo yakazara kugona kweanoongorora masisitimu. Kazhinji, pakugadzira matura edatha, 70-80% yebhajeti inoshandiswa pakuita kubatanidzwa kwedata. Iyo yekutarisa nekuvandudza maitiro inoramba isina kukwana, kana zvachose.
Tools
Kushandiswa kwezvishandiso zvesoftware kunogona kubatsira mukuita otomatiki kuvandudzwa kwemhando yedata uye kutarisa. Semuyenzaniso, ivo vanokwanisa zvizere otomatiki kusimbiswa kwehunyanzvi hwezvivakwa zvekuchengetera: fomati yemunda, kuvapo kwemaitiro akasarudzika, kutevedzera mazita emunda wetafura.
Zvinganyanya kuoma kutarisa zviri mukati. Sezvo zvinodiwa zvekuchengetedza zvichichinja, dudziro yedata inogonawo kuchinja. Chishandiso pachacho chinogona kuve chirongwa chikuru chinoda rutsigiro.
Tip
Relational dhatabhesi, umo zvitoro zvinowanzogadzirwa, zvine kugona kunoshamisa kugadzira maonero. Dzinogona kushandiswa kukurumidza kutarisa data kana iwe uchiziva zvakananga zvemukati. Imwe neimwe nyaya yekutsvaga kukanganisa kana dambudziko mune data inogona kurekodhwa muchimiro chemubvunzo wedatabase.
Nenzira iyi, hwaro hweruzivo nezvezviri mukati huchaumbwa. Chokwadi, zvikumbiro zvakadaro zvinofanira kukurumidza kuitwa. Maonero anowanzoda nguva shoma yemunhu kuchengetedza pane maturusi akavakirwa pamatafura. Maonero anogara akagadzirira kuratidza mhedzisiro yebvunzo.
Panyaya yemishumo yakakosha, maonero anogona kunge aine koramu nemugamuchiri. Zvine musoro kushandisa maturusi akafanana eBI kuzivisa nezve mamiriro emhando yedata mudura.
Muenzaniso:
Mubvunzo uyu wakanyorerwa dhatabhesi reOracle. Mumuenzaniso uyu, bvunzo dzinodzosa kukosha kwenhamba iyo inogona kududzirwa sezvaunoda. Iyo T_MIN uye T_MAX kukosha inogona kushandiswa kugadzirisa iyo alarm level. Iyo REPORT ndima yakamboshandiswa semeseji mune yekutengesa ETL chigadzirwa chaisaziva kutumira maemail nemazvo, saka rpad i "crutch".
Muchiitiko chetafura huru, unogona kuwedzera, semuenzaniso, UYE ROWNUM <= 10, i.e. kana paine zvikanganiso gumi, saka izvi zvakakwana kukonzeresa alarm.
CREATE OR REPLACE VIEW V_QC_DIM_PRODUCT_01 AS
SELECT
CASE WHEN OUTPUT>=T_MIN AND OUTPUT<=T_MAX
THEN 'OK' ELSE 'ERROR' END AS RESULT,
DESCRIPTION,
TABLE_NAME,
OUTPUT,
T_MIN,
T_MAX,
rpad(DESCRIPTION,60,' ') || rpad(OUTPUT,8,' ') || rpad(T_MIN,8,' ') || rpad(T_MAX,8,' ') AS REPORT
FROM (-- Test itself
SELECT
'DIM_PRODUCT' AS TABLE_NAME,
'Count of blanks' AS DESCRIPTION,
COUNT(*) AS OUTPUT,
0 AS T_MIN,
10 AS T_MAX
FROM DIM_PRODUCT
WHERE DIM_PRODUCT_ID != -1 -- not default value
AND ATTRIBUTE IS NULL ); -- count blanks
Chinyorwa chinoshandisa zvinyorwa kubva mubhuku
Ronald Bachmann, Dr. Guido Kemper
Raus aus der BI-Falle
Wie Business Intelligence zum Erfolg wird
Source: www.habr.com