--- title: "areebakhizer7 (@areebakhizer) | Hashnode" description: "Raw data in. Answers out. Read the latest articles by areebakhizer7 on Hashnode." url: "https://hashnode.com/@areebakhizer" --- @areebakhizer # areebakhizer7 @areebakhizer · London, UK · Joined July 2026 Raw data in. Answers out. ### [Part 4 - The Daily Report and What the Data Told Me](https://areebakhizer.hashnode.dev/part-4-the-daily-report-and-what-the-data-told-me?utm_source=hashnode&utm_medium=feed) How I built a serverless daily home report using AWS Lambda, Athena, and SES. Five SQL queries that turn smart home sensor data into insights. 8 min read · [areebakhizer.hashnode.dev](https://areebakhizer.hashnode.dev/part-4-the-daily-report-and-what-the-data-told-me?utm_source=hashnode&utm_medium=feed) [Oct 16](https://hashnode.com/posts/part-4-the-daily-report-and-what-the-data-told-me/6ad1e8a4cdc6f458185aa32b) ### [Part 3 - Stage by Stage: Building the Home Assistant ETL](https://areebakhizer.hashnode.dev/part-3-stage-by-stage-building-the-home-assistant-etl?utm_source=hashnode&utm_medium=feed) Three nightly AWS Glue jobs clean, flatten, and roll up raw Home Assistant events into Parquet tables queryable via Athena. 7 min read · [areebakhizer.hashnode.dev](https://areebakhizer.hashnode.dev/part-3-stage-by-stage-building-the-home-assistant-etl?utm_source=hashnode&utm_medium=feed) [Sep 10](https://hashnode.com/posts/part-3-stage-by-stage-building-the-home-assistant-etl/6aa2d5061cfb7c13fc90e119) ### [Part 2 — Getting Data from Home Assistant to AWS: The HA Forwarder](https://areebakhizer.hashnode.dev/home-assistant-to-aws-ha-forwarder?utm_source=hashnode&utm_medium=feed) A Python WebSocket forwarder that taps Home Assistant events, filters noise, and ships to AWS Kinesis. Part 2 of building a smart home data platform. 9 min read · [areebakhizer.hashnode.dev](https://areebakhizer.hashnode.dev/home-assistant-to-aws-ha-forwarder?utm_source=hashnode&utm_medium=feed) [Aug 21](https://hashnode.com/posts/home-assistant-to-aws-ha-forwarder/6a883dd858eda67fc233f6b0) ### [Unlocking Home Assistant Data: Building a Query Platform Part 1 — The Prelude](https://areebakhizer.hashnode.dev/home-assistant-data-platform-prelude?utm_source=hashnode&utm_medium=feed) HA deletes all history after 10 days. I built a pipeline to capture, store, and query it permanently. 4 min read · [areebakhizer.hashnode.dev](https://areebakhizer.hashnode.dev/home-assistant-data-platform-prelude?utm_source=hashnode&utm_medium=feed) [Aug 3](https://hashnode.com/posts/home-assistant-data-platform-prelude/6a7085b6b26ad397edfca448)