Our goal is to allow users within SFMC platform to be able to create audience / segmentation with drag and drop options (even if users are non-technical and got no experience with SQL).
Current state: Our contact database includes a number of tables (not just one master table) and each table got different kind of relationship with main contacts table (like one-to-one and one-to-many in some cases).
Future state: Goal was to look into audience builder since it allows joining multiple tables easily and segmentation can be created easily but recently I read online that audience builder is being retired in SFMC.
It seems like recommendation is to use SFMC filters but when contact datable consists of multiple tables, it can be quite tedious work to create so many filters and joining multiple tables in filters is quite a lot of work.
Question: Is there any recommendation how non-technical users can create segmentations easily? Is there any alternative to audience builder within SFMC?