How to create a custom map report
Short version is yes its possible to do what you are describing. 

Your report will have a spatial query to display the shapes you want. Whether that's a map or a floor plan. 

You can then add analytical data in a second query to colour the map. The two queries needs to be joined by a key. 
Im not familiar with qgis but ideally you'd want both the spatial data and analytics in sql server.

The other option is to have 2 layers. The first layer gives the 'map' shape and the 2nd adds points on top.

If you search Google images for "SSRS map" you'll see lots of examples.