Our consultants work with you to define your specific DW/BI requirements through a comprehensive examination of your focus areas. We work to derive a solution that factors in your investment plans and balances cost-efficiency with required business benefits. The key modules are:

	preparing business cases for BI&DW
	business & information analysis
	preparing BI&DW solution framework
	arriving at roadmap for implementation
	BI&DW project management

We formulate a design of the proposed BW/BI solution through aligning requirement analyses with your goals and existing infrastructure. Our key offerings include:

	data acquisition from different legacy systems on various platforms including Mainframes, AS/400, Unix, Digital, OLTP platforms as DB2, IMS, IDMS, VSAM, Oracle legacy applications, Sybase, Informix and ERP packages as Peoplesoft, BaaN etc.
	data modelling
	ETL architecture
	metadata architecture and management
	security architecture

As part of the integration phase, Wipro Infotech DW/BI team designs and builds physical databases ensuring that appropriate disaster recovery plans are in place. Our data mining implementation includes data cleaning, ETL, visualization and enabling data access. The data mining tool selection and creation of reporting environments are domain-specific and fulfil operational requirements such as customer profiling, target marketing, campaign effectiveness analysis and fraud detection and management. The reporting environments that we have developed and deployed are feature-rich and make multi-dimensional analyses possible across various types of data warehouses.

To ensure consistent performance as data warehouses scale in volume and use and to ensure maximum benefits, our DW/BI management offering includes:

	data warehouse administration, maintenance and support activities
	capacity planning
	data warehouse audit
	performance tuning

Integrating strategic information from ERP, legacy systems, and external data sources into a robust decision support environment that supports advanced query and analytics.

Maximising ROI from ERP systems through:

	developing a process model for building and implementing ERP data warehouse solution
	architecting and developing solutions to analyse specific metrics for departmental operations such as sales and billing as well as through development of enterprise-wide DW/BI strategies
	customised solutions using leading data warehousing tools and ERP product suites like SAP business information warehouse
	evaluating third party tools to complement SAP BW features

Wipro Infotech has focussed experience working on various SAP modules and products including data extraction from SAP R/3 and other data sources.

For organisations driven by customers, CRM applications that provide a unified view of customer data prove critical. Wipro Infotech combines its expertise in CRM applications with our extensive experience in data warehousing. This has resulted in providing:

	solution architecture to handle synchronous and asynchronous touch points
	integrated customer views across applications, channels, geographies
	data cleansing, match and merge and ETL to integrate customers
	customer centric data model to capture and track customer product holding, product usage, contact history and events

Given the migration of businesses to the online medium, web housing and data mining solutions that offer powerful insights through incisive and precise observations and analytical solutions on customer needs and behaviour patterns occupy an important space. Wipro Infotech Cybermine, a comprehensive e-Business intelligence framework, plugs that space.

Cybermine's features include:

	e-customer analytics - 360o view of online customers, profiling demographics, browsing behaviour
	e-marketing and e-sales - target marketing analysing market segmentation, identifying cross-sell/up-sell opportunity
	e-services - analysing effectiveness of online services, measurement of customer satisfaction levels
	e-personalisation - defining intelligent rules used to personalise content based on visitors' browsing behaviour
	site management - providing insights into web site activity