Call us at:- +91-9958934646

Create a free profile as

Sample Certificate


Certified Data Mining and Warehousing Professional

Indian : Rs.4719
International : $75

Vskills Data Mining and Warehousing Professional assesses the candidate for a company’s data mining and warehousing needs. The certification tests the candidates on various areas in data mining and warehousing which include knowledge of planning, managing, designing, implementing, supporting, maintaining and analyzing the organization’s data warehouse and covering data mining and On-Line Analytical Processing (OLAP).


This certification is intended for professionals and graduates wanting to excel in their chosen areas. It is also well suited for those who are already working and would like to take certification for further career progression. Earning Vskills Data Mining and Warehousing Professional Certification can help candidate differentiate in today’s competitive job market, broaden their employment opportunities by displaying their advanced skills, and result in higher earning potential.


Job seekers looking to find employment in IT department of various companies, students generally wanting to improve their skill set and make their CV stronger and existing employees looking for a better role can prove their employers the value of their skills through this certification.


Data Mining and Warehousing professional are in great demand. Companies specializing in Integration Services are constantly hiring knowledgeable professionals. Various banks, telecom and IT companies also need data mining and warehousing professionals for data management and analysis.


Data Warehousing Introduction

  • Introduction
  • Meaning of Data Warehousing
  • History of Data Warehousing

Data Warehousing CharacterIstics

  • Introduction
  • Data Warehousing
  • Operational vs. Informational Systems
  • Characteristics of Data Warehousing

Online Transaction Processing

  • Introduction
  • Data Warehousing and OLTP Systems
  • Processes in Data Warehousing OLTP
  • What is OLAP?
  • Who uses OLAP and WHY?
  • Multi-Dimensional View s
  • Benefits of OLAP

Data warehousing Models

  • Introduction
  • The Data Warehouse Model
  • Data Modeling for Data Warehouses

Data warehousing Architecture

  • Introduction
  • Structure of a Data Warehouse
  • Data Warehouse Physical Architectures
  • Principles of a Data Warehousing

Data Warehousing And Operational Systems

  • Introduction
  • Operational Systems
  • “ Warehousing” Data outside the Operational System s
  • Integrating Data from more than one Operational System
  • Differences between Transaction and Analysis Processes
  • Data is mostly Non-volatile
  • Data saved for longer periods than in transaction systems
  • Logical Transformation of Operational Data
  • Structured Extensible Data Model
  • Data Warehouse model aligns with the business structure
  • Transformation of the Operational State Information
  • De-normalization of Data
  • Static Relationships in Historical Data
  • Physical Transformation of Operational Data
  • Operational terms transformed into uniform business terms

Data Warehousing Considerations

  • Introduction
  • Building a Data Warehouse
  • Nine Decisions in the design of a Data Warehouse

Data Warehousing-Applications

  • Introduction
  • Data Warehouse Application

Roi And Design Considerations

  • Introduction
  • Need of a Data Warehouse
  • Business Considerations: Return on Investment
  • Organizational Issues
  • Design Considerations
  • Data content
  • Metadata
  • Data Distribution
  • Tools
  • Performance Considerations

Technical And Implementation Considerations

  • Introduction
  • Technical Considerations
  • Hardware Platforms
  • Balanced Approach
  • Optimal hardware architecture for parallel queryscalability
  • Data warehouse and DBMS Specialization
  • Communications Infrastructure
  • Implementation Considerations
  • Access Tools

Data Warehousing Benefits

  • Introduction
  • Benefits of Data Warehousing
  • Problems with Data Warehousing
  • Criteria for a Data Warehouse

Project Management Process

  • Introduction
  • Project Management Process
  • The Scope Statement
  • Project Planning
  • Project Scheduling
  • Software Project Planning
  • Critical Path Method
  • Decision Making

Work Breakdown Structure

  • Introduction
  • Work Breakdow n Structure (WBS)
  • How to build a WBS (a serving suggestion)
  • To Create Work Breakdown Structure
  • From WBS to Activity Plan
  • Estimating Time

Project Estimtion And Risk

  • Introduction
  • Project Estimation
  • Analyzing Probability & Risk

Managing Risk

  • Introduction
  • Risk Analysis
  • Risk Management
  • Risk Analysis Managing Risks: Internal & External
  • Internal and External Risks
  • Critical Path Analysis

Data Mining Concepts

  • Introduction
  • Data Mining
  • Data Mining Background
  • Inductive Learning
  • Statistics
  • Machine Learning

Data Mining And Kdd

  • Introduction
  • What is Data Mining?
  • Data Mining: Definitions
  • KDD vs. Data Mining
  • Stages OF KDD
  • Machine Learning vs. Data Mining
  • Data Mining vs. DBMS
  • Data Warehouse
  • Statistical Analysis

Elements Of Data Mining

  • Introduction
  • Elements and uses of Data Mining
  • Relationships & Patterns
  • Data Mining Problems/Issues
  • Goals of Data Mining and Know ledge Discovery

Data Information And Knowledge

  • Data, Information and Knowledge
  • What can Data Mining do?
  • How does Data Mining Work?
  • Data Mining in a Nutshell

Data Mining Models

  • Data Mining
  • Data Mining Models
  • Discovery of Association Rules
  • Discovery of Classification Rules

Data Mining Issues And Challenges

  • Other Mining Problems
  • Data mining Application Areas
  • Data Mining Applications-Case Studies
  • Housing Loan Prepayment Prediction
  • Mortgage Loan Delinquency Prediction
  • Crime Detection
  • Store-Level Fruits Purchasing Prediction
  • Other Application Area

Dm Nearest Nighbor And Clustering Techniques

  • Types of Knowledge Discovered during Data Mining
  • Comparing the Technologies
  • Clustering And Nearest-Neighbor Prediction Technique

Decision Trees

  • What is a Decision Tree?
  • Decision Trees
  • Where to use Decision Trees?
  • Tree Construction Principle
  • The Generic Algorithm
  • Guillotine Cut
  • Over Fit

Decision Trees - Advanced

  • Best Split
  • Decision Tree Construction Algorithms
  • Cart
  • ID3
  • C4.5
  • Chaid
  • How the Decision Tree Works
  • State of the Industry

Neural Networks

  • Basics of Neural Networks
  • Are neural networks easy to use?
  • Business Scorecard
  • Where to use Neural Networks
  • Neural Networks for Clustering
  • Neural Networks for Feature Extraction
  • Applications Score Card
  • The General Idea

Neural Networks - Advanced

  • What is a Neural Network Pparadigm?
  • Design decisions in architecting a neural network
  • Different types of Neural Networks
  • Kohonen feature Maps
  • Applications of Neural Networks
  • Knowledge Extraction Through Data Mining

Association Rules And Genetic Algorithm

  • Association Rules
  • Basic Algorithms for Finding Association Rules
  • Association Rules among Hierarchies
  • Negative Associations
  • Additional Considerations for Association Rules
  • Genetic Algorithm
  • Crossover
  • Genetic Algorithms In detail
  • Mutation
  • Problem-Dependent Parameters
  • Encoding
  • The Evaluation Step
  • Data Mining using GA

Olap Multidimensional Data Model

  • On Line Analytical Processing
  • OLAP Example
  • What is OLAP?
  • Who uses OLAP and WHY?
  • Multi-Dimensional Views
  • Complex Calculations
  • Time Intelligence

Olap Characteristics

  • Definitions of OLAP
  • Characteristics of OLAP: FASMI
  • Basic Features of OLAP
  • Special features

Multidimensional And multirelational Olap

  • Introduction
  • Multidimensional Data Model
  • Multidimensional versus Multi-relational OLAP
  • OLAP Guidelines

Olap Operations

  • Introduction OLAP Operations
  • Lattice of Cubes, Slice and Dice Operations
  • Relational Representation of the Data Cube
  • DBMS

Data Mining

  • Mining Association Rules
  • Classification by Decision Trees and Rules
  • Prediction Methods

Molap / Rolap Tools

  • Categorization of OLAP Tools
  • Managed Query Environment (MQE)
  • Cognos PowerPlay


Frequently Asked Questions

What is Vskills?

VSkills is a “skills testing” and certification exam conducted by - ICSIL, A Govt of India Undertaking and Govt of NCT Delhi Company. Vskills is a testing and certification programme focused on prior learning. Through Vskills Assessments, individuals with learning acquired outside of a formal classroom setting have the opportunity to get certified by appearing in standardized exams conducted throughout the nation at proctored centres.

What is Vskills Certification?

Vskills Certification is a professional skill test that is conducted to assure that a person is qualified to perform a job. It is a proof that the candidate has the requisite skills to do a job.

What are the benefits that I will get by taking Vskills Certification Exam?

Some of the benefits that you get on taking Vskills Certification exam are listed below,-

- Develop skills that are valued by experts in the industry
- Vskills Certifications opens avenue for candidates in various sectors
- Vskills Certification provides an opportunity to get certified in areas where you are not formally educated
- Vskills Certification enhances the chances of employment
- CVs of certified candidates are flagged on Monster India website as “Vskills Certified candidates” to employers.
- CVs of certified candidates are also tagged on website as “Vskills Certified candidates” to employers.
- CVs of all Vskills Certified candidates is shared with relevant employers for employment - Vskills Certified candidates are a part of the Job Centre for Life
- Vskills provides supplementary preparation material (hard copy or online videos) to candidate for easing the process of preparation.
- Vskills assessment exams are structured and regularly updated according to the industry standards
- Vskills Certifications do not require any time commitment since it is only a test and not classroom teaching.
- Vskills Certifications open avenues for candidates in various sectors
- Vskills Certifications provide an opportunity to get certified in areas where you are not formally educated
- Vskills Certifications greatly enhance the chances of employment

What is the duration of the course?

There is NO course duration for all certification exam. Exams are conducted on monthly basis and candidate has the flexibility to select the exam date from Exam Calender as per their per feasibility. Student can give the exam any time between 1 year from the date of enrollment.

What is the eligibility for registration?

There is no minimum qualification for taking up Vskills Certification Exam, so it is for everyone – from day to day users to senior management, say - Employees - Employers - Students - Teachers - Businessmen and Entrepreneurs - Housewives/Retired Professionals, etc

What is the duration of the exam?

Vskills Certification Exam is for one hour (1 hour) duration.

What type of questions are asked in the exam?

Vskills Certification Exam has 50 multiple choice questions (1 marks each), with no negative marking.

What is the passing percentage?

Passing percentage is 50% i.e., 25 marks need to be scored in order to clear the exam.

When is the the exam conducted?

Vskills Certification Exams are conducted on monthly basis and candidate has the flexibility to select the exam date from Exam Calender as per their per feasibility.

How many attempts can I give for a certification exam?

One exam attempt per registration with no limit on re-appearance.

Can I reschedule the exam?

Yes, candidate can re-shedule the exam till the date of exam after paying the re-schedule fees.

If I fail, what is the procedure to be followed for reappearing in the exam?

In case a candidate is unable to clear the exam then, candidate can register for exam retake by paying for registration fees of Rs. 1250/- but no reading material is sent.

Does the exam is available only in India?

Candidates residing outside India can register for specific certifications as listed under the international students by appearing in online open book exam.

Can I take two or more certification exams at one time?

Yes, candidate can take two or more exams at one time.

How tough will be the paper?

The certification exam is meant to assess the ability of the student in the particular domain and checks entry level to medium level skills in that particular domain. If you know the domain area, and have studied the accompanying material well, you will have no difficulty in passing the exam.

Do you provide any sample questions?

Practice tests are provided under every certification.

What is the duration of the certification?

There is no minimum duration of certification. You may register when you want; we suggest that minimum 30 days should be kept to go over the material provided at the time of registration.

Is the exam available for international candidates?

Yes, candidates residing outside India can follow the process for international students.

What kind of placement support is provided?

Vskills provides placement support to certified candidates as - CVs of certified candidates are flagged on Monster India website as “Vskills Certified candidates” to employers. - CVs of certified candidates are also tagged on website as “Vskills Certified candidates” to employers. - CVs of all Vskills Certified candidates is shared with relevant employers for employment - Vskills Certified candidates are a part of the Job Centre for Life

In case I am unable to take the exam will my fees be refunded?

As a policy under no circumstances will the fees be refunded to the candidate after registration, unless there is a situation that is unavoidable.

When is the result declared?

Result indicating pass or fail is told to candidate after finishing of the exam. Hard copy certificate and performance report is sent to candidates who had cleared the exam. Soft copy certificate is also e-mailed.

Is the material provided by you sufficient from exam point of view or should I refer other sources?

The study material provided by Vskills is a guideline for your exam, but you can refer to other sources for further clarity on any topic.

Are there any classes provided by you to prepare for the exam?

Vskills does not offer classes for any certification exam. The candidates have to prepare on its own for the exam. NO CLASSES are provided by Vskills.

Do you charge extra for placement assistance?

There are no charges apart from the registration fees or exam re-take in case candidate is unable to clear the certification exam.


V skills

VSkills is a “skills testing” and certification exam conducted by - ICSIL, A Govt of India Undertaking and Govt of NCT Delhi Company. It is one of the largest manpower companies of the government of NCT Delhi. VSkills certifications help candidates quantify and prove their skills in a particular domain - skills that are valued by the employer and are in great demand. Your Vskills Certificate is a proof that you have the requisite knowledge and makes you job ready - which is why employers rate VSkills certifications and look for people who have them.

Hot Courses

Our Partners