Not all account types in Sigma can do joins and model data as outlined above. You must be a Creator or have Admin rights to be able to perform joins and create a production-ready data set.