This repository features an Excel-based dashboard that provides insights into individuals' health and sleep habits. The dashboard analyzes data on sleep quality, physical activity, and dietary habits, exploring how daily routines impact health and quality of life.
The dataset used in this project is available on Kaggle: Health and Sleep Statistics Dataset
The dataset contains the following columns:
- User ID: Unique identifier for each individual.
- Age: The individual's age.
- Gender: Gender ('f' for female, 'm' for male).
- Sleep Quality: Sleep quality rating (1–10 scale).
- Bedtime: Bedtime (24-hour format).
- Wake-up Time: Wake-up time (24-hour format).
- Daily Steps: Number of steps taken per day.
- Calories Burned: Daily calories burned.
- Physical Activity Level: Activity level (low, medium, high).
- Dietary Habits: Dietary habits categorized as healthy, medium, or unhealthy.
- Sleep Disorders: Presence of sleep disorders (yes or no).
- Medication Usage: Usage of medication for sleep disorders (yes or no).
- Health_Sleep_Statistics: Contains the main dataset for analysis.
- working sheet: Used for data preparation and transformation.
- pivot table: Summarized data supporting the dashboard visualizations.
- Dashboard: Visual representation of insights derived from the dataset.
The dashboard provides insights into:
- Sleep Patterns: Displays sleep quality, bedtime, and wake-up times across age groups and genders.
- Physical Activity: Visualizes daily steps, calories burned, and activity levels.
- Health Insights: Correlates dietary habits, sleep disorders, and medication usage with sleep quality and activity levels.
- Clone this repository.
- Open the Excel file and navigate to the Dashboard sheet to view the visualizations.
- Explore the pivot table and working sheet for data transformations used in the dashboard.
- Microsoft Excel or any compatible software to view and interact with the
.xlsxfile.