Haven't done much BI work recently, but normally my approach boils down to:
a) OpenRefine (formerly Google Refine) for cleaning and filtering - i.e. exploring and making sense of new data dumps
b) Grafana for dashboards, once the data structures are defined.
c) looking forward to this Pinterest-backed data explorer https://www.querybook.org/