Portfolio Optimization Analysis for a Consumer Goods Company
This project was developed for a consumer goods company with the purpose of analyzing the market positioning of newly launched products. The solution involved comparing their sales performance against the company’s core products, evaluating their contribution to the portfolio, and assessing the profitability of maintaining low-performing items.
Project Overview
A deeper analysis was conducted to identify the reasons behind underperforming products, considering factors such as pricing, distribution, seasonality, competition, and consumer behavior. Based on these insights, strategic recommendations were provided to optimize the product portfolio, improve turnover, and support decisions regarding product continuation, replacement, or discontinuation.
Tools Used
- SAP Analytics Cloud for dashboard creation
- SAP data storage
Process
- Define objectives and requirements with the Marketing team.
- Analyze and prepare the data from data source in SAP.
- Build the data model Create the analytical model with relationships, measures, and business logic.
- Build dashboards, verify calculations, test with users, and make adjustments.
- Publish to production, train users, monitor performance, and update the project as needed.
