Concrete is the second most used material on the earth after water. The current era of concrete making material like the coarse and fine aggregate need alternatives to overcome the demand. In this present study, artificial fine aggregate or artificial sand (AS) as an alternative to fine aggregate has been investigated. The parameters studied in this study to investigate the AS effect of concrete are slump, modulus of rapture, compression strength, split-tensile strength, and shear strength. The experimental results show that the fresh properties and compression strength show significant changes when the replacement dosage of natural fine aggregate or natural sand (NS) increases with AS. However, the other parameters, namely shear strength, tensile strength, modulus of rapture, and AS replacement, also positively impacted concrete. The multi-criteria decision-making technique was used to determine the prepared mixtures’ optimum mixture. Based on TOPSIS analysis, it is confirmed that the replacement of AS is 25% more effective. The study revealed that 100% NS replacement is also possible by AS, but a suitable admixture is required for workability.