{"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":""}]]}},"_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}]}}