Posts

Showing posts from October, 2022

DATA WAREHOUSING

Image
  Data Warehousing A Data warehouse is a repository where information is gathered from multiple data sources and stored electronically .  Data engineers and Business analysts for business intelligence purposes in an organization can access data warehouses that store data in larger amounts. The data is accessible and easy to evaluate for business insights. The data gathered from multiple sources is in multiple formats, such as Structured, Semi-structured, or Unstructured. The collected data is processed, modified, and converted into information so that the users can access the data through multiple tools such as Spreadsheets, SQL Clients, etc.  A data warehouse is a centralized location where all the enterprise data gets stored for further analysis. Business Intelligence tools help organizations to explore the data to make better business decisions.   The data is stored in the data warehouse through ETL (Extract, Transform and Load). The data is extracted from the sou...