We are in the process of creating a Retail Business Intelligence Experience for a customer as you can see from below. We take a very HIGH END approach to the experience and graphics when dealing with business intelligence data.
Below you will see a 3D layout of a store footprint. Then you can drill into areas on the floor to see products and sales for those products. You can also click on the layout and get a video walkthrough of the aisles. Pretty amazing experience.
We are using SharePoint 2010, Visio 2010, SilverLight 4, and SQL Server 2008 R2 in the snapshot below.