I will do your all metabase tasks regarding installation, database connection and dashboard creation via sql. Here you can see my demo:
https://ercanvural.herokuapp.com/public/dashboard/44781192-d2ef-44f0-92e3-5d453e7cad8e?relative_date=lastyear
Installation: Your local machine or cloud service to have a public link.
Database: All options available here: https://www.metabase.com/docs/latest/administration-guide/01-managing-databases.html