So this situation sounds familiar, and you are wondering if you need an analytical sandbox…
The goal of an analytical sandbox is to enable business people to conduct discovery and situational analytics. This platform is targeted for business analysts and “power users” who are the go-to people that the entire business group uses when they need reporting help and answers. This target group is the analytical elite of the enterprise.
The analytical elite have been building their own makeshift sandboxes, referred to as data shadow systems or spreadmarts. The intent of the analytical sandbox is to provide the dedicated storage, tools and processing resources to eliminate the need for the data shadow systems.
The key components of an analytical sandbox are:
For more on analytical sandboxes, including architecture design principles and options, see the white paper Analytics Best Practices: The Analytical Sandbox