Health Data Analysis

Project Overview

This project involves analyzing a year’s worth of health data to uncover trends, correlations, and insights. The analysis focuses on metrics such as walking asymmetry percentage, step count, sleep duration, and more. The deliverables include a CSV file containing the raw data, a Power BI (.pbix) file with the analysis, and a PDF report summarizing the findings.

---

Below is the summary analysis of my health data

Project Files

1. CSV File: health_data.csv

• Description: This file contains the raw health data collected over a year. Each row represents a daily entry with various metrics recorded.
• Columns:
  • Date: Date of data collection.
  • Active Energy (kJ): Energy expenditure through active movement.
  • Flights Climbed (count): Number of flights of stairs climbed.
  • Headphone Audio Exposure (dBASPL): Average daily headphone audio exposure.
  • Resting Energy (kJ): Energy expenditure during rest.
  • Sleep Analysis [In Bed] (hr): Hours spent in bed.
  • Step Count (steps): Total steps taken.
  • Walking + Running Distance (km): Total distance covered by walking and running.
  • Walking Asymmetry Percentage (%): Difference in symmetry between left and right steps.
  • Walking Double Support Percentage (%): Percentage of time both feet are on the ground.
  • Walking Heart Rate Average (bpm): Average heart rate during walking.
  • Walking Speed (km/hr): Average walking speed.
  • Walking Step Length (cm): Average step length during walking.

2. Power BI File: health_analysis.pbix

• Description: This file contains the data model, transformations, and visualizations created in Power BI. It includes interactive dashboards for exploring trends and relationships within the data.
• Visualizations:
  • Trend analysis of walking asymmetry over time.
  • Correlation between walking asymmetry and walking speed.
  • Distribution of step count and active energy.
  • Heatmaps showing relationships between multiple metrics.

3. PDF Report: health_analysis_report.pdf

• Description: This document summarizes the key findings from the analysis. It includes visualizations, insights, and actionable recommendations based on the data.
• Sections:
  • Introduction: Overview of the dataset and analysis objectives.
  • Key Metrics: Detailed explanation of the metrics analyzed.
  • Visual Insights: Charts and graphs with interpretations.
  • Recommendations: Suggestions based on the findings.

---

How to Use

Step 1: Explore the CSV File

1. Open health_data.csv in Excel or any spreadsheet application.
2. Review the data structure and familiarize yourself with the metrics.

Step 2: Interact with the Power BI File

1. Open health_analysis.pbix in Power BI Desktop.
2. Use the interactive dashboards to explore the data.
   • Filter by date range or specific metrics.
   • Hover over charts for detailed tooltips.

Step 3: Review the PDF Report

1. Open health_analysis_report.pdf using any PDF reader.
2. Read the findings and recommendations to understand the insights derived from the analysis.

---

Requirements

• Software:
  • Power BI Desktop (to open .pbix file).
  • A PDF reader (to open .pdf file).
  • Excel or any CSV-compatible software (to open .csv file).

---

Contact

For questions or support, please contact:

• Name: [ Tran Quoc Dat Nguyen]
• Email: [ dtdatnguyen04@gmail.com ]
• Phone: [ 0938786756 ]

---

Acknowledgments

Special thanks to the tools and resources used for this project:

• Microsoft Power BI
• Microsoft Excel
• [Any other software or resources you utilized]