Transforming public data to insights