Analytic Vision

Analytic Vision has extensive experience in designing Star Schema dimensional models that optimize business intelligence and performance management environments. Whether you are implementing an enterprise-reporting product, business intelligence solution, a sophisticated OLAP solution, or a data-mining tool, a properly designed supporting data warehouse will enhance ease of use and query performance for your end users.

Have you noticed that many of the business intelligence service providers today typically only implement stand-alone data mart solutions? In the business intelligence practice we call these stovepipe solutions. Whether you are implementing CRM, BPM, Analytic or Business Intelligence solutions, you need an architecture and design methodology that provides an integrated data warehouse rather than stovepipe solutions.

Analytic Vision fully embraces the enterprise data warehouse as a foundation for business intelligence applications. The data warehouse then becomes the one version of the truth for your organization, with clean detailed historical data. Subject or composite data marts can then be built over the data warehouse to provide summarized analytical OLAP (Online Analytical Processing) data. The data warehouse can also be the source of data for web-based enterprise reports as well as future data mining efforts.

After designing the data warehouse, the extract, transform, and load (ETL) phase of the project begins. Designing, developing, and automating this phase of the project is typically very challenging and can take up to 60% of the implementation timeline.

Take comfort in our experience and allow Analytic Vision to share our in-depth understanding and knowledge to assist your development team in this critical area.