{"id":77180,"date":"2020-04-08T13:42:32","date_gmt":"2020-04-08T11:42:32","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya"},"modified":"2020-04-08T13:42:32","modified_gmt":"2020-04-08T11:42:32","slug":"testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya","status":"publish","type":"post","link":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya","title":{"rendered":"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Ahoj, jmenuji se Alexandr a jsem in\u017een\u00fdr kvality dat, kter\u00fd se zab\u00fdv\u00e1 kontrolou dat na kvalitu. V tomto \u010dl\u00e1nku se pod\u00edv\u00e1me na to, jak jsem se k tomu dostal a pro\u010d se v roce 2020 uk\u00e1zalo toto odv\u011btv\u00ed testov\u00e1n\u00ed jako kl\u00ed\u010dov\u00e9. <\/p>\n<p><img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/0691d5a78bcbc8f4f102eafbbef20c0a.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>Sv\u011btov\u00fd trend <\/h2>\n<p>\nDne\u0161n\u00ed sv\u011bt proch\u00e1z\u00ed dal\u0161\u00edm technologick\u00fdm revoluc\u00ed, jej\u00ed\u017e jedn\u00edm z aspekt\u016f je vyu\u017e\u00edv\u00e1n\u00ed akumulovan\u00fdch dat r\u016fzn\u00fdmi spole\u010dnostmi k podpo\u0159e vlastn\u00edho prodeje, zisk\u016f a PR. Zd\u00e1 se, \u017ee pr\u00e1v\u011b dostupnost kvalitn\u00edch dat a schopn\u00fdch mozk\u016f, kter\u00e9 z nich dok\u00e1\u017eou ud\u011blat pen\u00edze (spr\u00e1vn\u011b je zpracovat, vizualizovat, vytvo\u0159it modely strojov\u00e9ho u\u010den\u00ed atd.), jsou dnes kl\u00ed\u010dem k \u00fasp\u011bchu pro mnoh\u00e9. Zat\u00edmco p\u0159ed 15-20 lety se intenzivn\u00ed pr\u00e1ce na akumulaci a monetizaci dat soust\u0159edila hlavn\u011b na velk\u00e9 firmy, dnes je to v\u00fdsadou t\u00e9m\u011b\u0159 v\u0161ech rozumn\u00fdch subjekt\u016f. <\/p>\n<p>Vzhledem k tomu p\u0159ed n\u011bkolika lety v\u0161echny port\u00e1ly v\u011bnovan\u00e9 hled\u00e1n\u00ed pr\u00e1ce po cel\u00e9m sv\u011bt\u011b za\u010daly p\u0159et\u00e9k\u00e1n\u00edm nab\u00eddkami na pozice Data Scientist, proto\u017ee v\u0161ichni byli p\u0159esv\u011bd\u010deni, \u017ee pokud maj\u00ed ve sv\u00e9m t\u00fdmu takov\u00e9ho specialistu, mohou vytvo\u0159it supermodel strojov\u00e9ho u\u010den\u00ed, p\u0159edpov\u011bd\u011bt budoucnost a ud\u011blat \"kvantov\u00fd skok\" pro firmu. Postupem \u010dasu lid\u00e9 pochopili, \u017ee tento p\u0159\u00edstup t\u00e9m\u011b\u0159 nikde nefunguje, proto\u017ee ne v\u0161echna data, kter\u00e1 se dostanou do rukou t\u011bchto specialist\u016f, jsou vhodn\u00e1 pro tr\u00e9nink model\u016f. <\/p>\n<p>A za\u010daly p\u0159ich\u00e1zet \u017e\u00e1dosti od datov\u00fdch v\u011bdc\u016f: \u201eKupme si je\u0161t\u011b v\u00edce dat od t\u011bch a t\u011bch...\u201c, \u201ePot\u0159ebujeme v\u00edce dat...\u201c, \u201eJe t\u0159eba je\u0161t\u011b trochu dat, a pokud mo\u017eno kvalitn\u00edch...\u201c. Na z\u00e1klad\u011b t\u011bchto \u017e\u00e1dost\u00ed se za\u010dalo vytv\u00e1\u0159et mno\u017estv\u00ed interakc\u00ed mezi firmami, kter\u00e9 vlastn\u00ed r\u016fzn\u00e9 datov\u00e9 sady. To samoz\u0159ejm\u011b vy\u017eadovalo technickou organizaci tohoto procesu \u2014 p\u0159ipojen\u00ed k datov\u00e9mu zdroji, sta\u017een\u00ed dat, ov\u011b\u0159en\u00ed, \u017ee jsou na\u010dtena v pln\u00e9m rozsahu atd. Po\u010det takov\u00fdch proces\u016f vzrostl, a dnes m\u00e1me obrovskou pot\u0159ebu specialist\u016f jin\u00e9ho druhu \u2014 in\u017een\u00fdr\u016f kvality dat \u2014 t\u011bch, kte\u0159\u00ed dohl\u00ed\u017eej\u00ed na tok dat v syst\u00e9mu (datov\u00e9 kan\u00e1ly), na kvalitu dat na vstupu a v\u00fdstupu, a d\u011blaj\u00ed z\u00e1v\u011bry o jejich dostate\u010dnosti, celistvosti a dal\u0161\u00edch charakteristik\u00e1ch. <\/p>\n<p>Trend kvality datov\u00fdch in\u017een\u00fdr\u016f k n\u00e1m p\u0159i\u0161el ze Spojen\u00fdch st\u00e1t\u016f, kde v bou\u0159liv\u00e9 \u00e9\u0159e kapitalismu nikdo nen\u00ed p\u0159ipraven prohr\u00e1t bitvu o data. N\u00ed\u017ee jsem uvedl screenshoty z dvou nejpopul\u00e1rn\u011bj\u0161\u00edch pracovn\u00edch port\u00e1l\u016f v USA: <noindex><a rel=\"nofollow\" href=\"https:\/\/www.monster.com\">www.monster.com<\/a><\/noindex> a <noindex><a rel=\"nofollow\" href=\"https:\/\/www.dice.com\">www.dice.com<\/a><\/noindex> \u2014 na kter\u00fdch jsou zobrazeny \u00fadaje k 17. b\u0159eznu 2020 o po\u010dtu vyhl\u00e1\u0161en\u00fdch pracovn\u00edch pozic podle kl\u00ed\u010dov\u00fdch slov: Data Quality a Data Scientist. <\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.monster.com\">www.monster.com<\/a><\/noindex><\/p>\n<p>Data Scientists \u2013 21,416 pracovn\u00edch pozic<br \/>\nData Quality \u2013 41,104 pracovn\u00edch pozic<\/p>\n<p><img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/8578f2d1e600791e166ed6e8a7068015.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/3ff69acc3c7e0d649eae0808b1b535be.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.dice.com\">www.dice.com<\/a><\/noindex> <\/p>\n<p>Data Scientists \u2013 404 pracovn\u00edch pozic<br \/>\nData Quality \u2013 2,020 pracovn\u00edch pozic<\/p>\n<p><img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/b35a9b423ba4bef8736659580e3c281e.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/2c29b83bbe2361089de5a0ab65017300.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>\nJe z\u0159ejm\u00e9, \u017ee tyto profese si navz\u00e1jem nekonkuruj\u00ed. Screenshoty jsem cht\u011bl pouze ilustrovat aktu\u00e1ln\u00ed situaci na trhu pr\u00e1ce, pokud jde o popt\u00e1vku po in\u017een\u00fdrech kvality dat, kter\u00fdch je nyn\u00ed v\u00fdrazn\u011b v\u00edce ne\u017e po Data Scientists. <\/p>\n<p>V \u010dervnu 2019 spole\u010dnost EPAM, reaguj\u00edc na pot\u0159eby modern\u00edho IT trhu, vy\u010dlenila Data Quality jako samostatnou praxi. Data Quality in\u017een\u00fd\u0159i ve sv\u00e9 ka\u017edodenn\u00ed pr\u00e1ci spravuj\u00ed data, kontroluj\u00ed jejich chov\u00e1n\u00ed v nov\u00fdch podm\u00ednk\u00e1ch a syst\u00e9mech, monitoruj\u00ed relevanci dat, jejich dostate\u010dnost a aktu\u00e1lnost. P\u0159esto\u017ee v praktick\u00e9m smyslu se Data Quality in\u017een\u00fd\u0159i skute\u010dn\u011b v\u011bnuj\u00ed klasick\u00e9mu funk\u010dn\u00edmu testov\u00e1n\u00ed pouze m\u00e1lo, <u>NE<\/u> co\u017e siln\u011b z\u00e1vis\u00ed na projektu (p\u0159\u00edklad uvedu d\u00e1le). <\/p>\n<p>Povinnosti Data Quality in\u017een\u00fdra se neomezuj\u00ed pouze na rutinn\u00ed manu\u00e1ln\u00ed\/automatick\u00e9 kontroly na \u201enulls, count a sums\u201c v datab\u00e1zov\u00fdch tabulk\u00e1ch, ale vy\u017eaduj\u00ed hlubok\u00e9 pochopen\u00ed obchodn\u00edch pot\u0159eb klienta a odpov\u00eddaj\u00edc\u00edm zp\u016fsobem schopnosti transformovat dostupn\u00e1 data na u\u017eite\u010dn\u00e9 obchodn\u00ed informace. <\/p>\n<h2>Teorie kvality dat<\/h2>\n<p>\n<img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/d920a7a0435d6f3a1eb84fc16221c742.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>Abychom si co nejl\u00e9pe p\u0159edstavili roli takov\u00e9ho in\u017een\u00fdra, poj\u010fme si objasnit, co vlastn\u011b kvalitn\u00ed data v teorii znamenaj\u00ed. <\/p>\n<p><b>Kvalita dat<\/b> \u2014 je jedn\u00edm z krok\u016f spr\u00e1vy dat (cel\u00fd sv\u011bt, kter\u00fd v\u00e1m ponech\u00e1me na samostatn\u00e9 studium) a zodpov\u00edd\u00e1 za anal\u00fdzu dat podle n\u00e1sleduj\u00edc\u00edch krit\u00e9ri\u00ed: <\/p>\n<p><img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/8f5e75bad69e3cb589cc0e1104ad946f.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nMysl\u00edm, \u017ee nen\u00ed pot\u0159eba rozeb\u00edrat ka\u017ed\u00fd z bod\u016f (v teorii se naz\u00fdvaj\u00ed \u201edata dimensions\u201c), jsou dob\u0159e pops\u00e1ny na obr\u00e1zku. Av\u0161ak samotn\u00fd proces testov\u00e1n\u00ed nep\u0159edpokl\u00e1d\u00e1 striktn\u00ed kop\u00edrov\u00e1n\u00ed t\u011bchto charakteristik do testovac\u00edch sc\u00e9n\u00e1\u0159\u016f a jejich kontrolu. V oblasti kvality dat, stejn\u011b jako v jin\u00fdch typech testov\u00e1n\u00ed, je t\u0159eba se p\u0159edev\u0161\u00edm \u0159\u00eddit po\u017eadavky na kvalitu dat, kter\u00e9 byly dohodnuty s \u00fa\u010dastn\u00edky projektu, p\u0159ij\u00edmaj\u00edc\u00edmi obchodn\u00ed rozhodnut\u00ed. <\/p>\n<p><\/p>\n<blockquote><p>V z\u00e1vislosti na projektu m\u016f\u017ee in\u017een\u00fdr kvality dat vykon\u00e1vat r\u016fzn\u00e9 funkce: od obvykl\u00e9ho testera-automatiz\u00e1tora s povrchn\u00edmi posouzen\u00edmi kvality dat a\u017e po osobu, kter\u00e1 prov\u00e1d\u00ed hlubok\u00e9 profilov\u00e1n\u00ed podle v\u00fd\u0161e uveden\u00fdch charakteristik. <\/p><\/blockquote>\n<p>Velmi podrobn\u00e9 popisy proces\u016f spr\u00e1vy dat, kvality dat a p\u0159\u00edbuzn\u00fdch t\u00e9mat jsou skv\u011ble pops\u00e1ny v knize s n\u00e1zvem <i>\u201eDAMA-DMBOK: Data Management Body of Knowledge: 2nd Edition\u201c<\/i>. Tuto knihu velmi doporu\u010duji jako \u00favod do t\u00e9to t\u00e9matiky (odkaz na ni najdete na konci \u010dl\u00e1nku).<\/p>\n<h2>M\u016fj p\u0159\u00edb\u011bh<\/h2>\n<p>\nV IT pr\u016fmyslu jsem pro\u0161el cestou od Junior testera v produktov\u00fdch firm\u00e1ch a\u017e po Lead Data Quality Engineer ve spole\u010dnosti EPAM. Po p\u0159ibli\u017en\u011b dvou letech pr\u00e1ce jako tester jsem m\u011bl pevn\u00e9 p\u0159esv\u011bd\u010den\u00ed, \u017ee jsem vykonal v\u0161echny druhy testov\u00e1n\u00ed: regresn\u00ed, funk\u010dn\u00ed, stresov\u00e9, stability, bezpe\u010dnosti, UI atd. \u2014 a vyzkou\u0161el jsem velk\u00e9 mno\u017estv\u00ed testovac\u00edch n\u00e1stroj\u016f, p\u0159i\u010dem\u017e jsem pracoval ve t\u0159ech programovac\u00edch jazyc\u00edch: Java, Scala, Python. <\/p>\n<p><\/p>\n<blockquote><p>Kdy\u017e se ohl\u00e9dnu zp\u011bt, ch\u00e1pu, pro\u010d se soubor m\u00fdch profesion\u00e1ln\u00edch dovednost\u00ed uk\u00e1zal b\u00fdt tak r\u016fznorod\u00fd \u2014 \u00fa\u010dastnil jsem se projekt\u016f spojen\u00fdch s prac\u00ed s daty, velk\u00fdmi i mal\u00fdmi. To m\u011b p\u0159ivedlo do sv\u011bta mnoha n\u00e1stroj\u016f a p\u0159\u00edle\u017eitost\u00ed pro r\u016fst.<\/p><\/blockquote>\n<p>Abychom ocenili rozmanitost n\u00e1stroj\u016f a mo\u017enost\u00ed, jak z\u00edsk\u00e1vat nov\u00e9 znalosti a dovednosti, sta\u010d\u00ed se pod\u00edvat na obr\u00e1zek n\u00ed\u017ee, na kter\u00e9m jsou zobrazeny ty nejpopul\u00e1rn\u011bj\u0161\u00ed z nich ve sv\u011bt\u011b \u201eData &amp; AI\u201c.<\/p>\n<p><img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/e3278694195bf59b44055e1eaafd62b1.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nTakov\u00e9to ilustrace ka\u017edoro\u010dn\u011b vytv\u00e1\u0159\u00ed jeden z renomovan\u00fdch venture kapitalist\u016f Matt Turck, kter\u00fd poch\u00e1z\u00ed z v\u00fdvoje softwaru. Zde <noindex><a rel=\"nofollow\" href=\"https:\/\/mattturck.com\">odkaz<\/a><\/noindex> je jeho blog a <noindex><a rel=\"nofollow\" href=\"https:\/\/firstmarkcap.com\/team\/matt-turck\">firma venture kapit\u00e1lu<\/a><\/noindex>, kde pracuje jako partner. <\/p>\n<p>Obzvl\u00e1\u0161\u0165 rychle jsem profesion\u00e1ln\u011b rostl, kdy\u017e jsem byl jedin\u00fdm testerem na projektu, nebo alespo\u0148 na za\u010d\u00e1tku projektu. Pr\u00e1v\u011b v takov\u00e9m okam\u017eiku je t\u0159eba p\u0159evz\u00edt odpov\u011bdnost za cel\u00fd testovac\u00ed proces, a nem\u00e1te mo\u017enost ustoupit, pouze j\u00edt vp\u0159ed. Zpo\u010d\u00e1tku to bylo d\u011bsiv\u00e9, ale nyn\u00ed jsou mi jasn\u00e9 v\u0161echny v\u00fdhody takov\u00e9ho zkou\u0161en\u00ed: <\/p>\n<ul>\n<li>Za\u010d\u00edn\u00e1te komunikovat s cel\u00fdm t\u00fdmem jako nikdy p\u0159edt\u00edm, proto\u017ee neexistuje \u017e\u00e1dn\u00fd prokur\u00e1tor pro komunikaci: \u017e\u00e1dn\u00fd testovac\u00ed mana\u017eer, \u017e\u00e1dn\u00ed kolegov\u00e9 teste\u0159i. <\/li>\n<li>Pono\u0159en\u00ed do projektu se st\u00e1v\u00e1 neuv\u011b\u0159iteln\u011b hlubok\u00fdm a m\u00e1te informace o v\u0161ech komponentech jak v obecn\u00e9, tak v detailn\u00ed rovin\u011b. <\/li>\n<li>V\u00fdvoj\u00e1\u0159i na v\u00e1s nepohl\u00ed\u017eej\u00ed jako na \"toho kluka z testov\u00e1n\u00ed, kter\u00fd d\u011bl\u00e1 nevysv\u011btliteln\u00e9 v\u011bci\", ale sp\u00ed\u0161e jako na rovnocenn\u00e9ho kolegu, kter\u00fd t\u00fdm p\u0159in\u00e1\u0161\u00ed neuv\u011b\u0159iteln\u00fd p\u0159\u00ednos sv\u00fdmi automatick\u00fdmi testy a p\u0159edv\u00edd\u00e1n\u00edm vzniku chyb v konkr\u00e9tn\u00ed \u010d\u00e1sti produktu. <\/li>\n<li>V d\u016fsledku toho jste efektivn\u011bj\u0161\u00ed, kvalifikovan\u011bj\u0161\u00ed a \u017e\u00e1dan\u011bj\u0161\u00ed. <\/li>\n<\/ul>\n<p>\nJak projekt rostl, v 100% p\u0159\u00edpad\u016f jsem se stal mentorem pro nov\u011b p\u0159\u00edchoz\u00ed testery, \u0161kolil jsem je a p\u0159ed\u00e1val jim znalosti, kter\u00e9 jsem s\u00e1m z\u00edskal. V z\u00e1vislosti na projektu jsem v\u0161ak ne v\u017edy dostal od veden\u00ed specialisty na automatizovan\u00e9 testov\u00e1n\u00ed vysok\u00e9 \u00farovn\u011b a byla pot\u0159eba bu\u010f je \u0161kolit v automatizaci (pro z\u00e1jemce), nebo vytv\u00e1\u0159et n\u00e1stroje pro jejich pou\u017e\u00edv\u00e1n\u00ed v ka\u017edodenn\u00edch aktivit\u00e1ch (n\u00e1stroje pro generov\u00e1n\u00ed dat a jejich nahr\u00e1v\u00e1n\u00ed do syst\u00e9mu, n\u00e1stroj pro prov\u00e1d\u011bn\u00ed z\u00e1t\u011b\u017eov\u00e9ho testov\u00e1n\u00ed\/testov\u00e1n\u00ed stability \u201erychle\u201c atd.). <\/p>\n<h3>P\u0159\u00edklad konkr\u00e9tn\u00edho projektu<\/h3>\n<p>\nBohu\u017eel, kv\u016fli z\u00e1vazk\u016fm o ml\u010denlivosti nemohu podrobn\u011b vypr\u00e1v\u011bt o projektech, na kter\u00fdch jsem pracoval, ale uvedu p\u0159\u00edklady typick\u00fdch \u00fakol\u016f in\u017een\u00fdra kvality dat na jednom z projekt\u016f. <\/p>\n<p>Podstatou projektu bylo realizovat platformu pro p\u0159\u00edpravu dat pro \u0161kolen\u00ed strojov\u00e9ho u\u010den\u00ed. Objednavatelem byla velk\u00e1 farmaceutick\u00e1 spole\u010dnost z USA. Technicky to byl cluster <noindex><a rel=\"nofollow\" href=\"https:\/\/kubernetes.io\">Kubernetes<\/a><\/noindex>, postaven\u00fd na <noindex><a rel=\"nofollow\" href=\"https:\/\/aws.amazon.com\/ru\/ec2\">AWS EC2<\/a><\/noindex> instanc\u00edch, s n\u011bkolika mikroslu\u017ebami a zalo\u017een\u00fdm na open-source projektu firmy EPAM \u2014 <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/legion-platform\/legion\">Legion<\/a><\/noindex>, p\u0159izp\u016fsoben\u00fdm pot\u0159eb\u00e1m konkr\u00e9tn\u00edho objednavatele (nyn\u00ed byl projekt p\u0159etvo\u0159en na <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/odahu\/odahu-flow\">odahu<\/a><\/noindex>). ETL procesy byly uspo\u0159\u00e1d\u00e1ny pomoc\u00ed <noindex><a rel=\"nofollow\" href=\"https:\/\/airflow.apache.org\">Apache Airflow<\/a><\/noindex> a p\u0159esouvali data z <noindex><a rel=\"nofollow\" href=\"https:\/\/www.salesforce.com\">SalesForce<\/a><\/noindex> syst\u00e9mu z\u00e1kazn\u00edka do <noindex><a rel=\"nofollow\" href=\"https:\/\/aws.amazon.com\/ru\/s3\/?nc1=h_ls\">AWS S3<\/a><\/noindex> Buckets. Pot\u00e9 se na platformu nasadil Docker obraz modelu strojov\u00e9ho u\u010den\u00ed, kter\u00fd se tr\u00e9noval na aktu\u00e1ln\u00edch datech a prost\u0159ednictv\u00edm REST API rozhran\u00ed poskytoval p\u0159edpov\u011bdi, kter\u00e9 zaj\u00edmaly podniky a \u0159e\u0161ily konkr\u00e9tn\u00ed \u00fakoly. <\/p>\n<p><b>Vizu\u00e1ln\u011b to vypadalo asi takto: <\/b><\/p>\n<p><img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/c2de3c1919f3f9ff29147fce09eb14c4.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nFunk\u010dn\u00edho testov\u00e1n\u00ed na tomto projektu bylo dostatek, a vzhledem k rychlosti v\u00fdvoje funkcionalit a pot\u0159eb\u011b udr\u017eovat tempo release cyklu (dvout\u00fddenn\u00ed sprinty) bylo t\u0159eba hned p\u0159em\u00fd\u0161let o automatizaci testov\u00e1n\u00ed nejkriti\u010dt\u011bj\u0161\u00edch \u010d\u00e1st\u00ed syst\u00e9mu. V\u011bt\u0161ina samotn\u00e9 platformy postaven\u00e9 na Kubernetes byla pokryta automatizovan\u00fdmi testy, kter\u00e9 byly implementov\u00e1ny v <noindex><a rel=\"nofollow\" href=\"https:\/\/robotframework.org\/\">Robot Framework<\/a><\/noindex> + Python, ale bylo tak\u00e9 t\u0159eba je udr\u017eovat a roz\u0161i\u0159ovat. Krom\u011b toho, pro pohodl\u00ed z\u00e1kazn\u00edka, byla vytvo\u0159ena GUI pro spr\u00e1vu model\u016f strojov\u00e9ho u\u010den\u00ed, nasazen\u00fdch na clusteru, stejn\u011b jako mo\u017enost uv\u00e9st, odkud a kam je t\u0159eba p\u0159esunout data pro tr\u00e9nink model\u016f. Tato rozs\u00e1hl\u00e1 funkce vedla k roz\u0161\u00ed\u0159en\u00ed automatizovan\u00fdch funk\u010dn\u00edch kontrol, kter\u00e9 se p\u0159ev\u00e1\u017en\u011b prov\u00e1d\u011bly prost\u0159ednictv\u00edm REST API vol\u00e1n\u00ed a mal\u00e9 \u010d\u00e1sti end-to-end UI test\u016f. P\u0159ibli\u017en\u011b v polovin\u011b tohoto procesu se k n\u00e1m p\u0159idal manu\u00e1ln\u00ed tester, kter\u00fd exceloval v akcepta\u010dn\u00edm testov\u00e1n\u00ed verz\u00ed produktu a komunikaci se z\u00e1kazn\u00edkem ohledn\u011b akceptace dal\u0161\u00edho releasu. D\u00edky p\u0159\u00edchodu nov\u00e9ho specialisty jsme mohli dokumentovat na\u0161i pr\u00e1ci a p\u0159idat n\u011bkolik velmi d\u016fle\u017eit\u00fdch manu\u00e1ln\u00edch kontrol, kter\u00e9 bylo slo\u017eit\u00e9 ihned automatizovat. <\/p>\n<p>A kone\u010dn\u011b, pot\u00e9, co jsme dos\u00e1hli stability platformy a vytvo\u0159ili nadstavbu GUI, jsme se pustili do budov\u00e1n\u00ed ETL pipeline pomoc\u00ed Apache Airflow DAGs. Automatizovan\u00e1 kontrola kvality dat byla prov\u00e1d\u011bna pomoc\u00ed speci\u00e1ln\u011b napsan\u00fdch Airflow DAGs, kter\u00e9 kontrolovaly data na z\u00e1klad\u011b v\u00fdsledk\u016f pr\u00e1ce ETL procesu. V r\u00e1mci tohoto projektu jsme m\u011bli \u0161t\u011bst\u00ed, proto\u017ee klient n\u00e1m poskytl p\u0159\u00edstup k anonymizovan\u00fdm datov\u00fdm sad\u00e1m, na kter\u00fdch jsme testovali. Kontrolovali jsme data po \u0159\u00e1dc\u00edch na shodu typ\u016f, p\u0159\u00edtomnost po\u0161kozen\u00fdch dat, celkov\u00fd po\u010det z\u00e1znam\u016f p\u0159ed a po, srovn\u00e1n\u00ed transformac\u00ed proveden\u00fdch ETL procesem z hlediska agregace, zm\u011bny n\u00e1zv\u016f sloupc\u016f a dal\u0161\u00ed. Krom\u011b toho byly tyto kontroly \u0161k\u00e1lov\u00e1ny na r\u016fzn\u00e9 zdroje dat, nap\u0159\u00edklad krom\u011b SalesForce tak\u00e9 na MySQL. <\/p>\n<p>Kontroly kone\u010dn\u00e9 kvality dat se prov\u00e1d\u011bly na \u00farovni S3, kde byly ulo\u017eeny a byly p\u0159ipraveny k pou\u017eit\u00ed pro v\u00fduku model\u016f strojov\u00e9ho u\u010den\u00ed. Pro z\u00edsk\u00e1n\u00ed dat z kone\u010dn\u00e9ho CSV souboru, kter\u00fd le\u017eel v S3 Bucket, a jejich validaci, byl naps\u00e1n k\u00f3d pomoc\u00ed <noindex><a rel=\"nofollow\" href=\"https:\/\/aws.amazon.com\/ru\/sdk-for-python\">boto3 klienta<\/a><\/noindex>. <\/p>\n<p>Tak\u00e9 z pohledu klienta byl po\u017eadavek na uchov\u00e1n\u00ed \u010d\u00e1sti dat v jednom S3 Bucketu a \u010d\u00e1sti v jin\u00e9m. K tomu bylo tak\u00e9 pot\u0159eba napsat dodate\u010dn\u00e9 kontroly, kter\u00e9 kontrolovaly d\u016fv\u011bryhodnost takov\u00e9ho t\u0159\u00edd\u011bn\u00ed. <\/p>\n<h3>Obecn\u00e9 zku\u0161enosti z jin\u00fdch projekt\u016f<\/h3>\n<p>\nP\u0159\u00edklad nejv\u00edce z\u00e1kladn\u00edho seznamu aktivit Data Quality in\u017een\u00fdra: <\/p>\n<ul>\n<li>P\u0159ipravit testovac\u00ed data (platn\u00e1, neplatn\u00e1, velk\u00e1, mal\u00e1) prost\u0159ednictv\u00edm automatizovan\u00e9ho n\u00e1stroje. <\/li>\n<li>Nahr\u00e1t p\u0159ipravenou datovou sadu do zdrojov\u00e9ho syst\u00e9mu a zkontrolovat jej\u00ed p\u0159ipravenost k pou\u017eit\u00ed. <\/li>\n<li>Spustit ETL procesy na zpracov\u00e1n\u00ed datov\u00e9 sady ze zdrojov\u00e9ho \u00falo\u017ei\u0161t\u011b do kone\u010dn\u00e9ho nebo mezilehl\u00e9ho stavu s pou\u017eit\u00edm ur\u010dit\u00e9ho souboru nastaven\u00ed (pokud je mo\u017en\u00e9 zadat konfigurovateln\u00e9 parametry pro ETL \u00falohu). <\/li>\n<li>Ov\u011b\u0159it zpracovan\u00e1 data ETL procesem z hlediska jejich kvality a shody s obchodn\u00edmi po\u017eadavky. <\/li>\n<\/ul>\n<p>\nHlavn\u00ed d\u016fraz p\u0159i kontrol\u00e1ch by se m\u011bl kl\u00e1st nejen na to, zda datov\u00fd tok v syst\u00e9mu v\u016fbec prob\u011bhl a dos\u00e1hl konce (co\u017e je sou\u010d\u00e1st\u00ed funk\u010dn\u00edho testov\u00e1n\u00ed), ale p\u0159edev\u0161\u00edm na kontrolu a validaci dat z hlediska souladu s o\u010dek\u00e1van\u00fdmi po\u017eadavky, odhalov\u00e1n\u00ed anom\u00e1li\u00ed a podobn\u011b. <\/p>\n<h3>N\u00e1stroje<\/h3>\n<p>\nJednou z technik takov\u00e9 kontroly dat m\u016f\u017ee b\u00fdt organizace \u0159et\u011bzov\u00fdch kontrol na ka\u017ed\u00e9 f\u00e1zi zpracov\u00e1n\u00ed dat, naz\u00fdvan\u00e1 v literatu\u0159e \"data chain\" \u2014 kontrola dat od zdroje a\u017e po m\u00edsto kone\u010dn\u00e9ho pou\u017eit\u00ed. Takov\u00e9 kontroly se v\u011bt\u0161inou realizuj\u00ed pomoc\u00ed psan\u00ed kontroln\u00edch SQL dotaz\u016f. Je jasn\u00e9, \u017ee tyto dotazy by m\u011bly b\u00fdt co nejleh\u010d\u00ed a zam\u011b\u0159eny na jednotliv\u00e9 \u00faseky kvality dat (metadata tabulek, pr\u00e1zdn\u00e9 \u0159\u00e1dky, NULL hodnoty, syntaktick\u00e9 chyby \u2014 dal\u0161\u00ed po\u017eadovan\u00e9 kontroln\u00ed atributy). <\/p>\n<p>P\u0159i regresn\u00edm testov\u00e1n\u00ed, kde se pou\u017e\u00edvaj\u00ed ji\u017e p\u0159ipraven\u00e9 (nem\u011bniteln\u00e9 nebo jen m\u00edrn\u011b m\u011bniteln\u00e9) datov\u00e9 sady, mohou v k\u00f3du automatick\u00fdch test\u016f existovat ji\u017e hotov\u00e9 \u0161ablony pro kontrolu dat na shodu s kvalitou (popis o\u010dek\u00e1van\u00fdch metadat tabulek; v\u00fdb\u011brov\u00e9 objekty, kter\u00e9 mohou b\u00fdt n\u00e1hodn\u011b vyb\u00edr\u00e1ny b\u011bhem testu, a dal\u0161\u00ed). <\/p>\n<p>B\u011bhem testov\u00e1n\u00ed je tak\u00e9 nutn\u00e9 ps\u00e1t testovac\u00ed ETL procesy pomoc\u00ed r\u00e1mc\u016f jako je Apache Airflow, <noindex><a rel=\"nofollow\" href=\"https:\/\/spark.apache.org\/\">Apache Spark<\/a><\/noindex> nebo dokonce n\u00e1stroje typu black-box cloud, nap\u0159\u00edklad <noindex><a rel=\"nofollow\" href=\"https:\/\/cloud.google.com\/dataprep\">GCP Dataprep<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"https:\/\/cloud.google.com\/dataflow\">GCP Dataflow<\/a><\/noindex> a dal\u0161\u00ed. Tato skute\u010dnost nut\u00ed testovac\u00ed in\u017een\u00fdry pono\u0159it se do princip\u016f fungov\u00e1n\u00ed v\u00fd\u0161e uveden\u00fdch n\u00e1stroj\u016f a efektivn\u011b prov\u00e1d\u011bt jak funk\u010dn\u00ed testov\u00e1n\u00ed (nap\u0159\u00edklad existuj\u00edc\u00edch ETL proces\u016f na projektu), tak je vyu\u017e\u00edvat pro kontrolu dat. Konkr\u00e9tn\u011b pro Apache Airflow ji\u017e existuj\u00ed hotov\u00e9 oper\u00e1tory pro pr\u00e1ci s popul\u00e1rn\u00edmi analytick\u00fdmi datab\u00e1zemi, jako je <noindex><a rel=\"nofollow\" href=\"https:\/\/cloud.google.com\/bigquery\">GCP BigQuery<\/a><\/noindex>. Nejz\u00e1kladn\u011bj\u0161\u00ed p\u0159\u00edklad jeho pou\u017eit\u00ed ji\u017e byl uveden <noindex><a rel=\"nofollow\" href=\"https:\/\/medium.com\/@yuu.ishikawa\/apache-airflow-as-a-data-quality-checker-416ca7f5a3ad\">tady<\/a><\/noindex>, tak\u017ee se nebudu opakovat. <\/p>\n<p>Krom\u011b hotov\u00fdch \u0159e\u0161en\u00ed nikdo v\u00e1m nezakazuje implementovat sv\u00e9 vlastn\u00ed techniky a n\u00e1stroje. To bude pro projekt nejen p\u0159\u00ednosem, ale i pro samotn\u00e9ho Data Quality Engineer, kter\u00fd si t\u00edm roz\u0161\u00ed\u0159\u00ed sv\u00e9 technick\u00e9 obzory a dovednosti v programov\u00e1n\u00ed. <\/p>\n<h3>Jak to funguje na skute\u010dn\u00e9m projektu<\/h3>\n<p>\nDobrou ilustrac\u00ed posledn\u00edch odstavc\u016f o \u201edatov\u00e9m \u0159et\u011bzci\u201c, ETL a v\u0161udyp\u0159\u00edtomn\u00fdch kontrol\u00e1ch je n\u00e1sleduj\u00edc\u00ed proces z jednoho re\u00e1ln\u00e9ho projektu: <\/p>\n<p><img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/4a4cd3043b584bb3fbce4b9c3021e9f6.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nZde do vstupn\u00ed \u201etrycht\u00fd\u0159e\u201c na\u0161eho syst\u00e9mu p\u0159ich\u00e1zej\u00ed r\u016fzn\u00e9 \u00fadaje (pochopiteln\u011b p\u0159ipraven\u00e9 n\u00e1mi): platn\u00e9, neplatn\u00e9, sm\u00ed\u0161en\u00e9 atd., pot\u00e9 jsou filtrov\u00e1ny a putuj\u00ed do meziskladi\u0161t\u011b, kde na n\u011b \u010dek\u00e1 dal\u0161\u00ed \u0159ada transformac\u00ed, a pot\u00e9 jsou ulo\u017eeny do kone\u010dn\u00e9ho \u00falo\u017ei\u0161t\u011b, ze kter\u00e9ho bude n\u00e1sledn\u011b prob\u00edhat analytika, tvorba datov\u00fdch vitr\u00edn a vyhled\u00e1v\u00e1n\u00ed obchodn\u00edch poznatk\u016f. V takov\u00e9m syst\u00e9mu, ani\u017e bychom funk\u010dn\u011b ov\u011b\u0159ovali pracovn\u00ed postupy ETL, se zam\u011b\u0159ujeme na kvalitu dat p\u0159ed a po transformac\u00edch a tak\u00e9 na v\u00fdstup pro analytiku. <\/p>\n<p>Shrnuto, bez ohledu na m\u00edsta, kde jsem pracoval, byl jsem v\u0161ude zapojen do datov\u00fdch projekt\u016f, kter\u00e9 spojovaly n\u00e1sleduj\u00edc\u00ed rysy: <\/p>\n<ul>\n<li>Pouze prost\u0159ednictv\u00edm automatizace lze ov\u011b\u0159it n\u011bkter\u00e9 p\u0159\u00edpady a dos\u00e1hnout uspokojiv\u00e9ho vyd\u00e1n\u00ed pro podnik. <\/li>\n<li>Tester v takov\u00e9m projektu je jedn\u00edm z nejrespektovan\u011bj\u0161\u00edch \u010dlen\u016f t\u00fdmu, proto\u017ee p\u0159in\u00e1\u0161\u00ed obrovsk\u00fd p\u0159\u00ednos ka\u017ed\u00e9mu z \u00fa\u010dastn\u00edk\u016f (urychlen\u00ed testov\u00e1n\u00ed, kvalitn\u00ed data pro data science, odhalov\u00e1n\u00ed chyb v ran\u00fdch f\u00e1z\u00edch). <\/li>\n<li>Nez\u00e1le\u017e\u00ed na tom, zda pracujete na vlastn\u00edm hardwaru nebo v cloudu \u2014 v\u0161echny zdroje jsou zabalena v klastry typu Hortonworks, Cloudera, Mesos, Kubernetes atd. <\/li>\n<li>Projekty jsou postaveny na mikroservisn\u00edm p\u0159\u00edstupu s dominuj\u00edc\u00edmi distribuovan\u00fdmi a paraleln\u00edmi v\u00fdpo\u010dty. <\/li>\n<\/ul>\n<p>\nUpozor\u0148uji, \u017ee p\u0159i testov\u00e1n\u00ed v oblasti kvality dat se tester zam\u011b\u0159uje na k\u00f3d produktu a pou\u017eit\u00e9 n\u00e1stroje. <\/p>\n<h3>Charakteristick\u00e9 rysy testov\u00e1n\u00ed kvality dat<\/h3>\n<p>\nKrom\u011b toho jsem si vybral n\u00e1sleduj\u00edc\u00ed (hned dod\u00e1m, \u017ee velmi zjednodu\u0161en\u00e9 a v\u00fdhradn\u011b subjektivn\u00ed) charakteristick\u00e9 rysy testov\u00e1n\u00ed v Date (Big Data) projektech (syst\u00e9mech) a dal\u0161\u00edch oblastech: <\/p>\n<p><img decoding=\"async\" alt=\"Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh\" src=\"\/wp-content\/uploads\/2020\/04\/8df52fbae2998e70755bf84e254db83e.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<h2>U\u017eite\u010dn\u00e9 odkazy<\/h2>\n<p><\/p>\n<ol>\n<li>Teorie: <noindex><a rel=\"nofollow\" href=\"https:\/\/www.amazon.com\/DAMA-DMBOK-Data-Management-Body-Knowledge\/dp\/1634622340\">DAMA-DMBOK: T\u011blo znalost\u00ed o \u0159\u00edzen\u00ed dat: 2. vyd\u00e1n\u00ed<\/a><\/noindex>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/training.ru\/#!\/Home?lang=ru\">\u0160kol\u00edc\u00ed centrum<\/a><\/noindex>&nbsp;EPAM&nbsp;<\/li>\n<li>Doporu\u010den\u00e9 materi\u00e1ly pro za\u010d\u00ednaj\u00edc\u00edho in\u017een\u00fdra kvality dat:\n<ol>\n<li>Bezplatn\u00fd kurz na Stepik:&nbsp;<noindex><a rel=\"nofollow\" href=\"https:\/\/stepik.org\/course\/551\/syllabus\">\u00davod do datab\u00e1z\u00ed<\/a><\/noindex>.&nbsp;<\/li>\n<li>Kurz na LinkedIn Learning:&nbsp;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.linkedin.com\/learning\/data-science-foundations-data-engineering\/welcome\">Z\u00e1klady datov\u00e9 v\u011bdy: In\u017een\u00fdrstv\u00ed dat<\/a><\/noindex>.<\/li>\n<li>\u010cl\u00e1nky:\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.stickyminds.com\/article\/business-intelligence-and-data-quality\">Obchodn\u00ed inteligence a kvalita dat<\/a><\/noindex>;&nbsp;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.datagaps.com\/concepts\/etl-testing\">ETL testov\u00e1n\u00ed<\/a><\/noindex>;&nbsp;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/panoply.io\/analytics-stack-guide\/data-profiling-best-practices\">Co je profilov\u00e1n\u00ed dat? Proces, nejlep\u0161\u00ed postupy a n\u00e1stroje<\/a><\/noindex>;&nbsp;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.guru99.com\/software-testing-test-data.html\">Generov\u00e1n\u00ed testovac\u00edch dat: Co to je, Jak na to, P\u0159\u00edklad, N\u00e1stroje;&nbsp;<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.testbytes.net\/blog\/5-test-data-generation-techniques-to-know\">5 technik generov\u00e1n\u00ed testovac\u00edch dat, kter\u00e9 pot\u0159ebujete zn\u00e1t.<\/a><\/noindex>&nbsp;<\/li>\n<\/ul>\n<\/li>\n<li>Video:\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=HWaBdqmTqEA\">Z\u00e1klady kvality dat | Tutori\u00e1l o kvalit\u011b dat | Tutori\u00e1l o datov\u00fdch skladech<\/a><\/noindex>;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=avDqzhuHFkw\">Profilov\u00e1n\u00ed dat pomoc\u00ed SSIS<\/a><\/noindex>;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=r7SF5WldITk\">Profilov\u00e1n\u00ed dat a zpracov\u00e1n\u00ed datov\u00fdch tok\u016f se Sparkem.<\/a><\/noindex><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><\/p>\n<h2>Z\u00e1v\u011br<\/h2>\n<p>\n<b>Kvalita dat<\/b> \u2014 to je velmi mlad\u00e1 perspektivn\u00ed oblast, jej\u00ed\u017e sou\u010d\u00e1st\u00ed b\u00fdt znamen\u00e1 b\u00fdt sou\u010d\u00e1st\u00ed jak\u00e9hosi startupu. Pokud se dostanete do Data Quality, pono\u0159\u00edte se do velk\u00e9ho mno\u017estv\u00ed modern\u00edch, \u017e\u00e1dan\u00fdch technologi\u00ed, ale co je nejd\u016fle\u017eit\u011bj\u0161\u00ed \u2014 p\u0159ed v\u00e1mi se otev\u0159ou obrovsk\u00e9 p\u0159\u00edle\u017eitosti pro generov\u00e1n\u00ed a realizaci va\u0161ich n\u00e1pad\u016f. Budete moci vyu\u017e\u00edt p\u0159\u00edstup neust\u00e1l\u00e9ho zlep\u0161ov\u00e1n\u00ed nejen v projektu, ale i pro sebe, neust\u00e1le se rozv\u00edjej\u00edc\u00ed jako odborn\u00edk.<br \/>\n<br \/>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/epam_systems\/blog\/495478\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0412\u0441\u0435\u043c \u043f\u0440\u0438\u0432\u0435\u0442, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043b\u0435\u043a\u0441\u0430\u043d\u0434\u0440, \u0438 \u044f Data Quality \u0438\u043d\u0436\u0435\u043d\u0435\u0440, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0435\u0434\u043c\u0435\u0442 \u0438\u0445 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0430. \u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u0440\u0435\u0447\u044c \u043f\u043e\u0439\u0434\u0451\u0442 \u043e \u0442\u043e\u043c, \u043a\u0430\u043a \u044f \u043a \u044d\u0442\u043e\u043c\u0443 \u043f\u0440\u0438\u0448\u0451\u043b \u0438 \u043f\u043e\u0447\u0435\u043c\u0443 \u0432 2020 \u0433\u043e\u0434\u0443 \u044d\u0442\u043e \u043d\u0430\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u043d\u0430 \u0433\u0440\u0435\u0431\u043d\u0435 \u0432\u043e\u043b\u043d\u044b. \u041c\u0438\u0440\u043e\u0432\u043e\u0439 \u0442\u0440\u0435\u043d\u0434 \u0421\u0435\u0433\u043e\u0434\u043d\u044f\u0448\u043d\u0438\u0439 \u043c\u0438\u0440 \u043f\u0435\u0440\u0435\u0436\u0438\u0432\u0430\u0435\u0442 \u043e\u0447\u0435\u0440\u0435\u0434\u043d\u0443\u044e \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u0443\u044e \u0440\u0435\u0432\u043e\u043b\u044e\u0446\u0438\u044e, \u043e\u0434\u043d\u0438\u043c \u0438\u0437 \u0430\u0441\u043f\u0435\u043a\u0442\u043e\u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":77181,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-77180","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0412\u0441\u0435\u043c \u043f\u0440\u0438\u0432\u0435\u0442, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043b\u0435\u043a\u0441\u0430\u043d\u0434\u0440, \u0438 \u044f Data Quality \u0438\u043d\u0436\u0435\u043d\u0435\u0440, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0435\u0434\u043c\u0435\u0442 \u0438\u0445 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0430.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0422\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0449\u0438\u043a \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0438 \u043c\u0430\u043b\u0435\u043d\u044c\u043a\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0445: \u0442\u0440\u0435\u043d\u0434\u044b, \u0442\u0435\u043e\u0440\u0438\u044f, \u043c\u043e\u044f \u0438\u0441\u0442\u043e\u0440\u0438\u044f | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0412\u0441\u0435\u043c \u043f\u0440\u0438\u0432\u0435\u0442, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043b\u0435\u043a\u0441\u0430\u043d\u0434\u0440, \u0438 \u044f Data Quality \u0438\u043d\u0436\u0435\u043d\u0435\u0440, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0435\u0434\u043c\u0435\u0442 \u0438\u0445 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-04-08T11:42:32+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-04-08T11:42:32+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47 Tester velk\u00fdch a mal\u00fdch dat: trendy, teorie, m\u016fj p\u0159\u00edb\u011bh | ProHoster","description":"Ahoj v\u0161ichni, jmenuji se Alexander a jsem in\u017een\u00fdr Data Quality, kter\u00fd se zab\u00fdv\u00e1 kontrolou dat z hlediska jejich kvality.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0422\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0449\u0438\u043a \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0438 \u043c\u0430\u043b\u0435\u043d\u044c\u043a\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0445: \u0442\u0440\u0435\u043d\u0434\u044b, \u0442\u0435\u043e\u0440\u0438\u044f, \u043c\u043e\u044f \u0438\u0441\u0442\u043e\u0440\u0438\u044f | ProHoster","og:description":"\u0412\u0441\u0435\u043c \u043f\u0440\u0438\u0432\u0435\u0442, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043b\u0435\u043a\u0441\u0430\u043d\u0434\u0440, \u0438 \u044f Data Quality \u0438\u043d\u0436\u0435\u043d\u0435\u0440, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0435\u0434\u043c\u0435\u0442 \u0438\u0445 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0430.","og:url":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-04-08T11:42:32+00:00","article:modified_time":"2020-04-08T11:42:32+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"77180","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 17:22:32","updated":"2022-10-03 00:36:00","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/77180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=77180"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/77180\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media\/77181"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=77180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=77180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=77180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}