Why Your Data Lake Is Double‑Counting Sensors—and How Normalization Saves It
A pull of 719 openSenseMap sensors reveals four string variants for the same SDS011 model, inflating entity counts and corrupting dashboards. The author shows how extracting a stable natural key from observed strings—rather than minting IDs directly—keeps analytics accurate, with full code on GitHub.