{"id":28438,"date":"2022-11-25T12:43:55","date_gmt":"2022-11-25T07:13:55","guid":{"rendered":"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing\/"},"modified":"2023-03-14T15:36:21","modified_gmt":"2023-03-14T10:06:21","slug":"leading-mobile-marketing-platform-redshift-performance-testing","status":"publish","type":"case_study","link":"https:\/\/blazeclan.com\/anz\/studies\/leading-mobile-marketing-platform-redshift-performance-testing\/","title":{"rendered":"Leading Mobile Marketing Platform-Redshift &#038; Performance Testing"},"content":{"rendered":"<p><em>BlazeClan helped the customer with creating ETL steps for Redshift and testing the performance.<\/em><\/p>\n<h4>Business Description<\/h4>\n<p>The company is a leading mobile marketing platform augmenting each mobile internet user\u2019s profile; creating user persona\u2019s and identifying intent signals. With this data, they help in delivering relevant offerings to every mobile internet user; enabling marketers, app developers, telecom operators and data providers to derive sharper results.<\/p>\n<h4>Business Requirements &amp; Key Challenges<\/h4>\n<p>This company was using HP Vertica Data Warehouse solutions for their requirements. They were facing performance issues in analyzing the data.<\/p>\n<p>The Customer wanted BlazeClan to:<\/p>\n<ul>\n<li>Identify the Data from the current environment to be loaded<\/li>\n<li>Load large production data set to Redshift<\/li>\n<li>Optimize the query performance<\/li>\n<li>Test Redshift Performance with HP Vertica Performance<\/li>\n<\/ul>\n<h4>Business Solution<\/h4>\n<p>The Data Warehouse Solution will be shifted to Amazon Redshift. With this-<\/p>\n<ul>\n<li>The performance of redshift was checked using reporting tools like Jaspersoft\/Tableau.<\/li>\n<li>Optimizing the performance of any three reports including RIMS and CAD and dynamic report. Ad-hoc reporting and historical reporting.<\/li>\n<li>Historical Data Population<\/li>\n<\/ul>\n<h4>Benefits<\/h4>\n<p>BlazeClan helped the corporation with the following features:<\/p>\n<ul>\n<li>Design for Warehouse and Development<\/li>\n<li>Design for Application and Development<\/li>\n<li>ETL process Design and Development<\/li>\n<li>Data Validation and Testing<\/li>\n<\/ul>\n<p>BlazeClan\u2019s solution offered high-performance processing of data to derive intelligence from the interactions and transform it into actionable smart data.<\/p>\n<h4>Technology Overview<\/h4>\n<ul>\n<li>Amazon Redshift<\/li>\n<li>ETL<\/li>\n<li>JasperSoft<\/li>\n<li>Tableau<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>BlazeClan helped the customer with creating ETL steps for Redshift and testing the performance. Business Description The company is a leading mobile marketing platform augmenting each mobile internet user\u2019s profile; creating user persona\u2019s and identifying intent signals. With this data, they help in delivering relevant offerings to every mobile internet user; enabling marketers, app developers, [&hellip;]<\/p>\n","protected":false},"featured_media":11431,"parent":0,"menu_order":0,"template":"","case_category":[3876,3896],"case_tags":[],"class_list":["post-28438","case_study","type-case_study","status-publish","has-post-thumbnail","hentry","case_category-big-data-analytics-anz","case_category-cloudscale-anz"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Redshift &amp; Performance Testing Implementation by Blazeclan<\/title>\n<meta name=\"description\" content=\"Redshift &amp; Performance Testing Implementation by Blazeclan, read this case study\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blazeclan.com\/anz\/studies\/leading-mobile-marketing-platform-redshift-performance-testing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Redshift &amp; Performance Testing Implementation by Blazeclan\" \/>\n<meta property=\"og:description\" content=\"Redshift &amp; Performance Testing Implementation by Blazeclan, read this case study\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing\" \/>\n<meta property=\"og:site_name\" content=\"Blazeclan\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/blazeclan.hq\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-14T10:06:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blazeclan.com\/wp-content\/uploads\/2019\/04\/analysis-brainstorming-chart-1571699-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@blazeclan_hq\" \/>\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:\/\/blazeclan.com\/anz\/studies\/leading-mobile-marketing-platform-redshift-performance-testing\/\",\"url\":\"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing\",\"name\":\"Redshift & Performance Testing Implementation by Blazeclan\",\"isPartOf\":{\"@id\":\"https:\/\/blazeclan.com\/anz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2019\/04\/analysis-brainstorming-chart-1571699-1.jpg\",\"datePublished\":\"2022-11-25T07:13:55+00:00\",\"dateModified\":\"2023-03-14T10:06:21+00:00\",\"description\":\"Redshift & Performance Testing Implementation by Blazeclan, read this case study\",\"breadcrumb\":{\"@id\":\"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing#primaryimage\",\"url\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2019\/04\/analysis-brainstorming-chart-1571699-1.jpg\",\"contentUrl\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2019\/04\/analysis-brainstorming-chart-1571699-1.jpg\",\"width\":2000,\"height\":900},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blazeclan.com\/anz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Case Study\",\"item\":\"https:\/\/blazeclan.com\/anz\/case-studies\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Leading Mobile Marketing Platform-Redshift &#038; Performance Testing\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blazeclan.com\/anz\/#website\",\"url\":\"https:\/\/blazeclan.com\/anz\/\",\"name\":\"Blazeclan\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/blazeclan.com\/anz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blazeclan.com\/anz\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blazeclan.com\/anz\/#organization\",\"name\":\"Blazeclan\",\"url\":\"https:\/\/blazeclan.com\/anz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/blazeclan.com\/anz\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2024\/10\/ITCI-Blazeclan_logo.svg\",\"contentUrl\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2024\/10\/ITCI-Blazeclan_logo.svg\",\"caption\":\"Blazeclan\"},\"image\":{\"@id\":\"https:\/\/blazeclan.com\/anz\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/blazeclan.hq\/\",\"https:\/\/x.com\/blazeclan_hq\",\"https:\/\/www.instagram.com\/blazeclantechnologies\/\",\"https:\/\/www.linkedin.com\/company\/blazeclan-technologies\/\",\"https:\/\/www.youtube.com\/channel\/UCCKF4Lcbtus-pUoZr7Lxrow\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Redshift & Performance Testing Implementation by Blazeclan","description":"Redshift & Performance Testing Implementation by Blazeclan, read this case study","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:\/\/blazeclan.com\/anz\/studies\/leading-mobile-marketing-platform-redshift-performance-testing\/","og_locale":"en_US","og_type":"article","og_title":"Redshift & Performance Testing Implementation by Blazeclan","og_description":"Redshift & Performance Testing Implementation by Blazeclan, read this case study","og_url":"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing","og_site_name":"Blazeclan","article_publisher":"https:\/\/www.facebook.com\/blazeclan.hq\/","article_modified_time":"2023-03-14T10:06:21+00:00","og_image":[{"width":2000,"height":900,"url":"https:\/\/blazeclan.com\/wp-content\/uploads\/2019\/04\/analysis-brainstorming-chart-1571699-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@blazeclan_hq","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blazeclan.com\/anz\/studies\/leading-mobile-marketing-platform-redshift-performance-testing\/","url":"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing","name":"Redshift & Performance Testing Implementation by Blazeclan","isPartOf":{"@id":"https:\/\/blazeclan.com\/anz\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing#primaryimage"},"image":{"@id":"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing#primaryimage"},"thumbnailUrl":"https:\/\/blazeclan.com\/wp-content\/uploads\/2019\/04\/analysis-brainstorming-chart-1571699-1.jpg","datePublished":"2022-11-25T07:13:55+00:00","dateModified":"2023-03-14T10:06:21+00:00","description":"Redshift & Performance Testing Implementation by Blazeclan, read this case study","breadcrumb":{"@id":"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing#primaryimage","url":"https:\/\/blazeclan.com\/wp-content\/uploads\/2019\/04\/analysis-brainstorming-chart-1571699-1.jpg","contentUrl":"https:\/\/blazeclan.com\/wp-content\/uploads\/2019\/04\/analysis-brainstorming-chart-1571699-1.jpg","width":2000,"height":900},{"@type":"BreadcrumbList","@id":"https:\/\/blazeclan.com\/studies\/leading-mobile-marketing-platform-redshift-performance-testing#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blazeclan.com\/anz\/"},{"@type":"ListItem","position":2,"name":"Case Study","item":"https:\/\/blazeclan.com\/anz\/case-studies\/"},{"@type":"ListItem","position":3,"name":"Leading Mobile Marketing Platform-Redshift &#038; Performance Testing"}]},{"@type":"WebSite","@id":"https:\/\/blazeclan.com\/anz\/#website","url":"https:\/\/blazeclan.com\/anz\/","name":"Blazeclan","description":"","publisher":{"@id":"https:\/\/blazeclan.com\/anz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blazeclan.com\/anz\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/blazeclan.com\/anz\/#organization","name":"Blazeclan","url":"https:\/\/blazeclan.com\/anz\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/blazeclan.com\/anz\/#\/schema\/logo\/image\/","url":"https:\/\/blazeclan.com\/wp-content\/uploads\/2024\/10\/ITCI-Blazeclan_logo.svg","contentUrl":"https:\/\/blazeclan.com\/wp-content\/uploads\/2024\/10\/ITCI-Blazeclan_logo.svg","caption":"Blazeclan"},"image":{"@id":"https:\/\/blazeclan.com\/anz\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/blazeclan.hq\/","https:\/\/x.com\/blazeclan_hq","https:\/\/www.instagram.com\/blazeclantechnologies\/","https:\/\/www.linkedin.com\/company\/blazeclan-technologies\/","https:\/\/www.youtube.com\/channel\/UCCKF4Lcbtus-pUoZr7Lxrow"]}]}},"_links":{"self":[{"href":"https:\/\/blazeclan.com\/anz\/wp-json\/wp\/v2\/case_study\/28438","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blazeclan.com\/anz\/wp-json\/wp\/v2\/case_study"}],"about":[{"href":"https:\/\/blazeclan.com\/anz\/wp-json\/wp\/v2\/types\/case_study"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blazeclan.com\/anz\/wp-json\/wp\/v2\/media\/11431"}],"wp:attachment":[{"href":"https:\/\/blazeclan.com\/anz\/wp-json\/wp\/v2\/media?parent=28438"}],"wp:term":[{"taxonomy":"case_category","embeddable":true,"href":"https:\/\/blazeclan.com\/anz\/wp-json\/wp\/v2\/case_category?post=28438"},{"taxonomy":"case_tags","embeddable":true,"href":"https:\/\/blazeclan.com\/anz\/wp-json\/wp\/v2\/case_tags?post=28438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}