Wednesday, 7 January 2015

tableau componets

Tableau has five importent compenets they are
1.OLTP
2.ETL
3.STAGING AREA
4.DWH
5.BI

Now we can discuss about the five components of tableau
1. OLTP : 
OLTP stands for ONLINE TRANSACTIONAL PROCESS which stores the day to day business transactions

2.ETL :
ETL stands for EXTRACTION TRANSFORMATION LOADING ,ETL is mechanism mainly used to extract the data from multiple sources and performing the required transformations and finally loading the data into DWH

3.STANGING AREA  :
It is a temporary area where all the required transformations takes place ,transformations means coverting the data inthe different format into one universal format

4.DWH :
DWH is a house where the information gets stores for analysis and reporting DWH is also known as 'OLAP' OLAP stands for online analytical processing system

5.BI  :
BI stands for business intelligence bi is the process of incorporating the intelligence to the information stored in the data where house







0 comments:

Related Posts Plugin for WordPress, Blogger...

About This Blog

Lorem Ipsum

  © Blogger templates Newspaper III by Ourblogtemplates.com 2008

Back to TOP