The selection process of design team subcontractors by real estate companies is crucial in construction projects, directly affecting the quality and efficiency of the final results. However, the lack of time to evaluate potential subcontractors can lead to inadequate selection and negatively impact the project development. This study proposes an innovative approach to improve confidence in the selection processes of design team subcontractors in multifamily building projects by implementing Set Based Design (SBD) and Choosing by Advantages (CBA) methodologies. These methodologies, supported by Excel Macros programming and data visualization in Power BI, aim to automate and optimize the selection process, reducing human intervention. The study follows these steps: (1) information registration and analysis by experts, (2) determination of the conventional subcontract selection process in t...