Case Study — Sustainability
9 Boyoz = 1 Tree
A data pipeline connecting commercial sales performance to environmental reforestation efforts. For every 9 units of İzmir's signature pastry sold, one tree is planted. The project translates a local product into a measurable sustainability metric.
Python
Data Simulation
SQL
Data Visualization
53.6%
Chocolate Boyoz identified as the market leader — contributing more than half of all tree plantings in the "Boyoz Forest" dataset.
Technical Execution
- Engine: Realistic sales data simulated using Python and Pandas across multiple product variants and time periods.
- Transformation: SQL logic applied to convert raw sales figures into tree planting metrics based on the 9:1 ratio.
- Strategic Insight: Chocolate Boyoz identified as the dominant contributor — 53.6% of total environmental impact — informing production and marketing prioritization.
View Technical Workflow →