This repository contains SQL analysis of a streaming database.
The approach focuses on checking data quality before answering the business questions. This includes validating key identifiers and timestamps, reviewing calculated fields, and noting any inconsistencies found in the data.
The analysis answers business questions related to:
- Account-level streaming activity for June 2021
- User behavior around specific content (Avengers: Infinity War)
All queries are written with scalability in mind, using early filtering and account-level aggregation to support large datasets.