{"id":1044201,"date":"2021-05-20T00:00:00","date_gmt":"2021-05-20T00:00:00","guid":{"rendered":"https:\/\/www.beyondsoft.com\/sg\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/"},"modified":"2021-05-20T00:00:00","modified_gmt":"2021-05-20T00:00:00","slug":"networking-hardware-giant-accelerates-power-bi-performance-by-18x","status":"publish","type":"customer-story","link":"https:\/\/www.beyondsoft.com\/jp\/en\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/","title":{"rendered":"Networking hardware giant accelerates Power BI Performance by 18X"},"content":{"rendered":"<p><strong>THE CHALLENGE<\/strong><\/p>\n\n<p>During the COVID-19 pandemic, our client needed to conduct a complex Power BI analysis of office building usage by its worldwide workforce to determine which buildings\/locations should be closed and the financial impact of those closures. The analysis needed to include data on the operational costs and building usage, as well as the criticality of various job types and real-time worldwide COVID-19 trends and hot spots.<\/p>\n\n<p>Unfortunately, the reports developed in-house were very inefficient and took a long time to render, causing serious stability problems. They needed a better solution.<\/p>\n\n<p><strong>THE SOLUTION<\/strong><\/p>\n\n<p>The client connected with Beyondsoft through the <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/partners\/\">Microsoft Power BI partner program<\/a>. Beyondsoft\u2019s Power BI experts determined that the complexity of the calculations, sheer volume of data, and the inefficient data model all contributed to performance bottlenecks. The prolonged time needed to render all the visuals made the in-house developed reports unstable.<\/p>\n\n<p>To resolve these issues, Beyondsoft leveraged Microsoft Power BI, Oracle Server, Smartsheet, Excel, and R Scripting to optimize coding and data and eliminate the bottlenecks. The most impactful optimizations included:<\/p>\n\n<ul class=\"wp-block-list\">\n<li>Reducing data load size by millions of rows to improve data refresh and data transformation times.<\/li>\n<\/ul>\n\n<ul class=\"wp-block-list\">\n<li>Tuning Oracle SQL code to improve and filter unneeded data elements.<\/li>\n<\/ul>\n\n<ul class=\"wp-block-list\">\n<li>Updating the data model to create a reduced memory-footprint of the analytics engine.<\/li>\n<\/ul>\n\n<ul class=\"wp-block-list\">\n<li>Creating and updating data relationships to allow enhancement of additional metrics and KPIs.<\/li>\n<\/ul>\n\n<ul class=\"wp-block-list\">\n<li>Rewriting calculation code to decrease complexity.<\/li>\n<\/ul>\n\n<ul class=\"wp-block-list\">\n<li>Completing a query plan optimization analysis to find and resolve query inefficiencies.<\/li>\n<\/ul>\n\n<p>\u00a0<\/p>\n\n<p><strong>THE RESULTS<\/strong><\/p>\n\n<p>The series of Power BI optimizations significantly reduced the rendering time, down from six minutes to just 20 seconds for each report. The client was delighted with the 18X increase in efficiency. The vast improvement allowed the client to reliably make proactive decisions to address business continuity, risk mitigation, and cost reduction in response to the changes brought by the COVID-19 pandemic.<\/p>\n\n<p><a href=\"\/jp\/en\/contact-us\/\">Contact us today<\/a> to discover how we can help you <a href=\"\/jp\/en\/technology-partner-overview-microsoft\/\" data-wplink-edit=\"true\">power data-driven business decisions<\/a>.<\/p>\n\t\t\n\t\t\t<a href=\"http:\/\/www.beyondsoft.com\/wp-content\/uploads\/2021\/05\/Networking-hardware-giant-accelerates-Power-BI-Performance-by-18X.pdf\" role=\"button\">\n\t\t\t\t\t\tDownload Case Study\n\t\t\t\t\t<\/a>","protected":false},"excerpt":{"rendered":"<p>Our client is a global leader in IT, networking, and cyber security products and solutions, with offices across the world.<\/p>","protected":false},"featured_media":1044119,"template":"","meta":{"_links_to":"","_links_to_target":""},"service-category":[9],"industry-category":[43],"external-author":[],"class_list":["post-1044201","customer-story","type-customer-story","status-publish","has-post-thumbnail","hentry","service-category-data-and-ai-modernization","industry-category-high-tech"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Networking hardware giant accelerates Power BI Performance by 18X - IT Solutions Company Japan | Beyondsoft<\/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:\/\/www.beyondsoft.com\/jp\/en\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Networking hardware giant accelerates Power BI Performance by 18X - IT Solutions Company Japan | Beyondsoft\" \/>\n<meta property=\"og:description\" content=\"Our client is a global leader in IT, networking, and cyber security products and solutions, with offices across the world.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.beyondsoft.com\/jp\/en\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/\" \/>\n<meta property=\"og:site_name\" content=\"IT Solutions Company Japan | Beyondsoft\" \/>\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:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/\",\"url\":\"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/\",\"name\":\"Networking hardware giant accelerates Power BI Performance by 18X - IT Solutions Company Japan | Beyondsoft\",\"isPartOf\":{\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.beyondsoft.com\/jp\/wp-content\/uploads\/sites\/4\/2023\/12\/iStock-613537246-1.jpg\",\"datePublished\":\"2021-05-20T00:00:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/#primaryimage\",\"url\":\"https:\/\/www.beyondsoft.com\/jp\/wp-content\/uploads\/sites\/4\/2023\/12\/iStock-613537246-1.jpg\",\"contentUrl\":\"https:\/\/www.beyondsoft.com\/jp\/wp-content\/uploads\/sites\/4\/2023\/12\/iStock-613537246-1.jpg\",\"width\":724,\"height\":483},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.beyondsoft.com\/jp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Customer Stories\",\"item\":\"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Networking hardware giant accelerates Power BI Performance by 18X\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/#website\",\"url\":\"https:\/\/www.beyondsoft.com\/jp\/\",\"name\":\"IT Solutions Company Japan | Beyondsoft\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.beyondsoft.com\/jp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/#organization\",\"name\":\"IT Solutions Company Japan | Beyondsoft\",\"url\":\"https:\/\/www.beyondsoft.com\/jp\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.beyondsoft.com\/jp\/wp-content\/uploads\/sites\/4\/2023\/12\/logo-1.webp\",\"contentUrl\":\"https:\/\/www.beyondsoft.com\/jp\/wp-content\/uploads\/sites\/4\/2023\/12\/logo-1.webp\",\"width\":251,\"height\":66,\"caption\":\"IT Solutions Company Japan | Beyondsoft\"},\"image\":{\"@id\":\"https:\/\/www.beyondsoft.com\/jp\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Networking hardware giant accelerates Power BI Performance by 18X - IT Solutions Company Japan | Beyondsoft","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:\/\/www.beyondsoft.com\/jp\/en\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/","og_locale":"en_US","og_type":"article","og_title":"Networking hardware giant accelerates Power BI Performance by 18X - IT Solutions Company Japan | Beyondsoft","og_description":"Our client is a global leader in IT, networking, and cyber security products and solutions, with offices across the world.","og_url":"https:\/\/www.beyondsoft.com\/jp\/en\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/","og_site_name":"IT Solutions Company Japan | Beyondsoft","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/","url":"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/","name":"Networking hardware giant accelerates Power BI Performance by 18X - IT Solutions Company Japan | Beyondsoft","isPartOf":{"@id":"https:\/\/www.beyondsoft.com\/jp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/#primaryimage"},"image":{"@id":"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/#primaryimage"},"thumbnailUrl":"https:\/\/www.beyondsoft.com\/jp\/wp-content\/uploads\/sites\/4\/2023\/12\/iStock-613537246-1.jpg","datePublished":"2021-05-20T00:00:00+00:00","breadcrumb":{"@id":"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/#primaryimage","url":"https:\/\/www.beyondsoft.com\/jp\/wp-content\/uploads\/sites\/4\/2023\/12\/iStock-613537246-1.jpg","contentUrl":"https:\/\/www.beyondsoft.com\/jp\/wp-content\/uploads\/sites\/4\/2023\/12\/iStock-613537246-1.jpg","width":724,"height":483},{"@type":"BreadcrumbList","@id":"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/networking-hardware-giant-accelerates-power-bi-performance-by-18x\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.beyondsoft.com\/jp\/"},{"@type":"ListItem","position":2,"name":"Customer Stories","item":"https:\/\/www.beyondsoft.com\/jp\/customer-stories\/"},{"@type":"ListItem","position":3,"name":"Networking hardware giant accelerates Power BI Performance by 18X"}]},{"@type":"WebSite","@id":"https:\/\/www.beyondsoft.com\/jp\/#website","url":"https:\/\/www.beyondsoft.com\/jp\/","name":"IT Solutions Company Japan | Beyondsoft","description":"","publisher":{"@id":"https:\/\/www.beyondsoft.com\/jp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.beyondsoft.com\/jp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.beyondsoft.com\/jp\/#organization","name":"IT Solutions Company Japan | Beyondsoft","url":"https:\/\/www.beyondsoft.com\/jp\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.beyondsoft.com\/jp\/#\/schema\/logo\/image\/","url":"https:\/\/www.beyondsoft.com\/jp\/wp-content\/uploads\/sites\/4\/2023\/12\/logo-1.webp","contentUrl":"https:\/\/www.beyondsoft.com\/jp\/wp-content\/uploads\/sites\/4\/2023\/12\/logo-1.webp","width":251,"height":66,"caption":"IT Solutions Company Japan | Beyondsoft"},"image":{"@id":"https:\/\/www.beyondsoft.com\/jp\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.beyondsoft.com\/jp\/en\/wp-json\/wp\/v2\/customer-story\/1044201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beyondsoft.com\/jp\/en\/wp-json\/wp\/v2\/customer-story"}],"about":[{"href":"https:\/\/www.beyondsoft.com\/jp\/en\/wp-json\/wp\/v2\/types\/customer-story"}],"version-history":[{"count":0,"href":"https:\/\/www.beyondsoft.com\/jp\/en\/wp-json\/wp\/v2\/customer-story\/1044201\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.beyondsoft.com\/jp\/en\/wp-json\/wp\/v2\/media\/1044119"}],"wp:attachment":[{"href":"https:\/\/www.beyondsoft.com\/jp\/en\/wp-json\/wp\/v2\/media?parent=1044201"}],"wp:term":[{"taxonomy":"service-category","embeddable":true,"href":"https:\/\/www.beyondsoft.com\/jp\/en\/wp-json\/wp\/v2\/service-category?post=1044201"},{"taxonomy":"industry-category","embeddable":true,"href":"https:\/\/www.beyondsoft.com\/jp\/en\/wp-json\/wp\/v2\/industry-category?post=1044201"},{"taxonomy":"external-author","embeddable":true,"href":"https:\/\/www.beyondsoft.com\/jp\/en\/wp-json\/wp\/v2\/external-author?post=1044201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}