Case Study: Acceleration Partners reduces Power BI report time and AWS costs with P2H Inc.'s optimization and forecasting solution

Acceleration Partners cuts Power BI report generation from 5 hours to under 10 minutes with P2H Inc.

P2H Inc. worked with Acceleration Partners, LLC, a leading affiliate management agency, to address critical performance and cost issues within its Microsoft Power BI reporting system. As the company's client base grew, its databases expanded significantly, causing report generation times to exceed five hours. The platform was also struggling with inefficient data structures and exponentially increasing AWS computing costs, which hindered data-driven decision-making.

To solve this, P2H Inc. implemented a comprehensive back-end and front-end optimization of the Power BI system. This involved data grouping to reduce file sizes, minimizing excessive calculations and queries, reconfiguring table relationships, and applying techniques like binning and compression to keep files under 1 GB. Additionally, a custom forecasting module was developed. The results were significant: report generation time was reduced from over five hours to under ten minutes, AWS computing costs were lowered, and the client gained new capabilities to forecast marketing campaign performance.

Acceleration Partners, LLC