Home  >  Blog  >   Tableau  > 

Components Of Data Warehouse - Tableau

Rating: 4
  
 
3781
  1. Share:
Tableau Articles

 

Components of Data Warehouse in Tableau

Data Warehouse primarily contains 5 Components:
1. OLTP
2. ETL
3. Staging Area
4. OLAP/ Data Warehouse
5. BI

Tableau Certification Training makes you experts in data visualization tool. Take up online course get Certified. Start Learning!

 

1. OLTP: OLTP stands for online transaction processing system it stores the day to day business transactions

2. ETL: ETL stands for extraction, transformation, loading. It is the process of converting the data into information with the required transformation and validations.

3. Staging Area: Staging Area is the separate dedicated area to perform the required transformations.

  • It can store the data only for the temporary period of time.

Staging Area Transformation

4. Data Warehouse: Data Warehouse is the process of converting the raw data into valid information with the help of ETL and thereby performing required reporting and analysis, with the help of BI.

  • It is the permanent location to store the information
  • It is also known as OLAP
  • OLAP stands for online Analytical processing system.
  • As the data warehouse is giving the required information to perform required reporting and analysis. So, it is known as OLAP.

 MindMajix YouTube Channel

Related Article: Snowflake vs Redshift

5. BI: BI stands for "Business Intelligence".
BI is the process of incorporating the intelligence on the information stored in the data warehouse, by performing required reporting and analysis.

Checkout Tableau Server Tutorials

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
Tableau TrainingAug 05 to Aug 20
Tableau TrainingAug 08 to Aug 23
Tableau TrainingAug 12 to Aug 27
Tableau TrainingAug 15 to Aug 30
Last updated: 04 August 2023
About Author
Remy Sharp
Saikumar

As a Senior Writer for Mindmajix, Saikumar has a great understanding of today’s data-driven environment, which includes key aspects such as Business Intelligence and data management. He manages the task of creating great content in the areas of Programming, Microsoft Power BI, Tableau, Oracle BI, Cognos, and Alteryx. Connect with him on LinkedIn and Twitter.

Recommended Courses

1 /15