client:
SAÉ 5C02 — BUT Informatique
role:
Data Analyst, BI Developer
year:
2025
NutriSight
Nutritional Analysis
Dashboard
NutriSight is a business intelligence project that
transforms the Open Food Facts dataset into
interactive Power BI dashboards. The project
involved building a complete ETL pipeline with KNIME
to clean, normalize, and enrich nutritional data
from thousands of food products, then visualizing
key insights around Nutri-scores, sales patterns,
and product composition.
The Challenge
The Open Food Facts database contains millions of
entries with inconsistent formatting, missing
values, and unstructured nutritional data. The
challenge was to build a reliable data pipeline that
could clean and standardize this raw data, compute
meaningful Nutri-scores, and present actionable
insights through interactive dashboards — enabling
users to explore products by category, country, and
nutritional quality at a glance.
Technical
Stack
ETL: KNIME Analytics Platform —
data cleaning, normalization, and transformation
workflows
Visualization: Microsoft Power BI — interactive dashboards with slicers, gauges, and drill-down
Data Source: Open Food Facts (CSV/API) — global open-source food database
Analysis: Nutri-score computation, nutritional composition breakdown, sales pattern analysis
Data Processing: Excel, CSV manipulation, data quality validation
Visualization: Microsoft Power BI — interactive dashboards with slicers, gauges, and drill-down
Data Source: Open Food Facts (CSV/API) — global open-source food database
Analysis: Nutri-score computation, nutritional composition breakdown, sales pattern analysis
Data Processing: Excel, CSV manipulation, data quality validation
Key
Insights
Product Search Dashboard:
Interactive product explorer with real-time
Nutri-score gauge, energy metrics (kJ/100g),
quantity sold, and detailed ingredient composition
(fat, sugar, protein, fiber, salt) displayed as
donut charts. Product locations are mapped
geographically.
Sales Analysis Dashboard: Multi-dimensional breakdown of sales by food category (Groceries, Snacks, Confectioneries...), Nutri-score distribution across 2.1M+ entries, sales by country (US 42%, France 27%, UK 15%), and top-selling individual products.
Sales Analysis Dashboard: Multi-dimensional breakdown of sales by food category (Groceries, Snacks, Confectioneries...), Nutri-score distribution across 2.1M+ entries, sales by country (US 42%, France 27%, UK 15%), and top-selling individual products.
Key
Achievements
• Processed and cleaned thousands of food products
from the Open Food Facts database
• Built a complete KNIME ETL pipeline for data normalization and quality assurance
• Designed 2 interactive Power BI dashboards with drill-down capabilities and dynamic slicers
• Implemented Nutri-score computation and visualization with intuitive gauge charts
• Analyzed sales patterns across 5 countries and 11+ food categories
• Created a searchable product explorer with real-time nutritional breakdown
• Built a complete KNIME ETL pipeline for data normalization and quality assurance
• Designed 2 interactive Power BI dashboards with drill-down capabilities and dynamic slicers
• Implemented Nutri-score computation and visualization with intuitive gauge charts
• Analyzed sales patterns across 5 countries and 11+ food categories
• Created a searchable product explorer with real-time nutritional breakdown
