Online Analytical Processing (OLAP)

Online Analytical Processing (OLAP) Online analytical processing falls in the category of software technology which helps analysts, managers & executives to gain insights from data with the help of regular, immersive access to a variety of information that has...

Data Warehouse Tutorial

What is Data Warehousing? A data warehouse can be referred to as a relational database that is designed for query and analysis. It often contains historical data derived from transaction data, but it can also contain data from other sources. The main advantage of a...

Data Transformation in Data Warehouse

What is data transformation? When you extract the data from the source systems into the data warehouse, there is a need to perform various data transformations according to the standards. Data transformation means that you perform manipulations on the data to change...

Data Cleaning in Data Mining

Data Cleaning in Data Mining What is data cleaning? Data mining is concerned with extracting valuable information from the data, which can help organizations make business decisions. But before performing data mining, we have to clean the data. Data...

Project Planning and Management in Data Warehouse

Project Planning and Management in Data Warehouse Planning your Data Warehouse Inadequate project management and improper planning results in failure of the entire project.The most important thing to determine is that does your organization really need a data...

Difference between ETL and ELT

What is ETL?  ETL stands for Extract, Transform and Load. It is a technique that involves extracting the data/record from sources and passing it to a staging area, followed by transforming (Extraction, cleansing, aggregation). It reformats the data by performing...

Data Extraction and Data Transformation

What is data Extraction? Data extraction can be defined as the process of collecting or retrieving different types of data from different sources, many of which are semi-structured or completely unstructured. Types of data extraction techniques: There are two types of...

Pin It on Pinterest