{"id":79,"date":"2021-10-20T11:24:13","date_gmt":"2021-10-20T11:24:13","guid":{"rendered":"https:\/\/crmt.dev.wordpress.optiweb.si\/?post_type=solutions&#038;p=79"},"modified":"2022-01-25T07:47:53","modified_gmt":"2022-01-25T07:47:53","slug":"data-warehouse","status":"publish","type":"solutions","link":"https:\/\/crmt.dev.wordpress.optiweb.si\/sl\/solutions\/data-management\/data-warehouse\/","title":{"rendered":"Data Warehouse"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A Data Warehouse is a repository for all the data collected by various operational systems within an enterprise, dedicated to analysis and reporting. It is a key part of Business Intelligence and serves as a support for decision-making in the company.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">At CRMT, we begin by choosing the right technology for your analytical purposes. Every data model must be prepared and built in a way, which improves performance and can process any amount of data in a matter of minutes.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Our IT consultants excel at modeling and building a robust Data Warehouse, tailored to the customer&#8217;s needs. We offer workshops for end users and architects, as well as consulting on-site.<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>By applying relational and non-relational modeling techniques, we enable users to impose a structure on data and provide them a flexible way for data exploration and analysis.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Our know-how<\/h2>\n\n\n<div class=\"faq-block\"><div class=\"faq-block__single\"><h4>Building a Data Warehouse<\/h4><svg width=\"13\" height=\"24\" viewBox=\"0 0 13 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"> <path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M9.91328 12L0.5 1.44959L1.79336 0L12.5 12L1.79336 24L0.5 22.5504L9.91328 12Z\" fill=\"#8DC63F\"\/> <\/svg> <p>The core of each successfully finished DWH project is knowing what to expect from the underlying technology and DWH architecture. Place your trust in our experts, who can build a robust and comprehensive DWH, suited for your business model.<\/p><\/div><div class=\"faq-block__single\"><h4>Instant access to all data sources<\/h4><svg width=\"13\" height=\"24\" viewBox=\"0 0 13 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"> <path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M9.91328 12L0.5 1.44959L1.79336 0L12.5 12L1.79336 24L0.5 22.5504L9.91328 12Z\" fill=\"#8DC63F\"\/> <\/svg> <p>Through a data virtualization framework called \u201cvirtual schemas\u201d as well as a high-performance data integration framework, connect to and analyze data from more sources than ever before.<\/p><\/div><div class=\"faq-block__single\"><h4>Advanced in-Database analytics<\/h4><svg width=\"13\" height=\"24\" viewBox=\"0 0 13 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"> <path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M9.91328 12L0.5 1.44959L1.79336 0L12.5 12L1.79336 24L0.5 22.5504L9.91328 12Z\" fill=\"#8DC63F\"\/> <\/svg> <p>Integrate a variety of different analytics programming languages of your choice and use them for in-db analytics.<\/p><\/div><div class=\"faq-block__single\"><h4>Post-implementation services<\/h4><svg width=\"13\" height=\"24\" viewBox=\"0 0 13 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"> <path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M9.91328 12L0.5 1.44959L1.79336 0L12.5 12L1.79336 24L0.5 22.5504L9.91328 12Z\" fill=\"#8DC63F\"\/> <\/svg> <p>The real partnership begins after a successfully finished project. We provide full maintenance and support on-site as well as with remote access. All day, any day.<\/p><\/div><\/div>\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Success story<\/h2>\n\n\n<div class=\"text-image-block mb40 mt40 left\"><div class=\"text-image-block__text\"><p><b>Mladinska knjiga<\/b><\/p>\n<p><span style=\"font-weight: 400;\">When deploying Exasol database, the company\u2019s IT department had to do very little to make it perform. CRMT customized their ETL and syntax, and they were able to see immediate advantages in the system. Their business end-users suddenly had much faster reporting and data visualizations, with Exasol delivering information to their MicroStrategy BI platform in a fraction of the time when compared to the previous solution<\/span><\/p>\n<p><strong><a href=\"https:\/\/www.crmt.com\/resources\/case-studies\/case-study-mladinska-knjiga\/\">READ MORE<\/a><\/strong><\/p>\n<\/div><div class=\"text-image-block__image\"><img loading=\"lazy\" decoding=\"async\" width=\"572\" height=\"395\" src=\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2021\/10\/Mladinska_knjiga_572x395-572x395.png\" class=\"attachment-text-image size-text-image\" alt=\"\" srcset=\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2021\/10\/Mladinska_knjiga_572x395.png 572w, https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2021\/10\/Mladinska_knjiga_572x395-300x207.png 300w, https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2021\/10\/Mladinska_knjiga_572x395-260x180.png 260w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/div><\/div>\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Technology<\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/crmt.dev.wordpress.optiweb.si\/partners\/exasol\/\"><img loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"140\" src=\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140.png\" alt=\"\" class=\"wp-image-3289\" srcset=\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140.png 560w, https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140-300x75.png 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/a><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Exasol<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A powerhouse among analytics database solutions, achieving 18 out of 24 top-rankings in its peer groups.<\/p>\n<\/div>\n<\/div>\n\n\n<div class=\"partners-block\"><h2 class=\"text-center\" style=\"margin-bottom: 8px\">Happy customers<\/h2><div class=\"mb60 text-center\"><\/div><div class=\"partners-block__partners mb60\"><div class=\"single-partner__outer\"><div class=\"single-partner\"><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"36\" src=\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Mladinska_knjiga_160x36.png\" class=\"attachment-partner_logo size-partner_logo wp-post-image\" alt=\"\" \/><\/div><\/div><div class=\"single-partner__outer\"><div class=\"single-partner\"><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"36\" src=\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Telekom_slovenije_160x36.png\" class=\"attachment-partner_logo size-partner_logo wp-post-image\" alt=\"\" \/><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>A robust data warehouse is a core component of Business Intelligence<\/p>\n","protected":false},"featured_media":0,"parent":54,"menu_order":0,"template":"","class_list":["post-79","solutions","type-solutions","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Warehouse - crmt.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"sl_SI\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Warehouse - crmt.com\" \/>\n<meta property=\"og:description\" content=\"A robust data warehouse is a core component of Business Intelligence\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"crmt.com\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-25T07:47:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuta\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/\",\"url\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/\",\"name\":\"Data Warehouse - crmt.com\",\"isPartOf\":{\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140.png\",\"datePublished\":\"2021-10-20T11:24:13+00:00\",\"dateModified\":\"2022-01-25T07:47:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/#breadcrumb\"},\"inLanguage\":\"sl-SI\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sl-SI\",\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/#primaryimage\",\"url\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140.png\",\"contentUrl\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/sl\/homepage\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Solutions\",\"item\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Management\",\"item\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Data Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/#website\",\"url\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/\",\"name\":\"crmt.com\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sl-SI\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/#organization\",\"name\":\"crmt.com\",\"url\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sl-SI\",\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2021\/11\/logo-dark.png\",\"contentUrl\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2021\/11\/logo-dark.png\",\"width\":268,\"height\":60,\"caption\":\"crmt.com\"},\"image\":{\"@id\":\"https:\/\/crmt.dev.wordpress.optiweb.si\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Warehouse - crmt.com","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:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/","og_locale":"sl_SI","og_type":"article","og_title":"Data Warehouse - crmt.com","og_description":"A robust data warehouse is a core component of Business Intelligence","og_url":"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/","og_site_name":"crmt.com","article_modified_time":"2022-01-25T07:47:53+00:00","og_image":[{"url":"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/","url":"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/","name":"Data Warehouse - crmt.com","isPartOf":{"@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/#website"},"primaryImageOfPage":{"@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/#primaryimage"},"image":{"@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140.png","datePublished":"2021-10-20T11:24:13+00:00","dateModified":"2022-01-25T07:47:53+00:00","breadcrumb":{"@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/#breadcrumb"},"inLanguage":"sl-SI","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"sl-SI","@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/#primaryimage","url":"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140.png","contentUrl":"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2022\/01\/Exasol_560x140.png"},{"@type":"BreadcrumbList","@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/crmt.dev.wordpress.optiweb.si\/sl\/homepage\/"},{"@type":"ListItem","position":2,"name":"Solutions","item":"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/"},{"@type":"ListItem","position":3,"name":"Data Management","item":"https:\/\/crmt.dev.wordpress.optiweb.si\/solutions\/data-management\/"},{"@type":"ListItem","position":4,"name":"Data Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/#website","url":"https:\/\/crmt.dev.wordpress.optiweb.si\/","name":"crmt.com","description":"","publisher":{"@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/crmt.dev.wordpress.optiweb.si\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sl-SI"},{"@type":"Organization","@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/#organization","name":"crmt.com","url":"https:\/\/crmt.dev.wordpress.optiweb.si\/","logo":{"@type":"ImageObject","inLanguage":"sl-SI","@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/#\/schema\/logo\/image\/","url":"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2021\/11\/logo-dark.png","contentUrl":"https:\/\/crmt.dev.wordpress.optiweb.si\/wp-content\/uploads\/2021\/11\/logo-dark.png","width":268,"height":60,"caption":"crmt.com"},"image":{"@id":"https:\/\/crmt.dev.wordpress.optiweb.si\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/crmt.dev.wordpress.optiweb.si\/sl\/wp-json\/wp\/v2\/solutions\/79","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/crmt.dev.wordpress.optiweb.si\/sl\/wp-json\/wp\/v2\/solutions"}],"about":[{"href":"https:\/\/crmt.dev.wordpress.optiweb.si\/sl\/wp-json\/wp\/v2\/types\/solutions"}],"version-history":[{"count":39,"href":"https:\/\/crmt.dev.wordpress.optiweb.si\/sl\/wp-json\/wp\/v2\/solutions\/79\/revisions"}],"predecessor-version":[{"id":4091,"href":"https:\/\/crmt.dev.wordpress.optiweb.si\/sl\/wp-json\/wp\/v2\/solutions\/79\/revisions\/4091"}],"up":[{"embeddable":true,"href":"https:\/\/crmt.dev.wordpress.optiweb.si\/sl\/wp-json\/wp\/v2\/solutions\/54"}],"wp:attachment":[{"href":"https:\/\/crmt.dev.wordpress.optiweb.si\/sl\/wp-json\/wp\/v2\/media?parent=79"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}