This is a metaphorical reference to a powerful entity or group which either is not using or is not fully aware of it's own power. Usually it is used in a context where there is some hope (or danger) of waking the sleeping giant, undoing the ignorance or internal conflict that prevents the entity from using it's full power.