{"id":7992,"date":"2026-04-09T10:30:37","date_gmt":"2026-04-09T10:30:37","guid":{"rendered":"https:\/\/qral.com\/staging\/6311\/?post_type=case-study&#038;p=7992"},"modified":"2026-08-07T14:45:41","modified_gmt":"2026-08-07T14:45:41","slug":"data-lake-redesign","status":"publish","type":"case-study","link":"https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/","title":{"rendered":"Data lake design"},"content":{"rendered":"<p>How we designed a specialty pharmaceutical company&#8217;s commercial data infrastructure in eight weeks and implemented an automated reporting workflow.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How we designed a specialty pharmaceutical company&#8217;s commercial data infrastructure in eight weeks and implemented an automated reporting workflow.<\/p>\n","protected":false},"author":3,"featured_media":8441,"template":"","categories":[31],"tags":[29],"class_list":["post-7992","case-study","type-case-study","status-publish","has-post-thumbnail","hentry","category-data-lake-design","tag-information-management"],"acf":{"photo_gallery":{"gallery_images":[[{"id":8121,"title":"20260625 fixed data diagram_3542px","caption":"","full_image_url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-scaled.png","thumbnail_image_url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-150x150.png","large_srcset":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-1024x404.png 1024w, https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-300x118.png 300w, https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-768x303.png 768w, https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-1536x607.png 1536w, https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-2048x809.png 2048w","medium_srcset":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-300x118.png 300w, https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-1024x404.png 1024w, https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-768x303.png 768w, https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-1536x607.png 1536w, https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-2048x809.png 2048w","media_details":{"width":2560,"height":1011,"sizes":{"medium":{"file":"20260625-fixed-data-diagram_3542px-300x118.png","width":300,"height":118,"mime-type":"image\/png","filesize":24130,"source_url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-300x118.png"},"large":{"file":"20260625-fixed-data-diagram_3542px-1024x404.png","width":1024,"height":404,"mime-type":"image\/png","filesize":143359,"source_url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-1024x404.png"},"thumbnail":{"file":"20260625-fixed-data-diagram_3542px-150x150.png","width":150,"height":150,"mime-type":"image\/png","filesize":13796,"source_url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-150x150.png"},"medium_large":{"file":"20260625-fixed-data-diagram_3542px-768x303.png","width":768,"height":303,"mime-type":"image\/png","filesize":92190,"source_url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-768x303.png"},"1536x1536":{"file":"20260625-fixed-data-diagram_3542px-1536x607.png","width":1536,"height":607,"mime-type":"image\/png","filesize":282708,"source_url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-1536x607.png"},"2048x2048":{"file":"20260625-fixed-data-diagram_3542px-2048x809.png","width":2048,"height":809,"mime-type":"image\/png","filesize":461917,"source_url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/06\/20260625-fixed-data-diagram_3542px-2048x809.png"}}},"alt_text":"","url":"","target":""}]]}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data lake design : Qral Group<\/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:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data lake design : Qral Group\" \/>\n<meta property=\"og:description\" content=\"How we designed a specialty pharmaceutical company&#8217;s commercial data infrastructure in eight weeks and implemented an automated reporting workflow.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/\" \/>\n<meta property=\"og:site_name\" content=\"Qral Group\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-07T14:45:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/04\/20260720_qral_webiste_case_study_icons_3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"703\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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:\\\/\\\/qral.com\\\/staging\\\/6311\\\/case-study\\\/data-lake-redesign\\\/\",\"url\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/case-study\\\/data-lake-redesign\\\/\",\"name\":\"Data lake design : Qral Group\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/qral.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/case-study\\\/data-lake-redesign\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/case-study\\\/data-lake-redesign\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/20260720_qral_webiste_case_study_icons_3.jpg\",\"datePublished\":\"2026-04-09T10:30:37+00:00\",\"dateModified\":\"2026-08-07T14:45:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/case-study\\\/data-lake-redesign\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/case-study\\\/data-lake-redesign\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/case-study\\\/data-lake-redesign\\\/#primaryimage\",\"url\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/20260720_qral_webiste_case_study_icons_3.jpg\",\"contentUrl\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/20260720_qral_webiste_case_study_icons_3.jpg\",\"width\":1000,\"height\":703},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/case-study\\\/data-lake-redesign\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/qral.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data lake design\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/qral.com\\\/#website\",\"url\":\"https:\\\/\\\/qral.com\\\/\",\"name\":\"Qral Group\",\"description\":\"Together we advance\",\"publisher\":{\"@id\":\"https:\\\/\\\/qral.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/qral.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/qral.com\\\/#organization\",\"name\":\"Qral Group\",\"url\":\"https:\\\/\\\/qral.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/qral.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/favicon.png\",\"contentUrl\":\"https:\\\/\\\/qral.com\\\/staging\\\/6311\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/favicon.png\",\"width\":64,\"height\":64,\"caption\":\"Qral Group\"},\"image\":{\"@id\":\"https:\\\/\\\/qral.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/qral-group\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data lake design : Qral Group","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:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/","og_locale":"en_US","og_type":"article","og_title":"Data lake design : Qral Group","og_description":"How we designed a specialty pharmaceutical company&#8217;s commercial data infrastructure in eight weeks and implemented an automated reporting workflow.","og_url":"https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/","og_site_name":"Qral Group","article_modified_time":"2026-08-07T14:45:41+00:00","og_image":[{"width":1000,"height":703,"url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/04\/20260720_qral_webiste_case_study_icons_3.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/","url":"https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/","name":"Data lake design : Qral Group","isPartOf":{"@id":"https:\/\/qral.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/#primaryimage"},"image":{"@id":"https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/#primaryimage"},"thumbnailUrl":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/04\/20260720_qral_webiste_case_study_icons_3.jpg","datePublished":"2026-04-09T10:30:37+00:00","dateModified":"2026-08-07T14:45:41+00:00","breadcrumb":{"@id":"https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/#primaryimage","url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/04\/20260720_qral_webiste_case_study_icons_3.jpg","contentUrl":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2026\/04\/20260720_qral_webiste_case_study_icons_3.jpg","width":1000,"height":703},{"@type":"BreadcrumbList","@id":"https:\/\/qral.com\/staging\/6311\/case-study\/data-lake-redesign\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/qral.com\/"},{"@type":"ListItem","position":2,"name":"Data lake design"}]},{"@type":"WebSite","@id":"https:\/\/qral.com\/#website","url":"https:\/\/qral.com\/","name":"Qral Group","description":"Together we advance","publisher":{"@id":"https:\/\/qral.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/qral.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/qral.com\/#organization","name":"Qral Group","url":"https:\/\/qral.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/qral.com\/#\/schema\/logo\/image\/","url":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/qral.com\/staging\/6311\/wp-content\/uploads\/2024\/03\/favicon.png","width":64,"height":64,"caption":"Qral Group"},"image":{"@id":"https:\/\/qral.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/qral-group"]}]}},"_links":{"self":[{"href":"https:\/\/qral.com\/staging\/6311\/wp-json\/wp\/v2\/case-study\/7992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qral.com\/staging\/6311\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/qral.com\/staging\/6311\/wp-json\/wp\/v2\/types\/case-study"}],"author":[{"embeddable":true,"href":"https:\/\/qral.com\/staging\/6311\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":7,"href":"https:\/\/qral.com\/staging\/6311\/wp-json\/wp\/v2\/case-study\/7992\/revisions"}],"predecessor-version":[{"id":8657,"href":"https:\/\/qral.com\/staging\/6311\/wp-json\/wp\/v2\/case-study\/7992\/revisions\/8657"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qral.com\/staging\/6311\/wp-json\/wp\/v2\/media\/8441"}],"wp:attachment":[{"href":"https:\/\/qral.com\/staging\/6311\/wp-json\/wp\/v2\/media?parent=7992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qral.com\/staging\/6311\/wp-json\/wp\/v2\/categories?post=7992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qral.com\/staging\/6311\/wp-json\/wp\/v2\/tags?post=7992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}