{"id":494070,"date":"2024-06-05T12:07:38","date_gmt":"2024-06-05T10:07:38","guid":{"rendered":"https:\/\/www.devoteam.com\/success-story\/how-bambuser-optimized-their-bigquery-costs\/"},"modified":"2025-04-11T10:41:59","modified_gmt":"2025-04-11T08:41:59","slug":"how-bambuser-optimized-their-bigquery-costs","status":"publish","type":"success-story","link":"https:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/","title":{"rendered":"How Bambuser optimised their BigQuery costs"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Video commerce innovator Bambuser partnered with Devoteam G Cloud to streamline their BigQuery data warehouse costs and ensure scalable, cost-efficient growth. The collaboration yielded a remarkable 50-70% savings in BigQuery expenditure. Bambuser further benefited from expert Google Cloud cost optimization strategies and successful BI Engine implementation, positioning them for continued expansion.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-bambuser-a-video-commerce-pioneer\">Bambuser &#8211; a video commerce pioneer<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The company <a href=\"https:\/\/bambuser.com\/\">Bambuser<\/a> is a pioneer in the world of live video commerce. Their innovative platform helps brands and retailers connect with audiences in real-time, offering the streaming technology, the hosting app, the back-office, the data and the web applications necessary to go live. They are committed to pushing the boundaries of e-commerce by making videos both interactive and shoppable.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-challenge\">The Challenge<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As Bambuser&#8217;s influence grew, they needed to ensure their infrastructure scaled efficiently. Their in-house team possessed optimization skills but sought a partner to maximize the cost-efficiency of their BigQuery data warehouse. This is where Devoteam came into the picture.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-solution\">The Solution<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Our experts worked closely with Bambuser to gain a deeper understanding of their BigQuery usage and implement targeted cost-saving strategies. This partnership was about:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Analysing Usage:<\/strong> Identifying areas within BigQuery where efficiency could be improved and costs could be reduced.<\/li>\n\n\n\n<li><strong>Implementing Data Monitoring:<\/strong> Providing real-time insights into BigQuery usage with a customised Looker Studio dashboard.<\/li>\n\n\n\n<li><strong>Optimising Clustering and Partitioning:<\/strong> Enhancing query performance and reducing costs through refined data organisation techniques.<\/li>\n\n\n\n<li><strong>Deploying BI Engine:<\/strong> Strategically accelerating specific queries and lowering costs using Google Cloud&#8217;s BI Engine.<\/li>\n\n\n\n<li><strong>Exploring Further Optimizations:<\/strong> Investigating additional cost-saving opportunities across Bambuser&#8217;s Google Cloud infrastructure.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-results\">The Results<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The collaboration between Bambuser and Devoteam G Cloud was a resounding success resulting in:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Massive BigQuery<\/strong> <strong>Cost Reduction:<\/strong> Bambuser achieved a remarkable 50-70% decrease in BigQuery spending.<\/li>\n\n\n\n<li><strong>Scalability:<\/strong> The optimised BigQuery setup positions Bambuser to continue its impressive growth without unnecessary cost burdens.<\/li>\n\n\n\n<li><strong>Data-Driven Empowerment:<\/strong> Bambuser now has the tools and insights needed to make informed decisions about their cloud spending moving forward.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-in-short\">In Short<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bambuser wanted to streamline BigQuery costs to enable sustainable growth within their live video commerce operations. Devoteam G Cloud provided the expertise to reduce costs significantly, optimise their data organisation and empower the company with data-driven insights for the future.<\/p>\n\n\n\n\t<div class=\"align wp-block-acf-quote\">\n\n\t\n\t<figure class=\"text-center\"><blockquote class=\"blockquote\"><svg width=\"49\" height=\"38\" viewBox=\"0 0 49 38\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M42.875 0C44.4995 0 46.0574 0.652728 47.206 1.81459C48.3547 2.97645 49 4.55228 49 6.1954V15.4885C49 17.1316 48.3547 18.7075 47.206 19.8693C46.0574 21.0312 44.4995 21.6839 42.875 21.6839H33.6875C33.6875 24.1486 34.6555 26.5123 36.3785 28.2551C38.1014 29.9979 40.4383 30.977 42.875 30.977H45.9375C46.7497 30.977 47.5287 31.3034 48.103 31.8843C48.6773 32.4652 49 33.2532 49 34.0747C49 34.8963 48.6773 35.6842 48.103 36.2651C47.5287 36.8461 46.7497 37.1724 45.9375 37.1724H42.875C38.8139 37.1724 34.9191 35.5406 32.0474 32.6359C29.1758 29.7313 27.5625 25.7917 27.5625 21.6839V6.1954C27.5625 4.55228 28.2078 2.97645 29.3565 1.81459C30.5051 0.652728 32.063 0 33.6875 0H42.875ZM15.3125 0C16.937 0 18.4949 0.652728 19.6435 1.81459C20.7922 2.97645 21.4375 4.55228 21.4375 6.1954V15.4885C21.4375 17.1316 20.7922 18.7075 19.6435 19.8693C18.4949 21.0312 16.937 21.6839 15.3125 21.6839H6.125C6.125 24.1486 7.09296 26.5123 8.81596 28.2551C10.5389 29.9979 12.8758 30.977 15.3125 30.977H18.375C19.1872 30.977 19.9662 31.3034 20.5405 31.8843C21.1148 32.4652 21.4375 33.2532 21.4375 34.0747C21.4375 34.8963 21.1148 35.6842 20.5405 36.2651C19.9662 36.8461 19.1872 37.1724 18.375 37.1724H15.3125C11.2514 37.1724 7.35658 35.5406 4.48493 32.6359C1.61328 29.7313 0 25.7917 0 21.6839V6.1954C0 4.55228 0.645313 2.97645 1.79397 1.81459C2.94263 0.652728 4.50055 0 6.125 0H15.3125Z\" fill=\"#3C3C3A\"\/>\n<\/svg><p>Partnering with Devoteam G Cloud wasn&#8217;t just about reducing costs, it was about gaining a strategic ally who understands our business and our ambitions in the cloud.<\/p><\/blockquote><figcaption class=\"blockquote-footer\">\n<div class=\"wp-block-group is-nowrap is-layout-flex wp-container-core-group-is-layout-8d39b2df wp-block-group-is-layout-flex\">\n<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-6fa7971b wp-block-group-is-layout-flex\">\n\t<p class=\"has-medium-font-size wp-block-paragraph\" style=\"font-style:normal;font-weight:500\">Bambuser team manager<\/p>\n\t<\/div>\n<\/div>\n<\/figcaption><\/figure>\n\t\n\t<\/div>\n\n\n\n\n<div style=\"height:49px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Are you ready to optimise your cloud infrastructure? <\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-cover alignfull has-parallax\" style=\"margin-top:0;margin-bottom:0;padding-top:var(--wp--preset--spacing--xxx-large);padding-right:var(--wp--preset--spacing--large);padding-bottom:var(--wp--preset--spacing--xxx-large);padding-left:var(--wp--preset--spacing--large)\"><span aria-hidden=\"true\" class=\"wp-block-cover__background has-main-background-color has-background-dim-70 has-background-dim\"><\/span><div class=\"wp-block-cover__image-background wp-image-7229 has-parallax\" style=\"background-position:50% 50%;background-image:url(https:\/\/devoteam.info\/wp-content\/uploads\/2024\/05\/Surfer-001-copy.jpg)\"><\/div><div class=\"wp-block-cover__inner-container has-global-padding is-layout-constrained wp-container-core-cover-is-layout-ea3f966a wp-block-cover-is-layout-constrained\">\n<div class=\"wp-block-columns alignwide is-layout-flex wp-container-core-columns-is-layout-d064aeaa wp-block-columns-is-layout-flex\" style=\"border-style:none;border-width:0px\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:30%\">\n<h2 class=\"wp-block-heading\" id=\"h-your-success-starts-here\"><strong>Your Success Starts Here<\/strong><\/h2>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"border-left-color:var(--wp--preset--color--base);border-left-style:solid;border-left-width:2px;padding-right:var(--wp--preset--spacing--small);padding-left:var(--wp--preset--spacing--x-large);flex-basis:70%\">\n<div class=\"wp-block-group is-style-default has-global-padding is-layout-constrained wp-container-core-group-is-layout-9819b1f7 wp-block-group-is-layout-constrained\" style=\"padding-right:var(--wp--preset--spacing--x-small)\">\n<p class=\"has-medium-font-size wp-block-paragraph\">Partner with Devoteam to leverage award-winning tech expertise, agile execution, and a culture of continuous learning.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-fill\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/devoteam.info\/get-in-touch\/\">Get in touch<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Video commerce innovator Bambuser partnered with Devoteam G Cloud to streamline their BigQuery data warehouse costs and ensure scalable, cost-efficient growth. The collaboration yielded a remarkable 50-70% savings in BigQuery expenditure. Bambuser further benefited from expert Google Cloud cost optimization strategies and successful BI Engine implementation, positioning them for continued expansion. Bambuser &#8211; a video [&hellip;]<\/p>\n","protected":false},"featured_media":0,"template":"","categories":[2604],"tags":[2748,2637,2796],"industry":[],"class_list":["post-494070","success-story","type-success-story","status-publish","hentry","category-google-cloud-sk","tag-bigquery-sk","tag-g-cloud-sk","tag-google-cloud-platform-sk"],"acf":[],"cards":"\n\t<div class=\"single-post-card\">\n\n\t\t\n\n\t\t\n\t\t<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-43282307 wp-block-group-is-layout-flex\">\n\t<p style=\"font-style:normal;font-weight:700\" class=\"has-link-color wp-elements-1 wp-block-lp-post-type has-text-color has-primary-color has-small-font-size\">Success story<\/p>\n\n\t\t\n\t\t<h3 style=\"font-style:normal;font-weight:400\" class=\"wp-block-post-title has-base-font-size\"><a href=\"https:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/\" target=\"_self\" >How Bambuser optimised their BigQuery costs<\/a><\/h3><\/div>\n\t\t\n\t<\/div>\n\n","yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>BigQuery costs optimization | Bambuser | Devoteam<\/title>\n<meta name=\"description\" content=\"Discover how Bambuser enable sustainable growth within their live video commerce operations with BigQuery costs optimization.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Bambuser optimised their BigQuery costs\" \/>\n<meta property=\"og:description\" content=\"Discover how Bambuser enable sustainable growth within their live video commerce operations with BigQuery costs optimization.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/\" \/>\n<meta property=\"og:site_name\" content=\"Devoteam\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-11T08:41:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-costs-reduction-article.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1296\" \/>\n\t<meta property=\"og:image:height\" content=\"864\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/how-bambuser-optimized-their-bigquery-costs\\\/\",\"url\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/how-bambuser-optimized-their-bigquery-costs\\\/\",\"name\":\"BigQuery costs optimization | Bambuser | Devoteam\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/#website\"},\"datePublished\":\"2024-06-05T10:07:38+00:00\",\"dateModified\":\"2025-04-11T08:41:59+00:00\",\"description\":\"Discover how Bambuser enable sustainable growth within their live video commerce operations with BigQuery costs optimization.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/how-bambuser-optimized-their-bigquery-costs\\\/#breadcrumb\"},\"inLanguage\":\"en-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/how-bambuser-optimized-their-bigquery-costs\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/how-bambuser-optimized-their-bigquery-costs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Success stories\",\"item\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How Bambuser optimised their BigQuery costs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/#website\",\"url\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/\",\"name\":\"Devoteam\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-SK\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"BigQuery costs optimization | Bambuser | Devoteam","description":"Discover how Bambuser enable sustainable growth within their live video commerce operations with BigQuery costs optimization.","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:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/","og_locale":"en_US","og_type":"article","og_title":"How Bambuser optimised their BigQuery costs","og_description":"Discover how Bambuser enable sustainable growth within their live video commerce operations with BigQuery costs optimization.","og_url":"https:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/","og_site_name":"Devoteam","article_modified_time":"2025-04-11T08:41:59+00:00","og_image":[{"width":1296,"height":864,"url":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-costs-reduction-article.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/","url":"https:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/","name":"BigQuery costs optimization | Bambuser | Devoteam","isPartOf":{"@id":"https:\/\/devoteam.info\/sk\/#website"},"datePublished":"2024-06-05T10:07:38+00:00","dateModified":"2025-04-11T08:41:59+00:00","description":"Discover how Bambuser enable sustainable growth within their live video commerce operations with BigQuery costs optimization.","breadcrumb":{"@id":"https:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/#breadcrumb"},"inLanguage":"en-SK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/devoteam.info\/sk\/success-story\/how-bambuser-optimized-their-bigquery-costs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devoteam.info\/sk\/"},{"@type":"ListItem","position":2,"name":"Success stories","item":"https:\/\/devoteam.info\/sk\/success-story\/"},{"@type":"ListItem","position":3,"name":"How Bambuser optimised their BigQuery costs"}]},{"@type":"WebSite","@id":"https:\/\/devoteam.info\/sk\/#website","url":"https:\/\/devoteam.info\/sk\/","name":"Devoteam","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devoteam.info\/sk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-SK"}]}},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"jelena.saveljic","author_link":"https:\/\/devoteam.info\/sk\/author\/"},"uagb_comment_info":0,"uagb_excerpt":"Video commerce innovator Bambuser partnered with Devoteam G Cloud to streamline their BigQuery data warehouse costs and ensure scalable, cost-efficient growth. The collaboration yielded a remarkable 50-70% savings in BigQuery expenditure. Bambuser further benefited from expert Google Cloud cost optimization strategies and successful BI Engine implementation, positioning them for continued expansion. Bambuser &#8211; a video&hellip;","_links":{"self":[{"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/success-story\/494070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/success-story"}],"about":[{"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/types\/success-story"}],"version-history":[{"count":0,"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/success-story\/494070\/revisions"}],"wp:attachment":[{"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/media?parent=494070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/categories?post=494070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/tags?post=494070"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/industry?post=494070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}