🥗 Nutrition Analytics Dashboard

An Advanced Power BI Business Intelligence Dashboard for analyzing and comparing Traditional Indian Foods and Processed Foods using interactive visual analytics, drillthrough reporting, KPI tracking, and nutritional storytelling.

---

📌 Project Overview

The Nutrition Analytics Dashboard is an end-to-end Business Intelligence project built using Microsoft Power BI to explore nutritional patterns across multiple food categories.

This dashboard enables users to:

✅ Compare Traditional Indian Foods vs Processed Foods
✅ Analyze nutrient composition across dishes
✅ Identify high-protein and nutrient-rich foods
✅ Explore detailed dish-level nutritional insights
✅ Interact dynamically using slicers, tooltips, and drillthrough pages

The project focuses on transforming raw nutrition datasets into meaningful business insights using modern data visualization techniques.

---

🚀 Key Features

📊 Interactive Analytics Dashboard

• Dynamic slicers and filters
• Dish search functionality
• Cross-filtering interactions
• Interactive navigation between report pages
• Responsive dashboard design

---

🥘 Nutritional Analysis

The dashboard analyzes key nutritional metrics including:

Nutrient	Analysis
Calories	Energy intake analysis
Protein	Protein-rich food identification
Fat	Low-fat food comparison
Carbohydrates	Carb distribution analysis
Fiber	Fiber-rich food insights
Sodium	Sodium consumption analysis
Iron	Iron-rich dish identification

---

📈 Comparative Insights

• Traditional vs Processed food comparison
• Nutrient distribution visualization
• Top 10 protein-rich dishes
• Iron-rich food recommendations
• Fiber-rich food recommendations
• Healthy food exploration

---

⚡ Advanced Power BI Features

This project implements several advanced Power BI capabilities:

✅ Drillthrough Reporting
✅ Interactive Tooltips
✅ KPI Cards
✅ Dynamic Filtering
✅ Data Modeling
✅ DAX Measures
✅ Bookmark Navigation
✅ Visual Interactions
✅ Gauge Charts
✅ Nutritional Score Analysis

---

🖥️ Dashboard Pages

---

🏠 1. Main Analytics Dashboard

The main dashboard provides a complete nutritional comparison between Traditional Indian Foods and Processed Foods.

Included Features

• Nutrient comparison charts
• KPI summary cards
• Dish search functionality
• Nutrient distribution visuals
• Top protein dish analysis
• Iron-rich and fiber-rich recommendations

---

📷 Dashboard Preview

🎯 2. Drillthrough Nutrition Details

An advanced drillthrough page designed to provide detailed nutritional insights for individual dishes.

Included Features

• Dish-level nutrition profile
• Nutritional KPI cards
• Protein intake gauge
• Nutritional score comparison
• Dataset source identification
• Drillthrough navigation experience

Users can right-click any dish from the dashboard and directly navigate to detailed nutritional insights.

📷 Drillthrough Page Preview

🔍 3. Interactive Tooltip Analysis

This tooltip page provides quick nutritional insights when hovering over dishes and visuals.

Included Features

• Quick nutrition preview
• Instant nutrient comparison
• Hover-based interaction
• Compact nutritional insights
• Improved dashboard interactivity

📷 Tooltip Preview

🧠 Business Intelligence Workflow

Raw Dataset
     ↓
Data Cleaning using Power Query
     ↓
Data Transformation
     ↓
Data Modeling
     ↓
DAX Calculations
     ↓
Interactive Dashboard Development
     ↓
Insight Generation

---

🛠️ Tech Stack

Technology	Purpose
Microsoft Power BI	Dashboard Development
Power Query Editor	Data Cleaning & Transformation
DAX	KPI & Measure Calculations
Excel / CSV	Dataset Storage
Data Modeling	Relationship Management

---

🧹 Data Preparation Process

Data cleaning and transformation were performed using Power Query Editor.

Steps Performed

• Standardized column names
• Removed duplicate records
• Handled missing values
• Combined multiple datasets
• Added dataset source classification
• Aggregated duplicate dishes
• Structured data for reporting

---

📊 Dashboard Insights

The dashboard helps answer analytical questions such as:

• Which foods are highest in protein?
• Which dishes contain lower fat content?
• Are traditional foods healthier than processed foods?
• Which foods are rich in iron and fiber?
• Which dishes contain the highest calories?
• How do nutrient distributions vary across datasets?

---

📂 Project Structure

Interactive-Nutrition-Analytics-Dashboard/
│
├── Dashboard/
│   └── Nutrition_Analytics.pbix
│
├── Images/
│   ├── Dashboard-overview.png
│   ├── Dish Nutrition Deep Dive.png
│   ├── Dish Nutrition Quick View.png
│
└── README.md

---

⚙️ How to Use

Step 1

Download the .pbix file.

Step 2

Open using Microsoft Power BI Desktop.

Step 3

Refresh the dataset if required.

Step 4

Use filters, slicers, and visuals to explore nutritional insights.

Step 5

Right-click visuals to access drillthrough pages.

---

🧩 Skills Demonstrated

Power BI
DAX
Power Query
Data Cleaning
Data Modeling
Business Intelligence
Interactive Dashboards
Data Visualization
Healthcare Analytics
Analytical Storytelling

⭐ Support

If you found this project useful, consider giving this repository a ⭐ on GitHub.