Wipro Infotech
Consulting  
Business Solutions  
Professional Services  
Total Outsourcing  

Browse Business Solution by:

Home Services Business Solutions Data Warehousing/BI
Data Warehousing/BI
Data warehouses are an organisation's corporate memory, containing critical information that is the basis for their business management and operations. Organisations then require their data warehouses to be scalable, secure and stable with the ability to optimise storage and retrieval of complex sets of data. Business intelligence systems transform an organisation's ability to convert raw data into information that makes online multidimensional transaction and analytical processing possible. Data warehousing (DW) and business intelligence (BI) operations together enable organisations to base crucial business decisions on actual data analyses.

At Wipro Infotech, our DW/BI offerings provide your organisation with direct access to information analytics that will help you respond quickly to emergent business opportunities and rapidly changing market trends. With India's largest dedicated DW/BI team of 2050+ consultants who bring 4350+ person years of experience, Wipro Infotech DW/BI solution framework can be customised to address your domain-specific requirements.

We have extensive experience in the finance and insurance, retail, manufacturing, energy and utilities, telecom, healthcare and government sectors. Such varied domain experience, along with our alliance with global vendors in the field and cross-technology competency drive your BI operations from a departmental to an enterprise-wide initiative. As an end-to-end service provider, we consult, architect, integrate and manage your DW/BI operations to ensure that you stay ahead in today's competitive business environment.

Our DW/BI solution framework includes:

DW/BI consulting

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

DW/BI architecture

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

DW/BI integration

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.

DW/BI management

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

Additionally, our specialised DW/BI offerings include:

ERP analytics

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.

CRM data warehouse

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

E-business intelligence

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

Onsite - offshore delivery improving cost efficiency up to 35%
Multiple DW projects with 40 - 70 assigned resources
Dedicated BI competency centres for clients
Verticalised point solutions with reusable components

 

Data Warehousing/BI Tools
With strategic alliances with global leaders in data warehousing and business Intelligence, our expertise extends to domain segments.
 
Healthcare
We are highly recommended by Harvard Medical International (HMI) and Microsoft for implementation of Healthcare IT solutions.
 
White Paper

Data mining - Mining for gold


 
Client Speak
"Wipro has an impressive line of data warehousing and BI offerings, and any company considering data warehouse/BI development should place Wipro high at the top of their list of services providers."