How to create a custom map report not sure if this is the right forum. But just wondering is there a way one can make a map report out of an image or a map made on excel. I have the data and I've looked around and found that its possible to edit world maps, etc, to show information. Is it possible to make a simple map from scratch, to show something like a floor plan, something that isn't available on google maps. 
Thanks guys in advance sorry if I'm not being clear on what I'm asking. If i can be clearer please ask.

Note: I'm currently using SSRS and QGIS to try do this. I have the data i need to show but don't have the co-ordinates for the thing i want to show. I thought that could be something i could do when I'm making the map. Only a small map to show one piece of information about 200 distinct data points.
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.