Case study / Business intelligence
From portfolio data to better decisions.
A profitability analysis and Power BI dashboard project across brands, regions, and sales channels.
- Records analyzed · 14 columns
- 190,740
- Brands / regions / sales channels
- 10 / 5 / 4
- Observed fill rate
- 90.82%
The work
I analyzed an FMCG portfolio dataset and built Power BI dashboards to explore performance across 10 brands, 5 regions, and 4 sales channels. The analysis focused on promotion and stock-allocation opportunities that could support profitability.
Decision signals
The project reported a 90.82% fill rate and a 25.73% sell-through rate. These measures informed recommendations for promotion and stock allocation.
These figures describe the analyzed project dataset. Recommendations are not measured improvements or live business results.
Explore the project
The source project is available on GitHub, including the work behind the supply-chain and portfolio analysis.