Business Intelligence Framework

Services
Benefits
Retail Information
Analytics
KPI Workshop
Data Mining
Information Barriers

SERVICES
	Business Intelligence Consulting Our service offering includes the entire lifecycle of a business intelligence solution including concept, feasibility, project management, metrics, design, and implementation. We can undertake long term, short term or ongoing assignments.
	Metrics Development Dashboard & Scorecard development; Advertising Metrics; Brand Awareness Analysis; Customer Value Prediction Model; Customer Life-time Value Model; Customer Segmentations/Cluster Analysis/Profiling; Merchandising Report; Benchmarking; Call Centre/Telemarketing Reporting; Customer Attrition Studies; Migration Analysis; Campaign Evaluation
	Data Warehouse The architecture of the Data warehouse is the fundamental area that affects the long-term success of the Business Intelligence / Data Warehouse solution. We can assist in the development of a long-term strategy for maintaining the data or enterprise meta data. We create stability in the basic structures of data fundamental for providing business intelligence and running the business. We also ensure that each data element stands on its own as a fact or attribute to keep queries consistent and correct without having to apply decoding rules.
	ETL We can provide custom ETL development using SSIS, SQL Server Integration Services. This includes data cleaning, transformation and logging for data from any type of data source into a data warehouse.
	Analysis Services We use the data warehouse and Analysis Services to build multidimensional cubes that facilitate querying by providing extremely quick response to even very complex queries. Cubes can be further extended by creating data mining models for forecasting purposes. We also use tools like Excel or Proclarity to allow end users to perform their own detailed queries.

Business Intelligence Blog

Val Matison awarded Microsoft SQL Server MVP for 2007, 2008, 2009