Metabase has become indispensable to our product workflow at Slytrunk. It is powerful, flexible and reliable, and I would recommend it to any founder without the tens of thousands to spend on Periscope or Domo.
It requires some setup, and there is a learning curve, but it's IMO a great investment of time.
One thing that could be improved is more product manager focused documentation with cookbooks for common queries, such as those commonly rolled out for Google Analytics (BigQuery).