Data warehousing

---

Assalamualaikum steemians

---

How are you?Hope so everyone would be safe and sound just like me as I am also safe Alhamdulillah....

---

If I talk about my today's topic then this is all about data warehousing so I would like to go into depth of this topic!

Source

Data warehousing is important aspect of business intelligence which is used for enabling organizations for making data driven decisions.If I talk about data warehouse then this is centralized repository which is used for storing information from multiple sources which is used to provide single source of truth to report and to make analysis.

If I talk about data warehouse then this is database which is designed for storing and for management of large amounts of information.This is a repository which is used for integration of information through multiple sources including transactional databases, logging files as well as external data sources.Major purpose of data warehouse is for supporting business intelligence activities like to report,to make analysis as well as to mine data.

Benefits of data warehousing

Multiple benefits are associated with data warehousing implementation which can be understandable as follows;

• For improvement of decision making data warehousing is used to provides single, unified view of data of organization to enable a much better decision making process.
• For enhancement if business intelligence data warehouse is used for supporting business intelligence activities including to report,to make analysis as well as to mine data.
• For increasing efficiency data warehouse is used in automation of process of extraction, transformation and loading of information,to reduce manual effort and to increase efficiency.
• For an efficient management of information data warehouse is used for providing centralized repository for management of data,to ensure quality of data and to minimise data redundancy.

Data warehouse architecture

If I talk about its architecture then it is made with multiple components I am sharing here;

There are source systems first component which are transactional databases, logging files and external data sources which are used for providing information in data warehouse.If I talk about another component then these are ETL tools which are used for extraction of data from source systems, transforming it in a standardized format and then loading it in a data warehouse.

Data warehouse storage is a centralized repository which is used for making storage of integrated data and this is also of offer most important data warehousing component.Last but not least here data access tools comes which are useful in enabling users for accessing and analysing of information in data warehouse.

Source

Types of data warehouse

There are three different types of data warehouses which I am explaining below;

• If I talk about first type then this is enterprise data warehouse which is a centralized information warehouse which is used for storage of data from versatile sources across different organization.
• If I talk about second type then it's data mart which is smaller, departmental data warehouse used for storage of data particularly in a specific business unit or department.
• If I talk about third and last type then this is operational data store which is centralized data store used for integration of information through versatile operational systems that provides single source of truth for operational report system.

Data warehouse implementation

Implementation of data warehouse consists of multiple steps which are follows;

If I talk about first important step then it's all about selection of hardware and software in which you have to select hardware and software components for data warehouse including servers, storage as well as database managing systems.After that second step is about to design data warehouse architecture in which you have to determine architecture for data warehouse which consists of data warehouse storage, ETL tools as well as data access tools about which in types I have discussed them in detail.

Third step is all about implementation of data governance in which there's a need of development of data governance policies and procedures for giving surety of quality of information,security and compliance.Last but not least a step of testing and deployment comes in which first there's a need of testing of data warehouse and then deploying to production comes.

Data warehouse maintenance

If I talk about maintainance of a data warehouse then it consists of following things I am explaining below;

There should be better quality management at first in which there is a regular need of monitoring information quality and performance of data cleansing and data validating comes as required.After that there should be good security management for giving surety of security of data and compliance with regulatory needs.

If I talk about another important thing for maintaining data warehouse then this is data backup and recovery for performing regular backups of information and development of a disaster recovery planning.Last but not least there's performance tunning in which there is a need of monitoring data warehouse performance and optimization per requirement comes.

Data warehouse tools and technologies

Lastly if I talk about tools and technologies of data warehouse then these are below;

There are relational database managing systems consist of oracle, microsoft SQL server etc.After that there are column storage database managing systems in which most important to remember is Amazon Redshift.Last but not least there are ETL tools which consists of informatica power center, microsoft SQL server integration Services etc.

If I conclude my discussion then I have discussed about data warehouse,it's working,it's implementation,it's types,it's examples as well as tools and technologies used in it.I invite everyone to must share your feedback at my post!

---

Thanks

---