{"id":6675,"date":"2026-02-01T09:38:36","date_gmt":"2026-02-01T09:38:36","guid":{"rendered":"https:\/\/sumit.wordpress.avency.de\/project\/near-_realtime-bei-twint\/"},"modified":"2026-02-25T10:35:46","modified_gmt":"2026-02-25T10:35:46","slug":"near-realtime-dwh","status":"publish","type":"project","link":"https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/","title":{"rendered":"Near-\/Realtime Data Warehouse"},"content":{"rendered":"<p>Parallel to the development of the new payment system, sumIT was commissioned to design and develop a completely new data warehouse. This DWH forms the base for the development of several data marts, regulatory reporting and operational interfaces.<\/p>\n<p><strong>Business Intelligence<\/strong><\/p>\n<p>Development of reporting with dashboard and reporting functionalities for tracking business activities from various perspectives, such as trending and alerting.<\/p>\n<p><strong>Customer Intelligence<\/strong><\/p>\n<p>Adaptation of financial services to customer needs by linking and evaluating information about previous use of services and deepening customer relationships.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Parallel to the development of the new payment system, sumIT was commissioned to design and develop a completely new data warehouse. This DWH forms the base for the development of several data marts, regulatory reporting and operational interfaces. Business Intelligence Development of reporting with dashboard and reporting functionalities for tracking business activities from various perspectives, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6673,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"project_category":[],"project_tag":[],"class_list":["post-6675","project","type-project","status-publish","has-post-thumbnail","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Near-\/Realtime Data Warehouse - sumIT<\/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:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Near-\/Realtime Data Warehouse - sumIT\" \/>\n<meta property=\"og:description\" content=\"Parallel to the development of the new payment system, sumIT was commissioned to design and develop a completely new data warehouse. This DWH forms the base for the development of several data marts, regulatory reporting and operational interfaces. Business Intelligence Development of reporting with dashboard and reporting functionalities for tracking business activities from various perspectives, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/\" \/>\n<meta property=\"og:site_name\" content=\"sumIT\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-25T10:35:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sumit.ch\/wp-content\/uploads\/2026\/02\/Near_Realtime.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1376\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\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 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/project\\\/near-realtime-dwh\\\/\",\"url\":\"https:\\\/\\\/sumit.ch\\\/en\\\/project\\\/near-realtime-dwh\\\/\",\"name\":\"Near-\\\/Realtime Data Warehouse - sumIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/project\\\/near-realtime-dwh\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/project\\\/near-realtime-dwh\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sumit.ch\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Near_Realtime.webp\",\"datePublished\":\"2026-02-01T09:38:36+00:00\",\"dateModified\":\"2026-02-25T10:35:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/project\\\/near-realtime-dwh\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sumit.ch\\\/en\\\/project\\\/near-realtime-dwh\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/project\\\/near-realtime-dwh\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sumit.ch\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Near_Realtime.webp\",\"contentUrl\":\"https:\\\/\\\/sumit.ch\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Near_Realtime.webp\",\"width\":1376,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/project\\\/near-realtime-dwh\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/sumit.ch\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Projects\",\"item\":\"https:\\\/\\\/sumit.ch\\\/en\\\/project\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Near-\\\/Realtime Data Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sumit.ch\\\/en\\\/\",\"name\":\"sumIT \u2013 get value from data\",\"description\":\"get value from data\",\"publisher\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sumit.ch\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#organization\",\"name\":\"sumIT \u2013 get value from data\",\"url\":\"https:\\\/\\\/sumit.ch\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sumit.ch\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/sumit_logo_RGB.svg\",\"contentUrl\":\"https:\\\/\\\/sumit.ch\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/sumit_logo_RGB.svg\",\"width\":198,\"height\":61,\"caption\":\"sumIT \u2013 get value from data\"},\"image\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Near-\/Realtime Data Warehouse - sumIT","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:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/","og_locale":"en_US","og_type":"article","og_title":"Near-\/Realtime Data Warehouse - sumIT","og_description":"Parallel to the development of the new payment system, sumIT was commissioned to design and develop a completely new data warehouse. This DWH forms the base for the development of several data marts, regulatory reporting and operational interfaces. Business Intelligence Development of reporting with dashboard and reporting functionalities for tracking business activities from various perspectives, [&hellip;]","og_url":"https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/","og_site_name":"sumIT","article_modified_time":"2026-02-25T10:35:46+00:00","og_image":[{"width":1376,"height":768,"url":"https:\/\/sumit.ch\/wp-content\/uploads\/2026\/02\/Near_Realtime.webp","type":"image\/webp"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/","url":"https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/","name":"Near-\/Realtime Data Warehouse - sumIT","isPartOf":{"@id":"https:\/\/sumit.ch\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/#primaryimage"},"image":{"@id":"https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/#primaryimage"},"thumbnailUrl":"https:\/\/sumit.ch\/wp-content\/uploads\/2026\/02\/Near_Realtime.webp","datePublished":"2026-02-01T09:38:36+00:00","dateModified":"2026-02-25T10:35:46+00:00","breadcrumb":{"@id":"https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/#primaryimage","url":"https:\/\/sumit.ch\/wp-content\/uploads\/2026\/02\/Near_Realtime.webp","contentUrl":"https:\/\/sumit.ch\/wp-content\/uploads\/2026\/02\/Near_Realtime.webp","width":1376,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/sumit.ch\/en\/project\/near-realtime-dwh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/sumit.ch\/en\/"},{"@type":"ListItem","position":2,"name":"Projects","item":"https:\/\/sumit.ch\/en\/project\/"},{"@type":"ListItem","position":3,"name":"Near-\/Realtime Data Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/sumit.ch\/en\/#website","url":"https:\/\/sumit.ch\/en\/","name":"sumIT \u2013 get value from data","description":"get value from data","publisher":{"@id":"https:\/\/sumit.ch\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sumit.ch\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/sumit.ch\/en\/#organization","name":"sumIT \u2013 get value from data","url":"https:\/\/sumit.ch\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sumit.ch\/en\/#\/schema\/logo\/image\/","url":"https:\/\/sumit.ch\/wp-content\/uploads\/2025\/10\/sumit_logo_RGB.svg","contentUrl":"https:\/\/sumit.ch\/wp-content\/uploads\/2025\/10\/sumit_logo_RGB.svg","width":198,"height":61,"caption":"sumIT \u2013 get value from data"},"image":{"@id":"https:\/\/sumit.ch\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/project\/6675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/project"}],"about":[{"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/types\/project"}],"author":[{"embeddable":true,"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/comments?post=6675"}],"version-history":[{"count":8,"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/project\/6675\/revisions"}],"predecessor-version":[{"id":6889,"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/project\/6675\/revisions\/6889"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/media\/6673"}],"wp:attachment":[{"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/media?parent=6675"}],"wp:term":[{"taxonomy":"project_category","embeddable":true,"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/project_category?post=6675"},{"taxonomy":"project_tag","embeddable":true,"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/project_tag?post=6675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}