{"id":13268,"date":"2022-12-14T10:00:00","date_gmt":"2022-12-14T09:00:00","guid":{"rendered":"https:\/\/parm.com\/?p=13268"},"modified":"2026-09-28T08:07:30","modified_gmt":"2026-09-28T06:07:30","slug":"data-warehouse-and-data-lake","status":"publish","type":"post","link":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/","title":{"rendered":"Datavarasto ja dataj\u00e4rvi"},"content":{"rendered":"\n<div class=\"et_pb_section_0 et_pb_section et_section_regular et_block_section\"><div class=\"et_pb_row_0 et_pb_row et_block_row\"><div class=\"et_pb_column_0 et_pb_column et_pb_column_4_4 et-last-child et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_text_0 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><h1>Datavarasto ja dataj\u00e4rvi<\/h1>\n<p><span style=\"font-size: large;\">M\u00e4\u00e4ritelm\u00e4, yht\u00e4l\u00e4isyydet ja erot<\/span><\/p>\n<\/div><\/div><\/div><\/div><div class=\"et_pb_row_1 et_pb_row et_block_row\"><div class=\"et_pb_column_1 et_pb_column et_pb_column_4_4 et-last-child et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_image_0 et_pb_image et_pb_module et_block_module\"><span class=\"et_pb_image_wrap\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI.jpg\" alt=\"Datavarasto vs. dataj\u00e4rvi\" title=\"Post_Data_Warehouse_Lake\" width=\"1200\" height=\"630\" srcset=\"https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI.jpg 1200w, https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI-980x515.jpg 980w, https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI-480x252.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1200px, 100vw\" class=\"wp-image-13279\" \/><\/span><\/div><\/div><\/div><div class=\"et_pb_row_2 et_pb_row et_pb_equal_columns et_block_row\"><div class=\"et_pb_column_2 et_pb_column et_pb_column_4_4 et-last-child et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_text_1 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><p>Yrityksiss\u00e4 ker\u00e4ttyjen tietojen m\u00e4\u00e4r\u00e4 kasvaa jatkuvasti, ja sen my\u00f6t\u00e4 my\u00f6s tarve hallita n\u00e4it\u00e4 tietoja optimaalisesti ja k\u00e4ytt\u00e4\u00e4 niit\u00e4 analyyseiss\u00e4 kasvaa. Tietovarastot ja dataj\u00e4rvet ovat vakiintuneita ratkaisuja suurten tietom\u00e4\u00e4rien tallentamiseen. Kerromme n\u00e4iden kahden vaihtoehdon t\u00e4rkeimmist\u00e4 eroista.  <\/p>\n<\/div><\/div><\/div><\/div><div class=\"et_pb_row_3 et_pb_row et_block_row\"><div class=\"et_pb_column_3 et_pb_column et_pb_column_4_4 et-last-child et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_text_2 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_88 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#Mika_on_datavarasto\" >Mik\u00e4 on datavarasto?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#Mika_on_datajarvi\" >Mik\u00e4 on dataj\u00e4rvi?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#Samankaltaisuudet_ja_erot\" >Samankaltaisuudet ja erot<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#Miten_tehda_oikea_valinta\" >Miten tehd\u00e4 oikea valinta<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#Tulevaisuus_Data_Lakehouse\" >Tulevaisuus: Data Lakehouse<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#Paatelma\" >P\u00e4\u00e4telm\u00e4<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Mika_on_datavarasto\"><\/span>Mik\u00e4 on datavarasto?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Termi datavarasto viittaa tietojen keskitettyyn kokoamiseen, joka on yleens\u00e4 osa business intelligence -ratkaisua. Sinne voidaan ker\u00e4t\u00e4 ja tallentaa suuri m\u00e4\u00e4r\u00e4 tietoa eri l\u00e4hteist\u00e4. T\u00e4t\u00e4 varten tietovarasto poimii s\u00e4\u00e4nn\u00f6llisesti tietoja eri j\u00e4rjestelmist\u00e4, jotka sitten tarkistetaan, puhdistetaan, muotoillaan ja verrataan jo olemassa oleviin tietoihin. N\u00e4in tapahtuu niin sanottu ETL-prosessi (Extract, Transform, Load). T\u00e4t\u00e4 varten m\u00e4\u00e4ritet\u00e4\u00e4n ensin tietojen rakenne, eli niin sanottu skeema. T\u00e4t\u00e4 menettely\u00e4 kutsutaan nimell\u00e4 Schema on Write, ja siin\u00e4 m\u00e4\u00e4ritet\u00e4\u00e4n, milt\u00e4 konsolidoidut tiedot n\u00e4ytt\u00e4v\u00e4t. Koska tiedot tallennetaan yleens\u00e4 taulukoihin, skeema vastaa esimerkiksi seuraaviin kysymyksiin:      <\/p>\n<ul>\n<li>Milt\u00e4 taulukon rivi n\u00e4ytt\u00e4\u00e4?<\/li>\n<li>Mit\u00e4 ominaisuuksia kukin rivi sis\u00e4lt\u00e4\u00e4?<\/li>\n<li>Mit\u00e4 tietoja odotetaan olevan?<\/li>\n<\/ul>\n<p>K\u00e4sitellyt tiedot tallennetaan siten, ett\u00e4 k\u00e4ytt\u00e4j\u00e4t voivat k\u00e4ytt\u00e4\u00e4 niit\u00e4 milloin tahansa.<\/p>\n<\/div><\/div><div class=\"et_pb_image_1 et_pb_image et_pb_module et_block_module\"><span class=\"et_pb_image_wrap\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/parm.com\/wp-content\/uploads\/2022\/12\/Data_Warehouse.jpg\" width=\"805\" height=\"278\" srcset=\"https:\/\/parm.com\/wp-content\/uploads\/2022\/12\/Data_Warehouse.jpg 805w, https:\/\/parm.com\/wp-content\/uploads\/2022\/12\/Data_Warehouse-480x166.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 805px, 100vw\" class=\"wp-image-13289\" alt=\"Datavarasto ja dataj\u00e4rvi\" title=\"Data_Warehouse\" \/><\/span><\/div><div class=\"et_pb_text_3 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><h3>Datavarastojen edut<\/h3>\n<ul>\n<li><strong>Helppo analyysi:<\/strong> Koska tietovarastossa olevat tiedot ovat saatavilla yhten\u00e4isess\u00e4 muodossa, niit\u00e4 voidaan helposti analysoida BI-j\u00e4rjestelm\u00e4ss\u00e4 ja siten k\u00e4ytt\u00e4\u00e4 p\u00e4\u00e4t\u00f6ksentekoon. My\u00f6s k\u00e4ytt\u00e4j\u00e4t, joilla ei ole tietoteknist\u00e4 osaamista, voivat n\u00e4in ollen saada t\u00e4rkeit\u00e4 oivalluksia saatavilla olevista tiedoista. <strong><br \/><\/strong><\/li>\n<li><strong>Tietojen yhdist\u00e4minen:<\/strong> Koska tietovarastoon ker\u00e4t\u00e4\u00e4n tietoja eri tietokannoista, eri l\u00e4hteist\u00e4 per\u00e4isin olevat tiedot voidaan helposti liitt\u00e4\u00e4 toisiinsa tai niit\u00e4 voidaan analysoida korrelaatioiden l\u00f6yt\u00e4miseksi.<strong><br \/><\/strong><\/li>\n<li><strong>Tiedon laatu:<\/strong> Koska tiedot validoidaan ja muotoillaan ennen niiden tallentamista, tietovarasto sis\u00e4lt\u00e4\u00e4 vain yhdenmukaisia ja olennaisia tietoja. K\u00e4ytett\u00e4viss\u00e4 olevien tietojen laatu on n\u00e4in ollen eritt\u00e4in korkea. <strong><\/strong><\/li>\n<\/ul>\n<h3><\/h3>\n<h3>Datavarastojen haitat<\/h3>\n<ul>\n<li><strong>Puuttuvat tiedot:<\/strong> Datavarastoon tallennetaan vain sellaiset tiedot, joita tarvitaan alun perin aiottuun tarkoitukseen. Jos lis\u00e4\u00e4 tietoja tarvitaan, ne on lis\u00e4tt\u00e4v\u00e4 tietovarastoon hankalalla tavalla. <\/li>\n<li><strong>V\u00e4hemm\u00e4n joustavuutta:<\/strong> Jos tietovaraston k\u00e4ytt\u00f6tarkoitus on muuttunut tai jos tulevaisuudessa tarvitaan lis\u00e4\u00e4 tietoja, datavarastoa on mukautettava. T\u00e4m\u00e4 johtuu siit\u00e4, ett\u00e4 tietomalli tai -rakenne on m\u00e4\u00e4ritelty etuk\u00e4teen (schema on write). T\u00e4m\u00e4n muuttaminen voi olla aikaa viev\u00e4\u00e4 ja kallista. Tietovarasto ei n\u00e4in ollen ole yht\u00e4 joustava uusien tietol\u00e4hteiden suhteen.   <\/li>\n<li><strong>Korkeat k\u00e4ytt\u00f6\u00f6nottokustannukset:<\/strong> Koska schema on write on m\u00e4\u00e4ritelt\u00e4v\u00e4 ennen datavaraston k\u00e4yt\u00f6n aloittamista, syntyy aluksi korkeampia kustannuksia.<\/li>\n<\/ul>\n<\/div><\/div><div class=\"et_pb_text_4 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><h2><span class=\"ez-toc-section\" id=\"Mika_on_datajarvi\"><\/span>Mik\u00e4 on dataj\u00e4rvi?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Dataj\u00e4rvell\u00e4 tarkoitetaan keskitetty\u00e4 tietovarastoa, johon tallennetaan suuria m\u00e4\u00e4ri\u00e4 eri l\u00e4hteist\u00e4 per\u00e4isin olevia tietoja, yleens\u00e4 raakamuotoisina. Mutta my\u00f6s strukturoitua tai puolistrukturoitua dataa voidaan s\u00e4ilytt\u00e4\u00e4. Kun siis datavarastoon tallennetaan vain strukturoitua tietoa, dataj\u00e4rviin voidaan tallentaa tietoa eri muodoissa ja saattaa se n\u00e4in k\u00e4ytt\u00e4jien saataville. T\u00e4ll\u00f6in tietomalli tallennetaan yksityiskohtaisesti vasta sis\u00e4lt\u00f6\u00e4 luettaessa (schema on read), mik\u00e4 voi olla virhealtista. Siksi t\u00e4ss\u00e4 tapahtuu ELT-prosessi (Extract, Load, Transform).    <\/p>\n<\/div><\/div><div class=\"et_pb_image_2 et_pb_image et_pb_module et_block_module\"><span class=\"et_pb_image_wrap\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/parm.com\/wp-content\/uploads\/2022\/12\/Data_Lake.jpg\" width=\"805\" height=\"278\" srcset=\"https:\/\/parm.com\/wp-content\/uploads\/2022\/12\/Data_Lake.jpg 805w, https:\/\/parm.com\/wp-content\/uploads\/2022\/12\/Data_Lake-480x166.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 805px, 100vw\" class=\"wp-image-13285\" alt=\"Data Lake\" title=\"Data_Lake\" \/><\/span><\/div><div class=\"et_pb_text_5 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><h3>Dataj\u00e4rvien edut<\/h3>\n<ul>\n<li><strong>Saavutettavuus:<\/strong> Yrityksen tiedot tallennetaan keskitetysti dataj\u00e4rveen, joten kaikki k\u00e4ytt\u00e4j\u00e4t p\u00e4\u00e4sev\u00e4t niihin helposti k\u00e4siksi.<\/li>\n<li><strong>Tietosiilojen v\u00e4ltt\u00e4minen:<\/strong> Sek\u00e4 strukturoitua ett\u00e4 puolistrukturoitua tai strukturoimatonta tietoa voidaan tallentaa. N\u00e4in v\u00e4ltet\u00e4\u00e4n datasiiloja. <\/li>\n<li><strong>Suuri joustavuus:<\/strong> Tietoa voidaan muuttaa ja muokata, jotta sit\u00e4 voidaan analysoida eri tarkoituksiin. Lis\u00e4tietol\u00e4hteit\u00e4 voidaan lis\u00e4t\u00e4 helposti ja ilman suuria muutoksia dataj\u00e4rveen. <\/li>\n<li><strong>Koneoppiminen:<\/strong> Tallennetut tiedot soveltuvat erinomaisesti koneoppimiseen.<strong><\/strong><\/li>\n<\/ul>\n<h3><\/h3>\n<h3>Dataj\u00e4rvien haitat<\/h3>\n<ul>\n<li><strong>Varastointikapasiteetti:<\/strong> Koska kaikki tiedot tallennetaan suodattamattomina, tarvitaan enemm\u00e4n muistia kuin datavarastossa.<\/li>\n<li><strong>Tietojen laatu:<\/strong> Ilman tietojen laatua ja tiedonhallintaa koskevia toimenpiteit\u00e4 tallennetuista tiedoista voi tulla nopeasti niin sanottu datasuo. Datasuot on yll\u00e4pit\u00e4m\u00e4t\u00f6n dataj\u00e4rvi, jossa tietoja tallennetaan ilman asianmukaista dokumentointia, jolloin yleiskuva katoaa nopeasti. <\/li>\n<\/ul>\n<\/div><\/div><div class=\"et_pb_text_6 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><h2><span class=\"ez-toc-section\" id=\"Samankaltaisuudet_ja_erot\"><\/span>Samankaltaisuudet ja erot<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sek\u00e4 datavarastot ett\u00e4 dataj\u00e4rvet on suunniteltu liiketoiminta-analyysej\u00e4 varten, ja ne toimivat yrityksen keskeisin\u00e4 tietovarastoina. Koska niiden tarkoitus ja tavoitteet ovat samankaltaiset, n\u00e4m\u00e4 kaksi teknologiaa on helppo sekoittaa kesken\u00e4\u00e4n. T\u00e4rkeimm\u00e4t erot ovat:  <\/p>\n<p>&nbsp;<\/p>\n<table style=\"width: 100%; border-collapse: collapse; float: left;\" border=\"0\">\n<tbody>\n<tr>\n<td style=\"width: 33.3333%;\"><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #1b3e90;\"><strong>Tietovarasto<\/strong><\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #1b3e90;\"><strong>Tietoj\u00e4rvi<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><strong>Tietorakenne<\/strong><\/td>\n<td style=\"width: 33.3333%;\">J\u00e4sennellyt, k\u00e4sitellyt tiedot<\/td>\n<td style=\"width: 33.3333%;\">J\u00e4sennellyt ja puolij\u00e4sennellyt tiedot, mutta ennen kaikkea raakatiedot<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><strong>Tietojen tallentamisen tarkoitus<\/strong><\/td>\n<td style=\"width: 33.3333%;\">M\u00e4\u00e4ritelty, joten tietom\u00e4\u00e4r\u00e4 on pienempi<\/td>\n<td style=\"width: 33.3333%;\">Ei m\u00e4\u00e4ritelty, joten tietom\u00e4\u00e4r\u00e4 on suurempi<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><strong>K\u00e4ytt\u00e4j\u00e4t<\/strong><\/td>\n<td style=\"width: 33.3333%;\">Erilaiset k\u00e4ytt\u00e4j\u00e4t, joilla ei yleens\u00e4 ole tietoteknist\u00e4 osaamista<\/td>\n<td style=\"width: 33.3333%;\">Tarvitaan data-analyytikoita tai erityisi\u00e4 ty\u00f6kaluja, jotta tiedot voidaan muuntaa muiden k\u00e4ytt\u00e4jien ymm\u00e4rrett\u00e4v\u00e4\u00e4n muotoon<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><strong>Esteett\u00f6myys<\/strong><\/td>\n<td style=\"width: 33.3333%;\">Muutokset ovat monimutkaisia ja kalliita<\/td>\n<td style=\"width: 33.3333%;\">Tiedot ovat helposti saatavilla, ja niit\u00e4 on nopea ja helppo p\u00e4ivitt\u00e4\u00e4<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><strong>Schema<\/strong><\/td>\n<td style=\"width: 33.3333%;\">Schema on Write: Schema m\u00e4\u00e4ritell\u00e4\u00e4n ennen tietojen tallentamista<\/td>\n<td style=\"width: 33.3333%;\">Schema on Read: Schema m\u00e4\u00e4ritell\u00e4\u00e4n, kun tietoja luetaan<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div><\/div><\/div><div class=\"et_pb_row_4 et_pb_row et_block_row\"><div class=\"et_pb_column_4 et_pb_column et_pb_column_4_4 et-last-child et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_text_7 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><h2><span class=\"ez-toc-section\" id=\"Miten_tehda_oikea_valinta\"><\/span>Miten tehd\u00e4 oikea valinta<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Se, onko datavarasto vai dataj\u00e4rvi sinulle parempi valinta, riippuu useista tekij\u00f6ist\u00e4, jotka saattavat jo k\u00e4yd\u00e4 ilmi n\u00e4iden kahden tekniikan v\u00e4lisist\u00e4 eroista. Kysy siis itselt\u00e4si: <\/p>\n<ul>\n<li>Pit\u00e4isik\u00f6 tietojen olla j\u00e4senneltyj\u00e4 vai raakamuotoisia?<\/li>\n<li>T\u00e4ytyyk\u00f6 tietojen palvella tietty\u00e4 tarkoitusta?<\/li>\n<li>Kuka tietoja k\u00e4ytt\u00e4\u00e4? <\/li>\n<li>Kuinka todenn\u00e4k\u00f6ist\u00e4 on, ett\u00e4 arviointivaatimukset muuttuvat?<\/li>\n<\/ul>\n<\/div><\/div><div class=\"et_pb_text_8 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><h2><span class=\"ez-toc-section\" id=\"Tulevaisuus_Data_Lakehouse\"><\/span>Tulevaisuus: Data Lakehouse<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yritykset eiv\u00e4t useinkaan pysty tekem\u00e4\u00e4n selke\u00e4\u00e4 p\u00e4\u00e4t\u00f6st\u00e4 siit\u00e4, tarvitsevatko ne datavarastoa vai dataj\u00e4rve\u00e4. Ne tarvitsevat pikemminkin molempia - dataj\u00e4rve\u00e4, jotta ne voivat hy\u00f6dynt\u00e4\u00e4 raakadataa, mutta my\u00f6s datavarastoa, jotta ne voivat tarjota analytiikkaa kaikille liiketoiminnan k\u00e4ytt\u00e4jille. N\u00e4iden kahden teknologian samanaikaisesta k\u00e4ytt\u00e4misest\u00e4 on kuitenkin se haittapuoli, ett\u00e4 tiedot tallennetaan kahteen tai useampaan paikkaan, joten niit\u00e4 on my\u00f6s analysoitava, yll\u00e4pidett\u00e4v\u00e4 ja valvottava eri paikoissa. T\u00e4m\u00e4 puolestaan voi johtaa virheisiin tai vanhentuneisiin tietoihin.    <br \/>Data lakehouse yhdist\u00e4\u00e4 dataj\u00e4rvien joustavuuden ja datavaraston rakennetta luovat prosessit ja tarjoaa siten molempien tekniikoiden parhaat puolet. N\u00e4in BI-j\u00e4rjestelm\u00e4ss\u00e4 voidaan analysoida my\u00f6s j\u00e4sentym\u00e4t\u00f6nt\u00e4 dataa. <\/p>\n<\/div><\/div><\/div><\/div><div class=\"et_pb_row_5 et_pb_row et_block_row\"><div class=\"et_pb_column_5 et_pb_column et_pb_column_4_4 et-last-child et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_text_9 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><h2><span class=\"ez-toc-section\" id=\"Paatelma\"><\/span>P\u00e4\u00e4telm\u00e4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Datavarastot ja dataj\u00e4rvet on suunniteltu liiketoiminta-analyysej\u00e4 varten. Molemmilla on etunsa ja haittansa, mutta ne voivat my\u00f6s t\u00e4ydent\u00e4\u00e4 toisiaan. Se, mik\u00e4 on sopivampi ratkaisu yrityksesi tietojen hallintaan, riippuu tarpeistasi ja erilaisista olosuhteista.  <\/p>\n<\/div><\/div><\/div><\/div><div class=\"et_pb_row_6 et_pb_row et_block_row\"><div class=\"et_pb_column_6 et_pb_column et_pb_column_4_4 et-last-child et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_text_10 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><p>myPARM BI -liiketoimintatiedon hallintaohjelmisto<span style=\"font-size: x-small;\"><sup>act<\/sup><\/span> perustuu p\u00e4\u00e4asiassa tietovarastoon. T\u00e4m\u00e4n ansiosta my\u00f6s ty\u00f6ntekij\u00e4t, joilla ei ole tietoteknist\u00e4 osaamista, voivat analysoida tallennettuja tietoja, laatia raportteja ja kaavioita sek\u00e4 saada t\u00e4rke\u00e4\u00e4 tietoa tiedoista. <\/p>\n<p>Se l\u00f6ytyy myPARM BI:st\u00e4<span style=\"font-size: x-small;\"><sup>act<\/sup><\/span> on kuitenkin my\u00f6s mahdollista liitt\u00e4\u00e4 ja analysoida puolirakenteisia tietoja. T\u00e4m\u00e4 edellytt\u00e4\u00e4 kuitenkin syv\u00e4llisemp\u00e4\u00e4 tiet\u00e4myst\u00e4 tietomallien rakenteesta t\u00e4llaisten tietojen analysoimiseksi. Toisin sanoen t\u00e4ss\u00e4 saatetaan tarvita data-analyytikon osaamista.  <\/p>\n<\/div><\/div><\/div><\/div><div class=\"et_pb_row_7 et_pb_row et_block_row\"><div class=\"et_pb_column_7 et_pb_column et_pb_column_1_2 et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_text_11 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><p>Lue lis\u00e4\u00e4 Business Intelligence Software -ohjelmistosta myPARM BI<span style=\"font-size: x-small;\"><sup>act<\/sup><\/span>:<\/p>\n<\/div><\/div><div class=\"et_pb_module et_pb_button_module_wrapper et_pb_button_0_wrapper preset--group--divi-button--divi-button--hi917qs--default_wrapper preset--module--divi-button--default_wrapper\"><a class=\"et_pb_button_0 et_pb_button et_pb_bg_layout_light et_pb_module et_block_module preset--group--divi-button--divi-button--hi917qs--default preset--module--divi-button--default\" href=\"https:\/\/parm.com\/myparm-bi\/\" target=\"_blank\">LIS\u00c4TIETOJA<\/a><\/div><\/div><div class=\"et_pb_column_8 et_pb_column et_pb_column_1_2 et-last-child et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_text_12 et_pb_text et_pb_bg_layout_light et_pb_module et_block_module preset--module--divi-text--default\"><div class=\"et_pb_text_inner\"><p>Haluaisitko tutustua myPARM BI<span style=\"font-size: x-small;\"><sup>act<\/sup><\/span>iin demoesityksess\u00e4? Siin\u00e4 tapauksessa voit varata ajan tapaamiseen vaikka samantien!<\/p>\n<\/div><\/div><div class=\"et_pb_module et_pb_button_module_wrapper et_pb_button_1_wrapper preset--group--divi-button--divi-button--hi917qs--default_wrapper preset--module--divi-button--default_wrapper\"><a class=\"et_pb_button_1 et_pb_button et_pb_bg_layout_light et_pb_module et_block_module preset--group--divi-button--divi-button--hi917qs--default preset--module--divi-button--default\" href=\"https:\/\/calendly.com\/parmag\/myparm-biact-webdemo-fi\" target=\"_blank\">VARAA TAPAAMINEN<\/a><\/div><\/div><\/div><div class=\"et_pb_row_8 et_pb_row et_block_row\"><div class=\"et_pb_column_9 et_pb_column et_pb_column_4_4 et-last-child et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_code_0 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><div class=\"shariff shariff-align-left shariff-widget-align-left\" style=\"display:none\"><ul class=\"shariff-buttons theme-round orientation-horizontal buttonsize-medium\"><li class=\"shariff-button facebook shariff-nocustomcolor\" style=\"background-color:#4273c8\"><a href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Fparm.com%2Ffi%2Fdata-warehouse-and-data-lake%2F\" title=\"Bei Facebook teilen\" aria-label=\"Bei Facebook teilen\" role=\"button\" rel=\"nofollow\" class=\"shariff-link\" style=\"; background-color:#3b5998; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 18 32\"><path fill=\"#3b5998\" d=\"M17.1 0.2v4.7h-2.8q-1.5 0-2.1 0.6t-0.5 1.9v3.4h5.2l-0.7 5.3h-4.5v13.6h-5.5v-13.6h-4.5v-5.3h4.5v-3.9q0-3.3 1.9-5.2t5-1.8q2.6 0 4.1 0.2z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button linkedin shariff-nocustomcolor\" style=\"background-color:#1488bf\"><a href=\"https:\/\/www.linkedin.com\/sharing\/share-offsite\/?url=https%3A%2F%2Fparm.com%2Ffi%2Fdata-warehouse-and-data-lake%2F\" title=\"Bei LinkedIn teilen\" aria-label=\"Bei LinkedIn teilen\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\"; background-color:#0077b5; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 27 32\"><path fill=\"#0077b5\" d=\"M6.2 11.2v17.7h-5.9v-17.7h5.9zM6.6 5.7q0 1.3-0.9 2.2t-2.4 0.9h0q-1.5 0-2.4-0.9t-0.9-2.2 0.9-2.2 2.4-0.9 2.4 0.9 0.9 2.2zM27.4 18.7v10.1h-5.9v-9.5q0-1.9-0.7-2.9t-2.3-1.1q-1.1 0-1.9 0.6t-1.2 1.5q-0.2 0.5-0.2 1.4v9.9h-5.9q0-7.1 0-11.6t0-5.3l0-0.9h5.9v2.6h0q0.4-0.6 0.7-1t1-0.9 1.6-0.8 2-0.3q3 0 4.9 2t1.9 6z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button xing shariff-nocustomcolor\" style=\"background-color:#29888a\"><a href=\"https:\/\/www.xing.com\/spi\/shares\/new?url=https%3A%2F%2Fparm.com%2Ffi%2Fdata-warehouse-and-data-lake%2F\" title=\"Bei XING teilen\" aria-label=\"Bei XING teilen\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\"; background-color:#126567; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 25 32\"><path fill=\"#126567\" d=\"M10.7 11.9q-0.2 0.3-4.6 8.2-0.5 0.8-1.2 0.8h-4.3q-0.4 0-0.5-0.3t0-0.6l4.5-8q0 0 0 0l-2.9-5q-0.2-0.4 0-0.7 0.2-0.3 0.5-0.3h4.3q0.7 0 1.2 0.8zM25.1 0.4q0.2 0.3 0 0.7l-9.4 16.7 6 11q0.2 0.4 0 0.6-0.2 0.3-0.6 0.3h-4.3q-0.7 0-1.2-0.8l-6-11.1q0.3-0.6 9.5-16.8 0.4-0.8 1.2-0.8h4.3q0.4 0 0.5 0.3z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button mailto shariff-nocustomcolor\" style=\"background-color:#a8a8a8\"><a href=\"mailto:?body=https%3A%2F%2Fparm.com%2Ffi%2Fdata-warehouse-and-data-lake%2F&subject=Datavarasto%20ja%20dataj%C3%A4rvi\" title=\"Per E-Mail versenden\" aria-label=\"Per E-Mail versenden\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\"; background-color:#999; color:#fff\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 32 32\"><path fill=\"#999\" d=\"M32 12.7v14.2q0 1.2-0.8 2t-2 0.9h-26.3q-1.2 0-2-0.9t-0.8-2v-14.2q0.8 0.9 1.8 1.6 6.5 4.4 8.9 6.1 1 0.8 1.6 1.2t1.7 0.9 2 0.4h0.1q0.9 0 2-0.4t1.7-0.9 1.6-1.2q3-2.2 8.9-6.1 1-0.7 1.8-1.6zM32 7.4q0 1.4-0.9 2.7t-2.2 2.2q-6.7 4.7-8.4 5.8-0.2 0.1-0.7 0.5t-1 0.7-0.9 0.6-1.1 0.5-0.9 0.2h-0.1q-0.4 0-0.9-0.2t-1.1-0.5-0.9-0.6-1-0.7-0.7-0.5q-1.6-1.1-4.7-3.2t-3.6-2.6q-1.1-0.7-2.1-2t-1-2.5q0-1.4 0.7-2.3t2.1-0.9h26.3q1.2 0 2 0.8t0.9 2z\"\/><\/svg><\/span><\/a><\/li><\/ul><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"et_pb_section_1 et_pb_section et_section_regular et_block_section\"><div class=\"et_pb_row_9 et_pb_row et_block_row\"><div class=\"et_pb_column_10 et_pb_column et_pb_column_4_4 et-last-child et_block_column et_pb_css_mix_blend_mode_passthrough\"><div class=\"et_pb_code_1 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><!-- Begin Sendinblue Form -->\n<!-- START - We recommend to place the below code in head tag of your website html  -->\n<style>\n  @font-face {\n    font-display: block;\n    font-family: Roboto;\n    src: url(https:\/\/assets.sendinblue.com\/font\/Roboto\/Latin\/normal\/normal\/7529907e9eaf8ebb5220c5f9850e3811.woff2) format(\"woff2\"), url(https:\/\/assets.sendinblue.com\/font\/Roboto\/Latin\/normal\/normal\/25c678feafdc175a70922a116c9be3e7.woff) format(\"woff\")\n  }\n\n  @font-face {\n    font-display: fallback;\n    font-family: Roboto;\n    font-weight: 600;\n    src: url(https:\/\/assets.sendinblue.com\/font\/Roboto\/Latin\/medium\/normal\/6e9caeeafb1f3491be3e32744bc30440.woff2) format(\"woff2\"), url(https:\/\/assets.sendinblue.com\/font\/Roboto\/Latin\/medium\/normal\/71501f0d8d5aa95960f6475d5487d4c2.woff) format(\"woff\")\n  }\n\n  @font-face {\n    font-display: fallback;\n    font-family: Roboto;\n    font-weight: 700;\n    src: url(https:\/\/assets.sendinblue.com\/font\/Roboto\/Latin\/bold\/normal\/3ef7cf158f310cf752d5ad08cd0e7e60.woff2) format(\"woff2\"), url(https:\/\/assets.sendinblue.com\/font\/Roboto\/Latin\/bold\/normal\/ece3a1d82f18b60bcce0211725c476aa.woff) format(\"woff\")\n  }\n\n  #sib-container input:-ms-input-placeholder {\n    text-align: left;\n    font-family: \"Helvetica\", sans-serif;\n    color: #c0ccda;\n  }\n\n  #sib-container input::placeholder {\n    text-align: left;\n    font-family: \"Helvetica\", sans-serif;\n    color: #c0ccda;\n  }\n\n  #sib-container textarea::placeholder {\n    text-align: left;\n    font-family: \"Helvetica\", sans-serif;\n    color: #c0ccda;\n  }\n<\/style>\n<link rel=\"stylesheet\" href=\"https:\/\/sibforms.com\/forms\/end-form\/build\/sib-styles.css\">\n<!--  END - We recommend to place the above code in head tag of your website html -->\n\n<!-- START - We recommend to place the below code where you want the form in your website html  -->\n<div class=\"sib-form\" style=\"text-align: center;\n         background-color: transparent;                                 \">\n  <div id=\"sib-form-container\" class=\"sib-form-container\">\n    <div id=\"error-message\" class=\"sib-form-message-panel\" style=\"font-size:16px; text-align:left; font-family:\"Helvetica\", sans-serif; color:#661d1d; background-color:#ffeded; border-radius:3px; border-color:#ff4949;max-width:540px;\">\n      <div class=\"sib-form-message-panel__text sib-form-message-panel__text--center\">\n        <svg viewBox=\"0 0 512 512\" class=\"sib-icon sib-notification__icon\">\n          <path d=\"M256 40c118.621 0 216 96.075 216 216 0 119.291-96.61 216-216 216-119.244 0-216-96.562-216-216 0-119.203 96.602-216 216-216m0-32C119.043 8 8 119.083 8 256c0 136.997 111.043 248 248 248s248-111.003 248-248C504 119.083 392.957 8 256 8zm-11.49 120h22.979c6.823 0 12.274 5.682 11.99 12.5l-7 168c-.268 6.428-5.556 11.5-11.99 11.5h-8.979c-6.433 0-11.722-5.073-11.99-11.5l-7-168c-.283-6.818 5.167-12.5 11.99-12.5zM256 340c-15.464 0-28 12.536-28 28s12.536 28 28 28 28-12.536 28-28-12.536-28-28-28z\" \/>\n        <\/svg>\n        <span class=\"sib-form-message-panel__inner-text\">\n                          Your registration could not be saved. Please try again.\n                      <\/span>\n      <\/div>\n    <\/div>\n    <div><\/div>\n    <div id=\"success-message\" class=\"sib-form-message-panel\" style=\"font-size:16px; text-align:left; font-family:\"Helvetica\", sans-serif; color:#085229; background-color:#e7faf0; border-radius:3px; border-color:#13ce66;max-width:540px;\">\n      <div class=\"sib-form-message-panel__text sib-form-message-panel__text--center\">\n        <svg viewBox=\"0 0 512 512\" class=\"sib-icon sib-notification__icon\">\n          <path d=\"M256 8C119.033 8 8 119.033 8 256s111.033 248 248 248 248-111.033 248-248S392.967 8 256 8zm0 464c-118.664 0-216-96.055-216-216 0-118.663 96.055-216 216-216 118.664 0 216 96.055 216 216 0 118.663-96.055 216-216 216zm141.63-274.961L217.15 376.071c-4.705 4.667-12.303 4.637-16.97-.068l-85.878-86.572c-4.667-4.705-4.637-12.303.068-16.97l8.52-8.451c4.705-4.667 12.303-4.637 16.97.068l68.976 69.533 163.441-162.13c4.705-4.667 12.303-4.637 16.97.068l8.451 8.52c4.668 4.705 4.637 12.303-.068 16.97z\" \/>\n        <\/svg>\n        <span class=\"sib-form-message-panel__inner-text\">\n                          Your subscription was successful. Please check your mailbox and confirm your registration.\n                      <\/span>\n      <\/div>\n    <\/div>\n    <div><\/div>\n    <div id=\"sib-container\" class=\"sib-container--large sib-container--vertical\" style=\"text-align:center; background-color:rgba(27,62,144,1); max-width:1080px; border-radius:3px; border-width:0px; border-color:#C0CCD9; border-style:solid;\">\n      <form id=\"sib-form\" method=\"POST\" action=\"https:\/\/272a17fd.sibforms.com\/serve\/MUIEAEPrU75I-jrvN1G-IamWKnnTItWSl6-JcNlxvdKthgnl7MesOofIxFl0M4Mqzoz4KkiUgn7LiGPCjRvb3PnoX4j4YVujxd8FLVCArz_Tbt0d5x_bhDQRH5PxnfXLCF9mk4H8i92bCL6a-nvHfAK7z5Dsmr4RjwUxpuLLjaW5ckCDWIU4qCzfB2t3_2SXYwkpkb26gfinTgFp\" data-type=\"subscription\">\n        <div style=\"padding: 8px 0;\">\n          <div class=\"sib-form-block\" style=\"font-size:32px; text-align:left; font-weight:700; font-family:\"Helvetica\", sans-serif; color:#ffffff; background-color:transparent;\">\n            <p>Newsletter<\/p>\n          <\/div>\n        <\/div>\n        <div style=\"padding: 8px 0;\">\n          <div class=\"sib-form-block\" style=\"font-size:16px; text-align:left; font-family:\"Helvetica\", sans-serif; color:#ffffff; background-color:transparent;\">\n            <div class=\"sib-text-form-block\">\n              <p>Subscribe to our monthly newsletter and stay informed about Parm AG products, news, trends in project management as well as offers and events.<\/p>\n            <\/div>\n          <\/div>\n        <\/div>\n        <div style=\"padding: 8px 0;\">\n          <div class=\"sib-input sib-form-block\">\n            <div class=\"form__entry entry_block\">\n              <div class=\"form__label-row \">\n\n                <div class=\"entry__field\">\n                  <input class=\"input\" type=\"text\" id=\"EMAIL\" name=\"EMAIL\" autocomplete=\"off\" placeholder=\"EMAIL\" data-required=\"true\" required \/>\n                <\/div>\n              <\/div>\n\n              <label class=\"entry__error entry__error--primary\" style=\"font-size:16px; text-align:left; font-family:\"Helvetica\", sans-serif; color:#661d1d; background-color:#ffeded; border-radius:3px; border-color:#ff4949;\">\n              <\/label>\n            <\/div>\n          <\/div>\n        <\/div>\n        <div style=\"padding: 8px 0;\">\n          <div class=\"sib-optin sib-form-block\" data-required=\"true\">\n            <div class=\"form__entry entry_mcq\">\n              <div class=\"form__label-row \">\n                <div class=\"entry__choice\">\n                  <label>\n                    <input type=\"checkbox\" class=\"input_replaced\" value=\"1\" id=\"OPT_IN\" name=\"OPT_IN\" required \/>\n                    <span class=\"checkbox checkbox_tick_positive\"><\/span><span style=\"font-size:14px; text-align:left; font-family:\"Helvetica\", sans-serif; color:#ffffff; background-color:transparent;\"><p>I agree that the newsletter may be individually tailored to my interests. For this purpose, I allow Parm AG to analyse my opening, clicking and downloading behaviour in the newsletter and to create a personal user profile of me. I have read and accept the <a href=\"https:\/\/parm.com\/fi\/privacy-policy\/\" target=\"_blank\" rel=\"noopener\">privacy policy<\/a>. I can unsubscribe from the newsletter at any time.<\/p><span data-required=\"*\" style=\"display: inline;\" class=\"entry__label entry__label_optin\"><\/span><\/span> <\/label>\n                <\/div>\n              <\/div>\n              <label class=\"entry__error entry__error--primary\" style=\"font-size:16px; text-align:left; font-family:\"Helvetica\", sans-serif; color:#661d1d; background-color:#ffeded; border-radius:3px; border-color:#ff4949;\">\n              <\/label>\n            <\/div>\n          <\/div>\n        <\/div>\n        <div style=\"padding: 8px 0;\">\n          <div class=\"g-recaptcha\" data-sitekey=\"6LdyzNAcAAAAANv3WwEWU18I26AH-2q2CcQ6eQUk\" data-callback=\"invisibleCaptchaCallback\" data-size=\"invisible\" onclick=\"executeCaptcha\"><\/div>\n        <\/div>\n        <div style=\"padding: 8px 0;\">\n          <div class=\"sib-form-block\" style=\"text-align: left\">\n            <button class=\"sib-form-block__button sib-form-block__button-with-loader\" style=\"font-size:16px; text-align:left; font-weight:700; font-family:\"Helvetica\", sans-serif; color:#1b3e90; background-color:#ffffff; border-radius:3px; border-width:0px;\" form=\"sib-form\" type=\"submit\">\n              <svg class=\"icon clickable__icon progress-indicator__icon sib-hide-loader-icon\" viewBox=\"0 0 512 512\">\n                <path d=\"M460.116 373.846l-20.823-12.022c-5.541-3.199-7.54-10.159-4.663-15.874 30.137-59.886 28.343-131.652-5.386-189.946-33.641-58.394-94.896-95.833-161.827-99.676C261.028 55.961 256 50.751 256 44.352V20.309c0-6.904 5.808-12.337 12.703-11.982 83.556 4.306 160.163 50.864 202.11 123.677 42.063 72.696 44.079 162.316 6.031 236.832-3.14 6.148-10.75 8.461-16.728 5.01z\" \/>\n              <\/svg>\n              SUBSCRIBE\n            <\/button>\n          <\/div>\n        <\/div>\n\n        <input type=\"text\" name=\"email_address_check\" value=\"\" class=\"input--hidden\">\n        <input type=\"hidden\" name=\"locale\" value=\"de\">\n      <\/form>\n    <\/div>\n  <\/div>\n<\/div>\n<!-- END - We recommend to place the below code where you want the form in your website html  -->\n\n<!-- START - We recommend to place the below code in footer or bottom of your website html  -->\n<script>\n  window.REQUIRED_CODE_ERROR_MESSAGE = 'W\u00e4hlen Sie bitte einen L\u00e4ndervorwahl aus.';\n  window.LOCALE = 'de';\n  window.EMAIL_INVALID_MESSAGE = window.SMS_INVALID_MESSAGE = \"The information entered is not valid. Please check the fields and try again.\";\n\n  window.REQUIRED_ERROR_MESSAGE = \"This field must not be empty. \";\n\n  window.GENERIC_INVALID_MESSAGE = \"The information entered is not valid. Please check the fields and try again.\";\n\n\n\n\n  window.translation = {\n    common: {\n      selectedList: '{quantity} Liste ausgew\u00e4hlt',\n      selectedLists: '{quantity} Listen ausgew\u00e4hlt'\n    }\n  };\n\n  var AUTOHIDE = Boolean(0);\n<\/script>\n<script src=\"https:\/\/sibforms.com\/forms\/end-form\/build\/main.js\"><\/script>\n\n<script src=\"https:\/\/www.google.com\/recaptcha\/api.js?hl=de\"><\/script>\n\n<!-- END - We recommend to place the above code in footer or bottom of your website html  -->\n<!-- End Sendinblue Form --><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Yrityksiss\u00e4 ker\u00e4ttyjen tietojen m\u00e4\u00e4r\u00e4 kasvaa jatkuvasti, ja sen my\u00f6t\u00e4 my\u00f6s tarve hallita n\u00e4it\u00e4 tietoja optimaalisesti ja k\u00e4ytt\u00e4\u00e4 niit\u00e4 analyyseiss\u00e4 kasvaa. Tietovarastot ja dataj\u00e4rvet ovat vakiintuneita ratkaisuja suurten tietom\u00e4\u00e4rien tallentamiseen. Kerromme n\u00e4iden kahden vaihtoehdon t\u00e4rkeimmist\u00e4 eroista.  <\/p>\n","protected":false},"author":1,"featured_media":13279,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[106],"tags":[62,63,495,494],"class_list":["post-13268","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-fi","tag-bi","tag-business-intelligence","tag-data-lake","tag-data-warehouse"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Datavarasto ja dataj\u00e4rvi | Parm AG<\/title>\n<meta name=\"description\" content=\"Tietovarastot ja dataj\u00e4rvet ovat vakiintuneita ratkaisuja suurten tietom\u00e4\u00e4rien tallentamiseen. Selit\u00e4mme niiden t\u00e4rkeimm\u00e4t erot.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/\" \/>\n<meta property=\"og:locale\" content=\"fi_FI\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Datavarasto ja dataj\u00e4rvi\" \/>\n<meta property=\"og:description\" content=\"Yrityksiss\u00e4 ker\u00e4ttyjen tietojen m\u00e4\u00e4r\u00e4 kasvaa jatkuvasti, ja sen my\u00f6t\u00e4 my\u00f6s tarve hallita n\u00e4it\u00e4 tietoja optimaalisesti ja k\u00e4ytt\u00e4\u00e4 niit\u00e4 analyyseiss\u00e4 kasvaa. Tietovarastot ja dataj\u00e4rvet ovat vakiintuneita ratkaisuja suurten tietom\u00e4\u00e4rien tallentamiseen. Kerromme n\u00e4iden kahden vaihtoehdon t\u00e4rkeimmist\u00e4 eroista.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/\" \/>\n<meta property=\"og:site_name\" content=\"Parm AG\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/myparm\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-14T09:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-28T06:07:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Natascha Schleutker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Datavarasto ja dataj\u00e4rvi\" \/>\n<meta name=\"twitter:description\" content=\"Yrityksiss\u00e4 ker\u00e4ttyjen tietojen m\u00e4\u00e4r\u00e4 kasvaa jatkuvasti, ja sen my\u00f6t\u00e4 my\u00f6s tarve hallita n\u00e4it\u00e4 tietoja optimaalisesti ja k\u00e4ytt\u00e4\u00e4 niit\u00e4 analyyseiss\u00e4 kasvaa. Tietovarastot ja dataj\u00e4rvet ovat vakiintuneita ratkaisuja suurten tietom\u00e4\u00e4rien tallentamiseen. Kerromme n\u00e4iden kahden vaihtoehdon t\u00e4rkeimmist\u00e4 eroista.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Kirjoittanut\" \/>\n\t<meta name=\"twitter:data1\" content=\"Natascha Schleutker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Arvioitu lukuaika\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minuuttia\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/\"},\"author\":{\"name\":\"Natascha Schleutker\",\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/#\\\/schema\\\/person\\\/c24699ce0d4e2f1a102409a36cc80953\"},\"headline\":\"Datavarasto ja dataj\u00e4rvi\",\"datePublished\":\"2022-12-14T09:00:00+00:00\",\"dateModified\":\"2026-09-28T06:07:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/\"},\"wordCount\":4,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/parm.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/Post_Data_Warehouse_Lake_FI.jpg\",\"keywords\":[\"BI\",\"Business Intelligence\",\"Data Lake\",\"Data Warehouse\"],\"articleSection\":[\"Bisnes\u00e4ly\"],\"inLanguage\":\"fi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/\",\"url\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/\",\"name\":\"Datavarasto ja dataj\u00e4rvi | Parm AG\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/parm.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/Post_Data_Warehouse_Lake_FI.jpg\",\"datePublished\":\"2022-12-14T09:00:00+00:00\",\"dateModified\":\"2026-09-28T06:07:30+00:00\",\"description\":\"Tietovarastot ja dataj\u00e4rvet ovat vakiintuneita ratkaisuja suurten tietom\u00e4\u00e4rien tallentamiseen. Selit\u00e4mme niiden t\u00e4rkeimm\u00e4t erot.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/#breadcrumb\"},\"inLanguage\":\"fi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fi\",\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/#primaryimage\",\"url\":\"https:\\\/\\\/parm.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/Post_Data_Warehouse_Lake_FI.jpg\",\"contentUrl\":\"https:\\\/\\\/parm.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/Post_Data_Warehouse_Lake_FI.jpg\",\"width\":1200,\"height\":630,\"caption\":\"Datavarasto vs. dataj\u00e4rvi\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/data-warehouse-and-data-lake\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/parm.com\\\/fi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Datavarasto ja dataj\u00e4rvi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/#website\",\"url\":\"https:\\\/\\\/parm.com\\\/fi\\\/\",\"name\":\"Parm AG\",\"description\":\"Successful projects. Swiss quality. Software f\u00fcr Projektmanagement\",\"publisher\":{\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/#organization\"},\"alternateName\":\"Parm\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/parm.com\\\/fi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fi\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/#organization\",\"name\":\"Parm AG\",\"alternateName\":\"Parm\",\"url\":\"https:\\\/\\\/parm.com\\\/fi\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fi\",\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/parm.com\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Parm_Logo_blue_RGB.png\",\"contentUrl\":\"https:\\\/\\\/parm.com\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Parm_Logo_blue_RGB.png\",\"width\":908,\"height\":228,\"caption\":\"Parm AG\"},\"image\":{\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/myparm\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/parm-ag\",\"https:\\\/\\\/www.xing.com\\\/pages\\\/parmag\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/parm.com\\\/fi\\\/#\\\/schema\\\/person\\\/c24699ce0d4e2f1a102409a36cc80953\",\"name\":\"Natascha Schleutker\",\"sameAs\":[\"https:\\\/\\\/parm.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Datavarasto ja dataj\u00e4rvi | Parm AG","description":"Tietovarastot ja dataj\u00e4rvet ovat vakiintuneita ratkaisuja suurten tietom\u00e4\u00e4rien tallentamiseen. Selit\u00e4mme niiden t\u00e4rkeimm\u00e4t erot.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/","og_locale":"fi_FI","og_type":"article","og_title":"Datavarasto ja dataj\u00e4rvi","og_description":"Yrityksiss\u00e4 ker\u00e4ttyjen tietojen m\u00e4\u00e4r\u00e4 kasvaa jatkuvasti, ja sen my\u00f6t\u00e4 my\u00f6s tarve hallita n\u00e4it\u00e4 tietoja optimaalisesti ja k\u00e4ytt\u00e4\u00e4 niit\u00e4 analyyseiss\u00e4 kasvaa. Tietovarastot ja dataj\u00e4rvet ovat vakiintuneita ratkaisuja suurten tietom\u00e4\u00e4rien tallentamiseen. Kerromme n\u00e4iden kahden vaihtoehdon t\u00e4rkeimmist\u00e4 eroista.","og_url":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/","og_site_name":"Parm AG","article_publisher":"https:\/\/www.facebook.com\/myparm","article_published_time":"2022-12-14T09:00:00+00:00","article_modified_time":"2026-09-28T06:07:30+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI.jpg","type":"image\/jpeg"}],"author":"Natascha Schleutker","twitter_card":"summary_large_image","twitter_title":"Datavarasto ja dataj\u00e4rvi","twitter_description":"Yrityksiss\u00e4 ker\u00e4ttyjen tietojen m\u00e4\u00e4r\u00e4 kasvaa jatkuvasti, ja sen my\u00f6t\u00e4 my\u00f6s tarve hallita n\u00e4it\u00e4 tietoja optimaalisesti ja k\u00e4ytt\u00e4\u00e4 niit\u00e4 analyyseiss\u00e4 kasvaa. Tietovarastot ja dataj\u00e4rvet ovat vakiintuneita ratkaisuja suurten tietom\u00e4\u00e4rien tallentamiseen. Kerromme n\u00e4iden kahden vaihtoehdon t\u00e4rkeimmist\u00e4 eroista.","twitter_image":"https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI.jpg","twitter_misc":{"Kirjoittanut":"Natascha Schleutker","Arvioitu lukuaika":"7 minuuttia"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#article","isPartOf":{"@id":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/"},"author":{"name":"Natascha Schleutker","@id":"https:\/\/parm.com\/fi\/#\/schema\/person\/c24699ce0d4e2f1a102409a36cc80953"},"headline":"Datavarasto ja dataj\u00e4rvi","datePublished":"2022-12-14T09:00:00+00:00","dateModified":"2026-09-28T06:07:30+00:00","mainEntityOfPage":{"@id":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/"},"wordCount":4,"commentCount":0,"publisher":{"@id":"https:\/\/parm.com\/fi\/#organization"},"image":{"@id":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#primaryimage"},"thumbnailUrl":"https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI.jpg","keywords":["BI","Business Intelligence","Data Lake","Data Warehouse"],"articleSection":["Bisnes\u00e4ly"],"inLanguage":"fi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/","url":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/","name":"Datavarasto ja dataj\u00e4rvi | Parm AG","isPartOf":{"@id":"https:\/\/parm.com\/fi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#primaryimage"},"image":{"@id":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#primaryimage"},"thumbnailUrl":"https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI.jpg","datePublished":"2022-12-14T09:00:00+00:00","dateModified":"2026-09-28T06:07:30+00:00","description":"Tietovarastot ja dataj\u00e4rvet ovat vakiintuneita ratkaisuja suurten tietom\u00e4\u00e4rien tallentamiseen. Selit\u00e4mme niiden t\u00e4rkeimm\u00e4t erot.","breadcrumb":{"@id":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#breadcrumb"},"inLanguage":"fi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/"]}]},{"@type":"ImageObject","inLanguage":"fi","@id":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#primaryimage","url":"https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI.jpg","contentUrl":"https:\/\/parm.com\/wp-content\/uploads\/2023\/11\/Post_Data_Warehouse_Lake_FI.jpg","width":1200,"height":630,"caption":"Datavarasto vs. dataj\u00e4rvi"},{"@type":"BreadcrumbList","@id":"https:\/\/parm.com\/fi\/data-warehouse-and-data-lake\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/parm.com\/fi\/"},{"@type":"ListItem","position":2,"name":"Datavarasto ja dataj\u00e4rvi"}]},{"@type":"WebSite","@id":"https:\/\/parm.com\/fi\/#website","url":"https:\/\/parm.com\/fi\/","name":"Parm AG","description":"Successful projects. Swiss quality. Software f\u00fcr Projektmanagement","publisher":{"@id":"https:\/\/parm.com\/fi\/#organization"},"alternateName":"Parm","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/parm.com\/fi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fi"},{"@type":"Organization","@id":"https:\/\/parm.com\/fi\/#organization","name":"Parm AG","alternateName":"Parm","url":"https:\/\/parm.com\/fi\/","logo":{"@type":"ImageObject","inLanguage":"fi","@id":"https:\/\/parm.com\/fi\/#\/schema\/logo\/image\/","url":"https:\/\/parm.com\/wp-content\/uploads\/2021\/11\/Parm_Logo_blue_RGB.png","contentUrl":"https:\/\/parm.com\/wp-content\/uploads\/2021\/11\/Parm_Logo_blue_RGB.png","width":908,"height":228,"caption":"Parm AG"},"image":{"@id":"https:\/\/parm.com\/fi\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/myparm","https:\/\/www.linkedin.com\/company\/parm-ag","https:\/\/www.xing.com\/pages\/parmag"]},{"@type":"Person","@id":"https:\/\/parm.com\/fi\/#\/schema\/person\/c24699ce0d4e2f1a102409a36cc80953","name":"Natascha Schleutker","sameAs":["https:\/\/parm.com"]}]}},"_links":{"self":[{"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/posts\/13268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/comments?post=13268"}],"version-history":[{"count":6,"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/posts\/13268\/revisions"}],"predecessor-version":[{"id":262024,"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/posts\/13268\/revisions\/262024"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/media\/13279"}],"wp:attachment":[{"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/media?parent=13268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/categories?post=13268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/parm.com\/fi\/wp-json\/wp\/v2\/tags?post=13268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}