Imputing Missing Health Data with BigQuery + Visualizing in Power BI
Автор: Data Driven Decisions
Загружено: 2025-06-05
Просмотров: 253
Описание:
📆 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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: