CCBPI accelerates business and drives performance with Sales Capability tool

Customer Challenges

CCBPI knew it needed to integrate and automate its data. Users had been generating Power BI reports to show critical measures, but they were based on data derived from Microsoft Excel files that were manually edited and updated. Managing these files for report creation required multiple users to take several intermediate steps that were prone to human error.

When CIO Winnie Talosig-Rebancos and the rest of the CCBPI leadership team chose to accelerate the company's digital transformation, automating the report creation process was identified as critical to increasing operational efficiency while maintaining data transparency and consistency.

Partner Solution

After multiple workshops, Lingaro delivered a UX-centric proposal based on dashboard invention frameworks. The deployment of the new, entirely Azure-based Sales Capability tool began by structuring multiple data sources from a variety of CCBPI systems, and then bringing the data together into secure file transfer protocol (SFTP) storage.

Formats and data quality rules were characterized to ensure that data governance was properly supervised. Azure Synapse Analytics was used as a database, and proper data flow and massaging was ensured through a combination of Azure Data Lake and Azure Databricks. 

Customer Benefits

Through adoption of the tool, CCBPI now has a new set of dashboards that support simpler, faster, and more in-depth analyses of market data. The bottler now has also increased clarity into its operations and real cost savings. Further, the new Azure architecture introduced accurate historical data input management that now enables actionable trend analysis. The new Power BI reports—with over 52 tabs—also bring data to the highest level of sales and marketing decision-making, and the KPIs presented there are precise and consistently in line with global solutions.