Imputing Missing Health Data with BigQuery + Visualizing in Power BI

Описание: 📆 Power BI Month Profile Dashboard | May Activity, Sleep & Exercise Analytics

Welcome back to Data Driven Decisions! In this video, I walk through the design and early build of a new "Month Profile" dashboard—a page dedicated to visualizing everything about a single month’s health data, starting with my most successful month yet: May.

You'll see how I:

Build the foundation for a month-level dashboard in Power BI

Highlight key metrics like my Ultimate Day Score, Sleep Grades, and Activity Scores

Use Python + BigQuery to clean and model the raw data

Handle missing values using linear regression directly in BigQuery

Reflect on what made May such a strong month—and how I’m aiming to beat it in June

This video also gives a peek under the hood of my custom ETL and data modeling process, showing how I turn Apple Watch and wellness app data into a structured 3-level model: Day → Workout → Session.

🧠 Tools Used:

Power BI

Google BigQuery

Python

Excel

Apple Watch + Health Apps (AutoSleep, Pillow, Welltory, etc.)

If you're into health analytics, personal data modeling, or just want to see how to create real-time, actionable dashboards in Power BI, this one's for you.

📌 Subscribe for more videos like this as I continue building out my health analytics ecosystem—one month at a time.

#PowerBI #HealthAnalytics #BigQuery #FitnessTracking #ETL #DataScience #SleepTracking #ActivityDashboard #DataDrivenDecisions