Developing a GCP and Looker-Based Analytics Business Insights Solution for a Leading Global CPG Company

About the Client:

The client is a French American multinational beauty company. It develops, manufactures, markets, and distributes fragrances, cosmetics, skincare, nail care, and both professional and retail hair care products. Headquartered in New York, it has 20,000 employees and owns 77 brands.

Customer Challenge:

The customer was facing several challenges with substantial impact over multiple business avenues, ranging from sales to the leader’s ability to make data-driven decisions, significantly hindering insight generation, operational efficiency, and revenue.

• The inability to safeguard against uncertain macroeconomic factors affected category sales.
• The lack of visibility & analytics insights impacted business leaders’ propensity to make data-driven decisions.
• Siloed data significantly slowed down insight generation.

Solution:

After an exhaustive analysis of the client’s particular challenges and needs, Brillio decided to:

• Implement the use of Google Mobility data and macroeconomic factors (GDP & Inflation) to generate market predictions & category forecasts.
• Build a 360-degree Brand health dashboard to provide a unified view for business leaders to make data-driven decisions.
• Build a self-serving diagnostic tool to provide seamless and faster insights, enabling teams with access to an ad-hoc insight exploration tool that sits on the connected data model.

Result:

Following Brillio’s implementation, the client was able to generate significantly faster, more accurate insights, serving leaders and enabling them to make informed decisions. Our solution also improved operational efficiency, allowing analysts to focus their efforts on creating value for the company instead of repetitive tasks.

• Reduced insights time to market by 25%
• Reduced dependency on analysts by 22%
• 99.99%+ availability of systems
• Up to 30% reduction in TCO
• 20% improved application performance