What type of access I need to provide to the end users in SAS Visual Analytics to view the reports. Note: I don't want to enable guest access, due to department specific data
I think that you will need to provide them the Group/Role "Visual Analytics: Report Viewer" in the SAS management console, as a SAS Administrator.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.