Location intelligence is a set of tools and techniques to integrate spatial features into BI platforms, aimed at better monitoring and interpreting business events related to the territory. In this demonstration we present Lily, a geo-enhanced library that relies on a spatial data warehouse to add real location intelligence capabilities to existing BI platforms. Lily provides end-users with a highly-interactive interface that seamlessly achieves a bidirectional integration between the BI and the geospatial worlds, so as to enable advanced analytical, prediction, and simulation features taking into account the spatial dimension. In particular we focus on the impact of Lily on the user experience with reference to three case studies in the domain of healthcare, telco, and school services respectively.