Networking hardware giant accelerates Power BI Performance by 18X

THE CHALLENGE

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.

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.

THE SOLUTION

The client connected with Beyondsoft through the Microsoft Power BI partner program. Beyondsoft’s 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.

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:

  • Reducing data load size by millions of rows to improve data refresh and data transformation times.
  • Tuning Oracle SQL code to improve and filter unneeded data elements.
  • Updating the data model to create a reduced memory-footprint of the analytics engine.
  • Creating and updating data relationships to allow enhancement of additional metrics and KPIs.
  • Rewriting calculation code to decrease complexity.
  • Completing a query plan optimization analysis to find and resolve query inefficiencies.

 

THE RESULTS

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.

Contact us today to discover how we can help you power data-driven business decisions.

Download Case Study

Why BEYONDSOFT

私たちのオンショア、ニアショア、オフショアのデリバリーサービスは、24時間365日、お客様のビジネスをサポートします。日本の大手SI企業に対し数十年にわたりサービスを提供しています。1999年以来、日本で25年の経験を持っています。日本には500-600人のスタッフがいます。長年にわたる成功事例は、私たちがお客様の投資対効果においてどれほど重要であるかを証明しています。シンガポールは私たちのグローバル本部であり、世界各地に14の地域オフィスを持っています。

30年以上にわたる強力なITコンサルティングサービスの経験

COBOL, C, Java, Pythonなど幅広い開発言語や開発環境に対応

SAPにおけるABAP, BTP, Fioriなど幅広く対応

40以上のグローバルデリバリーネットワークを持つ4大陸をカバー

CMMI 5、ISO 9001、ISO 14001、ISO 20000、ISO 27001、ISO 22301、ISO 45001、TMMi5の認証

マイクロソフトの専門家であるAzure MSP

Beyondsoftと共にビジネスの潜在力を最大限に引き出しましょう。私たちがどのようにイノベーションを推進し、効率を向上させ、ビジネスの成長を実現するのか、ぜひご相談ください。

jaJapanese