Dynamically Embed Dashboard based on User

Hello, I am looking to embed user-specific dashboards to the Members section of my website.

I would like to :

  1. Build a database collection consisting of User Name/ID, Company Name, Dashboard URL

  2. Based on the Logged-in user, return the respective Dashboard URL for that user

  3. Reference the Dashboard URL and embed the Dashboard into the member’s page

Would any one be able to point me in the right direction for building this out? Thank you!