📊 Lifestyle, Diet & Fitness — Power BI Analytics Project
A data analytics project exploring the relationships between lifestyle habits, diet patterns, exercise routines, BMI, and perceived physical health. This project demonstrates:
✔ Excel data cleaning ✔ Power BI modeling (DAX, measures, categories) ✔ Dashboard design with bookmarks ✔ Insight-driven storytelling
🧰 Tools Used
Excel – Data cleaning & preprocessing
Power BI – Data modeling, measures, visualizations
DAX – BMI categories, age grouping
Dataset Source: Kaggle
Dataset Size: 500 records (219 original + AI-generated to expand sample)
📁 Project Structure ├── data/ │ ├── raw.xlsx │ └── cleaned.xlsx │ ├── pbix/ │ └── lifestyle_diet_fitness.pbix │ ├── reports/ │ ├── dashboard.pdf │ └── Mini Project Report.pdf │ └── README.md
🧹 Excel Data Cleaning Summary
✔ Removed duplicates ✔ Fixed inconsistent capitalization & spelling ✔ Standardized gender column ✔ Verified & corrected numeric fields ✔ Calculated BMI using:
BMI = Weight (kg) / (Height in meters²)
✔ Exported clean dataset for Power BI
📈 Power BI Dashboard Overview 1️⃣ Home Page — Demographics
Gender distribution
Work preference
Age groups
KPIs: Avg Age, Avg BMI, Avg Gym Time
2️⃣ Health & Exercise Section
Physical health rating vs exercise type
Gym time vs exercise importance
BMI vs exercise type
Slicers: sex, age, work preference
3️⃣ Diet & Lifestyle Section
Meals per day vs work preference
BMI category distribution
Physical health vs BMI
Slicers for BMI category, age group
🔍 Key Insights
From your report:
✔ Majority participants are Male (57%) ✔ 21–25 age group is the most represented ✔ Normal BMI is most common (~68%) ✔ Outdoor Games, Walking, and Gym → highest physical health ratings ✔ More gym time correlates with higher exercise-importance ratings ✔ Higher BMI slightly reduces perceived health ratings
📌 Conclusion
Lifestyle choices — including exercise routine, diet preferences, and work style — significantly impact BMI and physical health ratings. The Power BI dashboard provides a clear, interactive view of these behavioural patterns.
📬 Contact
Akhil Raj Aspiring Data Analyst LinkedIn: https://www.linkedin.com/in/akhilraj-data